使用注解和Mapper映射器的方式整合Mybatis和Spring

长头发的程序猿

已于 2022-10-26 05:22:54 修改

阅读量632

点赞数

文章标签： spring mybatis

于 2022-01-05 14:30:42 首次发布

本文链接：https://blog.csdn.net/weixin_55076626/article/details/122321741

版权

注：因为是使用注解和Mapper映射器的方式整合，所以不再需要UserMapperImpl，另外实体类smbms_role用不到，所以后面案例也不会出现。

pom.xml

dependencies标签下所需导入的18个依赖：

<dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</version>
    </dependency>
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>1.2.17</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.2.2</version>
    </dependency>
<!--spring核心架包-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-expression</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
<!--spring aop相关的依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aspects</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.6.9</version>
    </dependency>
    <dependency>
      <groupId>aopalliance</groupId>
      <artifactId>aopalliance</artifactId>
      <version>1.0</version>
    </dependency>
<!--mybatis整合-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.2.2</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>4.3.14.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>commons-dbcp</groupId>
      <artifactId>commons-dbcp</artifactId>
      <version>1.4</version>
    </dependency>
    <dependency>
      <groupId>commons-pool</groupId>
      <artifactId>commons-pool</artifactId>
      <version>1.6</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.45</version>
    </dependency>

build标签中注入resources标签：

<!--让src文件夹能够读取xml文件 原始的状态只能读取Java文件-->
    <resources>
      <resource>
        <directory>${basedir}/src/main/java</directory>
        <includes>
          <include>**/*.xml</include>
        </includes>
      </resource>
    </resources>

注：此案例我以smbms为数据库，使用此库中的表smbms_user

pojo包，Smbms_User

import java.util.Date;

private Integer id;
private String userCode;
private String userName;
private String userPassWord;
private String gender;
private Date birthday;
private String phone;
private String address;
private Integer userRole;
private Integer createBy;
private Date creationDate;
private Integer modifyBy;
private Date modifyDate;
private String idPicPath;
private String workPicPath;

get，set和toString方法省略......（Alt＋Insert快捷键）

userMapper包，UserMapper

import org.apache.ibatis.annotations.Param;
import pojo.Smbms_User;
import java.util.List;

public interface UserMapper {
    //根据用户名和角色id查询信息
    List<Smbms_User> selectBy(@Param("userName") String userName, @Param("roleId")  Integer roleId);
}

userMapper包，Smbms_UserMapper.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="userMapper.UserMapper">

<!--根据用户名和角色id查询 smbms_User是ApplicationContext.xml中起的别名-->
    <select id="selectBy" resultType="smbms_User">
        SELECT * FROM smbms_user WHERE username LIKE CONCAT('%',#{userName},'%') AND userrole = #{roleId}
    </select>

</mapper>

service包，UserService

import pojo.Smbms_User;
import java.util.List;

public interface UserService {
    //根据用户名和角色id查询信息
    List<Smbms_User> selectBy(String userName,Integer roleId);
}

serviceImpl包，UserServiceImpl

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import userMapper.UserMapper;
import pojo.Smbms_User;
import service.UserService;
import java.util.List;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    public UserMapper getUserMapper() {
        return userMapper;
    }

    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }

    @Override
    public List<Smbms_User> selectBy(String userName, Integer roleId) {
        return userMapper.selectBy(userName,roleId);
    }
}

resources文件夹，database (1).properties

driver=com.mysql.jdbc.Driver

#在和mysql传递数据的过程中，使用unicode编码格式，并且字符集设置为utf-8
url=jdbc:mysql://127.0.0.1:3306/smbms?useUnicode=true&characterEncoding=utf-8

username=root

password=ok

resources文件夹，log4j.properties

自己可以去百度下载，如果没有，正常的System.out.println()输出也行

resources文件夹，mybaties-config.xml

mybaties-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="logImpl" value="log4j"/>
<!--设置关联映射级别-->
        <setting name="autoMappingBehavior" value="FULL"/>
    </settings>
<!--起别名-->
    <typeAliases>
<!--<package name="entity"/>-->
        <typeAlias type="pojo.Smbms_User" alias="user"></typeAlias>
    </typeAliases>
</configuration>

resources文件夹，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"
       xsi:schemaLocation="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.xsd
       http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<!--注解扫描-->
    <context:component-scan base-package="serviceImpl"></context:component-scan>
<!--aop自动代理-->
<!--<aop:aspectj-autoproxy proxy-target-class="true"></aop:aspectj-autoproxy>-->
<!--读取database (1).properties配置文件-->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:database (1).properties"/>
    </bean>
<!--数据源的配置-->
    <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
    </bean>
<!--创建工厂的实例-->
    <bean id="factory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--数据源配置-->
        <property name="dataSource" ref="myDataSource"/>
<!--mapper映射文件配置-->
        <property name="mapperLocations">
            <list>
                <value>userMapper/Smbms_UserMapper.xml</value>
            </list>
        </property>
<!--起别名-->
        <property name="typeAliases">
            <array>
                <value>pojo.Smbms_User</value>
            </array>
        </property>
    </bean>
<!--注入映射器扫描-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="userMapper"/>
<!--工厂可以不加，但是在多个工厂的情况下需要指明-->
        <property name="sqlSessionFactoryBeanName" value="factory"/>
    </bean>
</beans>

AppTest测试类

import org.apache.log4j.Logger;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import pojo.Smbms_User;
import service.UserService;
import java.util.List;

public class AppTest {
    //采用日志打印
    private Logger logger = Logger.getLogger(AppTest.class);
    
    @Test
    public void test(){
        ApplicationContext atx = new
                ClassPathXmlApplicationContext("ApplicationContext.xml");
        UserService service = (UserService) atx.getBean("userServiceImpl");
        List<Smbms_User> users = service.selectBy("孙",3);
        for (Smbms_User user : users) {
            logger.debug(user.toString());
        }
    }
}

以上就是使用注解和Mapper映射器的方式整合Mybatis和Spring的全部步骤，测试结果过多，这里不便截图

总结：与我之前总结的普通方式整合Mybatis和Spring，(43条消息) Mybatis和Spring相整合的详细步骤_晓泽OVO的博客-CSDN博客

本章使用注解和Mapper映射器的方式整合Mybatis和Spring还是很方便的，主要去掉了

mapper层的实现类，在service层的实现类加上了@Service和@Autowired两个注解，

而且还给ApplicationContext.xml配置文件中添写了一些配置。

长头发的程序猿

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
使用注解和Mapper映射器的方式整合Mybatis和Spring

resources文件夹，database (1).properties。resources文件夹，ApplicationContext.xml。userMapper包，Smbms_UserMapper.xml。resources文件夹，mybaties-config.xml。resources文件夹，log4j.properties。userMapper包，UserMapper。service包，UserService。pojo包，Smbms_User。AppTest测试类。
复制链接

扫一扫