mybatis+0809

@Test public void testJdbc() throws Exception { //1. 注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //2. 获取连接对象 String url = "jdbc:mysql://localhost:3306/mybatis"; String username = "root"; String password = "1234"; Connection connection = DriverManager.getConnection(url, username, password); //3. 获取执行SQL的对象Statement,执行SQL,返回结果 String sql = "select * from user"; Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql); //4. 封装结果数据 List userList = new ArrayList<>(); while (resultSet.next()){ int id = resultSet.getInt("id"); String name = resultSet.getString("name"); short age = resultSet.getShort("age"); short gender = resultSet.getShort("gender"); String phone = resultSet.getString("phone"); User user = new User(id,name,age,gender,phone); userList.add(user); } //5. 释放资源 statement.close(); connection.close(); }