**
* 查询所有留言
*
* @return json
*/
public void findAllMsg() {
JDBCUtil jdbcUtil = new JDBCUtil();
jdbcUtil.connectDB();
List<Map<Object, Object>> list = new ArrayList<>();
String sql = "select * from guestbook order by msgdate desc";
try {
ResultSet rs = jdbcUtil.select(sql);
ResultSetMetaData md = rs.getMetaData();// 获得结果集结构信息(元数据)
int columnCount = md.getColumnCount();// ResultSet列数
// ResultSet转List<Map>数据结构
// next用于移动到ResultSet的下一行,使下一行成为当前行
while (rs.next()) {
Map<Object, Object> map = new HashMap<>();
for (int i = 1; i <= columnCount; i++) {// 遍历获取对当前行的每一列的键值对,put到map中
// rs.getObject(i) 获得当前行某一列字段的值
map.put(md.getColumnName(i).toLowerCase(), rs.getObject(i));
}
list.add(map);
System.out.println("list:" + list);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
jdbcUtil.close();
}
String data = "{\"msg\":" + JSONArray.fromObject(list) + " ,\"totalCount\":" + list.size() + "}";
send(data);
}
原文:https://blog.csdn.net/zhoukikoo/article/details/79164882