spring整合mybatis

官网完整配置：http://mybatis.org/spring/zh/getting-started.html

一、项目路径展示

二、导入jar包

在maven项目的pom.xml文件中导入以下jar包 。点击查看maven的文档头

    <dependencies>  
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency> 
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.23</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.5</version>
        </dependency> 
    </dependencies>  

三、在spring的spring-config.xml配置文件中配置

• 在resources资源包下新建spring-config.xml文件，这是spring项目的配置文件

点击查看spring-config.xml文件头

• 配置数据源

<!--    配置数据源-->
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	    <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
	    <property name="url" value="jdbc:mysql://localhost:3306/mybatias?serverTimeZone=Asia/Shanghai"/>
	    <property name="username" value="root"/>
	    <property name="password" value="123456"/>
	</bean>

• 配置sqlSession工厂，点击查看mybatis-config.xml文件

	<!--    配置sqlSession工厂-->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	    <property name="dataSource" ref="dataSource"/>
	    <property name="configLocation" value="classpath:mybatis-config.xml"/>
	    <property name="mapperLocations" value="classpath:mapper/*.xml"/>
	</bean>

• 创建SQLSession对象

    <!--    创建SQLSession对象-->
    <bean id="sessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
        <constructor-arg index="0" ref="sqlSessionFactory"/>
    </bean>

四、简单使用

• 使用MySQL数据库创建练习用的数据

drop database if exists `mybatis`;
create database if not exists `mybatis`;
use `mybatias`;
drop table if exists `user`;
create table if not exists  `user`(
    `id` int not null auto_increment,
    `username` varchar(11) not null ,
    `password` varchar(11) not null ,
    primary key (`id`)
) engine = InnoDB default charset =utf8;

• 创建user实体类，这里省略了get、set，toString方法

public class User {
    private int id;
    private String username;
    private String password;

    public User(String username, String password) {
        this.username = username;
        this.password = password;
    }
}

• 创建userMapper接口

public interface UserMapper {
    int addUser(User user);
}

• 创建userMapper.xml文件，放在resources资源目录下的mapper文件夹里面。点击查看mybaits mapper.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="cn.test.mapper.UserMapper">
    <parameterMap id="userMap" type="cn.test.pojo.User"/>
    <insert id="addUser" parameterMap="userMap">
        insert into `mybatias`.`user`(`username`, `password`) VALUES (${username},${password})
    </insert>
</mapper>

• 创建UserMapperImpl实现类

public class UserMapperImpl implements UserMapper {
    private SqlSessionTemplate sessionTemplate;

    public UserMapperImpl(SqlSessionTemplate sessionTemplate) {
        this.sessionTemplate = sessionTemplate;
    }

    @Override
    public int addUser(User user) {
        UserMapper mapper = sessionTemplate.getMapper(UserMapper.class);
        return mapper.addUser(user);
    }
} 

• 在spring的spring-config.xml文件中注入mapper的实现类

<!--    注入userMapper的实现类-->
<bean id="userMapperImpl" class="cn.test.mapper.UserMapperImpl">
    <constructor-arg index="0" ref="sessionTemplate"/>
</bean>

• 创建一个TestFun测试类

public class TestFun {
    @Test
    public void addUser() {
        ApplicationContext context = new ClassPathXmlApplicationContext("spring-config.xml");
        UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
        User user = new User("user001", "123456");
        int i = userMapper.addUser(user);
    }
}

• 查看数据库结果