大家帮忙看下这个为什么查不出~~
String form=request.getParameter("form")+"-"+request.getParameter("f")+"-"+"01";
String to=request.getParameter("to")+"-"+request.getParameter("t")+"-"+"01";
rs=stmt.executeQuery(" select * from ProEvolve where convert(varchar(16),examtime,120) between '"+form+"' and '"+to+"'");
String form=request.getParameter("form")+"-"+request.getParameter("f")+"-"+"01";
String to=request.getParameter("to")+"-"+request.getParameter("t")+"-"+"01";
rs=stmt.executeQuery(" select * from ProEvolve where convert(varchar(16),examtime,120) between '"+form+"' and '"+to+"'");
rs=stmt.executeQuery(" select * from ProEvolve where examtime between '"+form+"' and '"+to+"'");
还是不行啊~~~examtime是datetime类型的
1.在后台提交给数据库查询以前输出你要执行的SQL语句,在查询分析器下调试,看是否是你想要的结果
2.如果是你想要的结果,把返回的结果在后台输出,看是否成功将结果带回
3.在页面空白的地方直接输出结果集,看是否所有你要求的结果集都带到页面了
4.给你的TABLE赋值