SSM整合--以书籍管理为例(PageHelper分页)

本文主要是介绍SSM整合--以书籍管理为例(PageHelper分页)，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

1. 配置文件

Mybatis配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration><!--配置数据源，交给Spring去做--><!--日志--><settings><setting name="logImpl" value="STDOUT_LOGGING"/></settings><!--别名--><typeAliases><package name="com.lrm.pojo"/></typeAliases><!--配置pagehelper分页--><plugins><plugin interceptor="com.github.pagehelper.PageInterceptor"><property name="reasonable" value="true"/></plugin></plugins><!--绑定mapper--><mappers><mapper class="com.lrm.dao.BookMapper"/></mappers></configuration>

Spring配置文件

spring-dao.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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttps://www.springframework.org/schema/context/spring-context.xsd"><!--1. 关联数据库文件--><context:property-placeholder location="classpath:db.properties"/><!--2. 连接池dbcp：半自动化操作，不能自动连接c3p0：自动化操作（自动化的加载配置文件，可以自动设置到对象中）druid，hikari--><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><!-- c3p0连接池的私有属性 --><property name="maxPoolSize" value="30"/><property name="minPoolSize" value="10"/><!-- 关闭连接后不自动commit --><property name="autoCommitOnClose" value="false"/><!-- 获取连接超时时间 --><property name="checkoutTimeout" value="10000"/><!-- 当获取连接失败重试次数 --><property name="acquireRetryAttempts" value="2"/></bean><!--3. sqlSessionFactory--><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><!--绑定Mybatis的配置文件--><property name="configLocation" value="classpath:mybatis-config.xml"/></bean><!--4. 配置dao接口扫描包，动态实现了Dao接口可以注入到Spring容器中--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!--注入sqlSessionFactory--><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><!--要扫描的dao包--><property name="basePackage" value="com.lrm.dao"/></bean></beans>

spring-service.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/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttps://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/aophttps://www.springframework.org/schema/aop/spring-aop.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx.xsd"><!--1. 扫描service下的包--><context:component-scan base-package="com.lrm.service"/><!--2. 将所有的业务类注入到Spring，可以通过配置或者注解实现--><bean id="bookServiceImpl" class="com.lrm.service.BookServiceImpl"><property name="bookMapper" ref="bookMapper"/></bean><!--3. 声明式事务配置--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!--注入数据源--><property name="dataSource" ref="dataSource"/></bean><!--4. AOP事务支持--><tx:advice id="txAdvice" transaction-manager="transactionManager"><!--给那些方法配置事务--><!--配置事务的传播特性 propagation：REQUIRED默认--><tx:attributes><!--代表所有方法都要走事务--><tx:method name="*" propagation="REQUIRED"/></tx:attributes></tx:advice><!--配置事务切入--><aop:config><aop:pointcut id="txPointCut" expression="execution(* com.lrm.dao.*.*(..))"/><aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/></aop:config></beans>

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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd"><import resource="classpath:spring-dao.xml"/><import resource="classpath:spring-service.xml"/><import resource="classpath:spring-mvc.xml"/></beans>

SpringMVC配置文件

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"version="4.0"><!--1. DispatcherServlet--><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:applicationContext.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><!--2. 乱码过滤--><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></filter><filter-mapping><filter-name>encodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><!--3. Session--><session-config><session-timeout>15</session-timeout></session-config></web-app>

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/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/mvchttps://www.springframework.org/schema/mvc/spring-mvc.xsd"><!--1. 注解驱动--><mvc:annotation-driven/><!--2. 静态资源过滤--><mvc:default-servlet-handler/><!--3. 扫描包：controller--><context:component-scan base-package="com.lrm.controller"/><!--4. 视图解析器--><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /><property name="prefix" value="/WEB-INF/jsp/"/><property name="suffix" value=".jsp"/></bean></beans>

数据库配置文件

jdbc.driver=com.mysql.jdbc.Driver
# 如果使用的是MySQL8.0+ 还需要增加一个时区设置 &serverTimezone=Asia/Guangzhou
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456

数据库文件

CREATE DATABASE `ssmbuild`;USE `ssmbuild`;CREATE TABLE `books`(
`bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT 书id,
`bookName` VARCHAR(100) NOT NULL COMMENT 书名,
`bookCounts` INT(11) NOT NULL COMMENT 数量,
`detail` VARCHAR(200) NOT NULL COMMENT 描述,
KEY `bookID`(`bookID`)
)ENGINE=INNODB DEFAULT CHARSET=utf8;INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`) VALUES
(1,Java,1,从入门到放弃),
(2,MySQL,10,从删库到跑路),
(3,Linux,5,从进门到进牢);

2. 依赖导入

Junit

<dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.13</version>
</dependency>

数据库驱动

<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.47</version>
</dependency>

数据库连接池

<dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.5</version>
</dependency>

servlet、Jsp

<dependency><groupId>javax.servlet</groupId><artifactId>servlet-api</artifactId><version>2.5</version>
</dependency>
<dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.2</version>
</dependency>
<dependency><groupId>javax.servlet</groupId><artifactId>jstl</artifactId><version>1.2</version>
</dependency>

Mybatis

<dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.2</version>
</dependency>
<dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.2</version>
</dependency>

Spring

<dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>5.3.9</version>
</dependency>
<dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.3.9</version>
</dependency>
<dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.9.4</version>
</dependency>

lombok

<dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.20</version>
</dependency>

pagehelper分页插件

<dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.1.4</version>
</dependency>
<dependency><groupId>com.github.jsqlparser</groupId><artifactId>jsqlparser</artifactId><version>0.9.5</version>
</dependency>

静态资源导出

<build><resources><resource><directory>src/main/java</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource><resource><directory>src/main/resources</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource></resources>
</build>

3. 代码编写

入口：index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html><head><title>首页</title><style>a{text-decoration: none;color: black;font-size: 18px;}h3{width: 180px;height: 38px;margin: 100px auto;text-align: center;line-height: 38px;background: aqua;border-radius: 5px;}</style></head><body><h3><a href="${pageContext.request.contextPath}/book/allBook">进入书籍页面</a></h3></body>
</html>

Controller层

@Controller
@RequestMapping("/book")
public class BookController {//controller 调 service@Autowired@Qualifier("bookServiceImpl")private BookService bookService;//查询全部的书籍返回到页面@RequestMapping("/allBook")public String List(Model model, @RequestParam(defaultValue = "1", required = true, value = "pageNo") Integer pageNo){Integer pageSize = 2;List<Books> books = bookService.queryAllBooks(pageNo,pageSize);PageInfo<Books> pageInfo = new PageInfo<Books>(books);model.addAttribute("pageInfo",pageInfo);model.addAttribute("list",books);return "allBook";}//跳转到添加书籍页面@RequestMapping("/toAddBook")public String toAddBook(){return "addBook";}//添加书籍请求@RequestMapping("/addBook")public String adBook(Books books){//System.out.println("addBook=>" + books);bookService.addBook(books);//重定向到@RequestMapping("/allBook")请求return "redirect:/book/allBook";}//跳转到修改书籍页面@RequestMapping("/toUpdateBook")public String toUpdateBook(int id,Model model){Books books = bookService.queryBookById(id);model.addAttribute("book",books);return "updateBook";}//修改书籍请求@RequestMapping("/updateBook")public String updateBook(Books books){//System.out.println("updateBook=>" + books);bookService.updateBook(books);return "redirect:/book/allBook";}//删除书籍请求（restful风格）@RequestMapping("/deleteBook/{bookID}")public String deleteBook(@PathVariable("bookID") int id){bookService.deleteBookById(id);return "redirect:/book/allBook";}//查询书籍@RequestMapping("/queryBook")public String queryBook(String queryBookName,Model model,@RequestParam(defaultValue = "1", required = true, value = "pageNo") Integer pageNo){Integer pageSize = 2;List<Books> books = bookService.queryBookByName(pageNo,pageSize,queryBookName);PageInfo<Books> pageInfo = new PageInfo<Books>(books);model.addAttribute("pageInfo",pageInfo);model.addAttribute("list",books);return "allBook";}
}

Service层

Service接口

public interface BookService {//增加一本书int addBook(Books books);//删除一本书int deleteBookById(int id);//更新一本书int updateBook(Books books);//查询一本书Books queryBookById(int id);//查询全部的书List<Books> queryAllBooks(Integer pageNo, Integer pageSize);//通过书名查询书籍List<Books> queryBookByName(Integer pageNo, Integer pageSize,String bookName);}

ServiceImpl实现类

public class BookServiceImpl implements BookService{//service调dao层private BookMapper bookMapper;public void setBookMapper(BookMapper bookMapper) {this.bookMapper = bookMapper;}public int addBook(Books books) {return bookMapper.addBook(books);}public int deleteBookById(int id) {return bookMapper.deleteBookById(id);}public int updateBook(Books books) {return bookMapper.updateBook(books);}public Books queryBookById(int id) {return bookMapper.queryBookById(id);}public List<Books> queryAllBooks(Integer pageNo, Integer pageSize) {PageHelper.startPage(pageNo,pageSize);return bookMapper.queryAllBooks();}public List<Books> queryBookByName(Integer pageNo, Integer pageSize,String bookName) {PageHelper.startPage(pageNo,pageSize);return bookMapper.queryBookByName(bookName);}
}

Dao层

Mapper接口

public interface BookMapper {//增加一本书int addBook(Books books);//删除一本书int deleteBookById(@Param("bookID") int id);//更新一本书int updateBook(Books books);//查询一本书Books queryBookById(@Param("bookID") int id);//查询全部的书List<Books> queryAllBooks();//通过书名查询书籍List<Books> queryBookByName(@Param("bookName") String bookName);}

Mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lrm.dao.BookMapper"><insert id="addBook" parameterType="Books">insert into ssmbuild.books(bookName, bookCounts, detail)values(#{bookName}, #{bookCounts}, #{detail})</insert><delete id="deleteBookById" parameterType="int">delete from ssmbuild.bookswhere bookID = #{bookID}</delete><update id="updateBook" parameterType="Books">update ssmbuild.booksset bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}where bookID = #{bookID}</update><select id="queryBookById" parameterType="int" resultType="Books">select * from ssmbuild.bookswhere bookID = #{bookID}</select><select id="queryAllBooks" resultType="Books">select * from ssmbuild.books</select><select id="queryBookByName" parameterType="String" resultType="Books">select * from ssmbuild.books where bookName like concat('%',#{bookName},'%')</select></mapper>

查询结果显示界面 allBook.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>书籍展示</title><%--bootstrap美化界面--%><link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"></head>
<body>
<div class="container"><div class="row clearfix"><div class="col-md-12 column"><div class="page-header"><h1><small>书籍列表--显示所有书籍</small></h1></div></div><div class="row"><%--新增--%><div class="col-md-4 column"><a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增书籍</a></div><%--查询书籍--%><div class="col-md-8 column"><form class="form-inline" action="${pageContext.request.contextPath}/book/queryBook" method="post" style="float: right"><input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询的书籍名称"><input type="submit" class="btn btn-primary" value="查询"></form></div></div><div class="row clearfix"><div class="col-md-12 column"><table class="table table-hover table-striped"><thead><tr><th>书籍编号</th><th>书籍名称</th><th>书籍数量</th><th>书籍详情</th><th>操作</th></tr></thead><%--书籍从list中遍历出来--%><tbody><c:forEach var="book" items="${list}"><tr><td>${book.bookID}</td><td>${book.bookName}</td><td>${book.bookCounts}</td><td>${book.detail}</td><td><a href="${pageContext.request.contextPath}/book/toUpdateBook?id=${book.bookID}">修改</a>&nbsp; | &nbsp;<%--restful风格--%><a href="${pageContext.request.contextPath}/book/deleteBook/${book.bookID}">删除</a></td></tr></c:forEach></tbody></table><p>每页${pageInfo.pageSize}条 当前页${pageInfo.size}条 ${pageInfo.pageNum}/${pageInfo.pages}页 记录数${pageInfo.total}</p><a href="${pageContext.request.contextPath}/book/allBook">首页</a><a href="${pageContext.request.contextPath}/book/allBook?pageNo=${pageInfo.pageNum-1}">上一页</a><c:forEach begin="1" end="${pageInfo.pages}" var="pageNum"><a href="${pageContext.request.contextPath}/book/allBook?pageNo=${pageNum}">${pageNum}</a></c:forEach><a href="${pageContext.request.contextPath}/book/allBook?pageNo=${pageInfo.pageNum+1}">下一页</a><a href="${pageContext.request.contextPath}/book/allBook?pageNo=${pageInfo.pages}">尾页</a></div></div></div>
</div>
</body>
</html>

添加书籍界面 addBook.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>新增书籍</title><%--bootstrap美化界面--%><link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"></head>
<body>
<div class="container"><div class="row clearfix"><div class="col-md-12 column"><div class="page-header"><h1><small>新增书籍</small></h1></div></div></div><form action="${pageContext.request.contextPath}/book/addBook" method="post"><div class="form-group"><label>书籍名称：</label><input type="text" name="bookName" class="form-control" required></div><div class="form-group"><label>书籍数量：</label><input type="text" name="bookCounts" class="form-control" required></div><div class="form-group"><label>书籍描述：</label><input type="text" name="detail" class="form-control" required></div><div class="form-group"><input type="submit" class="form-control" value="添加"></div></form></div>
</body>
</html>

修改书籍页面 updateBook.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head><title>修改书籍</title><%--bootstrap美化界面--%><link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"></head>
<body>
<div class="container"><div class="row clearfix"><div class="col-md-12 column"><div class="page-header"><h1><small>修改书籍</small></h1></div></div></div><form action="${pageContext.request.contextPath}/book/updateBook" method="post"><%--隐藏域--%><input type="hidden" name="bookID" value="${book.bookID}"><div class="form-group"><label>书籍名称：</label><input type="text" name="bookName" class="form-control" value="${book.bookName}" required></div><div class="form-group"><label>书籍数量：</label><input type="text" name="bookCounts" class="form-control" value="${book.bookCounts}" required></div><div class="form-group"><label>书籍描述：</label><input type="text" name="detail" class="form-control" value="${book.detail}" required></div><div class="form-group"><input type="submit" class="form-control" value="修改"></div></form></div>
</body>
</html>