Spring+Mybatis+springMVC学生管理系统**
0.概述:
在写代码之前我们先了解一下这三个框架分别是干什么的?
-
SpringMVC:它用于web层,相当于controller(等价于传统的servlet和struts的action),用来处理用户请求。举个例子,用户在地址栏输入http://网站域名/login,那么springmvc就会拦截到这个请求,并且调用controller层中相应的方法,(中间可能包含验证用户名和密码的业务逻辑,以及查询数据库操作,但这些都不是springmvc的职责),最终把结果返回给用户,并且返回相应的页面(当然也可以只返回json/xml等格式数据)。springmvc就是做前面和后面过程的活,与用户打交道!!
-
Spring:太强大了,以至于我无法用一个词或一句话来概括它。但与我们平时开发接触最多的估计就是IOC容器,它可以装载bean(也就是我们java中的类,当然也包括service dao里面的),有了这个机制,我们就不用在每次使用这个类的时候为它初始化,很少看到关键字new。另外spring的aop,事务管理等等都是我们经常用到的。
-
MyBatis:数据访问层框架,封装的是jdbc; 如果你问我它跟鼎鼎大名的Hibernate有什么区别?我只想说,他更符合我的需求。第一,它能自由控制sql,这会让有数据库经验的人(当然不是说我啦捂脸)编写的代码能搞提升数据库访问的效率。第二,它可以使用xml的方式来组织管理我们的sql,因为一般程序出错很多情况下是sql出错,别人接手代码后能快速找到出错地方,甚至可以优化原来写的sql。
开发环境
IDE: idea 2020.1
JDK: 1.8
MySql: 5.6
tomcat: 9版本
Maven: 3.6.0
1. 设计数据库表
要求: 数据库表里面需要设计date类型的字段和图片字段
图片字段 设计成varchar类型
Tb_user:
tb_stu1
2. 搭建ssm开发环境
1.创建工程并导入依赖
创建mavenweb工程,更新pom.xml依赖:
File---->new project------>Maven----->勾选 Create from archetype复选框------>选择 maven-archetype-webapp-- next—>输入 project name ,maven坐标---->next------->finish
更新pom.xml文件:从name到build标签删掉,加入所需依赖:
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.example</groupId>
<artifactId>StuManage</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<!-- 从这开始 -->
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<!-- spring版本号 -->
<spring.version>4.3.14.RELEASE</spring.version>
<!-- log4j日志文件管理包版本 -->
<slf4j.version>1.7.22</slf4j.version>
<log4j.version>1.2.17</log4j.version>
</properties>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.13</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-instrument</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-instrument-tomcat</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jms</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-messaging</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-oxm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- springmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mybatis 包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!--mybatis spring 插件 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>
<!-- 上传下载 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-api</artifactId>
<version>8.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax</groupId>
<artifactId>javaee-web-api</artifactId>
<version>8.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>net.sf.json-lib</groupId>
<artifactId>json-lib</artifactId>
<version>2.1</version>
<classifier>jdk15</classifier>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- pagehelper分页插件 -->
<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.github.jsqlparser/jsqlparser -->
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.9.5</version>
</dependency>
<!-- poi上传下载组件 -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.14-beta1</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml-schemas</artifactId>
<version>3.14-beta1</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.14-beta1</version>
</dependency>
<dependency>
<groupId>org.apache.httpcomponents</groupId>
<artifactId>httpclient</artifactId>
<version>4.5.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.xmlbeans/xmlbeans -->
<dependency>
<groupId>org.apache.xmlbeans</groupId>
<artifactId>xmlbeans</artifactId>
<version>2.6.0</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
<!--fastjson-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.30</version>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.10</version>
</dependency>
</dependencies>
<build>
<pluginManagement>
<plugins>
<!-- 配置Tomcat插件 -->
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<port>8082</port>
<path>/</path>
</configuration>
</plugin>
</plugins>
</pluginManagement>
</build>
<!-- 到这结束 -->
</project>
2.构建项目
加入Tomcat服务器
Tomcat Home:选择Tomcat解压后文件夹bin的上一层路径,其他的默认就行。
完整的项目结构:
配置文件说明:
log4j.properties: 日志配置文件
db.properties: 数据库连接的数据源配置信息
mybatis-config.xml: mybatis配置文件
UserMapper.xml: mybatis映射文件
spring-mybatis.xml: spring和mybatis整合的配置文件,将mybatis的相关配置通过spring配置的方式来实现注入
spring-mvc.xml: springmvc的配置文件
web.xml web工程的核心配置文件
1、Dao层:
mybatis-config.xml: Mybatis的配置文件;可以配置mybatis的日志信息,别名配置,分页插件等文件必须存在。
spring-mybatis.xml:mybatis整合spring,通过由spring创建数据库连接池,spring管理SqlSessionFactory、 mapper代理对象。需要mybatis和spring的整合包。
2、Service层:
3、控制层:
Springmvc框架,由springmvc管理controller
spring-mvc.xml:springmvc配置文件
3.加入配置文件
1.log4j.properties
里面内容无需改动,直接复制即可;配置日志信息,执行操作时可以看到sql语句及参数
log4j.rootLogger=debug,stdout,logfile
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.Java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
2.db.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf-8
jdbc.username=root
jdbc.password=2000
3.mybatis-config.xml
mybatis配置文件;注意不要忘了setting里面配置mybatis-3-config.dtd 这个,否则标签没有提示功能
注意: 别名的配置包名一定要和自己的pojo实体类包名保持一致;
pagehelper分页插件是mybatis的一个分页插件,可以很好地实现分页功能, 配上吧
<?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="logImpl" value="STDOUT_LOGGING"/>
</settings>
<!-- 别名配置方式二 -->
<typeAliases>
<!-- 配置该包底下的所有的类默认使用类名表示别名 -->
<package name="com.pojo"/>
</typeAliases>
<!-- 配置分页插件 -->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 设置数据库类型 Oracle,Mysql,MariaDB,SQLite,Hsqldb,PostgreSQL六种数据库-->
<property name="helperDialect" value="mysql"/>
<property name="reasonable" value="true"/>
</plugin>
</plugins>
</configuration>
4.spring-mybatis.xml
spring和mybatis整合的配置文件,其实就是把mybatis的sqlSessionFactory,数据源,事务等信息通过spring来给他注入
注意: 这个配置 包名一定要和自己dao的包名保持一致
映射文件默认在resources/mapper/*Mapper.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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" 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/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- 引入外部properties文件 -->
<context:property-placeholder location="classpath:/db.properties" />
<!-- 配置数据源 -->
<bean class="org.springframework.jdbc.datasource.DriverManagerDataSource" id="dataSource">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>
<!-- 配置SqlSessionFactory对象 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 引入mybatis配置文件 -->
<property name="configLocation" value="classpath:mybatis-config.xml" />
<!-- 引入mybatis映射文件 -->
<property name="mapperLocations" value="classpath:mapper/*Mapper.xml"/>
</bean>
<!-- 自动扫描 将Mapper接口生成代理注入到Spring 基于xml方式的-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.dao" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!-- 配置引入映射文件 基于注解方式的 -->
<!--
<bean class="org.mybatis.spring.mapper.MapperFactoryBean">
<property name="mapperInterface" value="com.zjj.dao.UserDao" />
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
-->
<!-- 配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- 配置事务的注解驱动 -->
<tx:annotation-driven/>
</beans>
5.spring-mvc.xml
springmvc的配置文件
注意: <context:component-scan base-package=“com.zjj” /> 包名一定写成所有组件的父包
<?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/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
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">
<!-- 配置自动扫描的包 可以自动识别该包下的所有的注解 -->
<context:component-scan base-package="com" />
<!-- 注解驱动 表示对springmvc相关注解的支持 -->
<!-- json 转换器 -->
<mvc:annotation-driven conversion-service="conversionService">
<mvc:message-converters>
<bean
class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">
<description>JSON转换器</description>
<property name="supportedMediaTypes">
<list>
<value>application/json;charset=UTF-8</value>
<value>text/html;charset=UTF-8</value>
</list>
</property>
</bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!--转换器-->
<bean id="conversionService" class="org.springframework.format.support.FormattingConversionServiceFactoryBean">
<!-- 配置自定义格式转换器-->
<property name="formatters">
<list>
<bean class="com.convert.DateFormatter">
<property name="dateFormat" value="yyyy-MM-dd"/>
</bean>
</list>
</property>
</bean>
<!-- 配置视图解析器 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp" />
</bean>
<!-- 配置类似于全局的拦截器 如果项目中用到拦截器,需要配此项,如果没用的到拦截器,不能配,否则会报错-->
<!--
<mvc:interceptors>
<mvc:interceptor>
<mvc:mapping path="/**"/>
<mvc:exclude-mapping path="/login"/>
<bean class="com.bw.util.PermissionIntercepter"></bean>
</mvc:interceptor>
</mvc:interceptors>
-->
<!-- 配置上传解析器 -->
<!-- 设置文件上传大小 -->
<!-- 配置编码 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<property name="MaxUploadSize">
<value>6000000</value>
</property>
<property name="defaultEncoding" value="UTF-8"/>
</bean>
<!--静态资源的处理-->
<mvc:default-servlet-handler/>
<!-- 静态资源访问配置
1. 在springmvc配置文件里面配某个目录的访问
2. 在web.xml文件里面配置某种后缀名的文件可以访问
两种配置方式选择一种
-->
<!-- 配置静态资源的映射 -->
<!-- <mvc:resources location="/css/" mapping="/css/**" />
<mvc:resources location="/js/" mapping="/js/**" />
<mvc:resources location="/img/" mapping="/img/**" />
-->
</beans>
6.web.xml
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-*.xml</param-value>
</context-param>
<!-- 配置中文乱码过滤器 -->
<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>forceEncoding</param-name>
<param-value>true</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 配置spring在web项目中的使用 配置spring的监听器 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置springmvc的核心分发器 -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 引入springmvc的配置文件 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:spring-mvc.xml</param-value>
</init-param>
<!-- 配置servlet的加载时机 1表示tomcat启动的时候加载 -->
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<!-- / 代表项目名底下所有 -->
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- ssm配置静态资源访问2 某种类型的资源文件 的访问-->
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.jpg</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.gif</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.css</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>default</servlet-name>
<url-pattern>*.js</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>login.jsp</welcome-file>
</welcome-file-list>
</web-app>
7.mybatis映射文件
UserMapper.xml 和 StudentMapper.xml 注意路径 位于 resources/mapper目录下
**注意: **namespace 值必须和接口路径保持一致
4.环境搭建
实体类pojo可以引用lombok插件,加注解避免写构造方法
@Data
@AllArgsConstructor
@NoArgsConstructor
3. 实现学生管理系统功能
要求:实现系统的登录注册以及增删改查、PageHelper实现分页、convert转换日期格式。前端界面暂不考虑美观
springmvc里面正常返回值后面会加视图解析器的前缀和后缀;
但是请求转发和重定向不会加前缀和后缀,直接跳转到forward或者redirect的地址
springmvc实现请求转发和重定向的方式:
return “forward:地址” 请求转发
return “redirect:地址” 重定向
1.pojo实体类
User:
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
private Integer id;
private String stuName;
private Date birthday;
private String address;
private String photo;
}
Student:
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
private Integer id;
private String stuName;
private Date birthday;
private String address;
private String photo;
}
2.dao层
UserDao
public interface UserDao {
//登录
public User queryUserByUsernameAndPassword(User user);
//注册
public int registerUser(User user);
}
StudentDao
public interface StudentDao {
public List<Student> queryAllStudent();
public int addStudent(Student student);
public int deleteStudentById(int id);
public int updateStudent(Student student);
public Student queryStudentById(int id);
}
3.service层
UserService
public interface UserService {
public User login(User user);
public boolean register(User user);
}
StudentService
public interface StudentService {
public List<Student> queryAll();
public PageInfo<Student> queryStudentsByPage(int currentPage, int pageSize);
public boolean addStudent(Student student);
public boolean deleteStudentById(int id);
public boolean updateStudent(Student student);
public Student queryStudentById(int id);
}
实现类UserServiceImpl
@Service
@Transactional
public class UserServiceImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public User login(User user) {
return userDao.queryUserByUsernameAndPassword(user);
}
@Override
public boolean register(User user) {
int row=userDao.registerUser(user);
if(row>0){
return true;
}
return false;
}
}
实现类StudentServiceImpl
@Service
@Transactional
public class StudentServiceImpl implements StudentService {
@Autowired
private StudentDao studentDao;
@Override
public List<Student> queryAll() {
return studentDao.queryAllStudent();
}
@Override
public PageInfo<Student> queryStudentsByPage(int currentPage, int pageSize) {
//传入参数:当前页和每页条数
PageHelper.startPage(currentPage,pageSize);
List<Student> students = studentDao.queryAllStudent();
//通过包装获取分页所需的其他值
PageInfo<Student> pageInfo = new PageInfo<>(students);
return pageInfo;
}
@Override
public boolean addStudent(Student student) {
int row = studentDao.addStudent(student);
if(row>0){
return true;
}
return false;
}
@Override
public boolean deleteStudentById(int id) {
int row = studentDao.deleteStudentById(id);
if (row>0){
return true;
}
return false;
}
@Override
public boolean updateStudent(Student student) {
int row = studentDao.updateStudent(student);
if (row>0){
return true;
}
return false;
}
@Override
public Student queryStudentById(int id) {
return studentDao.queryStudentById(id);
}
}
4.转换器convert
DateFormatter
public class DateFormatter implements Formatter<Date> {
private SimpleDateFormat dateFormat;
public SimpleDateFormat getDateFormat(){
return dateFormat;
}
public void setDateFormat(SimpleDateFormat dateFormat) {
this.dateFormat = dateFormat;
}
@Override
public Date parse(String s, Locale locale) throws ParseException {
return dateFormat.parse(s);
}
@Override
public String print(Date date, Locale locale) {
return dateFormat.format(date);
}
}
5.Controller层
UserController
@Controller
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/login")
public String login(User user, HttpServletRequest request){
User htUser = userService.login(user);
//判断是否登录成功
if (htUser!=null){
HttpSession session = request.getSession();
session.setAttribute("user",htUser);
return "redirect:listpage";
}
//return "redirect:login.jsp"; //重定向
// return "forword:login.jsp"; //请求转发
return "redirect:/login.jsp";
}
@RequestMapping("/register")
public String register(User user){
boolean flag = userService.register(user);
if(flag){
return "redirect:/login.jsp";
}else{
return "redirect:/register.jsp";
}
}
}
StudentController
@Controller
public class StudentController {
@Autowired
private StudentService studentService;
/*@RequestMapping("/list")
@ResponseBody
public List<Student> queryAllStudent(Student student){
return studentService.queryAll(student);
}*/
@RequestMapping("/list")
public String queryAllStudent(Model model){
List<Student> students = studentService.queryAll();
model.addAttribute("list",students);
return "stulist";
}
//查询所有学生信息
@RequestMapping("listpage")
public String listAllStudents(Integer currentPage,Integer pageSize,Model model){
if(currentPage==null){
currentPage=1;
}
if(pageSize==null){
pageSize=3;
}
PageInfo<Student> page = studentService.queryStudentsByPage(currentPage, pageSize);
model.addAttribute("page",page);
return "stulistpage";
}
//添加中转站
@RequestMapping("toadd")
public String toadd(){
return "add";
}
@RequestMapping("/add")
public String add(Student student){
boolean flag = studentService.addStudent(student);
if (flag){
return "redirect:listpage";
}
return "add";
}
@RequestMapping("/update")
public String update(Student student){
boolean flag = studentService.updateStudent(student);
if(flag){
return "redirect:listpage";
}
return "redirect:update";
}
@RequestMapping("/delete")
public String delete(int id){
boolean flag = studentService.deleteStudentById(id);
if(flag){
return "redirect:listpage";
}
return "redirect:listpage";
}
@RequestMapping("load")
public String loadStudent(int id,Model model){
Student student = studentService.queryStudentById(id);
model.addAttribute("s",student);
return "update";
}
}
6.mapper文件
UserMapper.xml
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.UserDao">
<resultMap id="userResultMap" type="User">
<!--若是属性名和数据库对应一致,则不用配置属性-->
</resultMap>
<!--登录-->
<select id="queryUserByUsernameAndPassword" parameterType="User" resultMap="userResultMap">
select * from tb_user where username=#{username} and password=#{password}
</select>
<!--注册-->
<insert id="registerUser">
insert into tb_user values(0,#{username},#{password},#{isadmin})
</insert>
</mapper>
StudentMapper.xml
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.StudentDao">
<resultMap id="StuResultMap" type="Student">
<id property="id" column="sid"/>
<id property="stuName" column="sname"/>
<id property="birthday" column="birthday"/>
<id property="address" column="address"/>
<id property="photo" column="photo"/>
</resultMap>
<!--查询所有-->
<select id="queryAllStudent" resultMap="StuResultMap">
select * from tb_stu1
</select>
<!--添加学生-->
<insert id="addStudent" parameterType="Student">
insert into tb_stu1(sname,birthday,address,photo) values (#{stuName},#{birthday},#{address},#{photo})
</insert>
<!--修改学生-->
<update id="updateStudent" parameterType="Student">
update tb_stu1 SET sname=#{stuName},birthday=#{birthday},address=#{address},photo=#{photo} WHERE sid=#{id}
</update>
<!--删除单个学生-->
<delete id="deleteStudentById" parameterType="Student">
delete from tb_stu1 where sid=#{id}
</delete>
<!--查询单个学生-->
<select id="queryStudentById" parameterType="Student" resultMap="StuResultMap">
select * from tb_stu1 where sid=#{id}
</select>
</mapper>
7.前端界面
1.webapp下:
login.jsp:登录
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>登录</title>
</head>
<body>
<center>
<h1>登录页面</h1>
<form action="login" method="post">
<table>
<tr>
<td>用户名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td><input type="submit" value="登录"></td>
<td><a href="register.jsp">立即注册</a></td>
</tr>
</table>
</form>
</center>
</body>
</html>
register.jsp:注册
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>注册</title>
</head>
<body>
<center>
<h1>注册页面</h1>
<form action="register" method="post">
<table>
<tr>
<td>用户名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td><input type="radio" name="isadmin" value="1">管理员</td>
<td><input type="radio" name="isadmin" value="2" checked>普通用户</td>
</tr>
<tr>
<td><input type="submit" value="注册"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
img包:让数据库取到相对路径下的图片
2.WEB-INF/jsp下:
add.jsp:添加学生页面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<center>
<h1>添加学生</h1>
<form action="add" method="post">
<table>
<tr>
<td>姓名</td>
<td><input type="text" name="stuName"></td>
</tr>
<tr>
<td>生日</td>
<td>
<input type="date" name="birthday">
</td>
</tr>
<tr>
<td>户籍</td>
<td><input type="text" name="address"></td>
</tr>
<tr>
<td>头像</td>
<td><input type="text" name="photo"></td>
</tr>
<tr>
<td><input type="submit" value="添加学生"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
update.jsp:修改学生信息页面
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<center>
<h1>修改学生</h1>
<form action="update" method="post">
<table>
<tr>
<td>编号</td>
<td><input type="text" name="id" value="${s.id}" readonly></td>
</tr>
<tr>
<td>姓名</td>
<td><input type="text" name="stuName" value="${s.stuName}"></td>
</tr>
<tr>
<td>生日</td>
<td><input type="date" name="birthday" value="${s.birthday}"></td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="address" value="${s.address}"></td>
</tr>
<tr>
<td>头像</td>
<td><input type="text" name="photo" value="${s.photo}"></td>
</tr>
<tr>
<td><input type="submit" value="修改学生"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
stulistpage.jsp:所有学生页面
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" isErrorPage="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<html>
<head>
<title>Title</title>
</head>
<body>
欢迎${sessionScope.user.username}登陆
<center>
<h1>学生管理系统</h1>
<table width="60%" heigh="40%">
<tr>
<td>编号</td>
<td>学生姓名</td>
<td>生日</td>
<td>地址</td>
<td>头像</td>
<td><a href="toadd">添加学生信息</a></td>
</tr>
<c:forEach items="${page.list}" var="s">
<tr>
<td>${s.id}</td>
<td>${s.stuName}</td>
<td>
<fmt:formatDate value="${s.birthday}" pattern="yyyy-MM-dd"></fmt:formatDate>
</td>
<td>${s.address}</td>
<td>
<%-- <img src="show?path=${s.photo}" width="150px" height="150px"/>--%>
<img src="${s.photo}" width="150px" height="100px"/>
</td>
<td>
<a href="load?id=${s.id}">修改</a>
<a href="delete?id=${s.id}">删除</a>
</td>
</tr>
</c:forEach>
</table>
<input type="button" onclick="toFirst()" value="首页">
<input type="button" onclick="toPrev()" value="上一页">
当前页${page.pageNum}|${page.pages}总页数
<input type="button" onclick="toNext()" value="下一页">
<input type="button" onclick="toLast()" value="尾页">
每页显示<input type="text" size="2" id="pageNo" value="${page.pageSize}">条记录
</center>
</body>
<script>
function toFirst() {
var pageSize= document.getElementById("pageNo").value;
location.href="listpage?currentPage=1&pageSize="+pageSize;
}
function toPrev() {
var pageSize= document.getElementById("pageNo").value;
location.href="listpage?currentPage=${page.prePage}&pageSize="+pageSize;
}
function toNext() {
var pageSize= document.getElementById("pageNo").value;
location.href="listpage?currentPage=${page.nextPage}&pageSize="+pageSize;
}
function toLast() {
var pageSize= document.getElementById("pageNo").value;
location.href="listpage?currentPage=${page.lastPage}&pageSize="+pageSize;
}
</script>
</html>
4.项目展示
1.系统登录首页:
2.注册:
注册成功后跳转至登录页面,并在数据库tb_user增加一条数据:
3.输入账号登录成功后跳转到所有学生信息(查询操作):
欢迎该用户!并展示分页信息。可选择每页显示等操作:
4.添加学生信息:
添加学生把数据插入数据库
并跳转至所有学生页面,此时可查看刚添加的学生:
5.修改学生信息:
跳转至修改学生页面:
编号为了避免重复设置为只读!
修改成功后同步至数据库
并跳转到所有学生页面,此时可以查看是否修改成功:
6.删除学生
点击删除,删除对应数据库信息
并刷新所有学生信息: