Spring 整合 mybatis

Spring 整合Mybaits 我知道有两种方式，点击查看另外一种方式

一、项目结构图

一、创建maven工程，导入需要的jar包的依赖坐标

<dependencies> 
	   <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
	   <dependency>
	       <groupId>org.springframework</groupId>
	       <artifactId>spring-webmvc</artifactId>
	       <version>5.3.5</version>
	   </dependency> 
	   <!-- 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-config.xml配置文件，并配置

• 创建spring-config.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/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd"> 
</beans>

• 配置数据源

<!--    配置数据源-->
<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工厂

<!--    配置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> 

三、创建mybatis-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>
</configuration>  

四、创建User实体类

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

五、创建UserMapper接口

public interface UserMapper {
    User getUserById(int i);
}

六、创建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="cn.test.mapper.UserMapper">
    <resultMap id="userMap" type="cn.test.pojo.User"/>
    <select id="getUserById" resultMap="userMap">
        select * from `mybatias`.`user` where `user`.`id` = #{id}
    </select>
</mapper> 

六、创建UserMapperImpl实现类

• 注意这里是直接继承SqlSessionDaoSupport类，所以用在spring-config.xml文件中配置SqlSession（数据库会话）对象，这就是和另外一种方法区别的地方

public class UserMapperImpl extends SqlSessionDaoSupport implements UserMapper {
    @Override
    public User getUserById(int i) {
        return getSqlSession().getMapper(UserMapper.class).getUserById(i);
    }
}

七、创建MyTestFun测试类

• 测试代码如下：

public class MyTestFun {
    @Test
    public void getUserByID() {
        ApplicationContext context = new ClassPathXmlApplicationContext("spring-config.xml");
        UserMapper userMapperImpl = context.getBean("userMapperImpl", UserMapper.class);
        System.out.println(userMapperImpl.getUserById(1));
    }
}

• 查询结果
  

八、备注

• 使用的数据库