public static void main(String[] args) {
Connection conn =null;
Statement st =null;
PreparedStatement ps=null;
ResultSet rs=null;
List<user> userList=new ArrayList<user>(); //user表集合
user user=new user(); //user表domain
try {
conn = jdbcTest.getConnection();
st = conn.createStatement();
ps = conn.prepareStatement("select * from user");
rs = ps.executeQuery();
while(rs.next()) { //通过循环把结果集,添加到user,再添加到userList中
user.setName(rs.getString(1));
System.out.print(rs.getString(1)+" "); //查看添加的数据
user.setPwd(rs.getString(2));
System.out.println(rs.getString(2));
userList.add(user); //添加到userList
}
System.out.println(userList); //输出userList
} catch (SQLException e) {
e.printStackTrace();
}
finally {
jdbcTest.close(conn, st, null);
}
}
下面是结果:
zhang0 mima0
zhang1 mima1
zhang2 mima2
zhang3 mima3
zhang4 mima4
zhang5 mima5
zhang6 mima6
zhang7 mima7
zhang8 mima8
zhang9 mima9
zhang10 mima10
zhang11 mima11
zhang12 mima12
zhang13 mima13
zhang14 mima14
zhang15 mima15
zhang16 mima16
zhang17 mima17
zhang18 mima18
zhang19 mima19
[user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
, user [name=zhang19, pwd=mima19]
]