开发工具：Eclipse
前端技术：
基础：html+css+JavaScript
框架：JQuery+H-ui
后端技术：Spring+SpringMVC+mybatis
模板引擎：JSP
数据库：mysql 5.7.27
jdk版本：1.8.0_251
tomcat版本：Tomcat 9.0
数据库连接池：druid
一、功能概述
学生管理系统的用户包括学生、教师及管理员。
（1）学生可以对个人的各科成绩进行查询、个人信息修改、选课、修改登录密码等操作。
（2）教师可以对学生信息、教师个人信息、课程信息、成绩等进行管理，实现对这些信息的查询、录入、添加、修改、删除等操作。
（3）管理员可以对学生、教师、课程、成绩信息进行管理，实现对这些信息的查询、录入、添加、修改、删除以及权限管理等操作。
功能结构图：
二、数据库表结构
成绩表（Score）：
学生表（student）：
课程表（subject）：
教师表（teacher）：
用户表（user）：
三、项目结构
四、配置SSM文件
Spring-context.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc"
xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:util="http://www.springframework.org/schema/util" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd
http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.0.xsd"
default-lazy-init="true">
<description>Spring Configuration</description>
<context:property-placeholder ignore-unresolvable="true" location="classpath:demo.properties" />
<context:component-scan base-package="com.stusystem.controller">
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="typeAliasesPackage" value="com.stusystem.entity"/>
<property name="mapperLocations" value="classpath:/com/stusystem/mappings/**/*.xml"/>
<property name="configLocation" value="classpath:/mybatis-config.xml"></property>
</bean>
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
<property name="basePackage" value="com.stusystem.dao"/>
</bean>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
<bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean" />
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="initialSize" value="${jdbc.pool.init}" />
<property name="minIdle" value="${jdbc.pool.minIdle}" />
<property name="maxActive" value="${jdbc.pool.maxActive}" />
<property name="maxWait" value="60000" />
<property name="timeBetweenEvictionRunsMillis" value="60000" />
<property name="minEvictableIdleTimeMillis" value="300000" />
<property name="validationQuery" value="${jdbc.testSql}" />
<property name="testWhileIdle" value="true" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<property name="filters" value="stat" />
</bean>
</beans>
Mybatis-config.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>
<settings>
<setting name="cacheEnabled" value="true"/>
<setting name="lazyLoadingEnabled" value="true"/>
<setting name="aggressiveLazyLoading" value="true"/>
<setting name="multipleResultSetsEnabled" value="true"/>
<setting name="useColumnLabel" value="true"/>
<setting name="useGeneratedKeys" value="false"/>
<setting name="autoMappingBehavior" value="PARTIAL"/>
<setting name="defaultExecutorType" value="SIMPLE"/>
<setting name="mapUnderscoreToCamelCase" value="true"/>
<setting name="localCacheScope" value="SESSION"/>
<setting name="jdbcTypeForNull" value="NULL"/>
</settings>
</configuration>
spring-mvc.xml:
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
<description>Spring MVC Configuration</description>
<context:property-placeholder ignore-unresolvable="true" location="classpath:demo.properties" />
<context:component-scan base-package="com.stusystem" use-default-filters="false">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<mvc:annotation-driven content-negotiation-manager="contentNegotiationManager">
<mvc:message-converters register-defaults="true">
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<constructor-arg value="UTF-8" />
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<bean id="contentNegotiationManager" class="org.springframework.web.accept.ContentNegotiationManagerFactoryBean">
<property name="mediaTypes" >
<map>
<entry key="xml" value="application/xml"/>
<entry key="json" value="application/json"/>
</map>
</property>
<property name="ignoreAcceptHeader" value="true"/>
<property name="favorPathExtension" value="true"/>
</bean>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/"/>
<property name="suffix" value=".jsp"/>
</bean>
<mvc:default-servlet-handler />
<mvc:resources mapping="/static/**" location="/static/" cache-period="31536000"/>
<mvc:view-controller path="/" view-name="redirect:${web.view.index}"/>
<mvc:interceptors>
<mvc:interceptor>
<mvc:mapping path="/**"/>
<bean class="com.stusystem.interceptor.LoginInterceptor"></bean>
</mvc:interceptor>
</mvc:interceptors>
</beans>
五、配置web.xml和demo.properties
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
id="WebApp_ID" version="3.0">
<display-name>stusystem_3</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:/spring-context*.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<listener>
<listener-class>org.springframework.web.context.request.RequestContextListener</listener-class>
</listener>
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
<init-param>
<param-name>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<servlet>
<servlet-name>springServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:/spring-mvc*.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>DruidStatView</servlet-name>
<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
<init-param>
<param-name>allow</param-name>
<param-value>127.0.0.1</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>DruidStatView</servlet-name>
<url-pattern>/druid/*</url-pattern>
</servlet-mapping>
<session-config>
<session-timeout>600</session-timeout>
</session-config>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>/js/*</url-pattern>
<url-pattern>/css/*</url-pattern>
<url-pattern>/images/*</url-pattern>
<url-pattern>/font/*</url-pattern>
<url-pattern>/assets/*</url-pattern>
<url-pattern>/lib/*</url-pattern>
</servlet-mapping>
</web-app>
demo.properties
#============================#
#===== Database settings ====#
#============================#
#mysql database setting
jdbc.type=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/stusystem?useUnicode=true&characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
#pool settings
jdbc.pool.init=1
jdbc.pool.minIdle=3
jdbc.pool.maxActive=20
#jdbc.testSql=SELECT 'x'
jdbc.testSql=SELECT 'x' FROM DUAL
web.view.prefix=/
web.view.suffix=.jsp
web.view.index=/StuSystem/user/login
六、各个模块代码
**
(1)用户模块：
**
UserBean.java：
package com.stusystem.entity;
import org.apache.ibatis.type.Alias;
import org.springframework.stereotype.Component;
@Alias("userbean")
@Component
public class Userbean {
private String userName;
private int userId;
private String admin;
private String password;
private String xmm;
public String getXmm() {
return xmm;
}
public void setXmm(String xmm) {
this.xmm = xmm;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
public String getAdmin() {
return admin;
}
public void setAdmin(String admin) {
this.admin = admin;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
UserDao.java:
package com.stusystem.dao;
import com.stusystem.entity.Userbean;
public interface UserDao {
public Userbean getUsrInfoByNameAndPsw(Userbean userbean);
public void mmxg(Userbean userbean);
}
UserDao.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.stusystem.dao.UserDao">
<select id="getUsrInfoByNameAndPsw" parameterType="userbean" resultType="userbean">
select * from user where user_id=#{userId} and password=#{password} and admin=#{admin}
</select>
<update id="mmxg" parameterType="userbean">
UPDATE user SET password = #{xmm} WHERE (user_id=#{userId})
</update>
</mapper>
UserController.java:
package com.stusystem.controller;
import java.io.IOException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import com.stusystem.dao.UserDao;
import com.stusystem.entity.Userbean;
@Controller
@RequestMapping(value = "user")
public class UserController {
@Autowired
private UserDao userDao;
@RequestMapping(value = {"/login"})
public String userlogin() {
return "login";
}
@RequestMapping(value = {"/loginyanzheng"})
public void loginyanzheng(Userbean userbean,HttpServletResponse response,HttpServletRequest request) throws IOException {
Userbean user = userDao.getUsrInfoByNameAndPsw(userbean);
if(user==null){
response.getWriter().println("{\"status\":0,\"msg\":\"用户名或密码有误！\"}");
}else{
HttpSession session = request.getSession();
session.setAttribute("userbean", user);
response.getWriter().println("{\"status\":1,\"url\":\"index\"}");
}
}
@RequestMapping(value = {"/index"})
public String index() {
return "index";
}
@RequestMapping(value = {"/gy"})
public String guanyu() {
return "gy";
}
@RequestMapping(value = {"/dlmmxg"})
public String dlmmxg() {
return "dlmmxg";
}
@RequestMapping(value = {"/mmxg"})
public String mmxg(Userbean userbean,HttpServletResponse response,HttpServletRequest request){
Userbean user = userDao.getUsrInfoByNameAndPsw(userbean);
if(user==null){
request.setAttribute("status", '0');
}else{
userDao.mmxg(userbean);
request.setAttribute("status", '1');
}
return "dlmmxg";
}
@RequestMapping(value = {"/loginout"})
public String loginout(HttpServletRequest request){
HttpSession session = request.getSession();
session.invalidate();
return "login";
}
}
login.jsp
<!DOCTYPE html>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html>
<head>
<meta http-equiv="content-type" content="text/html">
<meta charset="UTF-8">
<title>学生成绩管理系统|登录</title>
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/host.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/animate.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/font-awesome.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/style.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/js/validator-0.7.3/jquery.validator.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/validator-0.7.3/jquery.validator.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/validator-0.7.3/local/zh_CN.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/host.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
function login() {
var userid = document.getElementById("userid").value;
var password = document.getElementById("password").value;
var list = document.getElementsByName("inlineRadioOptions");
var admin = null;
if(!list[0].checked&&!list[1].checked&&!list[2].checked){
return;
}
for(var i = 0 ; i < list.length ; i++){
if(list[i].checked){
admin = list[i].value;
}
}
$.ajax({
type : "POST",
data : "userId=" + userid + "&password=" + password +"&admin=" + admin,
dataType : "json",
url : "<%=request.getContextPath()%>/user/loginyanzheng",
success : function(result) {
if (result.status == 0) {
swal("哦豁","用户名或密码有误，请重新输入！","error");
} else {
swal({title:"太帅了",text:"登录成功，进入系统！",type:"success"},
function () {
location.href = "/StuSystem_3/user/index";
});
}
}
});
}
</script>
</head>
<body bgcolor="#FFFFFF">
<div class="middle-box text-center loginscreen ">
<div >
<div class="animated animated lightSpeedIn ">
<i class="icon iconfont">󰀨</i>
</div>
<h3>欢迎使用 学生成绩管理系统</h3>
<form class=" animated rollIn" data-validator-option="{theme:'yellow_right_effect',stopOnError:true}">
<div class="form-group">
<input type="text" class="form-control" placeholder="用户名" data-rule="用户名:required;digits" id = "userid">
</div>
<div class="form-group">
<input type="password" class="form-control" placeholder="密码" data-rule="密码:required;password" id = "password">
</div>
<fieldset>
<label class="radio-inline" >
<input type="radio" name="inlineRadioOptions" id="inlineRadio1" value="1" data-rule="checked"> 管理员
</label>
<label class="radio-inline">
<input type="radio" name="inlineRadioOptions" id="inlineRadio2" value="2" > 教师
</label>
<label class="radio-inline">
<input type="radio" name="inlineRadioOptions" id="inlineRadio3" value="3" > 学生
</label>
</fieldset>
<br/>
<br/>
<button type="submit" class="btn btn-primary block full-width " onclick="login();">登 录</button>
</form>
<br/>
<br/>
<div class = "animated bounceInLeft">
</div>
</div>
</div>
<div class="part"></div>
</body>
</html>
index.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>学生成绩管理系统|首页</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="<%=request.getContextPath()%>/assets/css/dpl-min.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/assets/css/bui-min.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/assets/css/main.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">
var index = layer.load(0, {shade: false});
</script>
</head>
<body>
<div class="header">
<div class="dl-title"><span class="">学生成绩管理系统</span></div>
<div class="dl-log">欢迎您，<span class="dl-log-user">${userbean.userName}</span>
<c:choose>
<c:when test="${userbean.admin == 1}">
<span class="admin">（管理员）</span>
</c:when>
</c:choose>
<c:choose>
<c:when test="${userbean.admin == 2}">
<span class="admin">（教师）</span>
</c:when>
</c:choose>
<c:choose>
<c:when test="${userbean.admin == 3}">
<span class="admin">（学生）</span>
</c:when>
</c:choose>
<a href="loginout" title="退出系统" class="dl-log-quit">[退出]</a>
</div>
</div>
<div class="content">
<div class="dl-main-nav">
<ul id="J_Nav" class="nav-list ks-clear">
<li class="nav-item dl-selected"><div class="nav-item-inner nav-storage">首页</div></li>
</ul>
</div>
<ul id="J_NavContent" class="dl-tab-conten">
</ul>
</div>
<script type="text/javascript" src="<%=request.getContextPath()%>/assets/js/jquery-1.8.1.min.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/assets/js/bui-min.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/assets/js/config-min.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script>
if('${userbean.admin}'=='3'){
BUI.use('common/main',function(){
var config = [{
id:'menu',
homePage:'gy',
menu:[{
text:'学生操作',
items:[
{id:'cjcx',text:'成绩查询',href:'/StuSystem_3/score/xsgrcjcx?studentId=' + '${userbean.userId}'},
{id:'xsgrkcgl',text:'学生个人课程管理',href:'/StuSystem_3/score/scoreone?page=1&studentId=' + '${userbean.userId}' },
{id:'xsgrxxgl',text:'学生个人信息管理',href:'/StuSystem_3/student/studentone?stuId=' + '${userbean.userId}' },
{id:'dlmmxg',text:'登录密码修改',href:'/StuSystem_3/user/dlmmxg'},
{id:'gy',text:'关于',href:'gy'}
]
}]
}];
new PageUtil.MainPage({
modulesConfig : config
});
});
}
if('${userbean.admin}'=='2'){
BUI.use('common/main',function(){
var config = [{
id:'menu',
homePage:'gy',
menu:[{
text:'教师操作',
items:[
{id:'xsxxgl',text:'学生信息管理',href:'/StuSystem_3/teacher/teacherlist?page=1'},
{id:'kcxxgl',text:'课程信息管理',href:'/StuSystem_3/student/studentlist?page=1'},
{id:'jsgrxxgl',text:'教师个人信息管理',href:'/StuSystem_3/teacher/teacherone?teacherId='+'${userbean.userId}'},
{id:'xscjgl',text:'学生成绩管理',href:'/StuSystem_3/score/scorelist?page=1'},
{id:'dlmmxg',text:'登录密码修改',href:'/StuSystem_3/user/dlmmxg'},
{id:'gy',text:'关于',href:'gy'}
]
}]
}];
new PageUtil.MainPage({
modulesConfig : config
});
});
}
if('${userbean.admin}'=='1'){
BUI.use('common/main',function(){
var config = [{
id:'menu',
homePage:'gy',
menu:[{
text:'管理员操作',
items:[
{id:'jsxxgl',text:'教师信息管理',href:'/StuSystem_3/teacher/teacherlist?page=1'},
{id:'xsxxgl',text:'学生信息管理',href:'/StuSystem_3/student/studentlist?page=1'},
{id:'kcxxgl',text:'课程信息管理',href:'/StuSystem_3/subject/subjectlist?page=1'},
{id:'xscjgl',text:'学生成绩管理',href:'/StuSystem_3/score/scorelist?page=1'},
{id:'dlmmxg',text:'登录密码修改',href:'/StuSystem_3/user/dlmmxg'},
{id:'gy',text:'关于',href:'gy'}
]
}]
}];
new PageUtil.MainPage({
modulesConfig : config
});
});
}
</script>
</body>
</html>
dlmmxg.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="<%=request.getContextPath()%>/css/H-ui.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/css/H-ui.1.x.patch.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/Validform.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/passwordStrength-min.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
$(function(){
$("#demoform-2").Validform({
tiptype:2,
usePlugin:{
datepicker:{},
passwordstrength:{
minLen:6,
maxLen:18,
trigger:function(obj,error){
if(error){
obj.parent().find(".Validform_checktip").show();
obj.parent().find(".passwordStrength").hide();
}else{
obj.parent().find(".passwordStrength").show();
}
}
}
}
});
});
</script>
<title>教师信息编辑页面</title>
</head>
<body>
<form action="mmxg" method="post" class="form form-horizontal responsive" id="demoform-2">
<div class="row cl">
<label class="form-label col-2">旧密码：</label>
<div class="formControls col-5">
<input type="text" name="userId" id = "userId" value="${userbean.userId}" style="display:none;"/>
<input type="text" name="admin" id = "admin" value="${userbean.admin}" style="display:none;"/>
<input type="password" class="input-text" placeholder="请输入旧密码" name="password" id="password" datatype="*6-16" nullmsg="旧密码不能为空" value = "">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">新密码：</label>
<div class="formControls col-5">
<input type="password" class="input-text" autocomplete="off" placeholder="密码" name="xmm" id="password1" datatype="*6-18" nullmsg="请输入密码！" >
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">密码验证：</label>
<div class="formControls col-5">
<input type="password" class="input-text" autocomplete="off" placeholder="密码" name="password2" id="password2" recheck="xmm" datatype="*6-18" nullmsg="请再输入一次密码！" errormsg="您两次输入的密码不一致！" >
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<div class="col-10 col-offset-2">
<input class="btn btn-primary" type="submit" onclick="tijiao();" value=" 提交 ">
</div>
</div>
</form>
</body>
<script type="text/javascript">
if("${status}" == '1'){
swal({title:"密码修改成功！",text:"您已经向服务器了这条信息!",type:"success"},
function () {
location.href = "dlmmxg";
});
}else if("${status}" == '0'){
swal("哦豁","修改失败失败，请确保密码输入正确！","error");
}else{}
</script>
</html>
**
(2)学生模块
**
StudentBean.java:
package com.stusystem.entity;
public class StudentBean {
private int stuId;
private String stuName;
private String stuSex;
private String stuSystem;
private String stuClass;
private String stuPhone;
private int page;
public int getPage() {
return (page-1)*6;
}
public void setPage(int page) {
this.page = page;
}
public int getStuId() {
return stuId;
}
public void setStuId(int stuId) {
this.stuId = stuId;
}
public String getStuName() {
return stuName;
}
public void setStuName(String stuName) {
this.stuName = stuName;
}
public String getStuSex() {
return stuSex;
}
public void setStuSex(String stuSex) {
this.stuSex = stuSex;
}
public String getStuSystem() {
return stuSystem;
}
public void setStuSystem(String stuSystem) {
this.stuSystem = stuSystem;
}
public String getStuClass() {
return stuClass;
}
public void setStuClass(String stuClass) {
this.stuClass = stuClass;
}
public String getStuPhone() {
return stuPhone;
}
public void setStuPhone(String stuPhone) {
this.stuPhone = stuPhone;
}
}
StudentDao.java:
package com.stusystem.dao;
import java.util.List;
import com.stusystem.entity.StudentBean;
public interface StudentDao {
public List<StudentBean> getStudent(StudentBean studentbean) throws Exception;
public int getstupage(StudentBean studentbean) throws Exception;
public StudentBean getStudentone (StudentBean studentbean) throws Exception;
public void studentdel(StudentBean studentbean) throws Exception;
public void studentadd(StudentBean studentbean) throws Exception;
public void studentxiugai(StudentBean studentbean) throws Exception;
}
StudentDao.xml:
```java
<?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.stusystem.dao.StudentDao">
<select id="getStudent" parameterType="com.stusystem.entity.StudentBean" resultType="com.stusystem.entity.StudentBean">
<if test=" stuName != null and stuName != '' "> SELECT * FROM student where stu_name = #{stuName} limit #{page} , 6 </if>
<if test=" stuName == null or stuName == '' "> SELECT * FROM student limit #{page} , 6 </if>
</select>
<select id="getstupage" parameterType="com.stusystem.entity.StudentBean" resultType="int">
<if test=" stuName != null and stuName != '' "> select count(*) from student where stu_name = #{stuName} </if>
<if test=" stuName == null or stuName == '' "> select count(*) from student </if>
</select>
<select id="getStudentone" parameterType="com.stusystem.entity.StudentBean" resultType="com.stusystem.entity.StudentBean" >
SELECT * FROM student WHERE stu_id=#{stuId}
</select>
<delete id="studentdel" parameterType="com.stusystem.entity.StudentBean" >
DELETE FROM student WHERE (stu_id=#{stuId})
</delete>
<update id="studentxiugai" parameterType="com.stusystem.entity.StudentBean">
UPDATE student SET stu_name=#{stuName}, stu_sex=#{stuSex}, stu_system=#{stuSystem}, stu_phone=#{stuPhone}, stu_class=#{stuClass} WHERE (stu_id=#{stuId})
</update>
<insert id="studentadd" parameterType="com.stusystem.entity.StudentBean">
INSERT INTO student (stu_name, stu_sex, stu_system, stu_phone, stu_class) VALUES (#{stuName},#{stuSex},#{stuSystem},#{stuPhone},#{stuClass})
</insert>
</mapper>
StudentController.java
package com.stusystem.controller;
import java.io.IOException;
import java.net.URLDecoder;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.stusystem.dao.StudentDao;
import com.stusystem.entity.StudentBean;
@Controller
@RequestMapping(value = "student")
public class StudentController {
@Autowired
private StudentDao studentDao;
@RequestMapping(value = {"/studentlist"})
public String getStudent(StudentBean stu,Model model) throws Exception{
if(stu.getStuName()!=null&&stu.getStuName()!=""){
stu.setStuName(URLDecoder.decode(stu.getStuName(), "UTF-8"));
}
List<StudentBean> stulist = studentDao.getStudent(stu);
int stupage = studentDao.getstupage(stu);
model.addAttribute("studentlist", stulist);
model.addAttribute("stupage", stupage);
model.addAttribute("studentname", stu.getStuName());
return "studentlist";
}
@RequestMapping(value = {"/studentone"})
public String getStudentone(StudentBean stu,Model model) throws Exception {
StudentBean studentone = studentDao.getStudentone(stu);
model.addAttribute("stuone", studentone);
return "studentone";
}
@RequestMapping(value = {"/studenteditor"})
public String studenteditor(StudentBean stu,Model model) throws Exception {
if(stu.getStuId()==0){
return "studenteditor";
}else{
StudentBean studentone = studentDao.getStudentone(stu);
model.addAttribute("studentone", studentone);
return "studenteditor";
}
}
@RequestMapping(value = {"/studentdel"})
public void studentdel(StudentBean stu,HttpServletResponse response) throws IOException {
int a = 0;
try {
studentDao.studentdel(stu);
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}else{
}
}
@RequestMapping(value = {"/studentadd"})
public void studentadd(StudentBean stu,HttpServletResponse response) throws IOException{
int a = 0;
try {
if(stu.getStuId()==0){
stu.setStuName(URLDecoder.decode(stu.getStuName(), "UTF-8"));
stu.setStuSystem(URLDecoder.decode(stu.getStuSystem(), "UTF-8"));
stu.setStuSex(URLDecoder.decode(stu.getStuSex(), "UTF-8"));
stu.setStuClass(URLDecoder.decode(stu.getStuClass(), "UTF-8"));
studentDao.studentadd(stu);
}else{
stu.setStuName(URLDecoder.decode(stu.getStuName(), "UTF-8"));
stu.setStuSystem(URLDecoder.decode(stu.getStuSystem(), "UTF-8"));
stu.setStuSex(URLDecoder.decode(stu.getStuSex(), "UTF-8"));
stu.setStuClass(URLDecoder.decode(stu.getStuClass(), "UTF-8"));
studentDao.studentxiugai(stu);
}
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}else{
}
}
}
studentlist.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
function del(studentid) {
swal({
title: "您确定要删除这条信息吗",
text: "删除后将无法恢复，请谨慎操作！",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "删除",
closeOnConfirm: false
}, function () {
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status== 1){
swal({title:"删除成功！",text:"您已经永久删除了这条信息!",type:"success"},
function () {
var b = '${stupage}' ;
b = Math.ceil(b/6) ;
location.href = "studentlist?page=" + b;
});
}else{
swal("哦豁","删除失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","studentdel?stuId="+studentid,true);
xmlhttp.send();
});
}
</script>
<title>学生列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="input-group">
<input type="text" class="form-control" placeholder="输入学生姓名搜索" id = "sousuo" value = "${studentname}">
<span class="input-group-btn">
<button class="btn btn-default" type="button" onclick="sousuo();">Go!</button>
</span>
</div>
</div>
<div class="col-md-3"><button type="button" class="btn btn-default" onclick="tianjia();">添加+</button></div>
<div class="col-md-6"></div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>学号</th>
<th>学生姓名</th>
<th>学生性别</th>
<th>所在系</th>
<th>班级</th>
<th>电话号码</th>
<th>操作</th>
</tr>
<c:forEach items="${studentlist}" var="stu">
<tr>
<td>${stu.stuId}</td>
<td>${stu.stuName}</td>
<td>${stu.stuSex}</td>
<td>${stu.stuSystem}</td>
<td>${stu.stuClass}</td>
<td>${stu.stuPhone}</td>
<td><button type="button" class="btn btn-info btn-xs" onclick="bianji(${stu.stuId});" ><i class="iconfont"></i> 编辑</button> <button type="button" onclick="del(${stu.stuId});" class="btn btn-danger btn-xs"><i class="iconfont"></i> 删除</button></td>
</tr>
</c:forEach>
</table>
<div id="page11" style="margin-top:5px; text-align:center;"></div>
</body>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
laypage({
cont: 'page11',
pages: Math.ceil("${stupage}"/6),
skip: true,
skin: '#6699FF',
curr: function(){
var page = location.search.match(/page=(\d+)/);
return page ? page[1] : 1;
}(),
jump: function(e, first){
if(!first){
var studengtname = document.getElementById("sousuo").value;
location.href = '?page='+e.curr + '&stuName=' + encodeURI(encodeURI(studengtname));
}
}
});
</script>
<script type="text/javascript">
function bianji(studentId) {
layer.open({
type: 2,
title: '学生信息编辑页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'studenteditor?stuId='+ studentId
});
}
function tianjia() {
layer.open({
type: 2,
title: '学生信息添加页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'studenteditor?stuId=0'
});
}
</script>
<script type="text/javascript">
function sousuo() {
var studentname = document.getElementById("sousuo").value;
location.href = 'studentlist?stuName='+ encodeURI(encodeURI(studentname)) + '&page=1' ;
}
</script>
</html>
studentone.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<title>学生信息列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生个人信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>学号</th>
<th>学生姓名</th>
<th>学生性别</th>
<th>所在系</th>
<th>班级</th>
<th>电话号码</th>
<th>操作</th>
</tr>
<tr>
<td>${stuone.stuId}</td>
<td>${stuone.stuName}</td>
<td>${stuone.stuSex}</td>
<td>${stuone.stuSystem}</td>
<td>${stuone.stuClass}</td>
<td>${stuone.stuPhone}</td>
<td>
<button id = "xiugai" type="button" class="btn btn-info btn-xs" οnclick="xiugai();" >
<i class="iconfont"></i>
编辑
</button>
</td>
</tr>
</table>
</body>
<script type="text/javascript">
function xiugai() {
layer.open({
type: 2,
title: '学生个人信息修改页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'studenteditor?stuId='+"${stuone.stuId}"
});
}
</script>
</html>
studenteditor.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="<%=request.getContextPath()%>/css/H-ui.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/css/H-ui.1.x.patch.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/Validform.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/passwordStrength-min.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
$(function(){
$("#demoform-2").Validform({
tiptype:2,
usePlugin:{
datepicker:{},
passwordstrength:{
minLen:6,
maxLen:18,
trigger:function(obj,error){
if(error){
obj.parent().find(".Validform_checktip").show();
obj.parent().find(".passwordStrength").hide();
}else{
obj.parent().find(".passwordStrength").show();
}
}
}
}
});
});
</script>
<title>教师信息编辑页面</title>
</head>
<body>
<form action="" method="post" class="form form-horizontal responsive" id="demoform-2">
<div class="row cl">
<label class="form-label col-2">姓名：</label>
<div class="formControls col-5">
<input type="text" name="studentid" id = "studentid" value="${studentone.stuId}" style="display:none;"/>
<input type="text" class="input-text" placeholder="请输入学生姓名" name="studentname" id="studentname" datatype="s2-5" nullmsg="学生姓名不能为空" value = "${studentone.stuName}">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">所在系：</label>
<div class="formControls col-5">
<input type="text" class="input-text" placeholder="请输入学生所在系" name="studentsystem" id="studentsystem" datatype="s2-10" nullmsg="所在系不能为空" value = "${studentone.stuSystem}">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">电话号码：</label>
<div class="formControls col-5">
<input type="text" class="input-text" autocomplete="off" placeholder="手机号码" name="studentphone" id="studentphone" datatype="m" nullmsg="电话号码不能为空" value = "${studentone.stuPhone}">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">班级：</label>
<div class="formControls col-5">
<input type="text" class="input-text" placeholder="请输入学生班级" name="studentclass" id="studentclass" datatype="s2-10" nullmsg="班级不能为空" value = "${studentone.stuClass}">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">学生性别：</label>
<div class="formControls skin-minimal col-5">
<div class="radio-box">
<input type="radio" id="sex-1" name="studentsex" value = "男" datatype="*" nullmsg="请选择性别！">
<label for="sex-1">男</label>
</div>
<div class="radio-box">
<input type="radio" id="sex-2" name="studentsex" value = "女">
<label for="sex-2">女</label>
</div>
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<div class="col-10 col-offset-2">
<input class="btn btn-primary" type="button" οnclick="hehe();" id = "tijiao" value=" 提交 ">
</div>
</div>
</form>
</body>
<script type="text/javascript">
if('${studentone.stuSex}' =="女"){
document.getElementById('sex-2').checked="checked";
}else if('${studentone.stuSex}' =="男") {
document.getElementById('sex-1').checked="checked";
}else{
}
</script>
<script type="text/javascript">
function hehe() {
var studentname = document.getElementById("studentname").value;
var studentsystem = document.getElementById("studentsystem").value;
var studentid = document.getElementById("studentid").value;
if(studentid==""){
studentid = 0;
}
var studentphone = document.getElementById("studentphone").value;
var studentclass = document.getElementById("studentclass").value;
var list = document.getElementsByName("studentsex");
var studentsex = null;
for(var i = 0 ; i < list.length ; i++){
if(list[i].checked){
studentsex = list[i].value;
}
}
if(studentname==""||studentsystem==""||studentphone==""||studentclass==""||studentsex==""){
swal("哦豁","提交失败，请重试！","error");
return;
}
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status == 1){
swal({title:"提交成功！",text:"您已经向服务器了这条信息!",type:"success"},
function () {
parent.top.topManager.reloadPage();
parent.layer.closeAll();
});
}else{
swal("哦豁","提交失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","studentadd?stuName="+encodeURI(encodeURI(studentname)) + "&stuSystem=" + encodeURI(encodeURI(studentsystem))+ "&stuId=" + studentid + "&stuPhone=" + encodeURI(encodeURI(studentphone))+ "&stuClass=" + encodeURI(encodeURI(studentclass))+ "&stuSex=" + encodeURI(encodeURI(studentsex)) ,true);
xmlhttp.send();
}
</script>
</html>
**
(3)教师模块
**
TeacherBean.java
package com.stusystem.entity;
import org.apache.ibatis.type.Alias;
import org.springframework.stereotype.Component;
@Alias("teacherBean")
@Component
public class TeacherBean {
private int teacherId;
private String teacherName;
private String teacherSex;
private String teacherSystem;
private String teacherPhone;
private String teacherEmail;
public String getTeacherEmail() {
return teacherEmail;
}
public void setTeacherEmail(String teacherEmail) {
this.teacherEmail = teacherEmail;
}
private int page;
public int getPage() {
return (page-1)*6;
}
public void setPage(int page) {
this.page = page;
}
public int getTeacherId() {
return teacherId;
}
public void setTeacherId(int teacherId) {
this.teacherId = teacherId;
}
public String getTeacherName() {
return teacherName;
}
public void setTeacherName(String teacherName) {
this.teacherName = teacherName;
}
public String getTeacherSystem() {
return teacherSystem;
}
public String getTeacherSex() {
return teacherSex;
}
public void setTeacherSex(String teacherSex) {
this.teacherSex = teacherSex;
}
public void setTeacherSystem(String teacherSystem) {
this.teacherSystem = teacherSystem;
}
public String getTeacherPhone() {
return teacherPhone;
}
public void setTeacherPhone(String teacherPhone) {
this.teacherPhone = teacherPhone;
}
}
TeacherDao.java
package com.stusystem.dao;
import com.stusystem.entity.*;
import java.util.*;
public interface TeacherDao {
public List<TeacherBean> getTeacher(TeacherBean teacherbean) throws Exception;
public int getteapage(TeacherBean teacherbean) throws Exception;
public TeacherBean getTeacherone(TeacherBean teacherbean) throws Exception;
public void teacherdel(TeacherBean teacherbean) throws Exception;
public void teacheradd(TeacherBean teacherbean) throws Exception;
public void teacherxiugai(TeacherBean teacherbean) throws Exception;
}
TeacherDao.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.stusystem.dao.TeacherDao">
<select id="getTeacher" parameterType="teacherBean" resultType="teacherBean">
<if test=" teacherName != null and teacherName != '' "> SELECT * FROM teacher where teacher_name = #{teacherName} limit #{page} , 6 </if>
<if test=" teacherName == null or teacherName == '' "> SELECT * FROM teacher limit #{page} , 6 </if>
</select>
<select id="getteapage" parameterType="teacherBean" resultType="int">
<if test=" teacherName != null and teacherName != '' "> select count(*) from `teacher` where teacher_name = #{teacherName} </if>
<if test=" teacherName == null or teacherName == '' "> select count(*) from `teacher` </if>
</select>
<select id="getTeacherone" parameterType="teacherBean" resultType="teacherBean" >
SELECT * FROM teacher WHERE teacher_id=#{teacherId}
</select>
<delete id="teacherdel" parameterType="teacherBean" >
DELETE FROM `teacher` WHERE (`teacher_id`=#{teacherId})
</delete>
<update id="teacherxiugai" parameterType="teacherBean">
UPDATE teacher SET teacher_name=#{teacherName}, teacher_sex=#{teacherSex}, teacher_system=#{teacherSystem}, teacher_phone=#{teacherPhone}, teacher_email=#{teacherEmail} WHERE (teacher_id=#{teacherId})
</update>
<insert id="teacheradd" parameterType="teacherBean">
INSERT INTO `teacher` (`teacher_name`, `teacher_sex`, `teacher_system`, `teacher_phone`, `teacher_email`) VALUES (#{teacherName},#{teacherSex},#{teacherSystem},#{teacherPhone},#{teacherEmail})
</insert>
</mapper>
TeacherController,java
package com.stusystem.controller;
import java.io.IOException;
import java.net.URLDecoder;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.stusystem.dao.TeacherDao;
import com.stusystem.entity.TeacherBean;
@Controller
@RequestMapping("teacher")
public class TeacherController {
@Autowired
TeacherDao teacherDao;
@RequestMapping("/teacherlist")
public String getTeacher(TeacherBean tea,Model model,HttpServletRequest request) throws Exception{
if(tea.getTeacherName()!=null&&tea.getTeacherName()!=""){
tea.setTeacherName(URLDecoder.decode(tea.getTeacherName(), "UTF-8"));
}
List<TeacherBean> teacherlist=teacherDao.getTeacher(tea);
int teapage=teacherDao.getteapage(tea);
model.addAttribute("teacherlist",teacherlist);
model.addAttribute("teapage",teapage);
model.addAttribute("teachername",tea.getTeacherName());
return "teacherlist";
}
@RequestMapping("/teacherone")
public String getTeacherone(TeacherBean tea,Model model) throws Exception{
TeacherBean teacherone=teacherDao.getTeacherone(tea);
model.addAttribute("teaone",teacherone);
return "teacherone";
}
@RequestMapping("/teachereditor")
public String teachereditor(TeacherBean tea,Model model) throws Exception{
if(tea.getTeacherId()==0) {
return "teachereditor";
}else {
TeacherBean teacherone=teacherDao.getTeacherone(tea);
model.addAttribute("teacherone",teacherone);
return "teachereditor";
}
}
@RequestMapping("/teacherdel")
public void teacherdel(TeacherBean tea,HttpServletResponse response) throws IOException{
int a = 0;
try {
teacherDao.teacherdel(tea);
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}else{
}
}
@RequestMapping(value = {"/teacheradd"})
public void teacheradd(TeacherBean tea,HttpServletResponse response) throws IOException{
int a = 0;
try {
if(tea.getTeacherId()==0){
tea.setTeacherName(URLDecoder.decode(tea.getTeacherName(), "UTF-8"));
tea.setTeacherSystem(URLDecoder.decode(tea.getTeacherSystem(), "UTF-8"));
tea.setTeacherSex(URLDecoder.decode(tea.getTeacherSex(), "UTF-8"));
tea.setTeacherEmail(URLDecoder.decode(tea.getTeacherEmail(), "UTF-8"));
teacherDao.teacheradd(tea);
}else{
tea.setTeacherName(URLDecoder.decode(tea.getTeacherName(), "UTF-8"));
tea.setTeacherSystem(URLDecoder.decode(tea.getTeacherSystem(), "UTF-8"));
tea.setTeacherSex(URLDecoder.decode(tea.getTeacherSex(), "UTF-8"));
tea.setTeacherEmail(URLDecoder.decode(tea.getTeacherEmail(), "UTF-8"));
teacherDao.teacherxiugai(tea);
}
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}else{
}
}
}
teacherlist.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
function del(teacherid) {
swal({
title: "您确定要删除这条信息吗",
text: "删除后将无法恢复，请谨慎操作！",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "删除",
closeOnConfirm: false
}, function () {
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status== 1){
swal({title:"删除成功！",text:"您已经永久删除了这条信息!",type:"success"},
function () {
var b = '${teapage}' ;
b = Math.ceil(b/6) ;
location.href = "teacherlist?page="+b;
});
}else{
swal("哦豁","删除失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","teacherdel?teacherId="+teacherid,true);
xmlhttp.send();
});
}
</script>
<title>教师列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">教师信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="input-group">
<input type="text" class="form-control" id ="sousuo" placeholder="输入教师姓名搜索" value = "${teachername}" >
<span class="input-group-btn">
<button class="btn btn-default" type="button" onclick="sousuo();">Go!</button>
</span>
</div>
</div>
<div class="col-md-3"><button type="button" class="btn btn-default" onclick="tianjia();">添加+</button></div>
<div class="col-md-6"></div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>教师编号</th>
<th>教师姓名</th>
<th>教师性别</th>
<th>所在系</th>
<th>电话号码</th>
<th>邮箱</th>
<th>操作</th>
</tr>
<c:forEach items="${teacherlist}" var="tea">
<tr>
<td>${tea.teacherId}</td>
<td>${tea.teacherName}</td>
<td>${tea.teacherSex}</td>
<td>${tea.teacherSystem}</td>
<td>${tea.teacherPhone}</td>
<td>${tea.teacherEmail}</td>
<td><button type="button" class="btn btn-info btn-xs" onclick="bianji(${tea.teacherId});" ><i class="iconfont"></i> 编辑</button> <button type="button" onclick="del(${tea.teacherId});" class="btn btn-danger btn-xs"><i class="iconfont"></i> 删除</button></td>
</tr>
</c:forEach>
</table>
<div id="page11" style="margin-top:5px; text-align:center;"></div>
</body>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
laypage({
cont: 'page11',
pages: Math.ceil("${teapage}"/6),
skip: true,
skin: '#6699FF',
curr: function(){
var page = location.search.match(/page=(\d+)/);
return page ? page[1] : 1;
}(),
jump: function(e, first){
if(!first){
var teachername = document.getElementById("sousuo").value;
location.href = '?page='+e.curr + '&teacherName=' + encodeURI(encodeURI(teachername));
}
}
});
</script>
<script type="text/javascript">
function bianji(teacherId) {
layer.open({
type: 2,
title: '教师信息编辑页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'teachereditor?teacherId='+ teacherId
});
}
function tianjia() {
layer.open({
type: 2,
title: '教师信息编辑页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'teachereditor?teacherId=0'
});
}
</script>
<script type="text/javascript">
function sousuo() {
var teachername = document.getElementById("sousuo").value;
location.href = 'teacherlist?teacherName='+ encodeURI(encodeURI(teachername)) + '&page=1' ;
}
</script>
</html>
teacherone.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<title>教师信息列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">教师个人信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>教师编号</th>
<th>教师姓名</th>
<th>教师性别</th>
<th>系别</th>
<th>电话号码</th>
<th>邮箱</th>
<th>操作</th>
</tr>
<tr>
<td>${teaone.teacherId}</td>
<td>${teaone.teacherName}</td>
<td>${teaone.teacherSex}</td>
<td>${teaone.teacherSystem}</td>
<td>${teaone.teacherPhone}</td>
<td>${teaone.teacherEmail}</td>
<td>
<button id = "xiugai" type="button" class="btn btn-info btn-xs" οnclick="xiugai();" >
<i class="iconfont"></i>
编辑
</button>
</td>
</tr>
</table>
</body>
<script type="text/javascript">
function xiugai() {
layer.open({
type: 2,
title: '学生个人信息修改页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'teachereditor?teacherId='+"${teaone.teacherId}"
});
}
</script>
</html>
teachereditor.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="<%=request.getContextPath()%>/css/H-ui.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/css/H-ui.1.x.patch.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/Validform.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/passwordStrength-min.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
$(function(){
$("#demoform-2").Validform({
tiptype:2,
usePlugin:{
datepicker:{},
passwordstrength:{
minLen:6,
maxLen:18,
trigger:function(obj,error){
if(error){
obj.parent().find(".Validform_checktip").show();
obj.parent().find(".passwordStrength").hide();
}else{
obj.parent().find(".passwordStrength").show();
}
}
}
}
});
});
</script>
<title>教师信息编辑页面</title>
</head>
<body>
<form action="" class="form form-horizontal responsive" id="demoform-2">
<div class="row cl">
<label class="form-label col-2">姓名：</label>
<div class="formControls col-5">
<input type="text" name="teacherid" id = "teacherid" value="${teacherone.teacherId}" style="display:none;"/>
<input type="text" value = "${teacherone.teacherName}" class="input-text" placeholder="请输入教师姓名" name="teachername" id="teachername" datatype="s2-5" nullmsg="教师姓名不能为空" >
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">所在系：</label>
<div class="formControls col-5">
<input type="text" class="input-text" placeholder="请输入教师所在系" name="teachersystem" id="teachersystem" datatype="s2-10" nullmsg="请输入所在系" value = '${teacherone.teacherSystem}' >
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">电话号码：</label>
<div class="formControls col-5">
<input type="text" class="input-text" autocomplete="off" placeholder="手机号码" name="teacherphone" id="teacherphone" datatype="m" nullmsg="电话号码不能为空" value = '${teacherone.teacherPhone}'>
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">邮箱：</label>
<div class="formControls col-5">
<input type="text" class="input-text" placeholder="@" name="teacheremail" id="teacheremail" datatype="e" nullmsg="请输入邮箱！" value = '${teacherone.teacherEmail}'>
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">教师性别：</label>
<div class="formControls skin-minimal col-5">
<div class="radio-box">
<input type="radio" id="sex-1" value = "男" name="teachersex" datatype="*" nullmsg="请选择性别！" >
<label for="sex-1">男</label>
</div>
<div class="radio-box">
<input type="radio" id="sex-2" name="teachersex" value = "女">
<label for="sex-2">女</label>
</div>
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<div class="col-10 col-offset-2">
<input class="btn btn-primary" type="button" οnclick="hehe();" id = "tijiao" value=" 提交 ">
</div>
</div>
</form>
</body>
<script type="text/javascript">
if('${teacherone.teacherSex}' =="女"){
document.getElementById('sex-2').checked="checked";
}else if('${teacherone.teacherSex}' =="男") {
document.getElementById('sex-1').checked="checked";
}else{
}
</script>
<script type="text/javascript">
function hehe() {
var teachername = document.getElementById("teachername").value;
var teachersystem = document.getElementById("teachersystem").value;
var teacherid = document.getElementById("teacherid").value;
if(teacherid==""){
teacherid = 0;
}
var teacherphone = document.getElementById("teacherphone").value;
var teacheremail = document.getElementById("teacheremail").value;
var list = document.getElementsByName("teachersex");
var teachersex = null;
for(var i = 0 ; i < list.length ; i++){
if(list[i].checked){
teachersex = list[i].value;
}
}
if(teachername==""||teachersystem==""||teacherphone==""||teacheremail==""||teachersex==""){
swal("哦豁","提交失败，请重试！","error");
return;
}
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status == 1){
swal({title:"提交成功！",text:"您已经向服务器了这条信息!",type:"success"},
function () {
parent.top.topManager.reloadPage();
parent.layer.closeAll();
});
}else{
swal("哦豁","提交失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","teacheradd?teacherName="+encodeURI(encodeURI(teachername)) + "&teacherSystem=" + encodeURI(encodeURI(teachersystem))+ "&teacherId=" + encodeURI(encodeURI(teacherid))+ "&teacherPhone=" + encodeURI(encodeURI(teacherphone))+ "&teacherEmail=" + encodeURI(encodeURI(teacheremail))+ "&teacherSex=" + encodeURI(encodeURI(teachersex)) ,true);
xmlhttp.send();
}
</script>
</html>
(4)课程模块
SubjectBean.java
package com.stusystem.entity;
public class SubjectBean {
private int subjectId;
private String subjectName;
private String teacherName;
private String subjectCredit;
private int page;
public int getPage() {
return (page-1)*6;
}
public void setPage(int page) {
this.page = page;
}
public int getSubjectId() {
return subjectId;
}
public void setSubjectId(int subjectId) {
this.subjectId = subjectId;
}
public String getSubjectName() {
return subjectName;
}
public void setSubjectName(String subjectName) {
this.subjectName = subjectName;
}
public String getTeacherName() {
return teacherName;
}
public void setTeacherName(String teacherName) {
this.teacherName = teacherName;
}
public String getSubjectCredit() {
return subjectCredit;
}
public void setSubjectCredit(String subjectCredit) {
this.subjectCredit = subjectCredit;
}
}
SubjectDao.java
package com.stusystem.dao;
import java.util.List;
import com.stusystem.entity.SubjectBean;
public interface SubjectDao {
public List<SubjectBean> getSubject(SubjectBean subjectBean) throws Exception;
public int getsbjpage(SubjectBean subjectBean) throws Exception;
public SubjectBean getSubjectone(SubjectBean subjectBean) throws Exception;
public void subjectdel(SubjectBean subjectBean) throws Exception;
public void subjectadd(SubjectBean subjectBean) throws Exception;
public void subjectxiugai(SubjectBean subjectBean) throws Exception;
}
SubjectDao.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.stusystem.dao.SubjectDao">
<select id="getSubject" parameterType="com.stusystem.entity.SubjectBean" resultType="com.stusystem.entity.SubjectBean">
<if test=" subjectName != null and subjectName != '' "> SELECT * FROM subject where subject_name = #{subjectName} limit #{page} , 6 </if>
<if test=" subjectName == null or subjectName == '' "> SELECT * FROM subject limit #{page} , 6 </if>
</select>
<select id="getsbjpage" parameterType="com.stusystem.entity.SubjectBean" resultType="int">
<if test=" subjectName != null and subjectName != '' "> select count(*) from `subject` where subject_name = #{subjectName} </if>
<if test=" subjectName == null or subjectName == '' "> select count(*) from `subject` </if>
</select>
<select id="getSubjectone" parameterType="com.stusystem.entity.SubjectBean" resultType="com.stusystem.entity.SubjectBean" >
SELECT * FROM subject WHERE subject_id=#{subjectId}
</select>
<delete id="subjectdel" parameterType="com.stusystem.entity.SubjectBean" >
DELETE FROM `subject` WHERE (`subject_id`=#{subjectId})
</delete>
<update id="subjectxiugai" parameterType="com.stusystem.entity.SubjectBean">
UPDATE subject SET subject_name=#{subjectName}, teacher_name=#{teacherName}, subject_credit=#{subjectCredit} WHERE (subject_id=#{subjectId})
</update>
<insert id="subjectadd" parameterType="com.stusystem.entity.SubjectBean">
INSERT INTO `subject` (`subject_name`, `teacher_name`, `subject_credit`) VALUES (#{subjectName},#{teacherName},#{subjectCredit})
</insert>
</mapper>
ScoreController.java
package com.stusystem.controller;
import java.io.IOException;
import java.net.URLDecoder;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.stusystem.dao.SubjectDao;
import com.stusystem.entity.SubjectBean;
@Controller
@RequestMapping("subject")
public class SubjectController {
@Autowired
SubjectDao subjectDao;
@RequestMapping("/subjectlist")
public String getSubject(SubjectBean sbj,Model model) throws Exception{
if(sbj.getSubjectName()!=null&&sbj.getSubjectName()!=""){
sbj.setSubjectName(URLDecoder.decode(sbj.getSubjectName(), "UTF-8"));
}
List<SubjectBean> subjectlist=subjectDao.getSubject(sbj);
int sbjpage=subjectDao.getsbjpage(sbj);
model.addAttribute("subjectlist",subjectlist);
model.addAttribute("sbjpage",sbjpage);
model.addAttribute("subjectName", sbj.getSubjectName());
return "subjectlist";
}
@RequestMapping("/subjecteditor")
public String studenteditor(SubjectBean sbj,Model model) throws Exception {
if(sbj.getSubjectId()==0){
return "subjecteditor";
}else{
SubjectBean subjectone = subjectDao.getSubjectone(sbj);
model.addAttribute("subjectone", subjectone);
return "subjecteditor";
}
}
@RequestMapping(value = {"/subjectdel"})
public void subjectdel(SubjectBean sbj,HttpServletResponse response) throws IOException {
int a = 0;
try {
subjectDao.subjectdel(sbj);
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}else{
}
}
@RequestMapping(value = {"/subjectadd"})
public void subjectadd(SubjectBean sbj,HttpServletResponse response) throws IOException{
int a = 0;
try {
if(sbj.getSubjectId()==0){
sbj.setSubjectName(URLDecoder.decode(sbj.getSubjectName(), "UTF-8"));
sbj.setTeacherName(URLDecoder.decode(sbj.getTeacherName(), "UTF-8"));
subjectDao.subjectadd(sbj);
}else{
sbj.setSubjectName(URLDecoder.decode(sbj.getSubjectName(), "UTF-8"));
sbj.setTeacherName(URLDecoder.decode(sbj.getTeacherName(), "UTF-8"));
subjectDao.subjectxiugai(sbj);
}
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}else{
}
}
}
subjectlist.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
function del(studentid) {
swal({
title: "您确定要删除这条信息吗",
text: "删除后将无法恢复，请谨慎操作！",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "删除",
closeOnConfirm: false
}, function () {
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status== 1){
swal({title:"删除成功！",text:"您已经永久删除了这条信息!",type:"success"},
function () {
var b = '${stupage}' ;
b = Math.ceil(b/6) ;
location.href = "studentlist?page=" + b;
});
}else{
swal("哦豁","删除失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","studentdel?stuId="+studentid,true);
xmlhttp.send();
});
}
</script>
<title>学生列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="input-group">
<input type="text" class="form-control" placeholder="输入学生姓名搜索" id = "sousuo" value = "${studentname}">
<span class="input-group-btn">
<button class="btn btn-default" type="button" onclick="sousuo();">Go!</button>
</span>
</div>
</div>
<div class="col-md-3"><button type="button" class="btn btn-default" onclick="tianjia();">添加+</button></div>
<div class="col-md-6"></div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>学号</th>
<th>学生姓名</th>
<th>学生性别</th>
<th>所在系</th>
<th>班级</th>
<th>电话号码</th>
<th>操作</th>
</tr>
<c:forEach items="${studentlist}" var="stu">
<tr>
<td>${stu.stuId}</td>
<td>${stu.stuName}</td>
<td>${stu.stuSex}</td>
<td>${stu.stuSystem}</td>
<td>${stu.stuClass}</td>
<td>${stu.stuPhone}</td>
<td><button type="button" class="btn btn-info btn-xs" onclick="bianji(${stu.stuId});" ><i class="iconfont"></i> 编辑</button> <button type="button" onclick="del(${stu.stuId});" class="btn btn-danger btn-xs"><i class="iconfont"></i> 删除</button></td>
</tr>
</c:forEach>
</table>
<div id="page11" style="margin-top:5px; text-align:center;"></div>
</body>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
laypage({
cont: 'page11',
pages: Math.ceil("${stupage}"/6),
skip: true,
skin: '#6699FF',
curr: function(){
var page = location.search.match(/page=(\d+)/);
return page ? page[1] : 1;
}(),
jump: function(e, first){
if(!first){
var studengtname = document.getElementById("sousuo").value;
location.href = '?page='+e.curr + '&stuName=' + encodeURI(encodeURI(studengtname));
}
}
});
</script>
<script type="text/javascript">
function bianji(studentId) {
layer.open({
type: 2,
title: '学生信息编辑页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'studenteditor?stuId='+ studentId
});
}
function tianjia() {
layer.open({
type: 2,
title: '学生信息添加页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'studenteditor?stuId=0'
});
}
</script>
<script type="text/javascript">
function sousuo() {
var studentname = document.getElementById("sousuo").value;
location.href = 'studentlist?stuName='+ encodeURI(encodeURI(studentname)) + '&page=1' ;
}
</script>
</html>
subjectone.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<title>学生信息列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生个人信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>学号</th>
<th>学生姓名</th>
<th>学生性别</th>
<th>所在系</th>
<th>班级</th>
<th>电话号码</th>
<th>操作</th>
</tr>
<tr>
<td>${stuone.stuId}</td>
<td>${stuone.stuName}</td>
<td>${stuone.stuSex}</td>
<td>${stuone.stuSystem}</td>
<td>${stuone.stuClass}</td>
<td>${stuone.stuPhone}</td>
<td>
<button id = "xiugai" type="button" class="btn btn-info btn-xs" οnclick="xiugai();" >
<i class="iconfont"></i>
编辑
</button>
</td>
</tr>
</table>
</body>
<script type="text/javascript">
function xiugai() {
layer.open({
type: 2,
title: '学生个人信息修改页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'studenteditor?stuId='+"${stuone.stuId}"
});
}
</script>
</html>
subjecteditoe.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="<%=request.getContextPath()%>/css/H-ui.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/css/H-ui.1.x.patch.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/Validform.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/passwordStrength-min.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
$(function(){
$("#demoform-2").Validform({
tiptype:2,
usePlugin:{
datepicker:{},
passwordstrength:{
minLen:6,
maxLen:18,
trigger:function(obj,error){
if(error){
obj.parent().find(".Validform_checktip").show();
obj.parent().find(".passwordStrength").hide();
}else{
obj.parent().find(".passwordStrength").show();
}
}
}
}
});
});
</script>
<title>教师信息编辑页面</title>
</head>
<body>
<form action="" class="form form-horizontal responsive" id="demoform-2">
<div class="row cl">
<label class="form-label col-2">课程名字：</label>
<div class="formControls col-5">
<input type="text" name="subjectid" id = "subjectid" value="${subjectone.subjectId}" style="display:none;"/>
<input type="text" class="input-text" placeholder="请输入课程名字" name="subjectname" id="subjectname" value="${subjectone.subjectName}" datatype="s2-10" nullmsg="课程名字不能为空">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">授课老师：</label>
<div class="formControls col-5">
<input type="text" class="input-text" placeholder="请输入授课老师" name="teachername" id="teachername" value="${subjectone.teacherName}" datatype="s2-5" nullmsg="授课老师不能为空">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<label class="form-label col-2">学分：</label>
<div class="formControls col-5">
<input type="text" class="input-text" autocomplete="off" placeholder="请输入学分" name="subjectcredit" id="subjectcredit" value="${subjectone.subjectCredit}" datatype="n" nullmsg="学分不能为空">
</div>
<div class="col-5">
</div>
</div>
<div class="row cl">
<div class="col-10 col-offset-2">
<input class="btn btn-primary" type="button" onclick="hehe();" value=" 提交 ">
</div>
</div>
</form>
</body>
<script type="text/javascript">
function hehe() {
var subjectid = document.getElementById("subjectid").value;
if(subjectid==""){
subjectid = 0;
}
var subjectname = document.getElementById("subjectname").value;
var teachername = document.getElementById("teachername").value;
var subjectcredit = document.getElementById("subjectcredit").value;
if(subjectname==""||teachername==""||subjectcredit==""){
swal("哦豁","提交失败，请重试！","error");
return;
}
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status == 1){
swal({title:"提交成功！",text:"您已经向服务器了这条信息!",type:"success"},
function () {
parent.top.topManager.reloadPage();
parent.layer.closeAll();
});
}else{
swal("哦豁","提交失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","subjectadd?subjectId="+encodeURI(encodeURI(subjectid)) + "&subjectName=" + encodeURI(encodeURI(subjectname))+ "&teacherName=" + encodeURI(encodeURI(teachername))+ "&subjectCredit=" + encodeURI(encodeURI(subjectcredit)),true);
xmlhttp.send();
}
</script>
</html>
(5)分数和选课模块
ScoreBean.java
package com.stusystem.entity;
import org.apache.ibatis.type.Alias;
import org.springframework.stereotype.Component;
@Alias("scoreBean")
@Component
public class ScoreBean {
private int scoreId;
private int studentId;
private String subjectName;
private String studentName;
private String score;
private int subjectId;
private String teacherName;
private String subjectCredit;
private int page;
public int getPage() {
return (page-1)*6;
}
public void setPage(int page) {
this.page = page;
}
public String getSubjectCredit() {
return subjectCredit;
}
public void setSubjectCredit(String subjectCredit) {
this.subjectCredit = subjectCredit;
}
public String getTeacherName() {
return teacherName;
}
public void setTeacherName(String teacherName) {
this.teacherName = teacherName;
}
public int getScoreId() {
return scoreId;
}
public void setScoreId(int scoreId) {
this.scoreId = scoreId;
}
public int getStudentId() {
return studentId;
}
public void setStudentId(int studentId) {
this.studentId = studentId;
}
public String getSubjectName() {
return subjectName;
}
public void setSubjectName(String subjectName) {
this.subjectName = subjectName;
}
public String getStudentName() {
return studentName;
}
public void setStudentName(String studentName) {
this.studentName = studentName;
}
public String getScore() {
return score;
}
public void setScore(String score) {
this.score = score;
}
public int getSubjectId() {
return subjectId;
}
public void setSubjectId(int subjectId) {
this.subjectId = subjectId;
}
}
ScoreDao.java
package com.stusystem.dao;
import java.util.List;
import com.stusystem.entity.ScoreBean;
import com.stusystem.entity.StudentBean;
import com.stusystem.entity.SubjectBean;
public interface ScoreDao {
public List<ScoreBean> getscorelist(StudentBean studentBean) throws Exception;
public void scoreadd(ScoreBean score) throws Exception;
public List<SubjectBean> getSubject(ScoreBean score) throws Exception;
public int getsbjpage(ScoreBean score)throws Exception;
public void setsubject(ScoreBean score)throws Exception;
public List<SubjectBean> yxsubjectlist(ScoreBean score) throws Exception;
public void delyxkc(ScoreBean score) throws Exception;
public List<ScoreBean> getscoreonelist(ScoreBean score)throws Exception;
}
ScoreDao.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.stusystem.dao.ScoreDao">
<select id="getscorelist" parameterType="com.stusystem.entity.StudentBean" resultType="scoreBean">
SELECT score.score, `subject`.subject_name, score.score_id FROM score , `subject` WHERE score.subject_id = `subject`.subject_id AND score.student_id = #{stuId}
</select>
<update id="scoreadd" parameterType="scoreBean">
UPDATE score SET score=#{score} WHERE score_id=#{scoreId}
</update>
<select id="getSubject" parameterType="scoreBean" resultType="com.stusystem.entity.SubjectBean">
<if test=" subjectName != null and subjectName != '' ">select * from `subject` where subject_name = #{subjectName} and subject_id not in (select subject_id from score where student_id = #{studentId} ) limit #{page} ,6 </if>
<if test=" subjectName == null or subjectName == '' "> SELECT * FROM subject where subject_id not in (select subject_id from score where student_id = #{studentId} ) limit #{page} ,6 </if>
</select>
<select id="getsbjpage" parameterType="scoreBean" resultType="int">
<if test=" subjectName != null and subjectName != '' ">select count(*) from `subject` where subject_name = #{subjectName} and subject_id not in (select subject_id from score where student_id = #{studentId} )</if>
<if test=" subjectName == null or subjectName == '' "> select count(*) from subject where subject_id not in (select subject_id from score where student_id = #{studentId} ) </if>
</select>
<insert id="setsubject" parameterType="scoreBean">
INSERT INTO `score` (`student_id`, `subject_id`) VALUES (#{studentId},#{subjectId})
</insert>
<select id="yxsubjectlist" parameterType="scoreBean" resultType="com.stusystem.entity.SubjectBean">
SELECT * FROM subject where subject_id in (select subject_id from score where student_id = #{studentId} )
</select>
<delete id="delyxkc" parameterType="scoreBean">
DELETE FROM `score` WHERE `student_id`=#{studentId} and subject_id = #{subjectId}
</delete>
<select id="getscoreonelist" parameterType="scoreBean" resultType="scoreBean">
SELECT * FROM score , `subject` WHERE score.subject_id = `subject`.subject_id AND score.student_id = #{studentId}
</select>
</mapper>
ScoreController.java
package com.stusystem.controller;
import java.io.IOException;
import java.net.URLDecoder;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import com.stusystem.dao.ScoreDao;
import com.stusystem.dao.StudentDao;
import com.stusystem.entity.ScoreBean;
import com.stusystem.entity.StudentBean;
import com.stusystem.entity.SubjectBean;
@Controller
@RequestMapping(value = "score")
public class ScoreController {
@Autowired
private StudentDao studentDao;
@Autowired
private ScoreDao scoreDao;
@RequestMapping(value = {"/scorelist"})
public String getStudent(StudentBean stu,Model model) throws Exception{
if(stu.getStuName()!=null&&stu.getStuName()!=""){
stu.setStuName(URLDecoder.decode(stu.getStuName(), "UTF-8"));
}
List<StudentBean> stulist = studentDao.getStudent(stu);
int stupage = studentDao.getstupage(stu);
model.addAttribute("studentlist", stulist);
model.addAttribute("stupage", stupage);
model.addAttribute("studentname", stu.getStuName());
return "scorelist";
}
@RequestMapping(value = {"/scoreeditor"})
public String scoreeditor(StudentBean stu,Model model) throws Exception{
List<ScoreBean> scorelist = scoreDao.getscorelist(stu);
model.addAttribute("scorelist", scorelist);
if(scorelist.size()==0){
model.addAttribute("h1", " 这位同学还没有选课！！！");
}
return "scoreeditor";
}
@RequestMapping(value = {"/scoreadd"})
public void scoreadd(String scorelist,HttpServletResponse response) throws IOException {
int a = 0;
String[] scoreStrArray = scorelist.split(",");
ScoreBean score = new ScoreBean();
try{
for(int i = 0 ; i < scoreStrArray.length ; i+=2 ){
score.setScore(scoreStrArray[i]);
score.setScoreId(Integer.parseInt(scoreStrArray[i+1]));
scoreDao.scoreadd(score);
}
}catch (Exception e){
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}
}
@RequestMapping(value = {"/scoreone"})
public String scoreone(ScoreBean scorebean,Model model)throws Exception{
String subjectname =scorebean.getSubjectName();
if (subjectname != null && !"".equals(subjectname)) {
subjectname= URLDecoder.decode(subjectname, "UTF-8");
scorebean.setSubjectName(URLDecoder.decode(subjectname, "UTF-8")) ;
}
List<SubjectBean> subjectlist = scoreDao.getSubject(scorebean);
int sbjpage = scoreDao.getsbjpage(scorebean);
model.addAttribute("sbjpage", sbjpage);
model.addAttribute("subjectlist", subjectlist);
model.addAttribute("subjectname", subjectname);
return "scoreone";
}
@RequestMapping(value = {"/xuanke"})
public void xuanke(HttpServletResponse response,ScoreBean scorebean) throws IOException{
int a = 0;
try {
scoreDao.setsubject(scorebean);
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}
}
@RequestMapping(value = {"/xsyxkc"})
public String xsyxkc(ScoreBean scorebean,Model model) throws Exception{
List<SubjectBean> yxsubjectlist = scoreDao.yxsubjectlist(scorebean);
model.addAttribute("yxsubjectlist", yxsubjectlist);
return "xsyxkc";
}
@RequestMapping(value = {"/yxkcdel"})
public void yxkcdel(ScoreBean scorebean,HttpServletResponse response) throws IOException{
int a = 0;
try {
scoreDao.delyxkc(scorebean);
} catch (Exception e) {
a=a+1;
response.getWriter().println("{'status':'0'}");
e.printStackTrace();
}
if(a==0){
response.getWriter().println("{'status':'1'}");
}
}
@RequestMapping(value = {"/xsgrcjcx"})
public String xsgrcjcx(ScoreBean scorebean,Model model)throws Exception{
List<ScoreBean> scoreonelist = scoreDao.getscoreonelist(scorebean);
model.addAttribute("scoreonelist", scoreonelist);
if(scoreonelist.size()==0){
model.addAttribute("h1", "你还没有选课！！");
}
return "xsgrcjcx";
}
}
scorelist.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<title>学生列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生成绩管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="input-group">
<input type="text" class="form-control" placeholder="输入学生姓名搜索" id = "sousuo" value = "${studentname}">
<span class="input-group-btn">
<button class="btn btn-default" type="button" onclick="sousuo();">Go!</button>
</span>
</div>
</div>
<div class="col-md-3"></div>
<div class="col-md-6"></div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>学号</th>
<th>学生姓名</th>
<th>学生性别</th>
<th>所在系</th>
<th>班级</th>
<th>电话号码</th>
<th>操作</th>
</tr>
<c:forEach items="${studentlist}" var="stu">
<tr>
<td>${stu.stuId}</td>
<td>${stu.stuName}</td>
<td>${stu.stuSex}</td>
<td>${stu.stuSystem}</td>
<td>${stu.stuClass}</td>
<td>${stu.stuPhone}</td>
<td><button type="button" onclick="bianji(${stu.stuId});" class="btn btn-info btn-xs"><i class="iconfont"></i> 编辑该学生成绩</button></td>
</tr>
</c:forEach>
</table>
<div id="page11" style="margin-top:5px; text-align:center;"></div>
</body>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
laypage({
cont: 'page11',
pages: Math.ceil("${stupage}"/6),
skip: true,
skin: '#6699FF',
curr: function(){
var page = location.search.match(/page=(\d+)/);
return page ? page[1] : 1;
}(),
jump: function(e, first){
if(!first){
var studengtname = document.getElementById("sousuo").value;
location.href = '?page='+e.curr + '&stuName=' + encodeURI(encodeURI(studengtname));
}
}
});
</script>
<script type="text/javascript">
function bianji(studentid) {
layer.open({
type: 2,
title: '学生成绩编辑页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'scoreeditor?stuId='+studentid
});
}
</script>
<script type="text/javascript">
function sousuo() {
var studentname = document.getElementById("sousuo").value;
location.href = 'scorelist?stuName='+ encodeURI(encodeURI(studentname)) + '&page=1';
}
</script>
</html>
scoreone.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
function xuanze(subjectid,studentid) {
swal({
title: "您确定要选择本课程吗？",
text: "请选择与本人专业相关的课程！！",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "选择",
closeOnConfirm: false
}, function () {
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status== 1){
swal({title:"选择成功！",text:"您已经成功选择了本课程!",type:"success"},
function () {
location.href = "scoreone?page=1"+"&studentId="+'${userbean.userId}';
});
}else{
swal("哦豁","选择失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","xuanke?subjectId="+ subjectid + "&studentId=" + studentid ,true);
xmlhttp.send();
});
}
</script>
<title>课程列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生个人课程信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="input-group">
<input type="text" class="form-control" placeholder="输入课程名搜索" id = "sousuo" value = "${subjectname}">
<span class="input-group-btn">
<button class="btn btn-default" type="button" onclick="sousuo();">Go!</button>
</span>
</div>
</div>
<div class="col-md-3"><button type="button" class="btn btn-default" onclick="yxkc();">查看已选择课程</button></div>
<div class="col-md-6"></div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>课程编号</th>
<th>课程名字</th>
<th>授课老师</th>
<th>课程学分</th>
<th>操作</th>
</tr>
<c:forEach items="${subjectlist}" var="sbj">
<tr>
<td>${sbj.subjectId}</td>
<td>${sbj.subjectName}</td>
<td>${sbj.teacherName}</td>
<td>${sbj.subjectCredit}</td>
<td>
<button id = "${sbj.subjectId}" type="button" class="btn btn-info btn-xs" οnclick="xuanze(${sbj.subjectId},${userbean.userId});" >
<i class="iconfont"></i>
添加本课程
</button>
</td>
</tr>
</c:forEach>
</table>
<div id="page11" style="margin-top:5px; text-align:center;"></div>
</body>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
var aa = Math.ceil("${sbjpage}"/6);
laypage({
cont: 'page11',
pages: aa,
skip: true,
skin: '#6699FF',
curr: function(){
var page = location.search.match(/page=(\d+)/);
return page ? page[1] : 1;
}(),
jump: function(e, first){
if(!first){
var subjectname = document.getElementById("sousuo").value;
location.href = '?page='+e.curr + '&subjectName=' + encodeURI(encodeURI(subjectname)+'&studentId=' + '${userbean.userId}');
}
}
});
</script>
<script type="text/javascript">
function sousuo() {
var subjectname = document.getElementById("sousuo").value;
location.href = 'scoreone?subjectName='+ encodeURI(encodeURI(subjectname)) + '&page=1' + '&studentId=' + '${userbean.userId}' ;
}
function yxkc() {
layer.open({
type: 2,
title: '学生已选课程信息页面',
shadeClose: true,
shade: 0.8,
shift: 1,
area: ['800px', '80%'],
content: 'xsyxkc?studentId='+"${userbean.userId}"
});
}
</script>
</html>
scoreeditor,jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="<%=request.getContextPath()%>/css/H-ui.css" rel="stylesheet" type="text/css" />
<link href="<%=request.getContextPath()%>/css/H-ui.1.x.patch.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/Validform.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/lib/Validform/5.3.2/passwordStrength-min.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<script type="text/javascript">
$(function(){
$("#demoform-2").Validform({
tiptype:2,
usePlugin:{
datepicker:{},
passwordstrength:{
minLen:6,
maxLen:18,
trigger:function(obj,error){
if(error){
obj.parent().find(".Validform_checktip").show();
obj.parent().find(".passwordStrength").hide();
}else{
obj.parent().find(".passwordStrength").show();
}
}
}
}
});
});
</script>
<title>学生成绩编辑页面</title>
</head>
<body>
<div class="row" id = "demo">
<div class="col-md-4"><h1>${h1}</h1></div>
<div class="col-md-4"></div>
<div class="col-md-4"></div>
</div>
<form action="" class="form form-horizontal responsive" id="demoform-2">
<c:forEach items="${scorelist}" var="sco">
<div class="row cl">
<label class="form-label col-3">${sco.subjectName}：</label>
<div class="formControls col-5">
<input type="text" name="scoreid" id = "scoreid" value="${sco.scoreId}" style="display:none;"/>
<input type="text" value = "${sco.score}" class="input-text" placeholder="请输入${sco.subjectName}成绩" name="scorelist" datatype="n1-3" nullmsg="成绩不能为空，可以为零" >
</div>
<div class="col-4">
</div>
</div>
</c:forEach>
<div class="row cl">
<div class="col-10 col-offset-2">
<input class="btn btn-primary" type="button" οnclick="hehe();" id = "tijiao" value=" 提交 ">
</div>
</div>
</form>
</body>
<script type="text/javascript">
var list = document.getElementsByName("scorelist");
if(list.length==0){
$("input").hide();
}
function hehe() {
var list1 = document.getElementsByName("scorelist");
var list2 = document.getElementsByName("scoreid");
var scorelist = [list1.length];
for(var i = 0 ;i < list1.length ; i++){
scorelist[i] = [list1[i].value,list2[i].value];
}
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status == 1){
swal({title:"提交成功！",text:"您已经向服务器了这条信息!",type:"success"},
function () {
parent.top.topManager.reloadPage();
parent.layer.closeAll();
});
}else{
swal("哦豁","提交失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","scoreadd?scorelist="+scorelist ,true);
xmlhttp.send();
}
</script>
</html>
xsgrcjcx.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<title>课程列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生个人课程信息管理表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<br/>
<table class="table table-hover" id = 'table'>
<tr class="info">
<th>课程编号</th>
<th>课程名字</th>
<th>授课老师</th>
<th>课程学分</th>
<th>分数</th>
</tr>
<c:forEach items="${scoreonelist}" var="sco">
<tr>
<td>${sco.subjectId}</td>
<td>${sco.subjectName}</td>
<td>${sco.teacherName}</td>
<td>${sco.subjectCredit}</td>
<td>${sco.score}</td>
</tr>
</c:forEach>
</table>
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h1>${h1}</h1></div>
<div class="col-md-4"></div>
</div>
<div id="page11" style="margin-top:5px; text-align:center;"></div>
</body>
</html>
xsyxkc.jsp
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/iconfont.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/sweetalert/sweetalert.css">
<script src="<%=request.getContextPath()%>/js/jquery.js"></script>
<script src="<%=request.getContextPath()%>/lib/layer/1.9.3/layer.js"></script>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script src="<%=request.getContextPath()%>/js/sweetalert/sweetalert.min.js"></script>
<title>已选课程列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="container-fluid">
<div class="row">
<div class="col-md-4"></div>
<div class="col-md-4"><h2 class="text-center">学生已选课程表</h2></div>
<div class="col-md-4"></div>
</div>
</div>
<br/>
<table class="table table-hover">
<tr class="info">
<th>课程编号</th>
<th>课程名字</th>
<th>授课老师</th>
<th>课程学分</th>
<th>操作</th>
</tr>
<c:forEach items="${yxsubjectlist}" var="sbj">
<tr>
<td>${sbj.subjectId}</td>
<td>${sbj.subjectName}</td>
<td>${sbj.teacherName}</td>
<td>${sbj.subjectCredit}</td>
<td>
<button type="button" class="btn btn-danger btn-xs" onclick="del(${sbj.subjectId},${userbean.userId});" >
<i class="iconfont"></i>
删除本课程
</button>
</td>
</tr>
</c:forEach>
</table>
</body>
<script src="<%=request.getContextPath()%>/lib/laypage/1.2/laypage.js"></script>
<script type="text/javascript">
function del(subjectid,studentid) {
swal({
title: "您确定要删除这条信息吗",
text: "删除后将无法恢复，请谨慎操作！",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
confirmButtonText: "删除",
closeOnConfirm: false
}, function () {
if (window.XMLHttpRequest){
xmlhttp=new XMLHttpRequest();
}
else{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function(){
if (xmlhttp.readyState==4 && xmlhttp.status==200){
var a = eval("("+xmlhttp.responseText+")");
if(a.status== 1){
swal({title:"删除成功！",text:"您已经永久删除了这条信息!",type:"success"},
function () {
location.href = 'xsyxkc?studentId=' + '${userbean.userId}' ;
});
}else{
swal("哦豁","删除失败，请重试！","error");
}
}
} ;
xmlhttp.open("post","yxkcdel?subjectId=" + subjectid + "&studentId=" + studentid,true);
xmlhttp.send();
});
}
</script>
</html>
关于界面gy.jsp：
<!DOCTYPE HTML>
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script src="<%=request.getContextPath()%>/js/jquery-1.8.3.js"></script>
<link rel="stylesheet" href="<%=request.getContextPath()%>/font/font1/LiDeBiao-Xing3.css">
<link rel="stylesheet" href="<%=request.getContextPath()%>/css/bootstrap.min.css">
<title>学生列表</title>
</head>
<body background="<%=request.getContextPath()%>/images/010.gif">
<div class="row">
<div class="col-md-2"></div>
<div class="col-md-8">
<div style='font-size: 60px;font-family:LiDeBiao-Xing3555757;margin-top:100px;' >
系统开发中。。。。。。。
</div>
</div>
<div class="col-md-2"></div>
</div>
</body>
</html>
项目截图：
。。。。。
具体项目源码地址：
源码地址：https://gitee.com/z77z/StuSystem
