我的第一个jdbc代码
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(); } } } }
上一篇:
多线程四大经典案例
下一篇:
SpringBoot之定时器