日期:2014-05-20 浏览次数:21127 次
public List<Admin> getAllAdmin() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Admin> adminList = new ArrayList<Admin>();
int count = 0;
try {
conn = JdbcUtil.getConnection();
String sql = "select id,adminid,adminname,password,time from admin";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
Admin[] adminArr = new Admin[]{};
while (rs.next()) {
//todo
}
}catch (SQLException e) {
e.printStackTrace();
}
return adminList;
}
public List<Admin> getAllAdmin() {
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<Admin> adminList = new ArrayList<Admin>();
int count = 0;
try {
conn = JdbcUtil.getConnection();
String sql = "select id,adminid,adminname,password,time from admin";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
Admin admin = new Admin();
admin.setId(rs.getString(1)) ;
admin.setAdminid(rs.getString(2)) ;
admin.setAdminname(rs.getString(3)) ;
admin.setPassword(rs.getString(4)) ;
admin.setTime(rs.getString(5)) ;
adminList.add(admin);
}
}catch (SQLException e) {
e.printStackTrace();
}
return adminList;
}