private void kaoqintongji(HttpServletRequest request,
HttpServletResponse response) {
String begdate=request.getParameter("begindate");//定义一个字符串型数据用来获取开始日期
String enddate=request.getParameter("enddate");//结束日期
String zgname=request.getParameter("zgname");
String SQL="select zgname,idcardno,status ,count(*) 天数 from kaoqin where 1=1 ";
if(begdate!=null)
SQL+=MessageFormat.format(" and kqdate>=''{0}'' ", begdate);
if(enddate!=null)
SQL+=MessageFormat.format(" and kqdate<=''{0}'' ",enddate);
if(zgname!=null)
SQL+=MessageFormat.format(" and zgname like ''%{0}%'' ",zgname);
SQL+=" group by zgname,idcardno,status";
List tongjilist=DALBase.runNativeSQL(SQL);
dispatchParams(request, response);
request.setAttribute("tongjilist", tongjilist);
String forwardurl=request.getParameter("forwardurl");
最好能每行注释一下。谢谢
数据库学了一部分。能给我写下注释不。~~~~(>_<)~~~~自己写不出来。以后就忘记了