教務(wù)管理系統(tǒng)核心代碼

1、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.sel

2、ectOne("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 up

3、dateUserInfo(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("s

4、aveUserInfo",user);mit();if(flag!=0)return true;return false;public static List<Users>findWithPage()List<Users>list=null;trySqlSession session=MyBatisUtils.getSqlSession();list=session.selectList("selectUserTable");MyBatisUtils.closeConn(session);catch (Exception e) return

5、 list;UserDaoMapper<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//DTD Mapper 3.0/EN""/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.cissst.dao.UserDao"><select id="findUserBy

6、Id" resultMap="userMapper" parameterType="int">select * from tb_users where id=#userId</select><select id="login" resultMap="userMapper">select * from tb_users where username=#uname and password=#upass</select><update id="upda

7、teUserInfo" parameterType="com.cissst.entity.Users">update tb_users set usernumber=#userNumber,username=#username,password=#password,sex=#sex,address=#address,tel=#tel,qq=#qq,age=#age,remark=#remarkwhere id=#id</update><delete id="delUserInfo" parameterType="

8、;int">delete from tb_userswhere id=#userId</delete><insert id="saveUserInfo" parameterType="com.cissst.entity.Users">insert intotb_users(usernumber,username,password,sex,address,age,tel,qq,remark)values(#userNumber,#username,#password,#sex,#address,#age,#tel,#

9、qq,#remark)</insert><select id="selectUserTable" resultMap="userMapper">select * from tb_users</select><resultMap type="com.cissst.entity.Users" id="userMapper"><id property="id" column="id" /><result proper

10、ty="userNumber" column="usernumber" /><result property="username" column="username" /><result property="password" column="password" /><result property="sex" column="sex" /><result property="a

11、ge" column="age" /><result property="address" column="address" /><result property="tel" column="tel" /><result property="qq" column="qq" /><result property="remark" column="remark"

12、/></resultMap></mapper>Users.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 r

13、emark;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

14、= 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 s

15、etUsername(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(Stri

16、ng 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 getRe

17、mark() 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.Servle

18、tException;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("/userServle

19、t")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, HttpSe

20、rvletResponse resp) throws ServletException, IOException String m=req.getParameter("m");/獲得頁面中傳遞的參數(shù)值resp.setCharacterEncoding("utf-8");if("find".equals(m)List<Users>list=UserDao.findWithPage();for(Users u:list)if("1".equals(u.getSex()u.setSex("男&quo

21、t;);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.fo

22、rmat(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&

23、quot;), 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.length>0)for(String delId:ids)int id=Integer.valueOf

24、(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".

25、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(

26、"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)Map<String,String>map=new HashMap<String,St

27、ring>();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.html<html><head><meta http-equiv="Content-Ty

28、pe" content="text/html; charset=UTF-8"><title>index.html</title><link rel="stylesheet" type="text/css"href="./jqueryui/themes/default/easyui.css"><link rel="stylesheet" type="text/css"href="./jqueryui/theme

29、s/icon.css"><script type="text/javascript" src="./jqueryui/jquery.min.js"></script><script type="text/javascript" src="./jqueryui/jquery.easyui.min.js"></script><script type="text/javascript"src="./jqueryui/loc

30、ale/easyui-lang-zh_CN.js"></script><script type="text/javascript">$(function() /當(dāng)瀏覽器載入html完成是執(zhí)行該函數(shù)中代碼$("#table").datagrid(toolbar : text : '添加',iconCls : 'icon-add',handler : function() $("#myDialog").dialog(closed : false,buttons : t

31、ext : '保存',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(cl

32、osed : true);/將對話框隱藏/將表格刷新$("#table").datagrid('reload');$("#form1").form('clear');elsealert('添加數(shù)據(jù)失敗'); ); , text : '重置',iconCls : 'icon-redo',handler : function() , text : '關(guān)閉',iconCls : 'icon-cancel',handler : function() $

33、("#myDialog").dialog(closed : true);$("#form1").form('clear'); ), text : '修改',iconCls : 'icon-edit',handler : function() var array = $("#table").datagrid('getSelections');if (array.length = 0) alert('請選擇要修改的數(shù)據(jù)'); else if (array.le

34、ngth > 1) alert('只能修改一條記錄');$("#table").datagrid('unselectAll'); else /調(diào)用后臺編寫的查詢一條記錄的方法，填充對話框中修改的表單$("#form2").form('load','./userServlet?m=findUserById&fId='+$("#table").datagrid('getSelected').id);/彈出對話框的代碼$("#myEdit

35、Dialog").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

36、(flag) if(flag)$("#myEditDialog").dialog(closed : true);/將對話框隱藏/將表格刷新$("#table").datagrid('reload');$("#form2").form('clear');elsealert('修改數(shù)據(jù)失敗'); ); , text : '關(guān)閉',iconCls : 'icon-cancel',handler : function() $("#table")

37、.datagrid('unselectAll');$("#myEditDialog").dialog(closed : true);$("#form2").form('clear'); );, text : '刪除',iconCls : 'icon-remove',handler : function() var ids = ;/定義一個javaScript數(shù)組var array = $("#table").datagrid('getSelections'

38、);if (array.length = 0) alert('請選擇要刪除的數(shù)據(jù)'); else for ( var i in array) ids.push(arrayi.id);/該方法是其他技術(shù)的知識點，直接使用$.post("./userServlet?m=deleteUserInfo","arrayIds":ids,function(flag)if(flag)$("#table").datagrid('reload');elsealert('刪除失敗');) )</scr

39、ipt></head><body><!- 定義對話框 -><div id="myEditDialog" class="easyui-dialog"style="width: 460px; height: 200px" title="修改用戶" modal="true"closable="false" closed="true"><form action="" method=&q

40、uot;post" id="form2"><table><tr><td>用戶名稱</td><td><input id="vv" class="easyui-validatebox" name="username"required="true" /></td><td>密碼</td><td><input class="easyui-validateb

41、ox" name="password"required="true" /></td></tr><tr><td>性別</td><td><select class="easyui-combobox" name="sex"style="width: 150px;"><option value="1">男</option><option value=&qu

42、ot;0">女</option></select></td><td>年齡</td><td><input class="easyui-validatebox" name="age" /></td></tr><tr><td>電話</td><td><input class="easyui-validatebox" name="tel" />

43、</td><td>qq號碼</td><td><input class="easyui-validatebox" name="qq" /></td></tr><tr><td>住址</td><td><input class="easyui-validatebox" name="address" /></td><td>備注</td><td

44、><input class="easyui-validatebox" name="remark" /></td></tr></table></form></div><!- 定義對話框 -><div id="myDialog" class="easyui-dialog"style="width: 460px; height: 200px" title="添加用戶" modal=&qu

45、ot;true"closable="false" closed="true"><form action="" method="post" id="form1"><table><tr><td>用戶名稱</td><td><input class="easyui-validatebox" name="username"required="true"

46、/></td><td>密碼</td><td><input class="easyui-validatebox" name="password"required="true" /></td></tr><tr><td>性別</td><td><select class="easyui-combobox" name="sex" style="width

47、: 150px;"><option value="1">男</option><option value="0">女</option></select></td><td>年齡</td><td><input class="easyui-validatebox" name="age" /></td></tr><tr><td>電話</t

48、d><td><input class="easyui-validatebox" name="tel" /></td><td>qq號碼</td><td><input class="easyui-validatebox" name="qq" /></td></tr><tr><td>住址</td><td><input class="easyui-

49、validatebox" name="address" /></td><td>備注</td><td><input class="easyui-validatebox" name="remark" /></td></tr></table></form></div><table id="table" class="easyui-datagrid"url=&qu

50、ot;/teacherManager/userServlet?m=find" fit="true" fitColumns="true"pagination="true" pagePosition="true"><thead><tr><th data-options="checkbox:true,field:'id',width:80">用戶ID</th><th data-options="field:

51、'userNumber',width:80">用戶編號</th><th data-options="field:'username',width:80">用戶名稱</th><th data-options="field:'sex',width:80">性別</th><th data-options="field:'age',width:80">年齡</th><th d

52、ata-options="field:'password',width:80">密碼</th><th data-options="field:'tel',width:80">電話</th><th data-options="field:'qq',width:80">qq號碼</th><th data-options="field:'address',width:80">住址&

53、lt;/th><th data-options="field:'remark',width:80">備注</th></tr></thead></table></body></html>Index.html<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>index

54、.html</title><link rel="stylesheet" type="text/css"href="jqueryui/themes/default/easyui.css"><link rel="stylesheet" type="text/css" href="jqueryui/themes/icon.css"><script type="text/javascript" src="jque

55、ryui/jquery.min.js"></script><script type="text/javascript" src="jqueryui/jquery.easyui.min.js"></script><script type="text/javascript"src="jqueryui/locale/easyui-lang-zh_CN.js"></script><script type="text/javascri

56、pt">window.history.forward(-1);$(function() /入口函數(shù)/樹形數(shù)據(jù)定義var mydata = text : '系統(tǒng)管理',state : 'closed',/定義樹形是否折疊 默認(rèn)展開children : text : '學(xué)生管理',attributes : /樹的自定義屬性，該屬性主要是用戶點擊樹葉時將頁面顯示在布局控件中間控件中url : 'html/studentList.html', text : '班級管理',attributes : url :

57、 '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,line

58、s : true,onClick : function(node) if (node.attributes) /定義函數(shù)傳遞選項卡面板標(biāo)題的文字以及在選項卡中顯示的頁面openTable(node.text, node.attributes.url);)/處理function openTable(text, url) if ($("#tabs").tabs('exists', text) $("#tabs").tabs('select', text); else /不存在新建選項卡var mycontent = "

59、;<iframe frameborder='0' scrolling='auto' style='width:100%;height:100%' src="+ url + "></iframe>"$("#tabs").tabs('add', title : text,/選項卡漢字標(biāo)題closable : true,/配置選項卡的關(guān)閉按鈕content : mycontent,);)</script></head><body cl

60、ass="easyui-layout"><div region="north" title="教務(wù)管理系統(tǒng)" style="height: 120px" split="true"><h1>教務(wù)管理系統(tǒng)</h1></div><div region="west" title="導(dǎo)航菜單" style="width: 130px" split="true">

61、<!- 編寫菜單 -><div id="tree"></div></div><div region="center" title="顯示數(shù)據(jù)" split="true"><div id="tabs" class="easyui-tabs" fit="true"><div title="首頁"><h1 align="center"

62、>歡迎第二組登錄該系統(tǒng)</h1></div></div></div></body></html>login.html<!DOCTYPE html PUBLIC "-/W3C/DTD HTML 4.01 Transitional/EN" "/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><t