JDBC标准写法

JDBC

//一个标准的JDBC程序

public void demo1(){
        Connection conn=null;
        Statement statement=null;
        ResultSet resultSet=null;
        try {
            //1.加载驱动
           // DriverManager.registerDriver(new Driver());
            Class.forName("com.mysql.cj.jdbc.Driver");//加载类时就会加载驱动,需要导入jar包
            //2.获得链接
             conn=DriverManager.getConnection("jdbc:mysql:///jdbctest?serverTimezone=UTC","root","123456"); //替换成自己的数据库名称
            //3.创建执行SQL语句的对象，执行SQl
            //3.1 创建执行SQL的对象
            String str="SELECT * FROM user";
             statement=conn.createStatement();
            //3.2 执行SQL语句
             resultSet=statement.executeQuery(str);
            while(resultSet.next()){
                int uid=resultSet.getInt("uid");
                String username = resultSet.getString("username");
                String password = resultSet.getString("password");
                String name = resultSet.getString("name");

                System.out.println(uid+"  "+username+"  "+password+"  "+name);
            }

        } catch (Exception throwables) {
            throwables.printStackTrace();
        }finally {
            //4.释放资源
            if(conn!=null){
                try {
                    conn.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
                conn=null;
            }
            if(resultSet!=null){
                try {
                    resultSet.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
                resultSet=null;
            }
            if(statement!=null){
                try {
                    statement.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
                statement=null;
            }

        }
    }