我的第一个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();
            }

        }
    }
}
经验分享 程序员 微信小程序 职场和发展