public Map<String, Object> classInfo(HttpServletRequest request,Integer id) {
Map<String, Object> map = new HashMap<String, Object>();
//获取学员
String sql_std = " select s.id,s.name,s.age,s.telphone from class_student cs "
+ " join classes c on cs.classid = c.id "
+ " join students s on cs.studentid = s.id "
+ " where cs.classid = " + id
+ " and c.teacherid = " + t.getId()
+ " and cs.status = 0 "
;
List list_std = baseDao.getSQLList(sql_std);
//返回的时候主要利用map
//先创建一个list里面元素是map
List<Map<String,Object>> list_std_rtn = new ArrayList<Map<String,Object>>();
//然后for循环list_std 将其中数据放入map key对应的是数据库所查询出来的字段
for (int i = 0; i < list_std.size(); i++) {
Object[] item = (Object[]) list_std.get(i);
Map<String,Object> map_std = new HashMap<String,Object>();
map_std.put("id", item[0]);
map_std.put("name", item[1]);
map_std.put("age", item[2]);
map_std.put("telphone", item[3]);
//然后将map依次放入(里面元素是map)的list中
list_std_rtn.add(map_std);
}
map.put("students", list_std_rtn);
return map;
}
前台页面ajax直接接收即可