MyBatis学习笔记——SSM整合（Spring4，SpringMVC4，MyBatis3）

最新推荐文章于 2019-08-08 15:28:09 发布

从程序猿到程序员

最新推荐文章于 2019-08-08 15:28:09 发布

阅读量277

点赞数

分类专栏： Mybatis

本文链接：https://blog.csdn.net/u012525096/article/details/81877720

版权

Mybatis 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

构建环境

导入Jar包

pom.xml

<dependencies>

        <!-- Spring/SpringMVC -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.apache.taglibs</groupId>
            <artifactId>taglibs-standard-impl</artifactId>
            <version>1.2.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.taglibs</groupId>
            <artifactId>taglibs-standard-spec</artifactId>
            <version>1.2.1</version>
        </dependency>
        <dependency>
            <groupId>net.sourceforge.cglib</groupId>
            <artifactId>com.springsource.net.sf.cglib</artifactId>
            <version>2.2.0</version>
        </dependency>


        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.1</version>
        </dependency>

        <!-- JDBC msql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>

        <!-- mybatis与spring的适配包 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.2</version>
        </dependency>

        <!-- 日志 -->
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.6</version>
            <exclusions>
                <exclusion>
                    <artifactId>slf4j-api</artifactId>
                    <groupId>org.slf4j</groupId>
                </exclusion>
            </exclusions>
        </dependency>

        <!-- C3P0数据源 -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>

    </dependencies>

构建mybatis目录环境

这里写图片描述

Spring相关配置文件

在/WEB-INF下的web.xml中配置Spring和SpringMVC的配置文件加载路径。

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" 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_2_5.xsd">

    <!-- Spring配置:needed for ContextLoaderListener -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>

    <!-- Bootstraps the root web application context before servlet initialization -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>


    <!-- SpringMVC配置 -->
    <!-- The front controller of this Spring Web application, responsible for handling 
        all application requests -->
    <servlet>
        <servlet-name>spring</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>

    <!-- Map all requests to the DispatcherServlet for handling -->
    <servlet-mapping>
        <servlet-name>spring</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>

配置SpringMVC

SpringMVC的配置文件采用默认位置，即在WEB-INF/下，与web.xml同级目录，创建spring-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: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.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">

    <!-- SpringMVC只是控制网站跳转逻辑 -->
    <!-- 只扫描控制器 -->
    <context:component-scan
        base-package="com.shen.mybatis" use-default-filters="false">
        <context:include-filter type="annotation"
            expression="org.springframework.stereotype.Controller" />
    </context:component-scan>

    <!-- 视图解析器 -->
    <bean
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>

    <!-- 正确处理Mapping -->
    <mvc:default-servlet-handler />
    <!-- 正确处理静态资源 -->
    <mvc:annotation-driven></mvc:annotation-driven>
</beans>

配置Spring(重点)

在src/main/conf包（类路径）下，创建applicationContext.xml，和web.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:tx="http://www.springframework.org/schema/tx"
    xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
    xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

    <!-- Spring希望管理所有的业务逻辑组件,等... -->
    <context:component-scan
        base-package="com.shen.mybatis">
        <context:exclude-filter type="annotation"
            expression="org.springframework.stereotype.Controller" />
    </context:component-scan>

    <!-- Spring用来控制业务逻辑.数据源、事务控制、AOP -->
    <!-- 引入外部数据库配置文件properties -->
    <context:property-placeholder
        location="classpath:dbconfig.properties" />

    <!-- 数据源 -->
    <bean id="dataSource" 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.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

    <!-- spring事务管理 -->
    <bean id="dataSourceTransactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!-- 开启基于注解的事务 -->
    <tx:annotation-driven
        transaction-manager="dataSourceTransactionManager" />

    <!-- 整合mybatis 目的: -->
    <!-- 1.Spring管理所有组件.mapper的实现类 service===>Dao @Autowired:自动注入mapper -->
    <!-- 2.spring用来管理事务,spring声明式事务 -->
    <!-- 创建出SqlSessionFactory对象 -->
    <bean class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <!-- configLocation:指定全局配置文件的位置 -->
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
        <!-- mapperLocations:指定mapper文件的位置 ,不配置Mapper接口和Mapper配置的包名必须相同 -->
        <property name="mapperLocations"
            value="classpath:mybatis/mapper/*.xml"></property>
    </bean>

    <!-- 扫描所有的mapper接口的实现,让这些mapper能够自动注入 -->
    <!-- base-package:指定mapper接口的包名 -->
    <mybatis-spring:scan base-package="com.shen.mybatis.dao" />
    <!-- 老版本使用方式,只是可以指定更多的属性 -->
    <!-- <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> -->
    <!-- <property name="basePackage" value="com.shen.mybatis.dao"></property> -->
    <!-- </bean> -->
</beans>

编写Mapper接口以及Mapper XML

com.shen.mybatis.dao.EmployeeMapper：

public interface EmployeeMapper {

    public Employee getEmpById(Integer id);

    public List<Employee> getEmps();
}

src/main/conf/mybatis/mapper/EmployeeMapper.xml：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.shen.mybatis.dao.EmployeeMapper">
    <!-- public Employee getEmpById(Integer id); -->
    <select id="getEmpById" resultType="com.shen.mybatis.bean.Employee">
        select * from tbl_employee where
        id = #{id}
    </select>

    <!-- public List<Employee> getEmps(); -->
    <select id="getEmps" resultType="com.shen.mybatis.bean.Employee">
        select * from tbl_employee
    </select>
</mapper>

编写Controller以及Service

com.shen.mybatis.service.EmployeeService：

@Service
public class EmployeeService {

    @Autowired
    private EmployeeMapper employeeMapper;

    public List<Employee> getEmps() {
        return employeeMapper.getEmps();
    }
}

EmployeeMapper使用Spring的自动注入功能，不用再使用sqlSession.getMapper来实例化。

com.shen.mybatis.controller.EmployeeController：

@Controller
public class EmployeeController {

    @Autowired
    EmployeeService employeeService;

    @RequestMapping(value = "/getemps")
    public String getAllEmps(Map<String, Object> map) {
        List<Employee> emps = employeeService.getEmps();
        map.put("emps", emps);
        return "list";
    }
}

（1）使用@Controller注解，标识该类是一个Controller。
（2）EmployeeService属性使用@Autowired，自动注入。

前端页面

src/main/webapp/index.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>首页</title>
</head>
<body>
    <a href="getemps">查询所有员工</a>
</body>
</html>

src/main/webapp/WEB-INF/pages/list.jsp：

<%@ 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 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>员工列表</title>
</head>
<body>
    <table>
        <tr>
            <td>编号</td>
            <td>名字</td>
            <td>邮箱</td>
            <td>性别</td>
        </tr>
        <c:forEach items="${emps}" var="emp">
            <tr>
                <td>${emp.id}</td>
                <td>${emp.lastName}</td>
                <td>${emp.email}</td>
                <td>${emp.gender}</td>
            </tr>
        </c:forEach>
    </table>

</body>
</html>

测试

基于Tomcat7.0，直接测试网页即可。

从程序猿到程序员

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
MyBatis学习笔记——SSM整合（Spring4，SpringMVC4，MyBatis3）

构建环境导入Jar包pom.xml&lt;dependencies&gt; &lt;!-- Spring/SpringMVC --&gt; &lt;dependency&gt; &lt;groupId&gt;org.springframework&lt;/groupId&gt; &lt;artifac...
复制链接

扫一扫

专栏目录