Action中的代码
@Getter
@Setter
private List<Map> recordlist;
@Getter
@Setter
private Map map;
public String records(){
recordlist = studentService.records(uid);
return SUCCESS;
}
---------service
public List<Map> records(int uid) {
// TODO Auto-generated method stub
return this.stdCourseDao.findStdCourseRecord(uid);
}
----------dao
public List<Map> findStdCourseRecord(int uid ) {
String sql = "select record.*,course.*,member.* from 7east_adminopencourse_record record ,7east_course course,uchome_member member where record.courseid=course.cid and record.userid=? and member.uid=record.adminuserid";
Object[] args = new Object[] { uid };
RowMapper argTypes = new RowMapper() {
@Override
public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
Map<String,Object> map = new HashMap<String,Object>();
String cname = rs.getString("cname");
String casetype = rs.getString("casetype");
int price = rs.getInt("price");
int createtime = rs.getInt("createtime");
String username = rs.getString("username");
map.put("cname", cname) ;
map.put("casetype", casetype) ;
map.put("price", price) ;
map.put("createtime", createtime) ;
map.put("username", username) ;
return map;
}
};
List<Map> list = getJdbcTemplate().query(sql, args,
argTypes);
return list;
}
<s:iterator value="recordlist">
<tr>
<td>
<s:property value="createtime"/>
</td>
<td >
<s:property value="casetype"/>
</td>
<td >
<s:property value="value"/>
</td>
<td >
<s:property value="price" />
</td>
<td >
<s:property value="cname" />
</td>
</tr>
</s:iterator>