前言
最近一直在学习SSM框架，通过在博客上面和查看视频来学习，所以在此感谢各位大佬的分享。在此记录一下自己用SSM框架搭建的选课系统，实现简单的增删改查功能。实际上可以做的更好一些，但是迫切想学习新的东西，就先做一个简单的雏形吧。在之前的博客也有些自己使用JSP和javabean实现的选课系统，但是代码比较乱，当时就觉得等学习完SSM框架要再做一个好一点的。
建立数据库
之前用的是h2数据库，但是感觉h2的使用人数好像比较少，后来就下载了mysql，直接在里面建立三个比较简单的数据库
create schema courseselectionsystem;
create table courseselectionsystem.user(
username varchar(100),
password varchar(200),
realname varchar(100),
phone int(11)
);
create table courseselectionsystem.course(
coursename varchar(20),
teacher varchar(20),
number int(100)
);
create table courseselectionsystem.user_course(
username varchar(100) references user(username),
coursename varchar(20) references course(coursename)
)
之前学过数据库这门课程，这个应该是符合第三范式的。知识建立三个表，比较简单
搭建SSM环境
首先看一下我的整个目录；
主要是看每个xml文件放置的路径，因为这个路径比较重要。
首先看pom.xml里面的依赖包
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>lixiaoli</groupId>
<artifactId>CourseSelectiveSystem</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>CourseSelectiveSystem Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies><dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
<!-- 1.springmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<!-- 返回json字符串支持 -->
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.7</version>
</dependency>
<!-- hibernate-validator jsr303校验 -->
<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-validator -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>5.3.5.Final</version>
</dependency>
<!-- 2.spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>5.1.3.RELEASE</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-test -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.1.3.RELEASE</version>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.2</version>
</dependency>
<!-- 3.mybatis -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<!-- <dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.3</version>
</dependency> -->
<!-- 日志 -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.12</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.12</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- 4.数据库连接池和驱动 -->
<!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!-- 5.其他(jstl servlet-api junit) -->
<!-- https://mvnrepository.com/artifact/jstl/jstl -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/junit/junit -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<finalName>sss-test</finalName>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.0</version>
<configuration>
<!-- 指定source和target的版本 -->
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
这里说明一下，我在写这个的时候有遇到过问题，Failure to transfer org.apache.maven.plugins:maven-compiler-plugin，找了很久，最后通过以下博客找到解答：
https://blog.csdn.net/wlwlwlwl015/article/details/50561921
接下来看看web.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">
<!-- 启动spring的容器 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
<!-- Spring MVC的前端控制器 -->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:SpringMVC-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 字符编码过滤器 -->
<filter>
<filter-name>characterEncodingFilter</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>forceRequestEncoding</param-name>
<param-value>true</param-value>
</init-param>
<init-param>
<param-name>forceResposeEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 使用rest风格的URI -->
<filter>
<filter-name>HiddenHttpMethodFilter</filter-name>
<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>HiddenHttpMethodFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<display-name>Archetype Created Web Application</display-name>
</web-app>
这个主要就是配置路径的问题了，spring的文件和springMVC的文件都是放在SRC/MAIN/RESOURCES路径下面，所以路径就是classpath，如果房子啊不同地方，就要做相应的修改了。
接着来看applicationContext.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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<context:component-scan base-package="com.course">
<context:exclude-filter type="annotation"
expression="org.springframework.stereotype.Controller" />
</context:component-scan>
<!--sping的配置文件和业务逻辑有关的 -->
<context:property-placeholder location="classpath:jdbc.properties" />
<bean id="pooledDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="driverClass" value="${jdbc.driver}"></property>
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 配置和mybatis的整合 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!-- 指定mybatis全局配置文件的位置 -->
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
<property name="dataSource" ref="pooledDataSource"></property>
<!-- 指定mybatis mapper文件的位置 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
</bean>
<!-- 配置扫描器 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 扫描素有的dao接口的实现，加入到容器中 -->
<property name="basePackage" value="com.course.dao"></property>
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="pooledDataSource"></property>
</bean>
<!-- 开启基于注解的事务 -->
<aop:config>
<!-- 切入点表达式 -->
<aop:pointcut expression="execution(* com.course.service..*(..))"
id="txPoint"></aop:pointcut>
<aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint" />
</aop:config>
<!-- 配置事务增强 -->
<tx:advice id="txAdvice">
<tx:attributes>
<tx:method name="*" />
<tx:method name="get*" read-only="true" />
</tx:attributes>
</tx:advice>
</beans>
这里面开始出现一些包名了，我是根据自己的包名来写的，这个是可以修改的，后面我也会一一展示自己的每个包里面的每个类。
applicationContext.xml文件里面还提到了jdbc.properties，这个是来连接数据库的一些信息：
jdbc.url=jdbc:mysql://localhost:3306/courseselectionsystem?useSSL=false
jdbc.driver=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=123456
这个也是根据自己的数据库，账号和密码来改就可以。
接着是mybatis文件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="mapUnderscoreToCamelCase" value="true" />
<!-- 在控制台输出相应的sql语句 -->
<!-- <setting name="logImpl" value="STDOUT_LOGGING"/> -->
</settings>
<typeAliases>
<package name="com.course.bean" />
</typeAliases>
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 参数合理化，不可能转到小于0的页数或者大于pageNum的页数 -->
<property name="reasonable" value="true"/>
</plugin>
</plugins>
</configuration>
这个要说明一下，刚开始配置环境的时候还不涉及到分页，所以
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 参数合理化，不可能转到小于0的页数或者大于pageNum的页数 -->
<property name="reasonable" value="true"/>
</plugin>
</plugins>
这个不要写，直接先注释掉，不然的话会出错，我刚开始就是因为这个出错。
接着就是dpringMVC的文件SpringMVC-servlet.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:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- spring MVC配置，包含网站跳转逻辑的控制，配置 -->
<context:component-scan base-package="com.course"
use-default-filters="false">
<!-- 只扫描控制器 -->
<context:include-filter type="annotation"
expression="org.springframework.stereotype.Controller"></context:include-filter>
</context:component-scan>
<!-- 定义无Controller的path<->view直接映射 -->
<!-- 定义视图文件解析 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/views/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 支持springmvc更高级的功能,就jsr303,ajax -->
<mvc:annotation-driven></mvc:annotation-driven>
<!-- 将springmvc不能处理的请求交给tomcat -->
<mvc:default-servlet-handler />
</beans>
至此就配置好环境了，运行一下程序，看看会不会出错，如果没有出错就是已经配置好了，如果出错了就根据提示慢慢找错误，我自己搭建环境真的搭建了超级久，因为总是有很多奇奇怪怪的错误。
环境搭建完之后就是生成mybatis的逆向工程了，我在前面的博客有具体提到怎么搭建，但是这里还是直接贴上代码。
首先是先建立各个包，海域mapper文件
刚开始的包都是空的，因为我是已经完成了代码的编写才来写博客的，所以我的包不是空的。
接着在根目录下建立generatorConfig.xml文件，代码如下：
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- 禁止添加注释 -->
<commentGenerator>
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!-- 数据库连接信息 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/courseselectionsystem?useSSL=false"
userId="root" password="123456">
</jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- 指定javabean生成的位置 -->
<javaModelGenerator targetPackage="com.course.bean"
targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- 指定映射文件生成的位置 -->
<sqlMapGenerator targetPackage="mapper" targetProject=".\src\main\resources">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- 指定dao接口生成的位置 -->
<javaClientGenerator type="XMLMAPPER"
targetPackage="com.course.dao" targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table tableName="user" domainObjectName="userBean"></table>
<table tableName="course" domainObjectName="courseBean"></table>
<table tableName="user_course" domainObjectName="user_courseBean"></table>
</context>
</generatorConfiguration>
这里面是对于我一开始所建立的表的。如果你建立的表跟我一样，那就可以直接复制过去用了。接着的com.course.test包里面建立测试类MBGTest.java
package com.course.test;
import java.io.File;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.Configuration;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.exception.InvalidConfigurationException;
import org.mybatis.generator.exception.XMLParserException;
import org.mybatis.generator.internal.DefaultShellCallback;
public class MBGTest {
public static void main(String args[])
throws IOException, XMLParserException, InvalidConfigurationException, SQLException, InterruptedException {
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
File configFile = new File("generatorConfig.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
}
然后运行程序，然后刷新项目，就可以看到bean包和dao包以及mapper文件里面都自动生成了各个java类和xml文件。mybatis逆向工程就完成了。这里顺便贴出另外一位大佬的博客，也是比较详细地给出这一整个过程，我也参考了他的代码，但是有些改动，大家也可以作为参考，如果跟着我建立有问题就跟着他建立试试。https://blog.csdn.net/u010378929/article/details/79057872
至此，环境搭建就完全可以了，接下来就是写业务逻辑功能了。
选课系统
首先看一下webapp的目录
首先static里面是bootstrap的文件，这个会死一个封装好的css文件，我觉得还不错，作为学习，我就用了这个。这个可以下载到自己电脑，也可以不下载，直接引用网页资源，但是我还是下载了，因为下载非常简单。首先就是搜索bootstrap，然后下载，解压，贴出几张过程照片
最后这个是解压前和解压后的文件，把解压后的文件复制到static文件夹下面。static文件夹里面还有一个js文件，这个是jQuery的文件，这个也是直接搜索下载就可以，哪个版本都一样，这里就不说明了。
然后就是代码了，由于代码比较多，所以就不多说明，直接给出代码和所对应的位置。
各个包：
CourseController.java：
package com.course.controller;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
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 org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.course.bean.courseBean;
import com.course.service.CourseService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
@Controller
public class CourseController {
@Autowired
CourseService courseService;
@RequestMapping("/Cou")
public String getCourse(@RequestParam(value="pn",defaultValue="1")Integer pn,
Model model,HttpServletRequest request){
//String userName=request.getParameter("loginuserName");
//System.out.println(userName);
PageHelper.startPage(pn, 5);
List<courseBean> result=courseService.getAllCourse();
PageInfo page=new PageInfo<>(result,5);
model.addAttribute("pageInfo", page);
return "courseList";
}
@RequestMapping(value="/insert",method=RequestMethod.POST)
@ResponseBody
public boolean insertCourse(HttpServletRequest request){
String coursename=request.getParameter("coursename");
/* String userName=request.getParameter("loginuserName");
String password=request.getParameter("loginpassword");*/
HttpServletRequest httprequest = (HttpServletRequest)request;
HttpSession session = httprequest.getSession();
String userName=(String) session.getAttribute("userName");
System.out.println(userName);
if(courseService.insert(coursename,userName))
return true;
else return false;
/* System.out.println(coursename);*/
}
}
firstController.java：
package com.course.controller;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.websocket.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.course.bean.userBean;
import com.course.service.userService;
@Controller
public class firstController {
@Autowired
userService userService;
@RequestMapping("/first")
public String userLogin(){
return "first";
}
@RequestMapping("/firstcheck")
@ResponseBody
public boolean firstcheck(HttpServletRequest request){
String userName=request.getParameter("loginuserName");
String password=request.getParameter("loginpassword");
HttpServletRequest httprequest = (HttpServletRequest)request;
HttpSession session = httprequest.getSession();
session.setAttribute("userName", userName);
session.setAttribute("password", password);
//System.out.println(userName);
if(userService.firstchexk(userName,password)==true){
return true ;
}
else return false;
}
}
perController.java
package com.course.controller;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
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 org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import com.course.bean.courseBean;
import com.course.bean.user_courseBean;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.course.service.perService;
@Controller
public class perController {
@Autowired
perService perService;
@RequestMapping("/per")
public String toPer(@RequestParam(value="pn",defaultValue="1")Integer pn,
Model model,HttpServletRequest request){
HttpServletRequest httprequest = (HttpServletRequest)request;
HttpSession session = httprequest.getSession();
String userName=(String) session.getAttribute("userName");
PageHelper.startPage(pn, 5);
List<user_courseBean> result=perService.getAllselectedCourse(userName);
PageInfo page=new PageInfo<>(result,5);
model.addAttribute("pageInfo", page);
return "perList";
}
@RequestMapping(value="/delete",method=RequestMethod.POST)
@ResponseBody
public boolean deleteCourse(HttpServletRequest request){
String coursename=request.getParameter("coursename");
/* String userName=request.getParameter("loginuserName");
String password=request.getParameter("loginpassword");*/
HttpServletRequest httprequest = (HttpServletRequest)request;
HttpSession session = httprequest.getSession();
String userName=(String) session.getAttribute("userName");
System.out.println(userName);
if(perService.delete(coursename,userName))
return true;
else return false;
/* System.out.println(coursename);*/
}
}
userController.java
package com.course.controller;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.course.bean.userBean;
import com.course.service.userService;
@Controller
public class userController {
@Autowired
userService userService;
@RequestMapping("/user")
public String userLogin(){
return "login";
}
@RequestMapping("/select")
@ResponseBody
public String isexits(HttpServletRequest request){
String userName=request.getParameter("userName");
String password=request.getParameter("password");
String realName=request.getParameter("realName");
Integer phone= Integer.valueOf(request.getParameter("phone"));
//System.out.println(password);
if(userService.chexk(userName)==true){
userBean userBean=new userBean(userName,password,realName,phone);
userService.insert(userBean);
return "true" ;
}
else return "false";
}
}
CourseService.java：
package com.course.service;
import java.util.Iterator;
import java.util.List;
import com.course.bean.user_courseBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.course.bean.courseBean;
import com.course.bean.courseBeanExample;
import com.course.bean.courseBeanExample.Criteria;
import com.course.dao.courseBeanMapper;
import com.course.dao.user_courseBeanMapper;
@Service
public class CourseService {
@Autowired
courseBeanMapper courseBeanMapper;
@Autowired
user_courseBeanMapper user_courseBeanMapper;
public List<courseBean> getAllCourse() {
// TODO Auto-generated method stub
return courseBeanMapper.selectByExample(null) ;
}
public boolean insert(String coursename,String userName){
int number=-1;
String teacher=null;
List<user_courseBean> list=user_courseBeanMapper.selectByExample(null);
Iterator<user_courseBean> it1 = list.iterator();
while(it1.hasNext()){
user_courseBean user=it1.next();
/*如果已经选了该课程，则直接返回false*/
if(user.getCoursename().equals(coursename)&&user.getUsername().equals(userName))
return false;
}
/*
* 如果没有选该课程，则插入该课程
* */
user_courseBean user_courseBean=new user_courseBean(userName,coursename);
user_courseBeanMapper.insert(user_courseBean);
/*
* 查询couse里面课程的选课人数
* */
courseBeanExample example=new courseBeanExample();
example.setDistinct(true);
Criteria criteria = example.createCriteria();
criteria.andCoursenameEqualTo(coursename);
List<courseBean> result=courseBeanMapper.selectByExample(example);
Iterator<courseBean> it2 = result.iterator();
if(it2.hasNext())
{
courseBean corse=it2.next();
number=corse.getNumber();
teacher=corse.getTeacher();
}
/*
* 更新选课的人数
* */
courseBeanExample example1=new courseBeanExample();
Criteria criteria1 = example1.createCriteria();
criteria1.andCoursenameEqualTo(coursename);
courseBean coursebean=new courseBean();
coursebean.setNumber(number+1);
coursebean.setTeacher(teacher);
coursebean.setCoursename(coursename);
int tt=-1;
tt=courseBeanMapper.updateByExample(coursebean,example1);
return true;
}
}
perService.java
package com.course.service;
import java.util.Iterator;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.course.bean.courseBean;
import com.course.bean.courseBeanExample;
import com.course.dao.courseBeanMapper;
import com.course.bean.user_courseBean;
import com.course.bean.user_courseBeanExample;
import com.course.bean.user_courseBeanExample.Criteria;
import com.course.dao.user_courseBeanMapper;;
@Service
public class perService {
@Autowired
courseBeanMapper courseBeanMapper;
@Autowired
user_courseBeanMapper user_courseBeanMapper;
public List<user_courseBean> getAllselectedCourse(String userName) {
user_courseBeanExample example=new user_courseBeanExample();
//example.setDistinct(true);
Criteria criteria = example.createCriteria();
criteria.andUsernameEqualTo(userName);
List<user_courseBean> result=user_courseBeanMapper.selectByExample(example);
return result;
}
public boolean delete(String coursename, String userName) {
// TODO Auto-generated method stub
int number=-1;
String teacher=null;
boolean flag=false;
List<user_courseBean> list=user_courseBeanMapper.selectByExample(null);
Iterator<user_courseBean> it1 = list.iterator();
while(it1.hasNext()){
user_courseBean user=it1.next();
/*如果已经选了该课程，则直接返回false*/
if(user.getCoursename().equals(coursename)&&user.getUsername().equals(userName))
{ flag=true;
break;
}
}
if(!flag)
return false;
/*
* 如果没有选该课程，则插入该课程
* */
user_courseBeanExample user = new user_courseBeanExample();
Criteria first = user.createCriteria();
first.andCoursenameEqualTo(coursename);
first.andUsernameEqualTo(userName);
user_courseBeanMapper.deleteByExample(user);
//相当于：delete from user where username='admin'
/* user_courseBean user_courseBean=new user_courseBean(userName,coursename);
user_courseBeanMapper.insert(user_courseBean);*/
/*
* 查询couse里面课程的选课人数
* */
courseBeanExample example=new courseBeanExample();
example.setDistinct(true);
com.course.bean.courseBeanExample.Criteria criteria = example.createCriteria();
criteria.andCoursenameEqualTo(coursename);
List<courseBean> result=courseBeanMapper.selectByExample(example);
Iterator<courseBean> it2 = result.iterator();
if(it2.hasNext())
{
courseBean corse=it2.next();
number=corse.getNumber();
teacher=corse.getTeacher();
}
/*
* 更新选课的人数
* */
courseBeanExample example1=new courseBeanExample();
com.course.bean.courseBeanExample.Criteria criteria1 = example1.createCriteria();
criteria1.andCoursenameEqualTo(coursename);
courseBean coursebean=new courseBean();
coursebean.setNumber(number-1);
coursebean.setTeacher(teacher);
coursebean.setCoursename(coursename);
int tt=-1;
tt=courseBeanMapper.updateByExample(coursebean,example1);
return true;
}
}
userService.java：
package com.course.service;
import java.util.Iterator;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.course.dao.userBeanMapper;
import com.course.bean.userBean;
import com.course.bean.user_courseBean;
@Service
public class userService {
@Autowired
userBeanMapper userBeanMapper;
public boolean chexk(String userName) {
List<userBean> list=userBeanMapper.selectByExample(null);
Iterator<userBean> it1 = list.iterator();
while(it1.hasNext()){
userBean user=it1.next();
if(user.getUsername().equals(userName))
{
return false;}
}
return true;
}
public void insert(userBean userBean) {
userBeanMapper.insert(userBean);
}
public boolean firstchexk(String userName, String password) {
List<userBean> list=userBeanMapper.selectByExample(null);
Iterator<userBean> it1 = list.iterator();
while(it1.hasNext()){
userBean user=it1.next();
if(user.getUsername().equals(userName)&&user.getPassword().equals(password))
{
return true;}
}
return false;
}
}
这样子各个控制器和service的包就写完了，接下来是写各个页面了：
先看看各个页面的位置：
index.jsp:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<jsp:forward page="/first"></jsp:forward>
first.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<%/**以/开头但是没有以/结尾**/
pageContext.setAttribute("APP_PATH",request.getContextPath());
%>
<%!int i=0; %>
<script type="text/javascript" src="${APP_PATH}/static/js/jquery-1.11.1.min.js"></script>
<link href="${APP_PATH}/static/bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
<script src="${APP_PATH}/static/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
</head>
<body>
<form action="">
用户名：<input type="text" id="loginuserName"><br/>
密码：<input type="password" id="loginpassword"><br/>
<button type="button" class="btn btn-danger" id="button1">登录</button>
<button type="button" class="btn btn-success" id="button2">注册</button>
</form>
<script type="text/javascript">
$("#button1").click(function(){
var userName=document.getElementById("loginuserName").value;
var password=document.getElementById("loginpassword").value;
if(userName.length==0||password.length==0)
alert("请输入完整的用户名和密码");
else {}
$.ajax({
url:"${APP_PATH}/firstcheck",
type:"POST",
data:"loginuserName="+userName+"&loginpassword="+password,
scriptCharset: 'utf-8',
success:function(data){
if(data)
window.location.href = '${APP_PATH}/Cou';
else
alert("密码或者用户名不正确");
}
});
});
$("#button2").click(function(){
window.open('${APP_PATH}/user');
});
</script>
</body>
</html>
login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<%/**以/开头但是没有以/结尾**/
pageContext.setAttribute("APP_PATH",request.getContextPath());
%>
<%!int i=0; %>
<script type="text/javascript" src="${APP_PATH}/static/js/jquery-1.11.1.min.js"></script>
<link href="${APP_PATH}/static/bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
<script src="${APP_PATH}/static/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
</head>
<body>
<form action="">
用户名:<input type="text" id="userName"><br>
用户密码：<input type="password" id="password"><br>
确认密码：<input type="password" id="repassword"><br>
真实姓名：<input type="text" id="realName"><br>
手机号码：<input type="text" id="phone"><br>
<button type="button" class="btn btn-danger" id="button">提交</button>
<button type="button" class="btn btn-success" id="button2">返回登录</button>
</form>
<script type="text/javascript">
$("#button2").click(function(){
window.open('${APP_PATH}/first');
}
);
$("#button").click(function(){
var userName=document.getElementById("userName").value;
var password=document.getElementById("password").value;
var repassword=document.getElementById("repassword").value;
var realName=document.getElementById("realName").value;
var phone=document.getElementById("phone").value;
var re = /^[0-9]+.?[0-9]*$/;
if(userName.length==0||password.length==0||repassword.length==0||realName.length==0||phone.length==0)
alert("请填好信息再提交");
else if(password!=repassword)
alert("重新输入密码不正确");
else if(!re.test(phone))
alert("电话号码请输入数字");
else{
// alert(coursename);
$.ajax({
url:"${APP_PATH}/select",
type:"POST",
data:"userName="+userName+"&password="+password+"&realName="+realName +"&phone="+phone ,
scriptCharset: 'utf-8',
success:function(data){
if(data=="true")
alert("成功");
else
alert("失败");
}
});
}
});
</script>
</body>
</html>
courseList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="com.course.service.*" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<%/**以/开头但是没有以/结尾**/
pageContext.setAttribute("APP_PATH",request.getContextPath());
%>
<%int i=0; %>
<script type="text/javascript" src="${APP_PATH}/static/js/jquery-1.11.1.min.js"></script>
<link href="${APP_PATH}/static/bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
<script src="${APP_PATH}/static/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
</head>
<body>
<!-- 搭建显示页面 -->
<div class="container">
<!-- 标题行 -->
<div class="row">
<div class="col-md-6">
<h1>可选课程</h1>
</div>
</div>
<div class="row">
<div class="col-md-6 col-md-offset-6">
<button class="btn btn-danger" id="person">个人中心</button>
</div>
</div>
<!-- 展示表格数据 -->
<div class="row">
<div class="col-md-12">
<table class="table table-hover">
<tr>
<th>课程名称</th>
<th>任课老师</th>
<th>选课人数</th>
<th>操作</th>
</tr>
<c:forEach items="${pageInfo.list }" var="course">
<tr>
<th> <input type="hidden" value=${course.coursename } id="coursename<%=i%>">${course.coursename }</th>
<th>${course.teacher }</th>
<th>${course.number}</th>
<th>
<button class="btn btn-primary btn-xs" id="select<%=i++%>" "clicked(<%=i%>-1)">
<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span>
选课</button>
</th>
</tr>
</c:forEach>
</table>
</div>
</div>
</div>
<!-- 分页信息 -->
<div class="row">
<!-- 分页信息 -->
<div class="col-md-6 col-md-offset-2">
当前第${pageInfo.pageNum }页，总共${pageInfo.pages }页,总共${pageInfo.total }条记录
</div>
<!-- 分页条 -->
<div class="col-md-6 col-md-offset-6">
<nav aria-label="Page navigation">
<ul class="pagination">
<li><a href="${APP_PATH%20}/Cou?pn=1">首页</a></li>
<c:if test="${pageInfo.hasPreviousPage }">
<li>
<a href="${APP_PATH%20}/Cou?pn=${pageInfo.pageNum-1}" aria-label="Previous">
<span aria-hidden="true">«</span>
</a>
</li>
</c:if>
<c:forEach items="${pageInfo.navigatepageNums }" var="page_Num">
<c:if test="${page_Num==pageInfo.pageNum }">
<li class="active"><a href="#">${page_Num}</a></li>
</c:if>
<c:if test="${page_Num!=pageInfo.pageNum }">
<li><a href="${APP_PATH%20}/Cou?pn=${page_Num}">${page_Num}</a></li>
</c:if>
</c:forEach>
<c:if test="${pageInfo.hasNextPage }">
<li>
<a href="${APP_PATH%20}/Cou?pn=${pageInfo.pageNum+1}" aria-label="Next">
<span aria-hidden="true">»</span>
</a>
</li>
</c:if>
<li><a href="${APP_PATH%20}/Cou?pn=${pageInfo.pages}">末页</a></li>
</ul>
</nav>
</div>
</div>
<script type="text/javascript">
function clicked(n){
var courseName=document.getElementById("coursename"+n).value;
$.ajax({
url:"${APP_PATH}/insert",
type:"POST",
data:"coursename="+courseName,
scriptCharset: 'utf-8',
success:function(data){
if(data)
alert("选课成功");
else
alert("选课失败");
}
});
// alert(n);
}
$("#person").click(function(){
window.location.href = '${APP_PATH}/per';
});
</script>
</body>
</html>
perList.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="com.course.service.*" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<%/**以/开头但是没有以/结尾**/
pageContext.setAttribute("APP_PATH",request.getContextPath());
%>
<%int i=0; %>
<script type="text/javascript" src="${APP_PATH}/static/js/jquery-1.11.1.min.js"></script>
<link href="${APP_PATH}/static/bootstrap-3.3.7-dist/css/bootstrap.min.css" rel="stylesheet">
<script src="${APP_PATH}/static/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>
</head>
<body>
<!-- 搭建显示页面 -->
<div class="container">
<!-- 标题行 -->
<div class="row">
<div class="col-md-6">
<h1>已选课程</h1>
</div>
</div>
</div>
<!-- 展示表格数据 -->
<div class="row">
<div class="col-md-12">
<table class="table table-hover">
<tr>
<th>学生姓名</th>
<th>课程名称</th>
</tr>
<c:forEach items="${pageInfo.list }" var="user_course">
<tr>
<th>${user_course.username }</th>
<th> <input type="hidden" value=${user_course.coursename } id="coursename<%=i%>">${user_course.coursename }</th>
<th>
<button class="btn btn-primary btn-xs" id="delete<%=i++%>" "clicked(<%=i%>-1)">
<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span>
删除</button>
</th>
</tr>
</c:forEach>
</table>
</div>
</div>
<!-- 分页信息 -->
<div class="row">
<!-- 分页信息 -->
<div class="col-md-6 col-md-offset-2">
当前第${pageInfo.pageNum }页，总共${pageInfo.pages }页,总共${pageInfo.total }条记录
</div>
<!-- 分页条 -->
<div class="col-md-6 col-md-offset-6">
<nav aria-label="Page navigation">
<ul class="pagination">
<li><a href="${APP_PATH%20}/per?pn=1">首页</a></li>
<c:if test="${pageInfo.hasPreviousPage }">
<li>
<a href="${APP_PATH%20}/per?pn=${pageInfo.pageNum-1}" aria-label="Previous">
<span aria-hidden="true">«</span>
</a>
</li>
</c:if>
<c:forEach items="${pageInfo.navigatepageNums }" var="page_Num">
<c:if test="${page_Num==pageInfo.pageNum }">
<li class="active"><a href="#">${page_Num}</a></li>
</c:if>
<c:if test="${page_Num!=pageInfo.pageNum }">
<li><a href="${APP_PATH%20}/per?pn=${page_Num}">${page_Num}</a></li>
</c:if>
</c:forEach>
<c:if test="${pageInfo.hasNextPage }">
<li>
<a href="${APP_PATH%20}/per?pn=${pageInfo.pageNum+1}" aria-label="Next">
<span aria-hidden="true">»</span>
</a>
</li>
</c:if>
<li><a href="${APP_PATH%20}/per?pn=${pageInfo.pages}">末页</a></li>
</ul>
</nav>
</div>
</div>
<script type="text/javascript">
function clicked(n){
var courseName=document.getElementById("coursename"+n).value;
alert(courseName);
$.ajax({
url:"${APP_PATH}/delete",
type:"POST",
data:"coursename="+courseName,
scriptCharset: 'utf-8',
success:function(data){
if(data)
alert("退课成功");
else
alert("退课失败");
}
});
// alert(n);
}
</script>
</body>
</html>
这就是全部的代码了，感觉基本上初二自己可能就没人会看完，但是还是写出来记录一下。
运行后的页面是这个样子的：
登录页面：
注册页面：
选课页面：
个人中心：
版权声明：本文为ali_lili原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。