package Test; import org.junit.Test; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import java.util.TimerTask; public class JDBCdemo4_ResultSet2 { /* * 查询test账户表数据,封装为Test对象种,并储存到ArrayList集合中 * 1.定义实体类Test * 2.查询,封装到Test对象种 *3.将Test对象存入ArrayList集合中 * * */ @Test public void testResultSet() throws Exception {//DQL查询语句 //1.注册驱动 //Class.forName("com.mysql.jdbc.Driver"); //2.获取连接 String url = "jdbc:mysql:///test?useSSL=false"; String username = "root"; String password = "1234"; Connection conn = DriverManager.getConnection(url, username, password); //3.定义sql String sql="select * from test"; //4.获取statement对象 Statement stmt = conn.createStatement(); //5.执行sql ResultSet rs = stmt.executeQuery(sql); //创建集合 List<pojo.Test> list=new ArrayList<>(); //6.处理结果,遍历rs中所有的数据 //6.1光标向下移动一行,并且判断当前行是否有数据 while (rs.next()){ //得到对象 pojo.Test test= new pojo.Test(); //6.2获取数据 getXxx() int id = rs.getInt("id"); String name = rs.getNString("name"); double money = rs.getDouble("money"); //赋值 test.setId(id); test.setName(name); test.setMoney(money); //存入集合 list.add(test); } System.out.println(list); //7.释放资源 rs.close(); stmt.close(); conn.close(); } }
标签:JDBC,java,rs,sql,test,API,ResultSet2,Test,import From: https://www.cnblogs.com/Karl-hut/p/17481968.html