navicat操作流程
使用Java对Mysql数据库的实现增删改查
使用的软件是IDEA(),mysql-connector-java-8.0.16(8.0版)驱动下载在博文下方
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcUtils {
//静态代码块:随着类的加载只执行一次
static {
//使用第三方jar报jdbc操作数据库
try {
new com.mysql.jdbc.Driver();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void add(){
Connection conn=null;
Statement state=null;
//创建连接 url form http://127.0.0.1:3306/name?username=zhi&password=pwd
// url jdbc:mysql://127.0.0.1:3306/test02
try {
conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false","root","wPn@123");
//新建查询窗口
state=conn.createStatement();
//写sql语句
String sql ="insert into cat(name,age) values('中文',5)";
//执行
int result = state.executeUpdate(sql);
System.out.println(result);
//关流
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
state.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void update(){
Connection conn=null;
Statement state=null;
try {
conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false","root","wPn@123");
//新建查询窗口
state=conn.createStatement();
//写sql语句
String sql="update cat set name='测试' where id=3";
//执行
int result = state.executeUpdate(sql);
System.out.println(result);
//关流
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
state.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void delete(){
Connection conn=null;
Statement state=null;
try {
conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false","root","wPn@123");
//新建查询窗口
state=conn.createStatement();
//写sql语句
String sql="delete from cat where id=3";
//执行
int result = state.executeUpdate(sql);
System.out.println(result);
//关流
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
state.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
//查询
public void select() {
Connection conn = null;
Statement state = null;
ResultSet rs = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test02?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false", "root", "wPn@123");
//创建查询窗口
state = conn.createStatement();
String sql = "select id,name,age from cat";
rs = state.executeQuery(sql);
//循环打印结果
while (rs.next()){
int id= rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
System.out.println("cat的id:"+id+" cat的name:"+name+" cat的age:"+age+"\n");
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
rs.close();
//关闭查询窗口
state.close();
//关闭连接
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
查询出来的结果:
mysql-connector-java-8.0.16驱动下载
链接:https://pan.baidu.com/s/16Xmxfn6HevC22hhrtYyQxQ
提取码:9c5m
mysql-connector-java-5.1.38驱动下载
链接:https://pan.baidu.com/s/18qsTlXAVvJWQL3fqAeEAJw
提取码:ulzm