JDBC连接mysql案例
import java.sql.*;
public class JDBCTest02{
public static void main(String[] args){
Statement stmt = null;
Connection conn = null;
try{
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
String url = "jdbc:mysql://localhost:3306/mysql";
String user = "root";
String pwd = "123456";
conn = DriverManager.getConnection(url,user,pwd);
System.out.println("数据库连接对象是"+conn);
stmt = conn.createStatement();
String sql = "insert into user(name,age) values('张三',35)";
int res = stmt.executeUpdate(sql);
System.out.println(res == 1?"保存成功":"保存失败");
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
if(stmt != null){
stmt.close();
}
}catch(SQLException e){
e.printStackTrace();
}
try{
if(conn != null){
conn.close();
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
}