-- 創建user表
CREATE TABLE user(
?uid int PRIMARY KEY auto_increment,
?uname VARCHAR(55),
?pwd VARCHAR(55),
?realName VARCHAR(55)
)
SELECT * FROM user;

Jdbc增刪改查

package myjdbc;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class myJDBC {

??? public static void main(String[] args) throws ClassNotFoundException, SQLException {

??????

??? ? //1.類加載，加載驅動

?????? Class.forName("com.mysql.cj.jdbc.Driver");

??? //2.鏈接數據庫，獲取鏈接對象

//? Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mydb01", "root","123456");

?????? Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?useSSL=false&"+"useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai", "root","123456");

??? ? //3.創建命令發送器（手槍）

?????? Statement statement=conn.createStatement();

??? //4.執行sql語句，返回結果（相當于子彈）。executeUpdate:增加，刪除，修改

//???? int update=statement.executeUpdate("insert into user values(default,'ww','234','王小五a')");

??? //刪除操作

//???? int update=statement.executeUpdate("delete from user where uid=6");

??? //修改操作

//???? int update=statement.executeUpdate("update user set uname='想',realname='你' where uid=7");

??? //單取一條數據

?????? ResultSet re=statement.executeQuery("select * from user where uid=7");

//? ??? ResultSet re=statement.executeQuery("select * from user");

?????? while(re.next()){

?????????? int id = re.getInt(1);

?????????? String name = re.getString(2);

?????????? String pwd = re.getString(3);

?????????? String rname=re.getString(4);

?????????? System.out.println(id+name+pwd+rname);

?????? }

??? //5.處理結果

//???? if (update>0) {

//???????? System.out.println("操作成功");

//???? } else {

//???????? System.out.println("操作失敗！");

//???? }

??? ? //6.關閉資源

?????? statement.close();

?????? conn.close();

??? }

}

?