public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
Connection conn = DBConnectUtils.getConnection();
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
String sql = "select id,username from User";
System.out.println(sql);
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int columnCount = md.getColumnCount();
List list = new ArrayList();
Map map = new LinkedHashMap();
// 之后将获取的每一条记录封装到一个类中
if (rs != null) {
while (rs.next()) {
for (int i = 1; i <= columnCount; i++) {
map.put(md.getColumnName(i), rs.getObject(i));
}
list.add(map);
}
}
//ArrayList转为JsonArray
JSONArray jsonArray = JSONArray.fromObject(list);
System.out.println("jsonArray.toString():" + jsonArray.toString());
不知道你用的什么发送的请求,如果是jquery整合的ajax发送请求,
直接用回调函数
success:function(data){
直接用data[i],就是遍历jsonarray数组。
data[i].name就是数组里边的属性
}
JS获取JsonArray的数据,js怎么写。。。。。。。。。