public class JDBCTest1 {
public static void main(String[] args) {
//1.注册驱动
//2.获取连接
//3.获取数据库操作对象
//4.执行sql语句
//5.处理查询结果
//6.释放资源
Statement stmt =null;
Connection conn =null;
try {
//1.注册驱动
Driver driver = new com.mysql.cj.jdbc.Driver();
DriverManager.registerDriver(driver);
// 2.获取连接
String url="jdbc:mysql://localhost:3306/girls?serverTimezone=UTC";
String username ="root";
String password = "root";
conn = DriverManager.getConnection(url, username, password);
System.out.println("数据库连接对象 =" + conn);
//3.获取数据库操作对象
stmt = conn.createStatement();
//4.执行sql语句
String sql ="insert into beauty(id,name,sex,borndate,phone,photo,boyfriend_id) values(20,'李白','男',NULL,'11555',NULL,5)";
//专门执行dml语句(insert delete update)
int count = stmt.executeUpdate(sql);
System.out.println(count==1?"保存成功":"保存失败");
} catch (SQLException e) {
e.printStackTrace();
}finally{
//6.释放资源
try {
if (stmt !=null){
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}