-- 創(chuàng)建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.類(lèi)加載，加載驅(qū)動(dòng)

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

??? //2.鏈接數(shù)據(jù)庫(kù)，獲取鏈接對(duì)象

//? 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.創(chuàng)建命令發(fā)送器（手槍）

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

??? //4.執(zhí)行sql語(yǔ)句，返回結(jié)果（相當(dāng)于子彈）。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");

??? //單取一條數(shù)據(jù)

?????? 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.處理結(jié)果

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

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

//???? } else {

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

//???? }

??? ? //6.關(guān)閉資源

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

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

??? }

}

?

創(chuàng)作挑戰(zhàn)賽新人創(chuàng)作獎(jiǎng)勵(lì)來(lái)咯，堅(jiān)持創(chuàng)作打卡瓜分現(xiàn)金大獎(jiǎng)

總結(jié)

以上是生活随笔為你收集整理的myjdbc链接数据库.增删改查的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。