JavaWeb：（练习）十四、基于mybatis框架的简单的学生管理系统
JavaWeb：（练习）十四、基于mybatis框架的简单的学生管理系统
一、说明
基于练习八、练习九、练习十、练习十一、练习十二、练习十三的逐步练习基础上，在实现了一个基于Servlet基础的简单的学生管理系统后，学习了mybatis基础知识后，实现了一个基于mybatis框架的简单的学生管理系统。
练习八链接：JavaWeb：（练习）八、Servlet前端发送数据到后端练习
练习九链接：JavaWeb：（练习）九、Servlet数据交互、XMLHttpRequest、JSON、AJAX、AXIOS练习
练习十链接：JavaWeb：（练习）十、Servlet数据交互与过滤器与Web会话跟踪机制练习
练习十一链接：JavaWeb：（练习）十一、Servlet数据交互与Session技术最终优化练习
练习十二链接：JavaWeb：（练习）十二、简单的学生管理系统
练习十三链接：JavaWeb：（练习）十三、mybatis练习
部分前端及样式素材来源：非凡教育。
学习来源：非凡教育。
获得系统方式：留言或私信，看到就回复
二、目标
通过HTML、CSS、JavaScript等前端技术书写前端界面。
通过JavaSE、MySQL、JSON等后端技术书写后端内容。
通过Servlet、Tomcat、Ajax、axios、mybatis等Web技术书写Web项目。
完成一个简单的学生管理系统，系统内包含管理员和学生两个用户，但只有管理员的登录界面，管理员可以登录和退出系统，可以对学生信息进行增删改查。
三、系统获得方式
获得系统方式：留言或私信，看到就回复
四、系统测试及演示
1、登陆演示
1）登陆展示
2）空账号密码登录
3）错误账号
4）错误密码
2、系统主页面演示
1）系统主界面
3、查看学生列表演示
1）学生信息展示及管理
4、添加学生演示
1）添加学生界面
2）添加空学生信息
3）添加已存在学生信息
4）添加成功
5）添加后跳转展示
5、修改学生演示
1）修改学生界面
2）修改为空学生信息
3）修改成功
4）修改后跳转展示
6、删除学生演示
1）删除学生
2）删除成功
3）删除后刷新展示
7、查询学生演示
1）按学号查询
2）查询不存在学生
3）按日期查询，日期格式有要求，否则查询不出
五、数据库设计
1、数据库创建
CREATE DATABASE StudentManageDB;
2、管理员表
CREATE TABLE USER(
user_id INT AUTO_INCREMENT,
user_account VARCHAR(20) NOT NULL,
user_password VARCHAR(20) NOT NULL,
PRIMARY KEY(user_id)
);
3、年级表
CREATE TABLE grade(
grade_id INT AUTO_INCREMENT,
grade_name VARCHAR(20) NOT NULL,
PRIMARY KEY(grade_id)
);
4、学生表
CREATE TABLE student(
student_id INT AUTO_INCREMENT,
student_number VARCHAR(20) NOT NULL,
student_name VARCHAR(10) NOT NULL,
student_gender VARCHAR(2) NOT NULL,
student_grade INT,
student_phone VARCHAR(11),
student_address VARCHAR(100),
student_date DATE,
student_operator INT,
PRIMARY KEY(student_id)
);
ALTER TABLE student ADD CONSTRAINT fk_student_grade_id FOREIGN KEY(student_grade) REFERENCES grade(grade_id);
ALTER TABLE student ADD CONSTRAINT fk_student_operator_id FOREIGN KEY(student_operator) REFERENCES USER(user_id);
六、前端设计
1、登录界面设计
1）HTML
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>后台管理</title>
<link href="css/login.css" rel="stylesheet" type="text/css" />
<script src="js/axios.min.js" type="text/javascript"></script>
<script src="js/common.js" type="text/javascript"> </script>
<script src="js/LoginJavaScript.js" type="text/javascript"> </script>
</head>
<body>
<div class="login_box">
<div class="login_l_img"><img src="img/login-img.png" /></div>
<div class="login">
<div class="login_logo"><a href="#"><img src="img/login_logo.png" /></a></div>
<div class="login_name">
<p>后台管理系统</p>
</div>
<form method="post">
<input id="account_id" type="text" placeholder="账号" value="admin">
<input id="password_id" type="password" placeholder="密码" value="admin"/>
<input value="登录" style="width:100%;" type="button" onclick="login()">
</form>
</div>
<div class="copyright">某某有限公司 版权所有©2016-2018 技术支持电话：000-00000000</div>
</div>
</body>
</html>
2）CSS
@charset "utf-8";
/* CSS Document */
* { font: 13px/1.5 '微软雅黑'; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -box-sizing: border-box; padding:0; margin:0; list-style:none; box-sizing: border-box; }
body, html { height:100%; overflow:hidden; }
body { background:#93defe; background-size: cover; }
a { color:#27A9E3; text-decoration:none; cursor:pointer; }
img{ border:none;}
.login_box{ width:1100px; margin:120px auto 0;min-width:800px;}
.login_box .login_l_img{ float:left; width:432px; height:440px; margin-left:50px;}
.login_box .login_l_img img{width:500px; height:440px; }
.login {height:360px; width:400px; padding:50px; background-color: #ffffff;border-radius:6px;box-sizing: border-box; float:right; margin-right:50px; position:relative; margin-top:50px;}
.login_logo{ width:120px; height:120px; border:5px solid #93defe;border-radius:100px; background:#fff; text-align:center; line-height:110px; position:absolute; top:-60px; right:140px;}
.login_name{ width:100%; float:left; text-align:center; margin-top:20px;}
.login_name p{ width:100%; text-align:center; font-size:18px; color:#444; padding:10px 0 20px;}
.login_logo img{ width:60px; height:60px;display: inline-block; vertical-align: middle;}
input[type=text], input[type=file], input[type=password], input[type=email], select { border: 1px solid #DCDEE0; vertical-align: middle; border-radius: 3px; height: 50px; padding: 0px 16px; font-size: 14px; color: #555555; outline:none; width:100%;margin-bottom: 15px;line-height:50px; color:#888;}
input[type=text]:focus, input[type=file]:focus, input[type=password]:focus, input[type=email]:focus, select:focus { border: 1px solid #27A9E3; }
input[type=submit], input[type=button] { display: inline-block; vertical-align: middle; padding: 12px 24px; margin: 0px; font-size:16px; line-height: 24px; text-align: center; white-space: nowrap; vertical-align: middle; cursor: pointer; color: #ffffff; background-color: #27A9E3; border-radius: 3px; border: none; -webkit-appearance: none; outline:none; width:100%; }
.copyright { font-size:14px; color:#fff; display:block;width:100%; float:left; text-align:center; margin-top:60px;}
#password_text{border: 1px solid #DCDEE0; vertical-align: middle; border-radius: 3px; height: 50px; padding: 0px 16px; font-size: 14px; color: #888; outline:none; width:100%;margin-bottom: 15px;display: block; line-height:50px;}
3）JavaScript
// 判断账户输入是否为空或大于十五
function accountIsEnptyOrMore() {
var value = document.getElementById("account_id").value;
var tips = document.getElementById("account_tips_id");
if (value.length == 0 || value.length > 15) {
tips.style.color = "red";
tips.innerHTML = "为空或长度大于十五"
} else {
tips.style.color = "green";
tips.innerHTML = "√";
}
}
// 判断密码输入是否为空或大于十五
function passwordIsEnptyOrMore() {
var value = document.getElementById("password_id").value;
var tips = document.getElementById("password_tips_id");
if (value.length == 0 || value.length > 15) {
tips.style.color = "red";
tips.innerHTML = "为空或长度大于十五"
} else {
tips.style.color = "green";
tips.innerHTML = "√";
}
}
// 进入注册页面
function registerFrame() {
// document.getElementById("register_body_id").style.backgroundImage = "url('../img/register.png')";
location.assign("register.html");
}
function returnLogin() {
// document.getElementById("login_body_id").style.backgroundImage = "url('../img/bgimg.png')";
location.assign("login.html");
}
// 执行注册
function register() {
var accountObj = document.getElementById("account_id");
var passwordObj = document.getElementById("password_id");
axios.get(serverPath + "/register?account=" + accountObj.value + "&password=" + passwordObj.value)
.then( function(resp) {
if (resp.data == 1) {
alert("该用户已被注册！");
accountObj.value = "";
passwordObj.value = "";
} else {
alert("注册成功");
location.replace("login.html");
}
} );
}
// 登录
function login() {
var accountObj = document.getElementById("account_id");
var passwordObj = document.getElementById("password_id");
axios.get(serverPath + "/user?mark=login&account=" + accountObj.value + "&password=" + passwordObj.value)
.then( function(resp) {
if (resp.data == 2) {
alert("用户不存在");
accountObj.value = "";
passwordObj.value = "";
} else if (resp.data == 3) {
alert("账号密码错误");
accountObj.value = "";
passwordObj.value = "";
} else {
sessionStorage.setItem("id",resp.data.userId);
sessionStorage.setItem("account",resp.data.userAccount);
sessionStorage.setItem("password",resp.data.userPassword);
location.replace("main.html");
}
} );
}
2、系统主界面设计
1）HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>信息管理系统界面</title>
<link href="css/back.css" rel="stylesheet" type="text/css" />
<script src="js/axios.min.js" type="text/javascript"></script>
<script src="js/common.js" type="text/javascript"> </script>
<script src="./js/MainJavaScript.js" type="text/javascript"> </script>
<style type="text/css">
*{
margin: 0px;
padding: 0px;
}
</style>
</head>
<body onload="loadMain()">
<table border="1" cellspacing="0" cellpadding="0" width="100%" height="100%">
<tr style="background:url(img/backimg/topbg.gif) repeat-x;">
<td colspan="2">
<div class="topleft">
<img src="img/backimg/logo.png" title="系统首页" />
</div>
<div class="topright">
<ul>
<li><a href="" target="_parent" onclick="logOut()">退出</a></li>
</ul>
<div class="user">
<span id="account_id"></span>
</div>
</div>
</td>
</tr>
<tr>
<td width="187" valign="top" height="100%" style="background:#f0f9fd;">
<div class="lefttop"><span></span>操作菜单</div>
<dl class="leftmenu">
<dd>
<div class="title">
<span><img src="img/backimg/leftico01.png" /></span>
<a href="">管理信息</a>
</div>
<ul class="menuson">
<li><cite></cite>
<a href="student/list.html" target="rightFrame">学生管理</a>
</li>
<li><cite></cite>
<a href="studentShow/list.html" target="rightFrame">信息管理</a>
</li>
<li><cite></cite>
<a href="studentShow/list.html" target="rightFrame">信息管理</a>
</li>
</ul>
</dd>
</dl>
</td>
<td>
<iframe name="rightFrame" src="mainFrame.html" width="100%" height="600"></iframe>
</td>
</tr>
</table>
</body>
</html>
2）CSS
@charset "utf-8";
/* CSS Document */
/***
* uimaker
* http://www.uimaker.com
* e-mail: admin@uimaker.com
*/
*{font-size:9pt;border:0;margin:0;padding:0;}
body{font-family:'微软雅黑'; margin:0 auto;min-width:980px;}
ul{display:block;margin:0;padding:0;list-style:none;}
li{display:block;margin:0;padding:0;list-style: none;}
img{border:0;}
dl,dt,dd,span{margin:0;padding:0;display:block;}
a,a:focus{text-decoration:none;color:#000;outline:none;blr:expression(this.onFocus=this.blur());}
a:hover{color:#00a4ac;text-decoration:none;}
table{border-collapse:collapse;border-spacing: 0;}
cite{font-style:normal;}
h2{font-weight:normal;}
/*cloud*/
#mainBody {width:100%;height:100%;position:absolute;z-index:-1;}
.cloud {position:absolute;top:0px;left:0px;width:100%;height:100%;background:url(../img/backimg/cloud.png) no-repeat;z-index:1;opacity:0.5;}
#cloud2 {z-index:2;}
/*login*/
.logintop{height:47px; position:absolute; top:0; background:url(../img/backimg/loginbg1.png) repeat-x;z-index:100; width:100%;}
.logintop span{color:#fff; line-height:47px; background:url(../img/backimg/loginsj.png) no-repeat 21px 18px; text-indent:44px; color:#afc5d2; float:left;}
.logintop ul{float:right; padding-right:30px;}
.logintop ul li{float:left; margin-left:20px; line-height:47px;}
.logintop ul li a{color:#afc5d2;}
.logintop ul li a:hover{color:#fff;}
.loginbody{background:url(../img/backimg/loginbg3.png) no-repeat center center; width:100%; height:585px; overflow:hidden; position:absolute; top:47px;}
.systemlogo{background:url(../img/backimg/loginlogo.png) no-repeat center;width:100%; height:71px; margin-top:75px;}
.loginbox{width:692px; height:336px; background:url(../img/backimg/logininfo.png) no-repeat; margin-top:30px;}
.loginbox ul{margin-top:88px; margin-left:285px;}
.loginbox ul li{margin-bottom:25px;}
.loginbox ul li label{color:#687f92; padding-left:25px;}
.loginbox ul li label a{color:#687f92;}
.loginbox ul li label a:hover{color:#3d96c9;}
.loginbox ul li label input{margin-right:5px;}
.loginuser{width:299px; height:48px; background:url(../img/backimg/loginuser.png) no-repeat; border:none; line-height:48px; padding-left:44px; font-size:14px; font-weight:bold;}
.loginpwd{width:299px; height:48px; background:url(../img/backimg/loginpassword.png) no-repeat; border:none;line-height:48px; padding-left:44px; font-size:14px; color:#90a2bc;}
.loginbtn{width:111px;height:35px; background:url(../img/backimg/buttonbg.png) repeat-x; font-size:14px; font-weight:bold; color:#fff;cursor:pointer; line-height:35px;}
.loginbm{height:50px; line-height:50px; text-align:center; background:url(../img/backimg/loginbg2.png) repeat-x;position:absolute; bottom:0; width:100%; color:#0b3a58;}
.loginbm a{font-weight:bold;color:#0b3a58;}
.loginbm a:hover{color:#fff;}
/*top.html*/
.header{height:88px;}
.topleft{height:88px;background:url(../img/backimg/topleft.jpg) no-repeat;float:left; width:300px;}
.topleft img{margin-top:12px;margin-left:10px;}
.topright{height:88px;background:url(../img/backimg/topright.jpg) no-repeat right;float:right;}
.nav{float:left;}
.nav li{float:left;width:87px;height:88px; text-align:center;}
.nav li a{display:block;width:87px;height:88px;-moz-transition: none; transition: background-color 0.3s linear; -moz-transition: background-color 0.3s linear; -webkit-transition: background-color 0.3s linear; -o-transition: background-color 0.3s linear; }
.nav li a.selected{background:url(../img/backimg/navbg.png) no-repeat;}
.nav li a:hover{display:block;background:#000;color:#fff;background: none repeat scroll 0% 0% rgb(43, 127, 181);}
.nav li img{margin-top:10px;}
.nav li a{display:block;}
.nav a h2{font-size:14px;color:#d6e8f1;}
.nav a:hover h2{color:#fff;}
.topright ul{padding-top:15px; float:right; padding-right:12px;}
.topright ul li{float:left; padding-left:9px; padding-right:9px; background:url(../img/backimg/line.gif) no-repeat right;}
.topright ul li:last-child{background:none;}
.topright ul li a{font-size:13px; color:#e9f2f7;}
.topright ul li a:hover{color:#fff;}
.topright ul li span{margin-top:2px;float:left;padding-right:3px;}
.user{height:30px;background:url(../img/backimg/ub1.png) repeat-x;clear:both;margin-top:10px;float:right; margin-right:12px;border-radius:30px; white-space:nowrap;position:relative;}
.user span{display:inline-block;padding-right:10px; background:url(../img/backimg/user.png) no-repeat 15px 10px; line-height:30px; font-size:14px;color:#b8ceda; padding-left:20px; padding-left:35px;}
.user b{display:inline-block;width:20px;height:18px; background:url(../img/backimg/msg.png);text-align:center; font-weight:normal; color:#fff;font-size:14px;margin-right:13px; margin-top:7px; line-height:18px;}
.user i{display:inline-block;margin-right:5px;font-style:normal;line-height:30px; font-size:14px;color:#b8ceda;}
/*left.html*/
.lefttop{background:url(../img/backimg/lefttop.gif) repeat-x;height:40px;color:#fff;font-size:14px;line-height:40px;}
.lefttop span{margin-left:8px; margin-top:10px;margin-right:8px; background:url(../img/backimg/leftico.png) no-repeat; width:20px; height:21px;float:left;}
.leftmenu{width:187px; overflow:hidden; background:url(../img/backimg/leftline.gif) repeat-y right;}
.leftmenu dd{background:url(../img/backimg/leftmenubg.gif) repeat-x;line-height:35px;font-weight:bold;font-size:14px;border-right:solid 1px #b7d5df;}
.leftmenu dd span{float:left;margin:10px 8px 0 12px;}
.leftmenu dd .menuson{display:none;}
.leftmenu dd:first-child .menuson{display:block;}
.menuson {line-height:30px; font-weight:normal; }
.menuson li{cursor:pointer;}
.menuson li.active{position:relative; background:url(../img/backimg/libg.png) repeat-x; line-height:30px; color:#fff;}
.menuson li cite{display:block; float:left; margin-left:32px; background:url(../img/backimg/list.gif) no-repeat; width:16px; height:16px; margin-top:7px;}
.menuson li.active cite{background:url(../img/backimg/list1.gif) no-repeat;}
.menuson li.active i{display:block; background:url(../img/backimg/sj.png) no-repeat; width:6px; height:11px; position:absolute; right:0;z-index:10000; top:9px; right:-1px;}
.menuson li a{ display:block; *display:inline; *padding-top:5px;}
.menuson li.active a{color:#fff;}
.title{cursor:pointer;}
/*right.html*/
.place{height:40px; background:url(../img/backimg/righttop.gif) repeat-x;}
.place span{line-height:40px; font-weight:bold;float:left; margin-left:12px;}
.placeul li{float:left; line-height:40px; padding-left:7px; padding-right:12px; background:url(../img/backimg/rlist.gif) no-repeat right;}
.placeul li:last-child{background:none;}
.rightinfo{padding:8px;}
.tools{clear:both; height:35px; margin-bottom:8px;}
.toolbar{float:left;}
.toolbar li{background:url(../img/backimg/toolbg.gif) repeat-x; line-height:33px; height:33px; border:solid 1px #d3dbde; float:left; padding-right:10px; margin-right:5px;border-radius: 3px; cursor:pointer;}
.toolbar li span{float:left; margin-left:10px; margin-right:5px; margin-top:5px;}
.toolbar1{float:right;}
.toolbar1 li{background:url(../img/backimg/toolbg.gif) repeat-x; line-height:33px; height:33px; border:solid 1px #d3dbde; float:left; padding-right:10px; margin-left:5px;border-radius: 3px; }
.toolbar1 li span{float:left; margin-left:10px; margin-right:5px; margin-top:5px;}
.tablelist{border:solid 1px #cbcbcb; width:100%; clear:both;}
.tablelist th{background:url(../img/backimg/th.gif) repeat-x; height:34px; line-height:34px; border-bottom:solid 1px #b6cad2; text-indent:11px; text-align:left;}
.tablelist td{line-height:35px; text-indent:11px; border-right: dotted 1px #c7c7c7;}
.tablelink{color:#056dae;}
.tablelist tbody tr.odd{background:#f5f8fa;}
.tablelist tbody tr:hover{background:#e5ebee;}
.sort{padding-left:3px;}
/*page*/
.pagin{position:relative;margin-top:10px;padding:0 12px;}
.pagin .blue{color:#056dae;font-style:normal;}
.pagin .paginList{position:absolute;right:12px;top:0;}
.pagin .paginList .paginItem{float:left;}
.pagin .paginList .paginItem a{float:left;width:31px;height:28px;border:1px solid #DDD; text-align:center;line-height:30px;border-left:none;color:#3399d5;}
.pagin .paginList .paginItem:first-child a{border-left:1px solid #DDD;}
.pagin .paginList .paginItem:first-child a{border-bottom-left-radius:5px;border-top-left-radius:5px;}
.pagin .paginList .paginItem:last-child a{border-bottom-right-radius:5px;border-top-right-radius:5px;}
.pagin .paginList .paginItem.current,.pagin .paginList .paginItem.current a{background:#f5f5f5; cursor:default;color:#737373;}
.pagin .paginList .paginItem:hover{background:#f5f5f5;}
.pagin .paginList .paginItem.more,.pagin .paginList .paginItem.more a:hover{ cursor:default;}
.pagin .paginList .paginItem.more:hover{background:#FFF;}
.pagin .paginList .paginItem.more a{color:#737373;}
.pagepre{background:url(../img/backimg/pre.gif) no-repeat center center; width:31px; height:28px;}
.pagenxt{background:url(../img/backimg/next.gif) no-repeat center center; width:31px; height:28px;}
/*index*/
.mainindex{padding:20px; overflow:hidden;}
.welinfo{height:32px; line-height:32px; padding-bottom:8px;}
.welinfo span{float:left;}
.welinfo b{padding-left:8px;}
.welinfo a{padding-left:15px;color:#3186c8;}
.welinfo a:hover{color:#F60;}
.welinfo i{font-style:normal; padding-left:8px;}
.xline{border-bottom:solid 1px #dfe9ee; height:5px;}
.iconlist{padding-left:40px; overflow:hidden;}
.iconlist li{text-align:center; float:left; margin-right:25px; margin-top:25px;}
.iconlist li p{line-height:25px;}
.ibox{clear:both; padding-left:40px; padding-top:18px; overflow:hidden; padding-bottom:18px;}
.ibtn{background:url(../img/backimg/ibtnbg.png) repeat-x;border:solid 1px #bfcfe1; height:23px; line-height:23px; display:block; float:left; padding:0 15px; cursor:pointer;}
.ibtn img{margin-top:5px; float:left; padding-right:7px;}
.box{height:15px;}
.infolist{padding-left:40px; padding-bottom:15px;}
.infolist li{ line-height:23px; height:23px; margin-bottom:8px;}
.infolist li span{float:left; display:block; margin-right:10px;}
.uimakerinfo{padding-left:40px; background:url(../img/backimg/search.png) no-repeat 10px 15px; padding-top:15px; padding-bottom:20px;}
.umlist{padding-left:40px;}
.umlist li{float:left; background:url(../img/backimg/ulist.png) no-repeat 0 5px; padding-left:10px; margin-right:15px;}
/*default*/
.mainbox{padding:8px;position:relative;}
.mainleft{padding-right:298px;}
.leftinfo{border:#d3dbde solid 1px; height:290px;}
.mainright{width:298px;position:absolute; top:8px; right:8px;}
.dflist{border:#d3dbde solid 1px; width:288px; height:290px; float:right;}
.dflist1{border:#d3dbde solid 1px; width:288px; height:238px; float:right; margin-top:8px;}
.listtitle{background:url(../img/backimg/tbg.png) repeat-x; height:36px; line-height:36px; border-bottom:solid 1px #d3dbde; text-indent:14px; font-weight:bold; font-size:14px;}
.more1{float:right; font-weight:normal;color:#307fb1; padding-right:17px;}
.maintj{text-align:center;}
.newlist{padding-left:14px; padding-top:15px;}
.newlist li{line-height:25px; background:url(../img/backimg/list2.png) no-repeat 0px 8px; text-indent:11px;}
.newlist i{width:80px; display:block; float:left; font-style:normal;}
.newlist b{font-weight:normal; color:#7b7b7b; padding-left:10px;}
.leftinfos{height:238px;margin-top:8px;}
.infoleft{border:#d3dbde solid 1px; float:left;height:238px;}
.inforight{border:#d3dbde solid 1px; float:right;height:238px; }
.tooli{padding:30px 20px;}
.tooli li{float:left;padding-left:15px; padding-right:15px;margin-bottom:20px;}
.tooli li span{text-align:center;}
.tooli li p{line-height:35px; text-align:center;}
/*form*/
.formbody{padding:10px 18px;}
.formtitle{border-bottom:solid 1px #d0dee5; line-height:35px; position:relative; height:35px; margin-bottom:28px;}
.formtitle span{font-weight:bold;font-size:14px; border-bottom:solid 3px #66c9f3;float:left; position:absolute; z-index:100; bottom:-1px; padding:0 3px; height:30px; line-height:30px;}
.forminfo{padding-left:23px;}
.forminfo li{margin-bottom:13px; clear:both;}
.forminfo li label{width:86px;line-height:34px; display:block; float:left;}
.forminfo li i{color:#7f7f7f; padding-left:20px; font-style:normal;}
.forminfo li cite{display:block; padding-top:10px;}
.dfinput{width:345px; height:32px; line-height:32px; border-top:solid 1px #a7b5bc; border-left:solid 1px #a7b5bc; border-right:solid 1px #ced9df; border-bottom:solid 1px #ced9df; background:url(../img/backimg/inputbg.gif) repeat-x; text-indent:10px;}
.textinput{border-top:solid 1px #a7b5bc; border-left:solid 1px #a7b5bc; border-right:solid 1px #ced9df; border-bottom:solid 1px #ced9df; background:url(../img/backimg/inputbg.gif) repeat-x; padding:10px; width:504px; height:135px; line-height:20px; overflow:hidden;}
.btn{width:137px;height:35px; background:url(../img/backimg/btnbg.png) no-repeat; font-size:14px;font-weight:bold;color:#fff; cursor:pointer;}
/*tip*/
.tip{width:485px; height:260px; position:absolute;top:10%; left:30%;background:#fcfdfd;box-shadow:1px 8px 10px 1px #9b9b9b;border-radius:1px; display:none; z-index:111111;}
.tiptop{height:40px; line-height:40px; background:url(../img/backimg/tcbg.gif) repeat-x; cursor:pointer;}
.tiptop span{font-size:14px; font-weight:bold; color:#fff;float:left; text-indent:20px;}
.tiptop a{display:block; background:url(../img/backimg/close.png) no-repeat; width:22px; height:22px;float:right;margin-right:7px; margin-top:10px; cursor:pointer;}
.tiptop a:hover{background:url(../img/backimg/close1.png) no-repeat;}
.tipinfo{padding-top:30px;margin-left:65px; height:95px;}
.tipinfo span{width:95px; height:95px;float:left;}
.tipright{float:left;padding-top:15px; padding-left:10px;}
.tipright p{font-size:14px; font-weight:bold; line-height:35px;}
.tipright cite{color:#858686;}
.tipbtn{margin-top:25px; margin-left:125px;}
.sure ,.cancel{width:96px; height:35px; line-height:35px; color:#fff; background:url(../img/backimg/btnbg1.png) repeat-x; font-size:14px; font-weight:bold;border-radius: 3px; cursor:pointer;}
.cancel{background:url(../img/backimg/btnbg2.png) repeat-x;color:#000;font-weight:normal;}
/*tools*/
.toolsli{clear:both; overflow:hidden; margin-bottom:20px;}
.toollist{margin-left:20px; overflow:hidden; float:left;}
.toollist li{width:66px; text-align:center; float:left; margin-right:32px;}
.toollist li a{width:65px; height:65px; background:#fafbfb; border-right:solid 1px #dbdbdb;border-bottom:solid 1px #dbdbdb; display:block;}
.toollist li a:hover{background:#eef4f7;border-right:solid 1px #d0d5d7;border-bottom:solid 1px #d0d5d7;}
.toollist li h2{line-height:35px;}
.tooladd{margin-top:25px; width:20px; height:20px; float:left; display:block;}
/*error 404*/
.error{background:url(../img/backimg/404.png) no-repeat; width:490px; margin-top:75px;padding-top:65px;}
.error h2{font-size:22px; padding-left:154px;}
.error p{padding-left:154px; line-height:35px;color:#717678;}
.reindex{padding-left:154px;}
.reindex a{width:115px; height:35px; font-size:14px; font-weight:bold; color:#fff; background:#3c95c8; display:block; line-height:35px; text-align:center;border-radius: 3px; margin-top:20px;}
/*computer*/
.comtitle{padding:20px; clear:both;}
.comtitle span{width:10px;height:10px; background:url(../img/backimg/clist.png) no-repeat; float:left; background:#fff; padding-top:3px;}
.comtitle h2{font-size:14px; display:block; float:left;color:#2a3e93; background:#fff; padding-left:5px; padding-right:8px;}
.rline{border-bottom:solid 1px #e5ecf0; height:10px; margin-left:50px;}
.disklist{padding-left:20px; padding-right:20px;}
.disklist li{width:275px;_width:270px;float:left; margin-right:10px;height:70px; cursor:pointer; margin-bottom:5px;border:solid 1px #fff;}
.disklist li a{color:#000;}
.disklist li:hover{background:#fcfcfc; border:solid 1px #e5ecf0;}
.dleft{background:url(../img/backimg/c02.png) no-repeat; height:50px; margin-left:12px; float:left; width:50px; margin-top:15px;}
.dleft1{background:url(../img/backimg/c01.png) no-repeat; height:50px; margin-left:12px; float:left; width:50px; margin-top:15px;}
.dleft2{background:url(../img/backimg/c03.png) no-repeat; height:50px; margin-left:12px; float:left; width:50px; margin-top:15px;}
.dright{float:left; margin-left:10px; margin-top:5px;}
.dright h3{font-weight:normal; padding-top:15px;}
.dright p{color:#949494;}
.dinfo{width:189px;height:15px; background:url(../img/backimg/diskbg.png) no-repeat; margin-top:5px; margin-bottom:5px;}
.dinfo span{background:url(../img/backimg/cbg.png) repeat-x; height:15px;}
.filetable{width:100%;}
.filetable thead tr{background:#f5f9fb; line-height:35px;}
.filetable thead tr th{text-align:left; text-indent:15px;font-weight:normal;color:#597190;}
.filetable tbody tr td{text-indent:15px; line-height:23px;}
.filetable tbody tr td img {margin-right:5px;}
.tdlast{text-align:right;}
.filetable tbody tr:hover{background:#f5f8fa; cursor:pointer;}
/*imglist*/
.imglist{clear:both; overflow:hidden; margin-bottom:20px; margin-left:5px;}
.imglist li{width:188px; border:solid 1px #fff;height:199px;float:left; margin-right:8px; margin-bottom:10px; cursor:pointer;}
.imglist li:hover{border:solid 1px #d7e4ea;}
.imglist li span{width:168px; height:126px; margin:8px;}
.imglist li h2{text-align:center; line-height:25px;}
.imglist li p{text-align:center; line-height:17px; background:url(../img/backimg/line1.png) center center no-repeat;}
.imglist li p a{color:#1f7cb6;}
.imglist li p a:hover{color:#F60;}
/*imgtable*/
.imgtable{width:100%;border:solid 1px #cbcbcb; }
.imgtable th{background:url(../img/backimg/th.gif) repeat-x; height:34px; line-height:34px; border-bottom:solid 1px #b6cad2; text-indent:21px; text-align:left;}
.imgtable td{line-height:20px; text-indent:21px; border-right: dotted 1px #c7c7c7;}
.imgtable td img{margin:10px 20px 10px 0;}
.imgtable td p{color:#919191;}
.imgtable td i{font-style:normal; color:#ea2020;}
.imgtd{text-indent:0;}
.imgtable tbody tr.odd{background:#f5f8fa;}
.imgtable tbody tr:hover{background:#e5ebee;}
/*tab*/
.itab{height:36px; border-bottom:solid 1px #d0dee5; position:relative; border-left:solid 1px #d3dbde;}
.itab ul li{float:left;height:37px; line-height:37px; background:url(../img/backimg/itabbg.png) repeat-x; border-right:solid 1px #d3dbde;}
.itab ul li a{font-size:14px; color:#000; padding-left:25px; padding-right:25px;}
.itab ul li a.selected{ height:37px; display:block; background:url(../img/backimg/itabbg1.png) repeat-x; font-weight:bold;}
.tabson{margin:18px 0px;}
.formtext{height:45px; padding-left:25px; line-height:20px; color:#848383;}
.formtext b{color:#d70101;}
.forminfo b{color:#ea2020; padding-left:3px;}
/*class*/
.classlist li{float:left;margin-right:10px;margin-bottom:10px;padding:12px;border:1px solid #ebebeb; background:#fcfcfc;}
.classlist li:hover{border:1px solid #3eafe0; cursor:pointer;}
.classlist li span{float:left;margin-right:18px;border:3px solid #fff;}
.classlist li .lright{float:left;width:150px;}
.classlist li .lright h2{font-size:12px; font-weight:bold;line-height:30px;}
.classlist li .lright p{line-height:20px;}
.enter{display:block;margin-top:5px;width:94px;height:30px;color:#fff;background:#3eafe0;font-weight:bold; border-radius:2px; text-align:center;line-height:30px; cursor:pointer;}
.enter:hover{color:#fff; background:#d98c1d;}
.clear{clear:both;}
/*seachform*/
.seachform{ height:42px;}
.seachform li{float:left; margin-right:15px;}
.seachform li label{padding-right:10px; float:left; line-height:32px;}
.scinput{width:150px; height:32px; line-height:32px; border-top:solid 1px #a7b5bc; border-left:solid 1px #a7b5bc; border-right:solid 1px #ced9df; border-bottom:solid 1px #ced9df; background:url(../img/backimg/inputbg.gif) repeat-x; text-indent:10px;}
.scbtn{width:85px;height:35px; background:url(../img/backimg/btnbg.png) no-repeat center; font-size:14px;font-weight:bold;color:#fff; cursor:pointer;border-radius:3px; behavior:url(js/pie.htc);}
3）JavaScript
function loadMain() {
axios.get(serverPath + "/back/studentManage?mark=show").then(function(resp){
if (resp.data == 4) {
alert("未登录");
location.replace("login.html");
} else {
var account = sessionStorage.getItem("account");
document.getElementById("account_id").innerHTML = account;
}
});
}
function showPassword() {
axios.get(serverPath + "/back/studentManage").then(function(resp){
if (resp.data == 4) {
alert("未登录");
location.replace("login.html");
} else {
var password = sessionStorage.getItem("password");
document.getElementById("password_id").innerHTML = password;
}
});
}
function logOut() {
axios.get(serverPath + "/user").then(function(resp){
sessionStorage.clear();
location.replace("login.html");
});
}
3、初始信息界面设计
1）HTML
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<h1 style="color: red; text-align: center;" >欢迎访问学生信息管理系统</h1>
</body>
</html>
4、学生信息界面设计
1）HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="../css/back.css" rel="stylesheet" type="text/css" />
<link href="../css/myList.css" rel="stylesheet" type="text/css" />
<script src="../js/axios.min.js" type="text/javascript"></script>
<script src="../js/common.js" type="text/javascript"> </script>
<script src="../js/ListJavaScript.js" type="text/javascript"></script>
</head>
<body onload="showStudents()">
<div class="rightinfo">
<!-- 顶部按钮 -->
<div class="tools">
<ul class="toolbar">
<a href="form.html">
<li class="click">
<span><img src="../img/backimg/t01.png" /></span>
添加
</li>
</a>
<li >
<input type="text" id="select_content_id" class="select_content_class" />
<a href="javaScript:void(0)" onclick="showSelectStudents()">
<span ><img src="../img/backimg/search.png" class="select_button_class"/></span>
</a>
<select id="select_type_id" class="select_type_class">
<option value="student_number">学号</option>
<option value="student_name">姓名</option>
<option value="student_gender">性别</option>
<option value="student_grade">年级</option>
<option value="student_phone">电话</option>
<option value="student_address">地址</option>
<option value="student_date">日期</option>
<option value="student_operator">操作员</option>
</select>
</li>
</ul>
</div>
<!--数据列表 -->
<table id="table_id" class="tablelist">
<tr>
<th>编号<i class="sort"><img src="../img/backimg/px.gif" /></i></th>
<th>学号</th>
<th>姓名</th>
<th>性别</th>
<th>年级</th>
<th>电话</th>
<th>地址</th>
<th>日期</th>
<th>操作员</th>
<th>操作</th>
</tr>
</table>
</div>
</body>
</html>
2）CSS
*{
margin: 0;
padding: 0;
}
.select_content_class{
height: 20px;
border: 1px black solid;width: 150px;
}
.select_button_class{
width: 24px;
}
.select_type_class{
width: 60px;
border: 1px black solid;
}
3）JavaScript
function showStudents() {
axios.get(serverPath + "/back/studentManage?mark=showStudents").then(function(resp){
if (resp.data == 4) {
alert("登录失效，请重新登陆");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else {
var s = "";
for (var i = 0; i < resp.data.length; i++) {
s += "<tr" + (i+1) + "'>"
s += "<td>" + (i+1) + "</td>";
s += "<td>" + resp.data[i].studentNumber + "</td>";
s += "<td>" + resp.data[i].studentName + "</td>";
s += "<td>" + resp.data[i].studentGender + "</td>";
s += "<td>" + resp.data[i].grade.gradeName + "</td>";
s += "<td>" + resp.data[i].studentPhone + "</td>";
s += "<td>" + resp.data[i].studentAddress + "</td>";
s += "<td>" + new Date(resp.data[i].studentDate).toLocaleString() + "</td>";
s += "<td>" + resp.data[i].user.userAccount + "</td>";
s += "<td><a href='update.html?id=" + resp.data[i].studentId + "'>修改 </a>";
s += "<a href='javaScript:void(0)' οnclick='daleteStudent(" + resp.data[i].studentId + ")'>删除</a></td>";
s += "</tr>"
}
document.getElementById("table_id").innerHTML += s;
}
})
}
function daleteStudent(studentId) {
var res = confirm("您确定要删除吗？" + studentId);
if (res) {
axios.get(serverPath + "/back/studentManage?mark=deleteStudent&studentId=" + studentId).then(function(resp){
if (resp.data == 4) {
alert("登录失效，请重新登陆");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else if (resp.data == 200) {
alert("删除成功")
location.reload();
} else {
alert("其他错误")
}
})
}
}
// 得到下拉框
function getSelect() {
var Objs = document.getElementById("select_type_id");
var option = Objs.options[Objs.selectedIndex].value
return option;
}
function showSelectStudents() {
var option = getSelect();
var select = document.getElementById("select_content_id").value;
if (select.length == 0) {
alert("查询内容为空")
} else {
axios.get(serverPath + "/back/studentManage?mark=showSelectStudents&option=" + option + "&select=" + select).then(function(resp){
if (resp.data == 4) {
alert("登录失效，请重新登陆");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else {
var s = "<tr>" +
"<th>编号<i class='sort'><img src='../img/backimg/px.gif' /></i></th>" +
"<th>学号</th>" +
"<th>姓名</th>" +
"<th>性别</th>" +
"<th>年级</th>" +
"<th>电话</th>" +
"<th>地址</th>" +
"<th>日期</th>" +
"<th>操作员</th>" +
"<th>操作</th>" +
"</tr>";
for (var i = 0; i < resp.data.length; i++) {
s += "<tr" + (i+1) + "'>"
s += "<td>" + (i+1) + "</td>";
s += "<td>" + resp.data[i].studentNumber + "</td>";
s += "<td>" + resp.data[i].studentName + "</td>";
s += "<td>" + resp.data[i].studentGender + "</td>";
s += "<td>" + resp.data[i].grade.gradeName + "</td>";
s += "<td>" + resp.data[i].studentPhone + "</td>";
s += "<td>" + resp.data[i].studentAddress + "</td>";
s += "<td>" + new Date(resp.data[i].studentDate).toLocaleString() + "</td>";
s += "<td>" + resp.data[i].user.userAccount + "</td>";
s += "<td><a href='update.html?id=" + resp.data[i].studentId + "'>修改 </a>";
s += "<a href='javaScript:void(0)' οnclick='daleteStudent(" + resp.data[i].id + ")'>删除</a></td>";
s += "</tr>"
}
document.getElementById("table_id").innerHTML = s;
}
})
}
}
5、添加学生界面设计
1）HTML
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>添加学生</title>
<link href="../css/back.css" rel="stylesheet" type="text/css" />
<script src="../js/axios.min.js" type="text/javascript" charset="UTF-8"></script>
<script src="../js/common.js" type="text/javascript" charset="UTF-8"> </script>
<script src="../js/FormJavaScript.js" type="text/javascript" charset="UTF-8"></script>
</head>
<body onload="loadGradeOption()">
<div class="formbody">
<div class="formtitle"><span>基本信息</span></div>
<ul class="forminfo">
<li>
<label>学号</label>
<input id="number_id" name="" type="text" class="dfinput" />
</li>
<li>
<label>姓名</label>
<input id="name_id" name="" type="text" class="dfinput" />
</li>
<li>
<label>性别</label>
<input name="gender" type="radio" value="男" checked="checked" />男
<input name="gender" type="radio" value="女" />女
</li>
<li>
<label>年级</label>
<select id="grade_select_id" class="dfinput">
</select>
</li>
<li>
<label>电话</label>
<input id="phone_id" name="" type="text" class="dfinput" />
</li>
<li>
<label>地址</label>
<textarea id="adress_id" name="" cols="" rows="" class="textinput"></textarea>
</li>
<li>
<input name="" type="button" class="btn" value="添加" onclick="addStudent()"/>
</li>
</ul>
</div>
</body>
</html>
2）CSS
与系统主界面使用同一个CSS文件。
3）JavaScript
/*
添加学生
*/
// 加载年级下拉列表
function loadGradeOption() {
axios.get(serverPath + "/back/studentManage?mark=loadGradeOption").then(function(resp){
if (resp.data == 4) {
alert("登录失效，请重新登陆");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else {
var s = "";
for (var i = 0; i < resp.data.length; i++) {
s += "<option value='" + resp.data[i].gradeId + "'>" + resp.data[i].gradeName + "</option>"
}
document.getElementById("grade_select_id").innerHTML += s;
}
})
}
// 得到单选框（性别）
function getGender() {
//通过名字获取 getElementsByName
var obj = document.getElementsByName("gender");
for(var i=0; i<obj.length; i ++){
if(obj[i].checked){
return obj[i].value;
}
}
}
// 得到下拉框（年级）
function getGrade() {
var gradeObjs = document.getElementById("grade_select_id");
var grade = gradeObjs.options[gradeObjs.selectedIndex].value
return grade;
}
// 判断是否为空
function isEmpty(value) {
if (value.length == 0) {
return true;
}
return false;
}
// 添加学生
function addStudent() {
var numberObj = document.getElementById("number_id");
var nameObj = document.getElementById("name_id");
var phoneObj = document.getElementById("phone_id");
var addressObj = document.getElementById("adress_id");
var number = numberObj.value;
var name = nameObj.value;
var gender = getGender();
var grade = getGrade();
var phone = phoneObj.value;
var address = addressObj.value;
var date = new Date;
var time = date.toLocaleDateString();
var operater = sessionStorage.getItem("id");
if (isEmpty(operater)) {
alert("错误：当前管理员未登录");
return;
}
if (isEmpty(number) || isEmpty(name) || isEmpty(grade) || isEmpty(phone) || isEmpty(address)) {
alert("信息填写未完成");
return;
} else {
var message = "?mark=addStudent&number=" + number + "&name=" + name + "&gender=" + gender + "&grade=" + grade + "&phone=" + phone + "&address=" + address + "&date=" + time + "&operater=" + operater;
axios.get(serverPath + "/back/studentManage" + message).then( function(resp) {
if (resp.data == 4) {
alert("登录失效");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else if (resp.data == 5) {
alert("该学生学号已存在");
} else if (resp.data == 200) {
alert("成功添加");
location.replace("list.html");
} else {
alert("其他错误");
}
} );
}
}
/*
修改学生信息
*/
// 展示将要修改的学生信息
function showStudent() {
// 得到学生信息
var studentId = location.href.split("=")[1];
axios.get(serverPath + "/back/studentManage?mark=showStudent&studentID=" + studentId).then(function(resp){
if (resp.data == 4) {
alert("登录失效，请重新登陆");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else {
// 展示学生信息
var studentIdObj = document.getElementById("studentId_id");
var numberObj = document.getElementById("number_id");
var nameObj = document.getElementById("name_id");
var phoneObj = document.getElementById("phone_id");
var addressObj = document.getElementById("adress_id");
studentIdObj.value = resp.data.studentId;
numberObj.value = resp.data.studentNumber;
nameObj.value = resp.data.studentName;
phoneObj.value = resp.data.studentPhone;
addressObj.value = resp.data.studentAddress;
var genderObjs = document.getElementsByName("gender");
if (resp.data.studentGender == "男") {
genderObjs[0].checked = true;
} else {
genderObjs[1].checked = true;
}
var gradeId = resp.data.grade.gradeId;
// 得到年级下拉列表
axios.get(serverPath + "/back/studentManage?mark=loadGradeOption").then(function(resp){
if (resp.data == 4) {
alert("登录失效，请重新登陆");
window.parent.location.replace("../login.html");
} else if (resp.data == 500) {
alert("查询失败");
} else {
var s = "";
for (var i = 0; i < resp.data.length; i++) {
if ( resp.data[i].gradeId == gradeId ) {
s += "<option value='" + resp.data[i].gradeId + "' selected >" + resp.data[i].gradeName + "</option>"
} else {
s += "<option value='" + resp.data[i].gradeId + "'>" + resp.data[i].gradeName + "</option>"
}
}
document.getElementById("grade_select_id").innerHTML += s;
return;
}
})
}
})
}
// 修改学生信息
function updateStudent() {
var idObj = document.getElementById("studentId_id");
var numberObj = document.getElementById("number_id");
var nameObj = document.getElementById("name_id");
var phoneObj = document.getElementById("phone_id");
var adressObj = document.getElementById("adress_id");
var id = idObj.value;
var number = numberObj.value;
var name = nameObj.value;
var gender = getGender();
var grade = getGrade();
var phone = phoneObj.value;
var adress = adressObj.value;
var date = new Date;
var time = date.toLocaleDateString();
var operater = sessionStorage.getItem("id");
if (isEmpty(operater)) {
alert("错误：当前管理员未登录");
return;
}
if (isEmpty(number) || isEmpty(name) || isEmpty(grade) || isEmpty(phone) || isEmpty(adress)) {
alert("信息填写未完成");
return;
} else {
var message = "?mark=updateStudent&studentId=" + id +"&number=" + number + "&name=" + name + "&gender=" + gender + "&grade=" + grade + "&phone=" + phone + "&adress=" + adress + "&date=" + time + "&operater=" + operater;
axios.get(serverPath + "/back/studentManage" + message).then( function(resp) {
if (resp.data == 4) {
alert("登录失效");
} else if (resp.data == 500) {
alert("修改失败");
} else if (resp.data == 6) {
alert("修改失败");
} else if (resp.data == 200) {
alert("修改成功");
location.replace("list.html");
} else {
alert("其他错误");
}
} );
}
}
6、修改学生信息界面设计
1）HTML
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>修改学生信息</title>
<link href="../css/back.css" rel="stylesheet" type="text/css" />
<script src="../js/axios.min.js" type="text/javascript" charset="UTF-8"></script>
<script src="../js/common.js" type="text/javascript" charset="UTF-8"> </script>
<script src="../js/FormJavaScript.js" type="text/javascript"> </script>
</head>
<body onload="showStudent()">
<div class="formbody">
<div class="formtitle"><span>基本信息</span></div>
<ul class="forminfo">
<li>
<label>学号</label>
<input id="studentId_id" type="hidden" />
<input disabled="disabled" id="number_id" name="" type="text" class="dfinput" />
</li>
<li>
<label>姓名</label>
<input id="name_id" name="" type="text" class="dfinput" />
</li>
<li>
<label>性别</label>
<input name="gender" type="radio" value="男" checked="checked" />男
<input name="gender" type="radio" value="女" />女
</li>
<li>
<label>年级</label>
<select id="grade_select_id" class="dfinput">
</select>
</li>
<li>
<label>电话</label>
<input id="phone_id" name="" type="text" class="dfinput" />
</li>
<li>
<label>地址</label>
<textarea id="adress_id" name="" cols="" rows="" class="textinput"></textarea>
</li>
<li>
<input name="" type="button" class="btn" value="修改" onclick="updateStudent()"/>
</li>
</ul>
</div>
</body>
</html>
2）CSS
与系统主界面使用同一个CSS文件。
3）JavaScript
与间接学生界面使用同一个JavaScript文件。
7、其他通用文件
1）axios
!function(e,t){"object"==typeof exports&&"object"==typeof module?module.exports=t():"function"==typeof define&&define.amd?define([],t):"object"==typeof exports?exports.axios=t():e.axios=t()}(this,(function(){return function(e){var t={};function n(r){if(t[r])return t[r].exports;var o=t[r]={i:r,l:!1,exports:{}};return e[r].call(o.exports,o,o.exports,n),o.l=!0,o.exports}return n.m=e,n.c=t,n.d=function(e,t,r){n.o(e,t)||Object.defineProperty(e,t,{enumerable:!0,get:r})},n.r=function(e){"undefined"!=typeof Symbol&&Symbol.toStringTag&&Object.defineProperty(e,Symbol.toStringTag,{value:"Module"}),Object.defineProperty(e,"__esModule",{value:!0})},n.t=function(e,t){if(1&t&&(e=n(e)),8&t)return e;if(4&t&&"object"==typeof e&&e&&e.__esModule)return e;var r=Object.create(null);if(n.r(r),Object.defineProperty(r,"default",{enumerable:!0,value:e}),2&t&&"string"!=typeof e)for(var o in e)n.d(r,o,function(t){return e[t]}.bind(null,o));return r},n.n=function(e){var t=e&&e.__esModule?function(){return e.default}:function(){return e};return n.d(t,"a",t),t},n.o=function(e,t){return Object.prototype.hasOwnProperty.call(e,t)},n.p="",n(n.s=11)}([function(e,t,n){"use strict";var r=n(3),o=Object.prototype.toString;function i(e){return Array.isArray(e)}function s(e){return void 0===e}function a(e){return"[object ArrayBuffer]"===o.call(e)}function u(e){return null!==e&&"object"==typeof e}function c(e){if("[object Object]"!==o.call(e))return!1;var t=Object.getPrototypeOf(e);return null===t||t===Object.prototype}function f(e){return"[object Function]"===o.call(e)}function l(e,t){if(null!=e)if("object"!=typeof e&&(e=[e]),i(e))for(var n=0,r=e.length;n<r;n++)t.call(null,e[n],n,e);else for(var o in e)Object.prototype.hasOwnProperty.call(e,o)&&t.call(null,e[o],o,e)}e.exports={isArray:i,isArrayBuffer:a,isBuffer:function(e){return null!==e&&!s(e)&&null!==e.constructor&&!s(e.constructor)&&"function"==typeof e.constructor.isBuffer&&e.constructor.isBuffer(e)},isFormData:function(e){return"[object FormData]"===o.call(e)},isArrayBufferView:function(e){return"undefined"!=typeof ArrayBuffer&&ArrayBuffer.isView?ArrayBuffer.isView(e):e&&e.buffer&&a(e.buffer)},isString:function(e){return"string"==typeof e},isNumber:function(e){return"number"==typeof e},isObject:u,isPlainObject:c,isUndefined:s,isDate:function(e){return"[object Date]"===o.call(e)},isFile:function(e){return"[object File]"===o.call(e)},isBlob:function(e){return"[object Blob]"===o.call(e)},isFunction:f,isStream:function(e){return u(e)&&f(e.pipe)},isURLSearchParams:function(e){return"[object URLSearchParams]"===o.call(e)},isStandardBrowserEnv:function(){return("undefined"==typeof navigator||"ReactNative"!==navigator.product&&"NativeScript"!==navigator.product&&"NS"!==navigator.product)&&("undefined"!=typeof window&&"undefined"!=typeof document)},forEach:l,merge:function e(){var t={};function n(n,r){c(t[r])&&c(n)?t[r]=e(t[r],n):c(n)?t[r]=e({},n):i(n)?t[r]=n.slice():t[r]=n}for(var r=0,o=arguments.length;r<o;r++)l(arguments[r],n);return t},extend:function(e,t,n){return l(t,(function(t,o){e[o]=n&&"function"==typeof t?r(t,n):t})),e},trim:function(e){return e.trim?e.trim():e.replace(/^\s+|\s+$/g,"")},stripBOM:function(e){return 65279===e.charCodeAt(0)&&(e=e.slice(1)),e}}},function(e,t,n){"use strict";var r=n(0),o=n(17),i=n(5),s={"Content-Type":"application/x-www-form-urlencoded"};function a(e,t){!r.isUndefined(e)&&r.isUndefined(e["Content-Type"])&&(e["Content-Type"]=t)}var u,c={transitional:{silentJSONParsing:!0,forcedJSONParsing:!0,clarifyTimeoutError:!1},adapter:(("undefined"!=typeof XMLHttpRequest||"undefined"!=typeof process&&"[object process]"===Object.prototype.toString.call(process))&&(u=n(6)),u),transformRequest:[function(e,t){return o(t,"Accept"),o(t,"Content-Type"),r.isFormData(e)||r.isArrayBuffer(e)||r.isBuffer(e)||r.isStream(e)||r.isFile(e)||r.isBlob(e)?e:r.isArrayBufferView(e)?e.buffer:r.isURLSearchParams(e)?(a(t,"application/x-www-form-urlencoded;charset=utf-8"),e.toString()):r.isObject(e)||t&&"application/json"===t["Content-Type"]?(a(t,"application/json"),function(e,t,n){if(r.isString(e))try{return(t||JSON.parse)(e),r.trim(e)}catch(e){if("SyntaxError"!==e.name)throw e}return(n||JSON.stringify)(e)}(e)):e}],transformResponse:[function(e){var t=this.transitional||c.transitional,n=t&&t.silentJSONParsing,o=t&&t.forcedJSONParsing,s=!n&&"json"===this.responseType;if(s||o&&r.isString(e)&&e.length)try{return JSON.parse(e)}catch(e){if(s){if("SyntaxError"===e.name)throw i(e,this,"E_JSON_PARSE");throw e}}return e}],timeout:0,xsrfCookieName:"XSRF-TOKEN",xsrfHeaderName:"X-XSRF-TOKEN",maxContentLength:-1,maxBodyLength:-1,validateStatus:function(e){return e>=200&&e<300},headers:{common:{Accept:"application/json, text/plain, */*"}}};r.forEach(["delete","get","head"],(function(e){c.headers[e]={}})),r.forEach(["post","put","patch"],(function(e){c.headers[e]=r.merge(s)})),e.exports=c},function(e,t,n){"use strict";function r(e){this.message=e}r.prototype.toString=function(){return"Cancel"+(this.message?": "+this.message:"")},r.prototype.__CANCEL__=!0,e.exports=r},function(e,t,n){"use strict";e.exports=function(e,t){return function(){for(var n=new Array(arguments.length),r=0;r<n.length;r++)n[r]=arguments[r];return e.apply(t,n)}}},function(e,t,n){"use strict";var r=n(0);function o(e){return encodeURIComponent(e).replace(/%3A/gi,":").replace(/%24/g,"$").replace(/%2C/gi,",").replace(/%20/g,"+").replace(/%5B/gi,"[").replace(/%5D/gi,"]")}e.exports=function(e,t,n){if(!t)return e;var i;if(n)i=n(t);else if(r.isURLSearchParams(t))i=t.toString();else{var s=[];r.forEach(t,(function(e,t){null!=e&&(r.isArray(e)?t+="[]":e=[e],r.forEach(e,(function(e){r.isDate(e)?e=e.toISOString():r.isObject(e)&&(e=JSON.stringify(e)),s.push(o(t)+"="+o(e))})))})),i=s.join("&")}if(i){var a=e.indexOf("#");-1!==a&&(e=e.slice(0,a)),e+=(-1===e.indexOf("?")?"?":"&")+i}return e}},function(e,t,n){"use strict";e.exports=function(e,t,n,r,o){return e.config=t,n&&(e.code=n),e.request=r,e.response=o,e.isAxiosError=!0,e.toJSON=function(){return{message:this.message,name:this.name,description:this.description,number:this.number,fileName:this.fileName,lineNumber:this.lineNumber,columnNumber:this.columnNumber,stack:this.stack,config:this.config,code:this.code,status:this.response&&this.response.status?this.response.status:null}},e}},function(e,t,n){"use strict";var r=n(0),o=n(18),i=n(19),s=n(4),a=n(20),u=n(23),c=n(24),f=n(7),l=n(1),p=n(2);e.exports=function(e){return new Promise((function(t,n){var d,h=e.data,m=e.headers,v=e.responseType;function y(){e.cancelToken&&e.cancelToken.unsubscribe(d),e.signal&&e.signal.removeEventListener("abort",d)}r.isFormData(h)&&delete m["Content-Type"];var g=new XMLHttpRequest;if(e.auth){var b=e.auth.username||"",x=e.auth.password?unescape(encodeURIComponent(e.auth.password)):"";m.Authorization="Basic "+btoa(b+":"+x)}var w=a(e.baseURL,e.url);function E(){if(g){var r="getAllResponseHeaders"in g?u(g.getAllResponseHeaders()):null,i={data:v&&"text"!==v&&"json"!==v?g.response:g.responseText,status:g.status,statusText:g.statusText,headers:r,config:e,request:g};o((function(e){t(e),y()}),(function(e){n(e),y()}),i),g=null}}if(g.open(e.method.toUpperCase(),s(w,e.params,e.paramsSerializer),!0),g.timeout=e.timeout,"onloadend"in g?g.onloadend=E:g.onreadystatechange=function(){g&&4===g.readyState&&(0!==g.status||g.responseURL&&0===g.responseURL.indexOf("file:"))&&setTimeout(E)},g.οnabοrt=function(){g&&(n(f("Request aborted",e,"ECONNABORTED",g)),g=null)},g.οnerrοr=function(){n(f("Network Error",e,null,g)),g=null},g.ontimeout=function(){var t=e.timeout?"timeout of "+e.timeout+"ms exceeded":"timeout exceeded",r=e.transitional||l.transitional;e.timeoutErrorMessage&&(t=e.timeoutErrorMessage),n(f(t,e,r.clarifyTimeoutError?"ETIMEDOUT":"ECONNABORTED",g)),g=null},r.isStandardBrowserEnv()){var O=(e.withCredentials||c(w))&&e.xsrfCookieName?i.read(e.xsrfCookieName):void 0;O&&(m[e.xsrfHeaderName]=O)}"setRequestHeader"in g&&r.forEach(m,(function(e,t){void 0===h&&"content-type"===t.toLowerCase()?delete m[t]:g.setRequestHeader(t,e)})),r.isUndefined(e.withCredentials)||(g.withCredentials=!!e.withCredentials),v&&"json"!==v&&(g.responseType=e.responseType),"function"==typeof e.onDownloadProgress&&g.addEventListener("progress",e.onDownloadProgress),"function"==typeof e.onUploadProgress&&g.upload&&g.upload.addEventListener("progress",e.onUploadProgress),(e.cancelToken||e.signal)&&(d=function(e){g&&(n(!e||e&&e.type?new p("canceled"):e),g.abort(),g=null)},e.cancelToken&&e.cancelToken.subscribe(d),e.signal&&(e.signal.aborted?d():e.signal.addEventListener("abort",d))),h||(h=null),g.send(h)}))}},function(e,t,n){"use strict";var r=n(5);e.exports=function(e,t,n,o,i){var s=new Error(e);return r(s,t,n,o,i)}},function(e,t,n){"use strict";e.exports=function(e){return!(!e||!e.__CANCEL__)}},function(e,t,n){"use strict";var r=n(0);e.exports=function(e,t){t=t||{};var n={};function o(e,t){return r.isPlainObject(e)&&r.isPlainObject(t)?r.merge(e,t):r.isPlainObject(t)?r.merge({},t):r.isArray(t)?t.slice():t}function i(n){return r.isUndefined(t[n])?r.isUndefined(e[n])?void 0:o(void 0,e[n]):o(e[n],t[n])}function s(e){if(!r.isUndefined(t[e]))return o(void 0,t[e])}function a(n){return r.isUndefined(t[n])?r.isUndefined(e[n])?void 0:o(void 0,e[n]):o(void 0,t[n])}function u(n){return n in t?o(e[n],t[n]):n in e?o(void 0,e[n]):void 0}var c={url:s,method:s,data:s,baseURL:a,transformRequest:a,transformResponse:a,paramsSerializer:a,timeout:a,timeoutMessage:a,withCredentials:a,adapter:a,responseType:a,xsrfCookieName:a,xsrfHeaderName:a,onUploadProgress:a,onDownloadProgress:a,decompress:a,maxContentLength:a,maxBodyLength:a,transport:a,httpAgent:a,httpsAgent:a,cancelToken:a,socketPath:a,responseEncoding:a,validateStatus:u};return r.forEach(Object.keys(e).concat(Object.keys(t)),(function(e){var t=c[e]||i,o=t(e);r.isUndefined(o)&&t!==u||(n[e]=o)})),n}},function(e,t){e.exports={version:"0.26.0"}},function(e,t,n){e.exports=n(12)},function(e,t,n){"use strict";var r=n(0),o=n(3),i=n(13),s=n(9);var a=function e(t){var n=new i(t),a=o(i.prototype.request,n);return r.extend(a,i.prototype,n),r.extend(a,n),a.create=function(n){return e(s(t,n))},a}(n(1));a.Axios=i,a.Cancel=n(2),a.CancelToken=n(26),a.isCancel=n(8),a.VERSION=n(10).version,a.all=function(e){return Promise.all(e)},a.spread=n(27),a.isAxiosError=n(28),e.exports=a,e.exports.default=a},function(e,t,n){"use strict";var r=n(0),o=n(4),i=n(14),s=n(15),a=n(9),u=n(25),c=u.validators;function f(e){this.defaults=e,this.interceptors={request:new i,response:new i}}f.prototype.request=function(e,t){"string"==typeof e?(t=t||{}).url=e:t=e||{},(t=a(this.defaults,t)).method?t.method=t.method.toLowerCase():this.defaults.method?t.method=this.defaults.method.toLowerCase():t.method="get";var n=t.transitional;void 0!==n&&u.assertOptions(n,{silentJSONParsing:c.transitional(c.boolean),forcedJSONParsing:c.transitional(c.boolean),clarifyTimeoutError:c.transitional(c.boolean)},!1);var r=[],o=!0;this.interceptors.request.forEach((function(e){"function"==typeof e.runWhen&&!1===e.runWhen(t)||(o=o&&e.synchronous,r.unshift(e.fulfilled,e.rejected))}));var i,f=[];if(this.interceptors.response.forEach((function(e){f.push(e.fulfilled,e.rejected)})),!o){var l=[s,void 0];for(Array.prototype.unshift.apply(l,r),l=l.concat(f),i=Promise.resolve(t);l.length;)i=i.then(l.shift(),l.shift());return i}for(var p=t;r.length;){var d=r.shift(),h=r.shift();try{p=d(p)}catch(e){h(e);break}}try{i=s(p)}catch(e){return Promise.reject(e)}for(;f.length;)i=i.then(f.shift(),f.shift());return i},f.prototype.getUri=function(e){return e=a(this.defaults,e),o(e.url,e.params,e.paramsSerializer).replace(/^\?/,"")},r.forEach(["delete","get","head","options"],(function(e){f.prototype[e]=function(t,n){return this.request(a(n||{},{method:e,url:t,data:(n||{}).data}))}})),r.forEach(["post","put","patch"],(function(e){f.prototype[e]=function(t,n,r){return this.request(a(r||{},{method:e,url:t,data:n}))}})),e.exports=f},function(e,t,n){"use strict";var r=n(0);function o(){this.handlers=[]}o.prototype.use=function(e,t,n){return this.handlers.push({fulfilled:e,rejected:t,synchronous:!!n&&n.synchronous,runWhen:n?n.runWhen:null}),this.handlers.length-1},o.prototype.eject=function(e){this.handlers[e]&&(this.handlers[e]=null)},o.prototype.forEach=function(e){r.forEach(this.handlers,(function(t){null!==t&&e(t)}))},e.exports=o},function(e,t,n){"use strict";var r=n(0),o=n(16),i=n(8),s=n(1),a=n(2);function u(e){if(e.cancelToken&&e.cancelToken.throwIfRequested(),e.signal&&e.signal.aborted)throw new a("canceled")}e.exports=function(e){return u(e),e.headers=e.headers||{},e.data=o.call(e,e.data,e.headers,e.transformRequest),e.headers=r.merge(e.headers.common||{},e.headers[e.method]||{},e.headers),r.forEach(["delete","get","head","post","put","patch","common"],(function(t){delete e.headers[t]})),(e.adapter||s.adapter)(e).then((function(t){return u(e),t.data=o.call(e,t.data,t.headers,e.transformResponse),t}),(function(t){return i(t)||(u(e),t&&t.response&&(t.response.data=o.call(e,t.response.data,t.response.headers,e.transformResponse))),Promise.reject(t)}))}},function(e,t,n){"use strict";var r=n(0),o=n(1);e.exports=function(e,t,n){var i=this||o;return r.forEach(n,(function(n){e=n.call(i,e,t)})),e}},function(e,t,n){"use strict";var r=n(0);e.exports=function(e,t){r.forEach(e,(function(n,r){r!==t&&r.toUpperCase()===t.toUpperCase()&&(e[t]=n,delete e[r])}))}},function(e,t,n){"use strict";var r=n(7);e.exports=function(e,t,n){var o=n.config.validateStatus;n.status&&o&&!o(n.status)?t(r("Request failed with status code "+n.status,n.config,null,n.request,n)):e(n)}},function(e,t,n){"use strict";var r=n(0);e.exports=r.isStandardBrowserEnv()?{write:function(e,t,n,o,i,s){var a=[];a.push(e+"="+encodeURIComponent(t)),r.isNumber(n)&&a.push("expires="+new Date(n).toGMTString()),r.isString(o)&&a.push("path="+o),r.isString(i)&&a.push("domain="+i),!0===s&&a.push("secure"),document.cookie=a.join("; ")},read:function(e){var t=document.cookie.match(new RegExp("(^|;\\s*)("+e+")=([^;]*)"));return t?decodeURIComponent(t[3]):null},remove:function(e){this.write(e,"",Date.now()-864e5)}}:{write:function(){},read:function(){return null},remove:function(){}}},function(e,t,n){"use strict";var r=n(21),o=n(22);e.exports=function(e,t){return e&&!r(t)?o(e,t):t}},function(e,t,n){"use strict";e.exports=function(e){return/^([a-z][a-z\d+\-.]*:)?\/\//i.test(e)}},function(e,t,n){"use strict";e.exports=function(e,t){return t?e.replace(/\/+$/,"")+"/"+t.replace(/^\/+/,""):e}},function(e,t,n){"use strict";var r=n(0),o=["age","authorization","content-length","content-type","etag","expires","from","host","if-modified-since","if-unmodified-since","last-modified","location","max-forwards","proxy-authorization","referer","retry-after","user-agent"];e.exports=function(e){var t,n,i,s={};return e?(r.forEach(e.split("\n"),(function(e){if(i=e.indexOf(":"),t=r.trim(e.substr(0,i)).toLowerCase(),n=r.trim(e.substr(i+1)),t){if(s[t]&&o.indexOf(t)>=0)return;s[t]="set-cookie"===t?(s[t]?s[t]:[]).concat([n]):s[t]?s[t]+", "+n:n}})),s):s}},function(e,t,n){"use strict";var r=n(0);e.exports=r.isStandardBrowserEnv()?function(){var e,t=/(msie|trident)/i.test(navigator.userAgent),n=document.createElement("a");function o(e){var r=e;return t&&(n.setAttribute("href",r),r=n.href),n.setAttribute("href",r),{href:n.href,protocol:n.protocol?n.protocol.replace(/:$/,""):"",host:n.host,search:n.search?n.search.replace(/^\?/,""):"",hash:n.hash?n.hash.replace(/^#/,""):"",hostname:n.hostname,port:n.port,pathname:"/"===n.pathname.charAt(0)?n.pathname:"/"+n.pathname}}return e=o(window.location.href),function(t){var n=r.isString(t)?o(t):t;return n.protocol===e.protocol&&n.host===e.host}}():function(){return!0}},function(e,t,n){"use strict";var r=n(10).version,o={};["object","boolean","number","function","string","symbol"].forEach((function(e,t){o[e]=function(n){return typeof n===e||"a"+(t<1?"n ":" ")+e}}));var i={};o.transitional=function(e,t,n){function o(e,t){return"[Axios v"+r+"] Transitional option '"+e+"'"+t+(n?". "+n:"")}return function(n,r,s){if(!1===e)throw new Error(o(r," has been removed"+(t?" in "+t:"")));return t&&!i[r]&&(i[r]=!0,console.warn(o(r," has been deprecated since v"+t+" and will be removed in the near future"))),!e||e(n,r,s)}},e.exports={assertOptions:function(e,t,n){if("object"!=typeof e)throw new TypeError("options must be an object");for(var r=Object.keys(e),o=r.length;o-- >0;){var i=r[o],s=t[i];if(s){var a=e[i],u=void 0===a||s(a,i,e);if(!0!==u)throw new TypeError("option "+i+" must be "+u)}else if(!0!==n)throw Error("Unknown option "+i)}},validators:o}},function(e,t,n){"use strict";var r=n(2);function o(e){if("function"!=typeof e)throw new TypeError("executor must be a function.");var t;this.promise=new Promise((function(e){t=e}));var n=this;this.promise.then((function(e){if(n._listeners){var t,r=n._listeners.length;for(t=0;t<r;t++)n._listeners[t](e);n._listeners=null}})),this.promise.then=function(e){var t,r=new Promise((function(e){n.subscribe(e),t=e})).then(e);return r.cancel=function(){n.unsubscribe(t)},r},e((function(e){n.reason||(n.reason=new r(e),t(n.reason))}))}o.prototype.throwIfRequested=function(){if(this.reason)throw this.reason},o.prototype.subscribe=function(e){this.reason?e(this.reason):this._listeners?this._listeners.push(e):this._listeners=[e]},o.prototype.unsubscribe=function(e){if(this._listeners){var t=this._listeners.indexOf(e);-1!==t&&this._listeners.splice(t,1)}},o.source=function(){var e;return{token:new o((function(t){e=t})),cancel:e}},e.exports=o},function(e,t,n){"use strict";e.exports=function(e){return function(t){return e.apply(null,t)}}},function(e,t,n){"use strict";var r=n(0);e.exports=function(e){return r.isObject(e)&&!0===e.isAxiosError}}])}));
//# sourceMappingURL=axios.min.map
2）common
var serverPath = "http://127.0.0.1:8080/MybatisHomework";
axios.defaults.withCredentials = true;
七、后端设计
1、Dao包
1）GradeDao
package com.renola.mybatisHomework.dao;
import com.renola.mybatisHomework.model.Grade;
import java.util.List;
public interface GradeDao {
List<Grade> showGradeList();
}
2）StudentDao
package com.renola.mybatisHomework.dao;
import com.renola.mybatisHomework.model.Student;
import com.renola.mybatisHomework.model.User;
import java.util.List;
public interface StudentDao {
// 展示学生信息
List<Student> showStudentList();
int addStudent(Student student);
Student showStudent(Integer id);
int updateStudent(Student webStudent);
int deleteStudent(Integer id);
List<Student> showSelectStudents(Student student);
}
3）UserDao
package com.renola.mybatisHomework.dao;
import com.renola.mybatisHomework.model.User;
public interface UserDao {
// 管理员登录
User checkLogin(User user);
}
2、filter包
1）CorsFilter
package com.renola.studentmanage.filter;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
public class CorsFilter implements Filter {
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain)
throws IOException, ServletException {
HttpServletResponse httpResponse = (HttpServletResponse) servletResponse;
HttpServletRequest httpRequest = (HttpServletRequest) servletRequest;
//允许携带Cookie时不能设置为* 否则前端报错
httpResponse.setHeader("Access-Control-Allow-Origin", httpRequest.getHeader("origin"));//允许所有请求跨域
httpResponse.setHeader("Access-Control-Allow-Methods", "*");//允许跨域的请求方法GET, POST, HEAD 等
httpResponse.setHeader("Access-Control-Allow-Headers", "*");//允许跨域的请求头
httpResponse.setHeader("Access-Control-Allow-Credentials", "true");//是否携带cookie
filterChain.doFilter(servletRequest, servletResponse);
}
}
2）EncodingFilter
package com.renola.studentmanage.filter;
import javax.servlet.*;
import java.io.IOException;
public class EncodingFilter implements Filter {
String charset;
//init()
@Override
public void init(FilterConfig filterConfig) throws ServletException {
charset = filterConfig.getInitParameter("charset");
}
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
servletRequest.setCharacterEncoding(charset);
servletResponse.setCharacterEncoding("utf-8");
filterChain.doFilter(servletRequest,servletResponse);
}
//destroy()
}
3）IsLoginFilter
package com.renola.studentmanage.filter;
import com.renola.studentmanage.model.User;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.io.IOException;
public class IsLoginFilter implements Filter {
@Override
public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
HttpServletRequest request = (HttpServletRequest)servletRequest;
HttpSession session = request.getSession();
User user = (User)session.getAttribute("user");
if (user == null) {
servletResponse.getWriter().print(4); // 状态 4 ：未登录状态
} else {
filterChain.doFilter(servletRequest,servletResponse);
}
}
}
3、model包
1）Grade
package com.renola.mybatisHomework.model;
import java.util.List;
public class Grade {
private int gradeId;
private String gradeName;
private List<Student> students;
public Grade() {
}
public Grade(int gradeId, String gradeName) {
this.gradeId = gradeId;
this.gradeName = gradeName;
}
public int getGradeId() {
return gradeId;
}
public void setGradeId(int gradeId) {
this.gradeId = gradeId;
}
public String getGradeName() {
return gradeName;
}
public void setGradeName(String gradeName) {
this.gradeName = gradeName;
}
public List<Student> getStudents() {
return students;
}
public void setStudents(List<Student> students) {
this.students = students;
}
@Override
public String toString() {
return "Grade{" +
"gradeId=" + gradeId +
", gradeName='" + gradeName + '\'' +
", students=" + students +
'}';
}
}
2）Student
package com.renola.mybatisHomework.model;
import java.util.Date;
public class Student {
private Integer studentId;
private String studentNumber;
private String studentName;
private String studentGender;
private Grade grade;
private String studentPhone;
private String studentAddress;
private Date studentDate;
private User user;
public Student() {
}
public Student(Integer studentId, String studentNumber, String studentName, String studentGender, Grade grade, String studentPhone, String studentAddress, Date studentDate, User user) {
this.studentId = studentId;
this.studentNumber = studentNumber;
this.studentName = studentName;
this.studentGender = studentGender;
this.grade = grade;
this.studentPhone = studentPhone;
this.studentAddress = studentAddress;
this.studentDate = studentDate;
this.user = user;
}
public Integer getStudentId() {
return studentId;
}
public void setStudentId(Integer studentId) {
this.studentId = studentId;
}
public String getStudentNumber() {
return studentNumber;
}
public void setStudentNumber(String studentNumber) {
this.studentNumber = studentNumber;
}
public String getStudentName() {
return studentName;
}
public void setStudentName(String studentName) {
this.studentName = studentName;
}
public String getStudentGender() {
return studentGender;
}
public void setStudentGender(String studentGender) {
this.studentGender = studentGender;
}
public Grade getGrade() {
return grade;
}
public void setGrade(Grade grade) {
this.grade = grade;
}
public String getStudentPhone() {
return studentPhone;
}
public void setStudentPhone(String studentPhone) {
this.studentPhone = studentPhone;
}
public String getStudentAddress() {
return studentAddress;
}
public void setStudentAddress(String studentAddress) {
this.studentAddress = studentAddress;
}
public Date getStudentDate() {
return studentDate;
}
public void setStudentDate(Date studentDate) {
this.studentDate = studentDate;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
@Override
public String toString() {
return "Student{" +
"studentId=" + studentId +
", studentNumber='" + studentNumber + '\'' +
", studentName='" + studentName + '\'' +
", studentGender='" + studentGender + '\'' +
", grade=" + grade +
", studentPhone='" + studentPhone + '\'' +
", studentAddress='" + studentAddress + '\'' +
", studentDate=" + studentDate +
", user=" + user +
'}';
}
}
3）User
package com.renola.mybatisHomework.model;
import java.util.List;
public class User {
private Integer userId;
private String userAccount;
private String userPassword;
private List<Student> students;
public User() {
}
public User(Integer userId, String userAccount, String userPassword, List<Student> students) {
this.userId = userId;
this.userAccount = userAccount;
this.userPassword = userPassword;
this.students = students;
}
public Integer getUserId() {
return userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public String getUserAccount() {
return userAccount;
}
public void setUserAccount(String userAccount) {
this.userAccount = userAccount;
}
public String getUserPassword() {
return userPassword;
}
public void setUserPassword(String userPassword) {
this.userPassword = userPassword;
}
public List<Student> getStudents() {
return students;
}
public void setStudents(List<Student> students) {
this.students = students;
}
@Override
public String toString() {
return "User{" +
"userId=" + userId +
", userAccount='" + userAccount + '\'' +
", userPassword='" + userPassword + '\'' +
", students=" + students +
'}';
}
}
4、service包
1）GradeService
package com.renola.mybatisHomework.service;
public class GradeService {
}
2）StudentService
package com.renola.mybatisHomework.service;
import com.renola.mybatisHomework.dao.GradeDao;
import com.renola.mybatisHomework.dao.StudentDao;
import com.renola.mybatisHomework.dao.UserDao;
import com.renola.mybatisHomework.model.Grade;
import com.renola.mybatisHomework.model.Student;
import com.renola.mybatisHomework.model.User;
import com.renola.mybatisHomework.util.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import javax.servlet.http.HttpServletRequest;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
public class StudentService {
public static List<Student> showStudentList() {
SqlSession sqlSession = MybatisUtil.getSqlSession();
StudentDao studentDao = sqlSession.getMapper(StudentDao.class);
List<Student> students = studentDao.showStudentList();
sqlSession.close();
return students;
}
public static List<Grade> loadGradeOption() {
SqlSession sqlSession = MybatisUtil.getSqlSession();
GradeDao gradeDao = sqlSession.getMapper(GradeDao.class);
List<Grade> grades = gradeDao.showGradeList();
sqlSession.close();
return grades;
}
public static boolean addStudent(HttpServletRequest req) {
SqlSession sqlSession = MybatisUtil.getSqlSession();
StudentDao studentDao = sqlSession.getMapper(StudentDao.class);
Student webStudent = new Student();
webStudent.setStudentNumber( req.getParameter("number") );
webStudent.setStudentName( req.getParameter("name") );
webStudent.setStudentGender( req.getParameter("gender") );
webStudent.setStudentPhone( req.getParameter("phone") );
webStudent.setStudentAddress( req.getParameter("address") );
Date now=new Date();
SimpleDateFormat f=new SimpleDateFormat("yyyy/MM/dd/kk:mm:ss");
webStudent.setStudentDate( new Date(f.format(now) ) );
Grade grade = new Grade();
grade.setGradeId( Integer.parseInt(req.getParameter("grade")) );
webStudent.setGrade( grade );
User user = new User();
user.setUserId( Integer.parseInt( req.getParameter("operater") ));
webStudent.setUser( user );
int count = studentDao.addStudent(webStudent);
sqlSession.commit();
sqlSession.close();
if (count != 0) {
return true;
} else {
return false;
}
}
public static Student showStudent(String studentId) {
SqlSession sqlSession = MybatisUtil.getSqlSession();
StudentDao studentDao = sqlSession.getMapper(StudentDao.class);
Integer id = Integer.parseInt(studentId);
Student student = studentDao.showStudent(id);
return student;
}
public static boolean updateStudent(HttpServletRequest req) {
SqlSession sqlSession = MybatisUtil.getSqlSession();
StudentDao studentDao = sqlSession.getMapper(StudentDao.class);
Student webStudent = new Student();
webStudent.setStudentId( Integer.parseInt(req.getParameter("studentId")) );
webStudent.setStudentNumber( req.getParameter("number") );
webStudent.setStudentName( req.getParameter("name") );
webStudent.setStudentGender( req.getParameter("gender") );
webStudent.setStudentPhone( req.getParameter("phone") );
webStudent.setStudentAddress( req.getParameter("adress") );
Date now=new Date();
SimpleDateFormat f=new SimpleDateFormat("yyyy/MM/dd/kk:mm:ss");
webStudent.setStudentDate( new Date(f.format(now) ) );
Grade grade = new Grade();
grade.setGradeId( Integer.parseInt(req.getParameter("grade")) );
webStudent.setGrade( grade );
User user = new User();
user.setUserId( Integer.parseInt( req.getParameter("operater") ));
webStudent.setUser( user );
int count = studentDao.updateStudent(webStudent);
sqlSession.commit();
sqlSession.close();
if (count != 0) {
return true;
} else {
return false;
}
}
public static boolean deleteStudent(HttpServletRequest req) {
SqlSession sqlSession = MybatisUtil.getSqlSession();
StudentDao studentDao = sqlSession.getMapper(StudentDao.class);
Integer id = Integer.parseInt( req.getParameter("studentId") );
int count = studentDao.deleteStudent(id);
sqlSession.commit();
sqlSession.close();
if (count != 0) {
return true;
} else {
return false;
}
}
public static List<Student> showSelectStudents(String option, String select) {
SqlSession sqlSession = MybatisUtil.getSqlSession();
StudentDao studentDao = sqlSession.getMapper(StudentDao.class);
Student student = new Student();
if ("student_grade".equals(option)) {
Grade grade = new Grade();
grade.setGradeName(select);
student.setGrade(grade);
} else if ("student_operator".equals(option)) {
User user = new User();
user.setUserAccount(select);
student.setUser(user);
} else if("student_number".equals(option)) {
student.setStudentNumber(select);
} else if("student_name".equals(option)) {
student.setStudentName(select);
} else if("student_gender".equals(option)) {
student.setStudentGender(select);
} else if("student_phone".equals(option)) {
student.setStudentPhone(select);
} else if("student_address".equals(option)) {
student.setStudentAddress(select);
} else if("student_date".equals(option)) {
student.setStudentDate(new Date(select));
}
List<Student> students = studentDao.showSelectStudents(student);
sqlSession.close();
return students;
}
}
3）UserService
package com.renola.mybatisHomework.service;
public class UserService {
}
5、servlet包
1）GradeServlet
package com.renola.mybatisHomework.servlet;
import javax.servlet.http.HttpServlet;
public class GradeServlet extends HttpServlet {
}
2）StudentServlet
package com.renola.mybatisHomework.servlet;
import com.google.gson.Gson;
import com.renola.mybatisHomework.model.Grade;
import com.renola.mybatisHomework.model.Student;
import com.renola.mybatisHomework.service.StudentService;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
public class StudentServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/html;charset=UTF-8");
String mark = req.getParameter("mark");
// 展示学生列表
if ("showStudents".equals(mark)) {
showStudentList(req,resp);
}
// 加载年级下拉选项
if ("loadGradeOption".equals(mark)) {
loadGradeOption(req,resp);
}
// 添加学生
if ("addStudent".equals(mark)) {
addStudent(req, resp);
}
// 展示被修改学生的信息
if ("showStudent".equals(mark)) {
String studentId = req.getParameter("studentID");
showStudent(req, resp, studentId);
}
// 更新被修改学生信息
if ("updateStudent".equals(mark)) {
updateStudent(req, resp);
}
// 删除学生
if ("deleteStudent".equals(mark)) {
daleteStduent(req, resp);
}
if ("showSelectStudents".equals(mark)) {
String option = req.getParameter("option");
String select = req.getParameter("select");
showSelectStudents(req, resp, option, select);
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
System.out.println("doPost");
}
private void showStudentList(HttpServletRequest req, HttpServletResponse resp) {
PrintWriter out = null;
try {
out = resp.getWriter();
List<Student> list = StudentService.showStudentList();
out.print( new Gson().toJson( list ));
} catch (Exception e) {
out.print(500); // 状态码 500 ：展示学生列表异常
}
}
private void loadGradeOption(HttpServletRequest req, HttpServletResponse resp) {
PrintWriter out = null;
try {
out = resp.getWriter();
List<Grade> list = StudentService.loadGradeOption();
out.print( new Gson().toJson( list ));
} catch (Exception e) {
out.print(500); // 状态码 500 ：加载年级列表异常
}
}
private void addStudent(HttpServletRequest req, HttpServletResponse resp) {
PrintWriter out = null;
try {
boolean flag = StudentService.addStudent( req );
out = resp.getWriter();
if (flag) {
out.print(200); // 状态 200 ：成功添加学生
} else {
out.print(5); // 状态 5 ：数据库已经包含此学号
}
} catch (Exception e) {
out.print(500); // 状态码 500 ：异常
}
}
private void showStudent(HttpServletRequest req, HttpServletResponse resp, String studentId) {
PrintWriter out = null;
try {
Student student = StudentService.showStudent(studentId);
out = resp.getWriter();
if (student == null) {
out.print(500); // 失败
} else {
out.print( new Gson().toJson(student)); // 状态 200 ：成功查询学生
}
} catch (Exception e) {
out.print(500); // 状态码 500 ：异常
}
}
private void updateStudent(HttpServletRequest req, HttpServletResponse resp) {
PrintWriter out = null;
try {
boolean flag = StudentService.updateStudent( req );
out = resp.getWriter();
if (flag) {
out.print(200); // 状态 200 ：成功修改学生
} else {
out.print(500); // 修改学生信息失败
}
} catch (Exception e) {
out.print(500); // 状态码 500 ：异常
}
}
private void daleteStduent(HttpServletRequest req, HttpServletResponse resp) {
PrintWriter out = null;
try {
boolean flag = StudentService.deleteStudent( req );
out = resp.getWriter();
if (flag) {
out.print(200); // 状态 200 ：成功删除学生
} else {
out.print(500); // 删除学生信息失败
}
} catch (Exception e) {
out.print(500); // 状态码 500 ：异常
}
}
private void showSelectStudents(HttpServletRequest req, HttpServletResponse resp, String option, String select) {
PrintWriter out = null;
try {
out = resp.getWriter();
List<Student> list = StudentService.showSelectStudents(option, select);
out.print( new Gson().toJson( list ));
} catch (Exception e) {
out.print(500); // 状态码 500 ：异常
}
}
}
3）UserServlet
package com.renola.mybatisHomework.servlet;
import com.google.gson.Gson;
import com.renola.mybatisHomework.dao.UserDao;
import com.renola.mybatisHomework.model.User;
import com.renola.mybatisHomework.util.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
public class UserServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
resp.setContentType("text/html;charset=UTF-8");
String mark = req.getParameter("mark");
if ("login".equals(mark)) {
login(req, resp);
}
if ("logOut".equals(mark)) {
logOut(req, resp);
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
System.out.println("doPost");
}
private void login(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String account = req.getParameter("account");
String password = req.getParameter("password");
User webUser = new User();
webUser.setUserAccount(account);
webUser.setUserPassword(password);
System.out.println(webUser);
SqlSession sqlSession = MybatisUtil.getSqlSession();
UserDao userDao = sqlSession.getMapper(UserDao.class);
User user = userDao.checkLogin(webUser);
if (user == null) {
resp.getWriter().println(2); // 状态 2 ：账户不存在
return;
} else {
// 会话机制
HttpSession session = req.getSession();
session.setAttribute("user",user);
// 把 user 对象转为 json 对象，发送给html前端
Gson gson = new Gson();
String json = gson.toJson(user);
resp.getWriter().println(json);
}
}
private void logOut(HttpServletRequest req, HttpServletResponse resp) {
req.getSession().invalidate();
}
}
6、util包
MybatisUtil
package com.renola.mybatisHomework.util;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
public class MybatisUtil {
static SqlSessionFactory sqlSessionFactory;
//在MybatisUtil第一次加载时,初始化好SqlSessionFactory
static {
String resource = "mybatis.xml";
InputStream inputStream = null;
try {
inputStream = Resources.getResourceAsStream(resource);
} catch (IOException e) {
e.printStackTrace();
}
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession();
}
}
7、resources配置文件
1）GradeMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.renola.mybatisHomework.dao.GradeDao">
<cache></cache>
<!-- 展示年级下拉列表 -->
<select id="showGradeList" resultType="Grade" useCache="true">
SELECT * FROM grade
</select>
</mapper>
2）StudentMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.renola.mybatisHomework.dao.StudentDao">
<cache></cache>
<!-- 展示学生信息 -->
<resultMap id="showStudentListMap" type="Student">
<id column="student_id" property="studentId"></id>
<result column="student_number" property="studentNumber"></result>
<result column="student_name" property="studentName"></result>
<result column="student_gender" property="studentGender"></result>
<result column="student_phone" property="studentPhone"></result>
<result column="student_address" property="studentAddress"></result>
<result column="student_date" property="studentDate"></result>
<association property="grade" javaType="Grade">
<result column="grade_id" property="gradeId"></result>
<result column="grade_name" property="gradeName"></result>
</association>
<association property="user" javaType="User">
<result column="user_id" property="userId"></result>
<result column="user_account" property="userAccount"></result>
<result column="user_password" property="userPassword"></result>
</association>
</resultMap>
<select id="showStudentList" resultMap="showStudentListMap">
SELECT s.`student_id`,
s.`student_number`,
s.`student_name`,
s.`student_gender`,
g.`grade_id`,
g.`grade_name`,
s.`student_phone`,
s.`student_address`,
s.`student_date`,
u.`user_id`,
u.`user_account`,
u.`user_password`
FROM student s
LEFT JOIN grade g ON s.student_grade = g.grade_id
LEFT JOIN USER u ON s.student_operator = u.user_id
</select>
<!-- 添加学生 -->
<insert id="addStudent" >
INSERT INTO student
(student_id, student_number, student_name, student_gender, student_grade, student_phone, student_address, student_date, student_operator)
VALUES(NULL, #{studentNumber}, #{studentName}, #{studentGender}, #{grade.gradeId}, #{studentPhone}, #{studentAddress}, #{studentDate}, #{user.userId});
</insert>
<!-- 展示被修改的学生信息 -->
<select id="showStudent" parameterType="int" resultMap="showStudentListMap">
SELECT s.`student_id`,
s.`student_number`,
s.`student_name`,
s.`student_gender`,
g.`grade_id`,
g.`grade_name`,
s.`student_phone`,
s.`student_address`,
s.`student_date`,
u.`user_id`,
u.`user_account`,
u.`user_password`
FROM student s
LEFT JOIN grade g ON s.student_grade = g.grade_id
LEFT JOIN USER u ON s.student_operator = u.user_id
WHERE student_id = #{id}
</select>
<!-- 修改学生 -->
<update id="updateStudent">
update student set
student_number = #{studentNumber},
student_name = #{studentName},
student_gender = #{studentGender},
student_grade = #{grade.gradeId},
student_phone = #{studentPhone},
student_address = #{studentAddress},
student_date = #{studentDate},
student_operator = #{user.userId}
where student_id = #{studentId}
</update>
<!-- 删除学生 -->
<delete id="deleteStudent">
delete from student where student_id = #{id}
</delete>
<!-- 展示条件查询的学生 -->
<select id="showSelectStudents" resultMap="showStudentListMap">
SELECT s.`student_id`,
s.`student_number`,
s.`student_name`,
s.`student_gender`,
g.`grade_id`,
g.`grade_name`,
s.`student_phone`,
s.`student_address`,
s.`student_date`,
u.`user_id`,
u.`user_account`,
u.`user_password`
FROM student s
LEFT JOIN grade g ON s.student_grade = g.grade_id
LEFT JOIN USER u ON s.student_operator = u.user_id
<where>
<if test="studentNumber != null">
and student_number = #{studentNumber}
</if>
<if test="studentName != null">
and student_name = #{studentName}
</if>
<if test="studentGender != null">
and student_gender = #{studentGender}
</if>
<if test="studentPhone != null">
and student_phone = #{studentPhone}
</if>
<if test="studentAddress != null">
and student_address = #{studentAddress}
</if>
<if test="studentDate != null">
and student_date = #{studentDate}
</if>
<if test="grade != null">
and g.`grade_name` = #{grade.gradeName}
</if>
<if test="user != null">
and u.`user_account` = #{user.userAccount}
</if>
</where>
</select>
</mapper>
3）UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.renola.mybatisHomework.dao.UserDao">
<cache></cache>
<!-- 登录 -->
<select id="checkLogin" parameterType="User" resultType="User">
SELECT * FROM user
where user_account = #{userAccount}
and user_password = #{userPassword}
</select>
</mapper>
4）conjig.properties
dirverClassName=com.mysql.cj.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/studentmanagedb?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
username = root
password = root
5）mybatis.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource="config.properties"></properties>
<settings>
<!-- <setting name="logImpl" value="STDOUT_LOGGING"/>-->
<setting name="mapUnderscoreToCamelCase" value="true"/>
<setting name="cacheEnabled" value="true"/>
</settings>
<typeAliases>
<typeAlias type="com.renola.mybatisHomework.model.Grade" alias="Grade"></typeAlias>
<typeAlias type="com.renola.mybatisHomework.model.Student" alias="Student"></typeAlias>
<typeAlias type="com.renola.mybatisHomework.model.User" alias="User"></typeAlias>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${dirverClassName}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mapper/GradeMapper.xml"></mapper>
<mapper resource="mapper/StudentMapper.xml"></mapper>
<mapper resource="mapper/UserMapper.xml"></mapper>
</mappers>
</configuration>
8、其他配置
1）web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
version="4.0">
<!-- 管理员 -->
<servlet>
<servlet-name>user</servlet-name>
<servlet-class>com.renola.mybatisHomework.servlet.UserServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>user</servlet-name>
<url-pattern>/user</url-pattern>
</servlet-mapping>
<!-- 学生 -->
<servlet>
<servlet-name>studentManage</servlet-name>
<servlet-class>com.renola.mybatisHomework.servlet.StudentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>studentManage</servlet-name>
<url-pattern>/back/studentManage</url-pattern>
</servlet-mapping>
<!-- 编码格式过滤器 -->
<filter>
<filter-name>encoding</filter-name>
<filter-class>com.renola.mybatisHomework.filter.EncodingFilter</filter-class>
<init-param>
<param-name>charset</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 跨域过滤器 -->
<filter>
<filter-name>cross</filter-name>
<filter-class>com.renola.mybatisHomework.filter.CorsFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>cross</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 登录状态过滤器 -->
<filter>
<filter-name>isLogOut</filter-name>
<filter-class>com.renola.mybatisHomework.filter.IsLoginFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>isLogOut</filter-name>
<url-pattern>/back/*</url-pattern>
</filter-mapping>
</web-app>
2）pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.example</groupId>
<artifactId>MybatisHomework</artifactId>
<version>1.0</version>
<name>MybatisHomework</name>
<packaging>war</packaging>
<properties>
<maven.compiler.target>1.8</maven.compiler.target>
<maven.compiler.source>1.8</maven.compiler.source>
<junit.version>5.6.2</junit.version>
</properties>
<dependencies>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>
<!-- servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>4.0.1</version>
<scope>provided</scope>
</dependency>
<!-- gson -->
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
<version>2.9.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>3.3.0</version>
</plugin>
</plugins>
</build>
</project>
3）系统环境
java运行环境：jdk1.8
服务器运行环境：Tomcat9.0
八、总结
这一个系统只是在学习阶段的一个练习，其中包含很多不完善的地方。在实现了一个基于Servlet基础的简单的学生管理系统后，学习了mybatis基础知识后，实现了一个基于mybatis框架的简单的学生管理系统。
系统留有一些未完成的功能，如对年级进行管理等。还可以添加学生的界面，添加选课功能等。
业精于勤，荒于嬉。
1912
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
