JAVA基础知识

JBDC原生操作

@Test
    public void test1() throws SQLException, ClassNotFoundException {
        //1.导入jar包依赖 mysql-connector-java-5.1.44-bin.jar

        //2.注册驱动
        Class.forName("com.mysql.jdbc.Driver"); 
        //3.获取数据库连接对象 Connection  如果返回对象不为null,证明连接成功
        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/share?useSSL=false","root","123456");
        //4.定义sql
        String sql = "SELECT * FROM `user`";
        //5.获取执行sql语句的对象，Statement
        Statement statement = connection.createStatement();
        //6.执行sql语句，接收返回结果
        /** statement 的执行方法
        Boolean  statement.execute()    //返回boolean
        int  statement.executeUpdate() //更新操作 ,返回int
        ResultSet statement.executeQuery(); //查询操作 ,返回结果集--->结果集处理
         */
        ResultSet resultSet = statement.executeQuery(sql);
        //7.处理结果集 resultSet.next()
        while(resultSet.next()){
            int row = resultSet.getRow();
            //通过表字段名来取
            int id = resultSet.getInt("id");
            String name = resultSet.getString("name");
            String phone = resultSet.getString("phone");
            //通过列号来取,列号从1开始
            String salt = resultSet.getString(6);
            String email =resultSet.getString(7);
            int state = resultSet.getInt(8);
            //汇总输出
            System.out.println("row:"+ row +" id=" + id + " name=" + name+ " phone="+ phone+" salt="+ salt +" email="+ email +" state="+state);
        }
        //8.释放资源
        connection.close();
        statement.close();
    }