ApDBUtils引出
土方法完成封装
利用最原始的方法进行封装
package com.jh.datasource; import org.junit.jupiter.api.Test; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; //使用原始的方法解决ResultSet问题,将结果集封装到ArrayList public class JDBCUtilsDruid_tuidea { @Test public void testSelect(){ //1.得到连接 Connection connection = null; //2.组织sql String sql = "select * from admin02 where id = ?"; PreparedStatement preparedStatement = null; ResultSet resultSet = null; //创建ArrayList 对象,用来存放admin02 ArrayList<Admin02> list = new ArrayList<>(); //3.创建PreparedStatement的对象 try { connection = JDBCUtilsDruid.getConnection(); preparedStatement = connection.prepareStatement(sql); preparedStatement.setInt(1,1); resultSet = preparedStatement.executeQuery(); while (resultSet.next()){ int id = resultSet.getInt("id"); String username = resultSet.getString("username"); String password = resultSet.getString("password"); //得到的resultSet的记录,封装到Admin02中,并放入到ArrayList集合中 list.add(new Admin02(id,username,password)); } System.out.println("list集合数据:" + list); } catch (SQLException e) { throw new RuntimeException(e); }finally { //6.关闭资源 JDBCUtilsDruid.close(resultSet,preparedStatement,connection); } //return list; } }