Spring4.2.4+Mybatis3.4.5+SpringMVC4.2.4+PageHelper 的整合

1、开发环境

Eclipse 4.6.3

Windows 64位

Tomcat 7.0

2、项目结构

3、整合思路，首先整合Spring和Mybatis，把Mybatis的Sqlsesson和SqlsessonFactory 交给Spring管理，利用mybatis-spring 1.3.0 jar来无缝对接

1、导入mybatis 需要的jar

       

2、导入Spring需要的jar

        

3、导入数据源包，利用阿里巴巴数据源

        

4、导入spring日志支持jar

         

5、导入分页插件包

        

6、导入Springmvc需要的jar

        

7、导入标签jar包

4、编写实体

package com.cn.bean;public class Goods {private Integer id;private String name;private String type;public void setId(Integer id) {this.id = id;}public Integer getId() {return id;}public void setName(String name) {this.name = name;}public String getName() {return name;}public void setType(String type) {this.type = type;}public String getType() {return type;}@Overridepublic String toString() {return "Goods [id=" + id + ", name=" + name + ", type=" + type + "]";}}

5、编写mapper接口和映射文件

package com.cn.mapper;import java.util.List;import com.cn.bean.Goods;/** * @ClassName GoodsMapper * @Description TODO(这里用一句话描述这个类的作用) * @author hasee * @Date 2017年12月1日 下午5:46:25 * @version 1.0.0 */public interface GoodsMapper {List<Goods> findAll();void save(Goods goods);}

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.cn.mapper.GoodsMapper">  <select id="findAll" resultType="goods">     select * from goods  </select>    <insert id="save" parameterType="goods">      insert into goods(name,type) values(#{name},#{type})  </insert></mapper>

6、编写服务层

package com.cn.service;import java.util.List;import com.cn.bean.Goods;import com.github.pagehelper.PageInfo;/** * @ClassName GoodsService * @Description TODO(这里用一句话描述这个类的作用) * @author hasee * @Date 2017年12月1日 下午5:49:30 * @version 1.0.0 */public interface GoodsService {List<Goods> queryAll();void add(Goods goods);PageInfo<Goods> page(int currentPage);}

package com.cn.service;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import com.cn.bean.Goods;import com.cn.mapper.GoodsMapper;import com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;/** * @ClassName GoodsServiceImpl * @Description TODO(这里用一句话描述这个类的作用) * @author hasee * @Date 2017年12月1日 下午5:50:11 * @version 1.0.0 */@Transactional@Servicepublic class GoodsServiceImpl implements GoodsService {@Autowiredprivate GoodsMapper mapper;@Overridepublic List<Goods> queryAll() {// TODO Auto-generated method stubreturn mapper.findAll();}@Overridepublic void add(Goods goods) {mapper.save(goods);}@Overridepublic PageInfo<Goods> page(int currentPage) {PageHelper.startPage(currentPage, 3);List<Goods> list = mapper.findAll();PageInfo<Goods> pageInfo = new PageInfo<>(list);return pageInfo;}}

7、编写Myatis配置文件

<?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="autoMappingBehavior" value="FULL" /> <!-- 开启全部自动映射，包含嵌套查询 --><!-- 打开懒加载的开关 --><setting name="lazyLoadingEnabled" value="true" /></settings></configuration>

8、编写数据库连接配置参数

mybatis.driver=com.mysql.jdbc.Drivermybatis.url=jdbc:mysql://localhost:3308/mybatismybatis.username=rootmybatis.password=123456#配置信息mybatis.maxActive=20mybatis.initialSize=5mybatis.minIdle=3

9、编写日志配置文件

#定义LOG输出级别log4j.rootLogger=INFO,Console,File#定义日志输出目的地为控制台log4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.Target=System.out#可以灵活地指定日志输出格式，下面一行是指定具体的格式log4j.appender.Console.layout = org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=[%c] - %m%n #文件大小到达指定尺寸的时候产生一个新的文件log4j.appender.File =org.apache.log4j.RollingFileAppender#指定输出目录log4j.appender.File.File = logs/spring.log#定义文件最大大小log4j.appender.File.MaxFileSize = 10MB# 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志log4j.appender.File.Threshold = ALLlog4j.appender.File.layout =org.apache.log4j.PatternLayoutlog4j.appender.File.layout.ConversionPattern =[%p] [%d{yyyy-MM-ddHH\:mm\:ss}][%c]%m%nlog4j.category.org.springframework.beans.factory=DEBUG# MyBatis logging configuration...log4j.logger.org.mybatis.example.BlogMapper=TRACE

10、编写Spring-mybatis整合配置文件

<?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.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"><!-- 开启组件扫描 --><context:component-scan base-package="com.cn.service"></context:component-scan><!--加载数据源配置信息 --><context:property-placeholder location="classpath:db.properties" /><!--配置数据源 --><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"><property name="driverClassName" value="${mybatis.driver}"></property><property name="url" value="${mybatis.url}"></property><property name="username" value="${mybatis.username}"></property><property name="password" value="${mybatis.password}"></property><!-- 选配信息 --><property name="maxActive" value="${mybatis.maxActive}"></property><property name="initialSize" value="${mybatis.initialSize}"></property><property name="minIdle" value="${mybatis.minIdle}"></property></bean><!-- 配置sqlsessionFactory --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><property name="configLocation" value="classpath:mybatis-config.xml"></property><!--扫描映射文件 --><property name="mapperLocations" value="classpath:com/cn/mapper/*.xml"></property><!--设置别名 --><property name="typeAliasesPackage" value="com.cn.bean"></property>         <!-- 插件 --><property name="plugins"><array><bean class="com.github.pagehelper.PageInterceptor"><property name="properties"><!-- config params as the following --><value>helperDialect=mysql</value></property></bean></array></property></bean><!--配置扫描Mapper接口 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property><property name="basePackage" value="com.cn.mapper"></property></bean><!--配置JDBC事务管理 --><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean><!--开启注解事务 --><tx:annotation-driven transaction-manager="transactionManager" /></beans>

11、编写控制器

package com.cn.controller;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.cn.service.GoodsService;/** * @ClassName IndexController * @Description TODO(这里用一句话描述这个类的作用) * @author hasee * @Date 2017年12月6日 上午9:44:24 * @version 1.0.0 */@Controllerpublic class IndexController {@Autowiredprivate GoodsService service;@RequestMapping("/index.do")public String queryAll(Model model) {model.addAttribute("goods", service.queryAll());return "index";}@RequestMapping("/indexPage.do")public String queryPage(Model model, int page) {model.addAttribute("goods", service.page(page));return "index";}}

12、编写springmvc的配置文件

<?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.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"><!--组件扫描 --><context:component-scan base-package="com.cn.controller"></context:component-scan>     <!--导入Spring-mybatis配置文件  -->      <import resource="spring-mybatis.xml"/><!--视图解析器 --><beanclass="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/jsp/"></property><property name="suffix" value=".jsp"></property></bean></beans>

13、编写web.xml配置前端控制器

<?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>SSM-Base</display-name><!-- The front controller of this Spring Web application, responsible for handling all application requests --><servlet><servlet-name>springDispatcherServlet</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><!-- Map all requests to the DispatcherServlet for handling --><servlet-mapping><servlet-name>springDispatcherServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping></web-app>

14、前端显示页面

<?xml version="1.0" encoding="UTF-8" ?><%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%>    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><!DOCTYPE html><html><head><title>首页</title></head><body><table border="1px" cellspacing="0"><tr><th>商品编号</th><th>商品名称</th><th>商品类型</th></tr><c:forEach var="good" items="${goods.list }"><tr><td>${good.id }</td><td>${good.name }</td><td>${good.type }</td></tr></c:forEach></table><div>     总页数:${goods.pages}/当前页：${goods.pageNum }    <a href="indexPage.do?page=${goods.prePage}">上一页</a>    <a href="indexPage.do?page=${goods.nextPage}">下一页</a></div></body></html>

15、运行效果图