![下面就是后台 java查询数据库的代码,先提取input框里面的值,input的name=“liuyan”,这里先检查story表里面有没有这个小说名,然后再查询该小说留言表。]
@RequestMapping(value="/liuyan")
public ModelAndView liuyan(@RequestParam(value="liuyan", required=false) String liuyan,
HttpSession httpSession){
System.out.println(liuyan);
String sql = "select * from story where sname = '"+liuyan+"'";
System.out.println(sql);
String viewname="";
final int[] isExist = new int[1];
isExist[0] = 0;
jt.query(sql, new RowCallbackHandler(){
public void processRow(ResultSet rs) throws SQLException {
if (rs.isFirst()) {
isExist[0]=1;
}
}
});
if(isExist[0]==1) {
String sql1 ="select * from "+liuyan+" limit 0,1000";
System.out.println(sql1);
viewname = "liuyan";
final List<liuyan>liuyans = new ArrayList<liuyan>();
jt.query(sql1, new RowCallbackHandler(){
public void processRow(ResultSet rs1) throws SQLException {
System.out.println(rs1.getFetchSize());
while (!rs1.isAfterLast()) {
liuyan liuyanss = new liuyan(rs1.getString(1),
rs1.getInt(2),
rs1.getString(3),
rs1.getString(4));
liuyans.add(liuyanss);
System.out.println(liuyans);
rs1.next();
}
}
});
httpSession.setAttribute("liuyan", liuyan);
System.out.println(liuyans.size());
ModelAndView mv = new ModelAndView(viewname);
mv.addObject("liuyans", liuyans);
return mv;
} else {
httpSession.setAttribute("liuyan", liuyan);
viewname = "chaxun_failed";
ModelAndView mv = new ModelAndView(viewname);
mv.addObject("liuyan", liuyan);
return mv;
}
}