58,452
社区成员




public List<BbsRootieInfo> getAllRoot() {
ArrayList rootList = new ArrayList<BbsRootieInfo>();
Connection conn = null;
try {
conn = DBUtils.getConnection();
String sql = "select * from dbo.tb_bbs";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
System.out.println(rs.getRow());
while (rs.next()) {
BbsRootieInfo root = new BbsRootieInfo();
root.setBbs_id(rs.getInt(1));
root.setBbs_boardID(rs.getInt(2));
root.setBbs_title(rs.getString(3));
root.setBbs_content(rs.getString(4));
root.setBbs_sender(rs.getString(5));
root.setBbs_sendTime(rs.getString(6));
root.setBbs_face(rs.getString(7));
root.setBbs_opTime(rs.getString(8));
root.setBbs_isTop(rs.getString(9));
root.setBbs_toTopTime(rs.getString(10));
root.setBbs_isGood(rs.getString(11));
root.setBbs_toGoodTime(rs.getString(12));
rootList.add(root);
}
rs.close();
st.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return rootList;
}