1、获取搜索条件值

     function searchStudent(){

                    $('#dg').datagrid('load',{

                         stuNo:$('#s_stuNo').val(),

                         stuName:$('#s_stuName').val(),

                         sex:$('#s_sex').combobox("getValue"),

                         bbirthday:$('#s_bbirthday').datebox("getValue"),

                         ebirthday:$('#s_ebirthday').datebox("getValue"),

                         gradeId:$('#s_gradeId').combobox("getValue")

                    });

               }

2、servlet

     String stuNo=request.getParameter("stuNo");

          String stuName=request.getParameter("stuName");

          String sex=request.getParameter("sex");

          String bbirthday=request.getParameter("bbirthday");

          String ebirthday=request.getParameter("ebirthday");

          String gradeId=request.getParameter("gradeId");

          Student student= new Student();

          if(stuNo!=null){

               student.setStuNo(stuNo);

               student.setStuName(stuName);

               student.setSex(sex);

               if(StringUtil.isNotEmpty(gradeId)){

                    student.setGradeId(Integer.parseInt(gradeId));

               }

          }

          //获取page、rows请求

          String page=request.getParameter("page");

          String rows=request.getParameter("rows");

          //封装

          PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));

          Connection con=null;

          try {

               con=dbUtil.getCon();

               JSONObject result=new JSONObject();

               JSONArray jsonArray=JsonUtil.formatRsToJsonArray(studentDao.studentList(con, pageBean,student,bbirthday,ebirthday));

               int total=studentDao.studentCount(con,student,bbirthday,ebirthday);

               result.put("rows", jsonArray);

               result.put("total", total);

               ResponseUtil.write(response, result);

          } catch (Exception e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

          }finally{

               try {

                    dbUtil.closeCon(con);

               } catch (Exception e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

               }

          }

3、查询dao

public ResultSet studentList(Connection con,PageBean pageBean,Student student,String bbirthday,String ebirthday)throws Exception{

          StringBuffer sb=new StringBuffer("select * from t_student s,t_grade g where s.gradeId=g.id");

          if(StringUtil.isNotEmpty(student.getStuNo())){

               sb.append(" and s.stuNo like '%"+student.getStuNo()+"%'");

          }

          if(StringUtil.isNotEmpty(student.getStuName())){

               sb.append(" and s.StuName like '%"+student.getStuName()+"%'");

          }

          if(StringUtil.isNotEmpty(student.getSex())){

               sb.append(" and s.sex ='"+student.getSex()+"'");

          }

          if(student.getGradeId()!=-1){

               sb.append(" and s.GradeId ='"+student.getGradeId()+"'");

          }

          if(StringUtil.isNotEmpty(bbirthday)){

               sb.append(" and TO_DAYS(s.birthday)>=TO_DAYS('"+bbirthday+"')");

          }

          if(StringUtil.isNotEmpty(ebirthday)){

               sb.append(" and TO_DAYS(s.birthday)<=TO_DAYS('"+ebirthday+"')");

          }

          if(pageBean!=null){

               sb.append(" limit "+pageBean.getStart()+","+pageBean.getRows());

          }

          PreparedStatement pstmt=con.prepareStatement(sb.toString());

          return pstmt.executeQuery();

     }

     public int studentCount(Connection con,Student student,String bbirthday,String ebirthday)throws Exception{

          StringBuffer sb=new StringBuffer("select count(*) as total from t_student s,t_grade g where s.gradeId=g.id");

          if(StringUtil.isNotEmpty(student.getStuNo())){

               sb.append(" and s.stuNo like '%"+student.getStuNo()+"%'");

          }

          if(StringUtil.isNotEmpty(student.getStuName())){

               sb.append(" and s.StuName like '%"+student.getStuName()+"%'");

          }

          if(StringUtil.isNotEmpty(student.getSex())){

               sb.append(" and s.sex ='"+student.getSex()+"'");

          }

          if(student.getGradeId()!=-1){

               sb.append(" and s.GradeId ='"+student.getGradeId()+"'");

          }

          if(StringUtil.isNotEmpty(bbirthday)){

               sb.append(" and TO_DAYS(s.birthday)>=TO_DAYS('"+bbirthday+"')");

          }

          if(StringUtil.isNotEmpty(ebirthday)){

               sb.append(" and TO_DAYS(s.birthday)<=TO_DAYS('"+ebirthday+"')");

          }

          PreparedStatement pstmt=con.prepareStatement(sb.toString());

          ResultSet rs=pstmt.executeQuery();

          if(rs.next()){

               return rs.getInt("total");

          }else{

               return 0;

          }

     }

4、删除dao

     public int studentDelect(Connection con,String delIds)throws Exception{

          String sql="delete from t_student where stuId in("+delIds+")";

          PreparedStatement pstmt=con.prepareStatement(sql);

          return pstmt.executeUpdate();

     }

5、删除servlet

     String delIds=request.getParameter("delIds");

          Connection con=null;

          try {

               con=dbUtil.getCon();

               JSONObject result=new JSONObject();

               int delNums=studentDao.studentDelect(con, delIds);

               if(delNums>0){

                    result.put("success", "true");

                    result.put("delNums", delNums);

               }else{

                    result.put("errorMeg", "删除失败");

               }

               result.put("delNum", delNums);

               ResponseUtil.write(response, result);

          } catch (Exception e) {

               // TODO Auto-generated catch block

               e.printStackTrace();

          }finally{

               try {

                    dbUtil.closeCon(con);

               } catch (Exception e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

               }

          }

6、修改web.xml

         <servlet>

    <servlet-name>studentDeleteServlet</servlet-name>

    <servlet-class>com.java1234.web.StudentDeleteServlet</servlet-class>

  </servlet>

  <servlet-mapping>

    <servlet-name>studentDeleteServlet</servlet-name>

    <url-pattern>/studentDelete</url-pattern>

  </servlet-mapping>

7、删除前端

     function deleteStudent(){

                    var selectedRows=$("#dg").datagrid('getSelections');

                    if(selectedRows.length==0){

                         $.messager.alert("系统提示","请选择要删除的数据！");

                         return;

                    }

                    var strIds=[];

                    for(var i=0;i<selectedRows.length;i++){

                         strIds.push(selectedRows[i].stuId);

                    }

                    var ids=strIds.join(",");

                    $.messager.confirm("系统提示","您确认要删掉这<font color=red>"+selectedRows.length+"</font>条数据吗？",function(r){

                         if(r){

                              $.post("studentDelete",{delIds:ids},function(result){

                                   if(result.success){

                                        $.messager.alert("系统提示","您已成功删除<font color=red>"+result.delNum+"</font>条数据!");

                                        $("#dg").datagrid("reload");

                                   }else{

                                        $.messager.alert("系统提示",result.errorMsg);

                                   }

                              },"json");

                         }

                    });

               }