开发工具：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
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" />
<!-- 使用Annotation自动注册Bean，解决事物失效问题：在主容器中不扫描@Controller注解，在SpringMvc中只扫描@Controller注解。 -->
<context:component-scan base-package="com.stusystem.controller"><!-- base-package 如果多个，用“,”分隔 -->
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- MyBatis begin -->
<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>
<!-- 扫描basePackage下所有以@MyBatisDao注解的接口 -->
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
<property name="basePackage" value="com.stusystem.dao"/>
</bean>
<!-- 定义事务，用@Transactiona注解表示事物 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 配置 Annotation 驱动，扫描@Transactional注解的类定义事务 -->
<tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
<!-- MyBatis end -->
<!-- 配置 JSR303 Bean Validator 定义 -->
<bean id="validator" class="org.springframework.validation.beanvalidation.LocalValidatorFactoryBean" />
<!-- 数据源配置, 使用 BoneCP 数据库连接池 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<!-- 数据源驱动类可不写，Druid默认会自动根据URL识别DriverClass -->
<property name="driverClassName" value="${jdbc.driver}" />
<!-- 基本属性 url、user、password -->
<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" />
<!-- 配置监控统计拦截的filters -->
<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"/>
<!-- 是否允许单条sql 返回多个数据集 (取决于驱动的兼容性) default:true -->
<setting name="multipleResultSetsEnabled" value="true"/>
<!-- 是否可以使用列的别名 (取决于驱动的兼容性) default:true -->
<setting name="useColumnLabel" value="true"/>
<!-- 允许JDBC 生成主键。需要驱动器支持。如果设为了true，这个设置将强制使用被生成的主键，有一些驱动器不兼容不过仍然可以执行。 default:false -->
<setting name="useGeneratedKeys" value="false"/>
<!-- 指定 MyBatis 如何自动映射 数据基表的列 NONE：不隐射 PARTIAL:部分 FULL:全部 -->
<setting name="autoMappingBehavior" value="PARTIAL"/>
<!-- 这是默认的执行类型 （SIMPLE: 简单； REUSE: 执行器可能重复使用prepared statements语句；BATCH: 执行器可以重复执行语句和批量更新） -->
<setting name="defaultExecutorType" value="SIMPLE"/>
<!-- 使用驼峰命名法转换字段。 -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
<!-- 设置本地缓存范围 session:就会有数据的共享 statement:语句范围 (这样就不会有数据的共享 ) defalut:session -->
<setting name="localCacheScope" value="SESSION"/>
<!-- 设置但JDBC类型为空时,某些驱动程序 要指定值,default:OTHER，插入空值时不需要指定类型 -->
<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" />
<!-- 使用Annotation自动注册Bean,只扫描@Controller -->
<context:component-scan base-package="com.stusystem" use-default-filters="false"><!-- base-package 如果多个，用“,”分隔 -->
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 默认的注解映射的支持，org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping -->
<mvc:annotation-driven content-negotiation-manager="contentNegotiationManager">
<mvc:message-converters register-defaults="true">
<!-- 将StringHttpMessageConverter的默认编码设为UTF-8 -->
<bean class="org.springframework.http.converter.StringHttpMessageConverter">
<constructor-arg value="UTF-8" />
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!-- REST中根据URL后缀自动判定Content-Type及相应的View -->
<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="${web.view.suffix}"/> -->
<property name="suffix" value=".jsp"/>
</bean>
<!-- 对静态资源文件的访问， 将无法mapping到Controller的path交给default servlet handler处理 -->
<mvc:default-servlet-handler />
<!-- 静态资源映射 -->
<mvc:resources mapping="/static/**" location="/static/" cache-period="31536000"/>
<!-- 定义无Controller的path<->view直接映射 -->
<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
六、各个模块代码
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">
<!-- namesapce ,DAO的package路径 -->
<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;
// ApplicationContext applicationContext = new ClassPathXmlApplicationContext("classpath:spring-context.xml");
// UserDao userDao = (UserDao) applicationContext.getBean("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{
// 用户的信息存放到session中。
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}); //0代表加载的风格，支持0-2
</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,//设置密码长度最小值，默认为0;
maxLen:18,//设置密码长度最大值，默认为30;
trigger:function(obj,error){
//该表单元素的keyup和blur事件会触发该函数的执行;
//obj:当前表单元素jquery对象;
//error:所设密码是否符合验证要求，验证不能通过error为true，验证通过则为false;
//console.log(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;//返回学生信息的list
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">
<!-- namespace ,DAO的package路径 -->
<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>
<!--根据id查询出一条学生信息-->
<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;
// ApplicationContext applicationContext = new ClassPathXmlApplicationContext("classpath:spring-context.xml");
// StudentDao studentDao = (StudentDao) applicationContext.getBean("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{
}
}
//添加/修改 （ 以是否有stuId来判断） 学生信息
@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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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), //可以叫服务端把总页数放在某一个隐藏域，再获取。假设我们获取到的是18 length
skip: true, //是否开启跳页
skin: '#6699FF',
curr: function(){ //通过url获取当前页，也可以同上（pages）方式获取
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, //0-6的动画形式，-1不开启
area: ['800px', '80%'],
content: 'studenteditor?stuId='+ studentId
});
}
function tianjia() {
layer.open({
type: 2,
title: '学生信息添加页面',
shadeClose: true,
shade: 0.8,
shift: 1, //0-6的动画形式，-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, //0-6的动画形式，-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,//设置密码长度最小值，默认为0;
maxLen:18,//设置密码长度最大值，默认为30;
trigger:function(obj,error){
//该表单元素的keyup和blur事件会触发该函数的执行;
//obj:当前表单元素jquery对象;
//error:所设密码是否符合验证要求，验证不能通过error为true，验证通过则为false;
//console.log(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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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;//根据Id返回一条教师记录
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">
<!-- namespace ,DAO的package路径 -->
<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>
<!-- 根据id查询出一条教师信息 -->
<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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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), //可以叫服务端把总页数放在某一个隐藏域，再获取。假设我们获取到的是18
skip: true, //是否开启跳页
skin: '#6699FF',
curr: function(){ //通过url获取当前页，也可以同上（pages）方式获取
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, //0-6的动画形式，-1不开启
area: ['800px', '80%'],
content: 'teachereditor?teacherId='+ teacherId
});
}
function tianjia() {
layer.open({
type: 2,
title: '教师信息编辑页面',
shadeClose: true,
shade: 0.8,
shift: 1, //0-6的动画形式，-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, //0-6的动画形式，-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,//设置密码长度最小值，默认为0;
maxLen:18,//设置密码长度最大值，默认为30;
trigger:function(obj,error){
//该表单元素的keyup和blur事件会触发该函数的执行;
//obj:当前表单元素jquery对象;
//error:所设密码是否符合验证要求，验证不能通过error为true，验证通过则为false;
//console.log(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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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">
<!-- namesapce ,DAO的package路径 -->
<mapper namespace="com.stusystem.dao.SubjectDao">
<!-- 查询所有课程信息的list -->
<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);//如subjecteditor.jsp中可用subjectone.sybjectId来获取课程号
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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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), //可以叫服务端把总页数放在某一个隐藏域，再获取。假设我们获取到的是18 length
skip: true, //是否开启跳页
skin: '#6699FF',
curr: function(){ //通过url获取当前页，也可以同上（pages）方式获取
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, //0-6的动画形式，-1不开启
area: ['800px', '80%'],
content: 'studenteditor?stuId='+ studentId
});
}
function tianjia() {
layer.open({
type: 2,
title: '学生信息添加页面',
shadeClose: true,
shade: 0.8,
shift: 1, //0-6的动画形式，-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, //0-6的动画形式，-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,//设置密码长度最小值，默认为0;
maxLen:18,//设置密码长度最大值，默认为30;
trigger:function(obj,error){
//该表单元素的keyup和blur事件会触发该函数的执行;
//obj:当前表单元素jquery对象;
//error:所设密码是否符合验证要求，验证不能通过error为true，验证通过则为false;
//console.log(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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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;
//查询一个学生已选课程信息的list
public List<SubjectBean> yxsubjectlist(ScoreBean score) throws Exception;
//删除一条已选课程
public void delyxkc(ScoreBean score) throws Exception;
//查询一个学生的已选课程成绩和课程信息的list
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">
<!-- namesapce ,DAO的package路径 -->
<mapper namespace="com.stusystem.dao.ScoreDao">
<!-- 多表查询查询出一个学生的成绩和其他信息保存到一个score对象中 -->
<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>
<!--查询一个学生的未选选课程信息list -->
<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>
<!-- 查询一个学生已选课程信息的list-->
<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>
<!-- 查询一个学生的已选课程成绩和课程信息的list-->
<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;
//要注入必须要将这个类在spring容器中注册
@Autowired
private ScoreDao scoreDao;
// ApplicationContext applicationContext = new ClassPathXmlApplicationContext("classpath:spring-context.xml");
// StudentDao studentDao = (StudentDao) applicationContext.getBean("studentDao");
// ScoreDao scoreDao = (ScoreDao) applicationContext.getBean("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";
}
//查询出一个学生已选课程信息list到该学生成绩编辑页面
@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";
}
//得到在编辑页面编辑好一个学生的各科成绩的list，循环存入数据库中后，在返回存入结果
@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'}");
}
}
//查询出一个学生的未选课程的信息list
@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'}");
}
}
//返回一个学生的已选课程的list到已选课程编辑页面
@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), //可以叫服务端把总页数放在某一个隐藏域，再获取。假设我们获取到的是18 length
skip: true, //是否开启跳页
skin: '#6699FF',
curr: function(){ //通过url获取当前页，也可以同上（pages）方式获取
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, //0-6的动画形式，-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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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, //可以叫服务端把总页数放在某一个隐藏域，再获取。假设我们获取到的是18 length
skip: true, //是否开启跳页
skin: '#6699FF',
curr: function(){ //通过url获取当前页，也可以同上（pages）方式获取
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, //0-6的动画形式，-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,//设置密码长度最小值，默认为0;
maxLen:18,//设置密码长度最大值，默认为30;
trigger:function(obj,error){
//该表单元素的keyup和blur事件会触发该函数的执行;
//obj:当前表单元素jquery对象;
//error:所设密码是否符合验证要求，验证不能通过error为true，验证通过则为false;
//console.log(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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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){
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
} //创建XMLHttpRequest对象
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> <!-- 站在巨人的肩膀上，在互联网的胯下疯狂输出！<br/> ——邹海清 --> </html>
注：参考往届学长的代码：https://www.cnblogs.com/liangmingda/p/13561915.html