教务管理系统核心代码.docx

UserDaopackage com.cissst.dao;import java.util.List;import org.apache.ibatis.session.SqlSession;import com.cissst.entity.Users;import com.cissst.utils.MyBatisUtils;public class UserDao public static Users findUserById(int userId)SqlSession session=MyBatisUtils.getSqlSession();Users users=session.selectOne(findUserById,userId);MyBatisUtils.closeConn(session);return users;public static boolean delUserInfo(int userId)SqlSession session=MyBatisUtils.getSqlSession();int flag=session.insert(delUserInfo,userId);mit();if(flag!=0)return true;return false;public static boolean updateUserInfo(Users users)SqlSession session=MyBatisUtils.getSqlSession();int flag=session.update(updateUserInfo, users);mit();if(flag!=0)return true;return false;public static boolean saveUserInfo(Users user) SqlSession session=MyBatisUtils.getSqlSession();int flag=session.insert(saveUserInfo,user);mit();if(flag!=0)return true;return false;public static ListfindWithPage()Listlist=null;trySqlSession session=MyBatisUtils.getSqlSession();list=session.selectList(selectUserTable);MyBatisUtils.closeConn(session);catch (Exception e) return list;UserDaoMapperselect * from tb_users where id=#userIdselect * from tb_users where username=#uname and password=#upassupdate tb_users set usernumber=#userNumber,username=#username,password=#password,sex=#sex,address=#address,tel=#tel,qq=#qq,age=#age,remark=#remarkwhere id=#iddelete from tb_userswhere id=#userIdinsert intotb_users(usernumber,username,password,sex,address,age,tel,qq,remark)values(#userNumber,#username,#password,#sex,#address,#age,#tel,#qq,#remark)select * from tb_usersUsers.javapackage com.cissst.entity;public class Users private Integer id;private String userNumber;private String username;private String password;private String sex;private String age;private String address;private String tel;private String qq;private String remark;public String getUserNumber() return userNumber;public Users(String userNumber, String username, String password, String sex, String age,String address, String tel, String qq, String remark) this.userNumber = userNumber;this.username = username;this.password = password;this.sex = sex;this.age = age;this.address = address;this.tel = tel;this.qq = qq;this.remark = remark;public Users() public void setUserNumber(String userNumber) this.userNumber = userNumber;public Integer getId() return id;public void setId(Integer id) this.id = id;public String getUsername() return username;public void setUsername(String username) this.username = username;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getSex() return sex;public void setSex(String sex) this.sex = sex;public String getAge() return age;public void setAge(String age) this.age = age;public String getAddress() return address;public void setAddress(String address) this.address = address;public String getTel() return tel;public void setTel(String tel) this.tel = tel;public String getQq() return qq;public void setQq(String qq) this.qq = qq;public String getRemark() return remark;public void setRemark(String remark) this.remark = remark;UserServlet.javapackage com.cissst.servlet;import java.io.IOException;import java.text.SimpleDateFormat;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.cissst.dao.UserDao;import com.cissst.entity.Users;import com.google.gson.Gson;WebServlet(/userServlet)public class UserServlet extends HttpServletUsers users=null;private static final long serialVersionUID = 1L;protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException this.doPost(req, resp);protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException String m=req.getParameter(m);/获得页面中传递的参数值resp.setCharacterEncoding(utf-8);if(find.equals(m)Listlist=UserDao.findWithPage();for(Users u:list)if(1.equals(u.getSex()u.setSex(男);else if(0.equals(u.getSex()u.setSex(女);elseu.setSex(什么都不是);resp.getWriter().print(new Gson().toJson(list);else if(saveUserInfo.equals(m)/编写后台自定生成编号SimpleDateFormat format=new SimpleDateFormat(yyyyMMddhhmmss); String userNumber=format.format(new Date();Users users=new Users(userNumber, req.getParameter(username), req.getParameter(password), req.getParameter(sex), req.getParameter(age), req.getParameter(address), req.getParameter(tel), req.getParameter(qq), req.getParameter(remark);if(UserDao.saveUserInfo(users)resp.getWriter().print(true);elseresp.getWriter().print(false);else if(deleteUserInfo.equals(m)String ids=req.getParameterValues(arrayIds);if(ids.length0)for(String delId:ids)int id=Integer.valueOf(delId);if(UserDao.delUserInfo(id)resp.getWriter().print(true);elseresp.getWriter().print(false);else if(findUserById.equals(m) users=UserDao.findUserById(Integer.valueOf(req.getParameter(fId);resp.getWriter().print(new Gson().toJson(users);else if(updateUserInfo.equals(m)users.setUsername(req.getParameter(username);users.setAddress(req.getParameter(address);users.setAge(req.getParameter(age);users.setPassword(req.getParameter(password);users.setQq(req.getParameter(qq);users.setSex(req.getParameter(sex);users.setTel(req.getParameter(tel);users.setRemark(req.getParameter(remark); if(UserDao.updateUserInfo(users)resp.getWriter().print(true);elseresp.getWriter().print(false);else if(login.equals(m)Mapmap=new HashMap();map.put(uname, req.getParameter(username);map.put(upass, req.getParameter(password);if(UserDao.login(map)resp.getWriter().print(true);elseresp.getWriter().print(false);userList.htmlindex.html$(function() /当浏览器载入html完成是执行该函数中代码$(#table).datagrid(toolbar : text : 添加,iconCls : icon-add,handler : function() $(#myDialog).dialog(closed : false,buttons : text : 保存,iconCls : icon-save,handler : function() $(#form1).form(submit, url:./userServlet?m=saveUserInfo, onSubmit: function() return $(#form1).form(validate); , success:function(flag) if(flag)$(#myDialog).dialog(closed : true);/将对话框隐藏/将表格刷新$(#table).datagrid(reload);$(#form1).form(clear);elsealert(添加数据失败); ); , text : 重置,iconCls : icon-redo,handler : function() , text : 关闭,iconCls : icon-cancel,handler : function() $(#myDialog).dialog(closed : true);$(#form1).form(clear); ), text : 修改,iconCls : icon-edit,handler : function() var array = $(#table).datagrid(getSelections);if (array.length = 0) alert(请选择要修改的数据); else if (array.length 1) alert(只能修改一条记录);$(#table).datagrid(unselectAll); else /调用后台编写的查询一条记录的方法，填充对话框中修改的表单$(#form2).form(load,./userServlet?m=findUserById&fId=+$(#table).datagrid(getSelected).id);/弹出对话框的代码$(#myEditDialog).dialog(closed : false,buttons : text : 保存,iconCls : icon-save,handler : function() $(#form2).form(submit, url:./userServlet?m=updateUserInfo, onSubmit: function() return $(#form2).form(validate); , success:function(flag) if(flag)$(#myEditDialog).dialog(closed : true);/将对话框隐藏/将表格刷新$(#table).datagrid(reload);$(#form2).form(clear);elsealert(修改数据失败); ); , text : 关闭,iconCls : icon-cancel,handler : function() $(#table).datagrid(unselectAll);$(#myEditDialog).dialog(closed : true);$(#form2).form(clear); );, text : 删除,iconCls : icon-remove,handler : function() var ids = ;/定义一个javaScript数组var array = $(#table).datagrid(getSelections);if (array.length = 0) alert(请选择要删除的数据); else for ( var i in array) ids.push(arrayi.id);/该方法是其他技术的知识点，直接使用$.post(./userServlet?m=deleteUserInfo,arrayIds:ids,function(flag)if(flag)$(#table).datagrid(reload);elsealert(删除失败);) )用户名称密码性别男女年龄电话qq号码住址备注用户名称密码性别男女年龄电话qq号码住址备注用户ID用户编号用户名称性别年龄密码电话qq号码住址备注Index.htmlindex.htmlwindow.history.forward(-1);$(function() /入口函数/树形数据定义var mydata = text : 系统管理,state : closed,/定义树形是否折叠 默认展开children : text : 学生管理,attributes : /树的自定义属性，该属性主要是用户点击树叶时将页面显示在布局控件中间控件中url : html/studentList.html, text : 班级管理,attributes : url : html/gradeList.html, text : 课程管理,attributes : url : html/courseList.html, text : 教师管理,attributes : url : html/teacherList.html, text : 用户管理,attributes : url : html/userList.html /树形控件定义$(#tree).tree(data : mydata,lines : true,onClick : function(node) if (node.att