Jsp&Servlet入门级项目全程实录第8讲
惯例广告一发，对于初学真，真的很有用www.java1234.com，去试试吧！
1、添加dao public int studentAdd(Connection con,Student student)throws Exception{ String sql="insert into t_student values(null,?,?,?,?,?,?,?)"; PreparedStatement pstmt=con.prepareStatement(sql); pstmt.setString(1, student.getStuNo()); pstmt.setString(2, student.getStuName()); pstmt.setString(3, student.getSex()); pstmt.setString(4, DateUtil.formatDate(student.getBirthday(), "yyyy-MM-dd")); pstmt.setInt(5, student.getGradeId()); pstmt.setString(6, student.getEmail()); pstmt.setString(7, student.getStuDesc()); return pstmt.executeUpdate(); } 2、修改dao public int studentModify(Connection con,Student student)throws Exception{ String sql="update t_student set stuNo=?,stuName=?,sex=?,birthday=?,gradeId=?,email=?,stuDesc=? where stuId=?"; PreparedStatement pstmt=con.prepareStatement(sql); pstmt.setString(1, student.getStuNo()); pstmt.setString(2, student.getStuName()); pstmt.setString(3, student.getSex()); pstmt.setString(4, DateUtil.formatDate(student.getBirthday(), "yyyy-MM-dd")); pstmt.setInt(5, student.getGradeId()); pstmt.setString(6, student.getEmail()); pstmt.setString(7, student.getStuDesc()); pstmt.setInt(8, student.getStuId()); return pstmt.executeUpdate(); } 3、修改servlet request.setCharacterEncoding("utf-8"); String stuNo=request.getParameter("stuNo"); String stuName=request.getParameter("stuName"); String sex=request.getParameter("sex"); String birthday=request.getParameter("birthday"); String gradeId=request.getParameter("gradeId"); String email=request.getParameter("email"); String stuDesc=request.getParameter("stuDesc"); String stuId=request.getParameter("stuId"); Student student=null; try { student=new Student( stuNo, stuName, sex, DateUtil.formatString(birthday, "yyyy-MM-dd"), Integer.parseInt(gradeId), email, stuDesc); } catch (Exception e) { e.printStackTrace(); } if(StringUtil.isNotEmpty(stuId)){ student.setStuId(Integer.parseInt(stuId)); } Connection con=null; try { con=dbUtil.getCon(); int saveNums=0; JSONObject result=new JSONObject(); if(StringUtil.isNotEmpty(stuId)){ saveNums=studentDao.studentModify(con, student); }else{ saveNums=studentDao.studentAdd(con, student); } if(saveNums>0){ result.put("success", "true"); }else{ result.put("success", "true"); result.put("errorMeg", "删除失败"); } 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(); } } 封装student public Student(String stuNo, String stuName, String sex, Date date, int gradeId, String email, String stuDesc) { super(); this.stuNo = stuNo; this.stuName = stuName; this.sex = sex; this.birthday = date; this.gradeId = gradeId; this.email = email; this.stuDesc = stuDesc; } 字符串转日期 public static Date formatString(String str,String format) throws Exception{ SimpleDateFormat sdf=new SimpleDateFormat(format); return sdf.parse(str); } 日期转字符串 public static String formatDate(Date date,String format){ String result=""; SimpleDateFormat sdf=new SimpleDateFormat(format); if(date!=null){ result=sdf.format(date); } return result; } 4、修改web.xml <servlet> <servlet-name>studentSaveServlet</servlet-name> <servlet-class>com.java1234.web.StudentSaveServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>studentSaveServlet</servlet-name> <url-pattern>/studentSave</url-pattern> </servlet-mapping> 5、前端（略） 6、email验证 validType="email" 6、隐藏列 <th field="gradeId" width="100" align="center" hidden="true">班级ID</th> 7、重置 function resetValue(){ $('#stuNo').val(""); $('#stuName').val(""); $('#sex').combobox("setValue",""); $('#bbirthday').datebox("setValue",""); $('#gradeId').combobox("setValue",""); $('#email').val(""); $('#stuDesc').val(""); } 8、关闭 function closeStudentDialog() { $("#dlg").dialog("close"); resetValue(); } 9、添加 function saveStudent(){ $("#fm").form("submit",{ url:url, onSubmit:function(){ if($('#sex').combobox("getValue")==""){ $.messager.alert("系统提示","请选择性别"); return false; } if($('#gradeId').combobox("getValue")==""){ $.messager.alert("系统提示","请选择所属班级"); return false; } return $(this).form("validate"); }, success:function(result){ if(result.errorMsg){ $.messager.alert("系统提示",result.errorMsg); return; }else{ $.messager.alert("系统提示","保存成功"); resetValue(); $("#dlg").dialog("close"); $("#dg").datagrid("reload"); } } }); } 10、修改前端 function openStudentModifyDialog(){ var selectedRows=$("#dg").datagrid('getSelections'); if(selectedRows.length!=1){ $.messager.alert("系统提示","请选择一条要编辑的数据！"); return; } var row=selectedRows[0]; $("#dlg").dialog("open").dialog("setTitle","编辑学生信息"); $("#fm").form("load",row); url="studentSave?stuId="+row.stuId; } 11、关联判断操作 在删除班级时判断班级下面是否有人？ public boolean getStudentByGradeId(Connection con,String gradeId)throws Exception{ String sql="select * from t_student where gradeId=?"; PreparedStatement pstmt=con.prepareStatement(sql); pstmt.setString(1, gradeId); ResultSet rs=pstmt.executeQuery(); if(rs.next()){ return true; }else{ return false; } } String str[]=delIds.split(","); for(int i=0;i<str.length;i++){ boolean f=studentDao.getStudentByGradeId(con, str[i]); if(f){ result.put("errorIndex", i); result.put("errorMsg", "班级下面有学生,不能删除!"); ResponseUtil.write(response, result); return; } } function deleteGrade(){ 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].id); } var ids=strIds.join(","); $.messager.confirm("系统提示","您确认要删掉这<font color=red>"+selectedRows.length+"</font>条数据吗？",function(r){ if(r){ $.post("gradeDelete",{delIds:ids},function(result){ if(result.success){ $.messager.alert("系统提示","您已成功删除<font color=red>"+result.delNum+"</font>条数据!"); $("#dg").datagrid("reload"); }else{ $.messager.alert("系统提示",'<font color=red>'+selectedRows[result.errorIndex].gradeName+'</font>'+result.errorMsg); } },"json"); } }); }
