public String search() throws Exception {
//applicationDao.insertUser(app);
String searchname = app.getSearchname();
String userstatus = app.getUserstatus();
HttpServletRequest request = ServletActionContext.getRequest();
HttpSession session = request.getSession();
session.setAttribute("userstatus", userstatus);
session.setAttribute("searchname", searchname);
display();
return "insert";
}
dao层负责读取session里的查询条件
//分页查询
public List queryByPage (int pageSize, int pageNow) {
HttpServletRequest request = ServletActionContext.getRequest();
HttpSession session = request.getSession();
String sql_exd="";
String searchname = (String)session.getAttribute("searchname");
String userstatus = (String)session.getAttribute("userstatus");
if(searchname!=null)
{
if(!searchname.equals(""))
sql_exd=sql_exd+"and name='"+searchname+"'";
}
List list = new ArrayList () ;
String sql=" SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM JITUMS.TB_APPLICATION) A WHERE ROWNUM <="+(pageNow*pageSize)+") WHERE RN > "+(pageNow*pageSize-pageSize)+" ";
sql=sql+sql_exd+" order by app_id desc";
// System.out.println(sql);
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
list = jdbcTemplate.query(sql,
new RowMapper() {
public Object mapRow(ResultSet rs, int rowNum)
throws SQLException {
application = new Application () ;
application.setApp_id(rs.getString("app_id")) ;
application.setCode(rs.getString("code")) ;
application.setName(rs.getString("name"));
return application;
}
});
return list;
}