• mybatis-spring的整合

    Maven环境搭建

    导入jar包

    • junit

    • mybatis

    • mysql数据库

    • spring相关

    • aop织入

    • mybatis-spring

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <parent>
    6.         <artifactId>spring-studyartifactId>
    7.         <groupId>com.yuangroupId>
    8.         <version>1.0-SNAPSHOTversion>
    9.     parent>
    10.     <modelVersion>4.0.0modelVersion>
    11.  
    12.     <artifactId>spring-10-mybatisartifactId>
    13.  
    14.     <properties>
    15.         <maven.compiler.source>8maven.compiler.source>
    16.         <maven.compiler.target>8maven.compiler.target>
    17.         <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    18.     properties>
    19.  
    20.     <dependencies>
    21.         <dependency>
    22.             <groupId>junitgroupId>
    23.             <artifactId>junitartifactId>
    24.             <version>4.12version>
    25.             <scope>testscope>
    26.         dependency>
    27.  
    28.         <dependency>
    29.             <groupId>mysqlgroupId>
    30.             <artifactId>mysql-connector-javaartifactId>
    31.             <version>5.1.47version>
    32.         dependency>
    33.  
    34.         <dependency>
    35.             <groupId>org.mybatisgroupId>
    36.             <artifactId>mybatisartifactId>
    37.             <version>3.5.2version>
    38.         dependency>
    39.  
    40.         <dependency>
    41.             <groupId>org.springframeworkgroupId>
    42.             <artifactId>spring-webmvcartifactId>
    43.             <version>5.2.0.RELEASEversion>
    44.         dependency>
    45.  
    46.  
    47.         
    48.         <dependency>
    49.             <groupId>org.springframeworkgroupId>
    50.             <artifactId>spring-jdbcartifactId>
    51.             <version>5.3.19version>
    52.             <scope>compilescope>
    53.         dependency>
    54.  
    55.  
    56.         <dependency>
    57.             <groupId>org.aspectjgroupId>
    58.             <artifactId>aspectjweaverartifactId>
    59.             <version>1.8.13version>
    60.         dependency>
    61.  
    62.         
    63.         <dependency>
    64.             <groupId>org.aspectjgroupId>
    65.             <artifactId>aspectjweaverartifactId>
    66.             <version>1.8.13version>
    67.         dependency>
    68.  
    69.         
    70.         
    71.         <dependency>
    72.             <groupId>org.mybatisgroupId>
    73.             <artifactId>mybatis-springartifactId>
    74.             <version>2.0.2version>
    75.         dependency>
    76.  
    77.         <dependency>
    78.             <groupId>org.projectlombokgroupId>
    79.             <artifactId>lombokartifactId>
    80.             <version>1.16.10version>
    81.         dependency>
    82.  
    83.     dependencies>
    84.  
    85.  
    86.  
    87.     <build>
    88.         <resources>
    89.             <resource>
    90.                 <directory>src/main/javadirectory>
    91.                 <includes>
    92.                     <include>**/*.xmlinclude>
    93.                 includes>
    94.                 <filtering>truefiltering>
    95.             resource>
    96.         resources>
    97.     build>
    98.  
    99.  
    100. project>

    编写mybatis层

    编写实体类

    1. import lombok.Data;
    2.  
    3. @Data
    4. public class User {
    5.     private int id;
    6.     private String name;
    7.     private String pwd;
    8. }

    编写核心配置文件

    mybatis-config.xml

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    6. <configuration>
    7.     
    8.     <environments default="development">
    9.         <environment id="development">
    10.             <transactionManager type="JDBC"/>
    11.             <dataSource type="POOLED">
    12.                 <property name="driver" value="com.mysql.jdbc.Driver"/>
    13.                 <property name="url"
    14.                           value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8"/>
    15.                 <property name="username" value="root"/>
    16.                 <property name="password" value="123456"/>
    17.             dataSource>
    18.         environment>
    19.     environments>
    20.     
    21.     
    22.     <mappers>
    23.         <mapper resource="com/yuan/mapper/UserMapper.xml"/>
    24.     mappers>
    25. configuration>

    编写接口

    1. import com.yuan.pojo.User;
    2. import java.util.List;
    3.  
    4. public interface UserMapper {
    5.     public List selectUser();
    6. }

    编写Mapper.xml

    1. "1.0" encoding="UTF-8" ?>
    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5.  
    6. <mapper namespace="com.yuan.mapper.UserMapper">
    7.     <select id="selectUser" resultType="user">
    8.         select * from mybatis.user;
    9.     select>
    10.  
    11. mapper>

    测试

    1. import com.yuan.mapper.UserMapper;
    2. import com.yuan.pojo.User;
    3. import org.apache.ibatis.io.Resources;
    4. import org.apache.ibatis.session.SqlSession;
    5. import org.apache.ibatis.session.SqlSessionFactory;
    6. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    7. import org.junit.Test;
    8.  
    9.  
    10. import java.io.IOException;
    11. import java.io.InputStream;
    12. import java.util.List;
    13.  
    14. public class MyTest {
    15.     @Test
    16.     public void test() throws IOException {
    17.         String resources = "mybatis-config.xml";
    18.         InputStream in = Resources.getResourceAsStream(resources);
    19.         SqlSessionFactory sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder().build(in);
    20.         SqlSession sqlSession = sqlSessionFactoryBuilder.openSession(true);
    21.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    22.         List userList = mapper.selectUser();
    23.         for (User user : userList) {
    24.             System.out.println(user);
    25.         }
    26.     }
    27.  
    28. }

    mybatis-spring整合

            官方文档：mybatis-spring –

    方式一

    步骤（在mybatis层上改造）

        1.配置数据源

        2.sqlSessionFactory

        3.SqlSessionTemplate

            配置文件spring-dao.xml【固定配置】

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:aop="http://www.springframework.org/schema/aop"
    5.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    6.         https://www.springframework.org/schema/beans/spring-beans.xsd
    7.         http://www.springframework.org/schema/aop
    8.         https://www.springframework.org/schema/aop/spring-aop.xsd">
    9.  
    10.     
    11.     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    12.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    13.         <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8"/>
    14.         <property name="username" value="root"/>
    15.         <property name="password" value="123456"/>
    16.     bean>
    17.  
    18.     
    19.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    20.         <property name="dataSource" ref="dataSource"/>
    22.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
    23.         <property name="mapperLocations" value="classpath:com/yuan/mapper/*.xml"/>
    24.     bean>
    25.  
    27.     <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    29.         <constructor-arg index="0" ref="sqlSessionFactory"/>
    30.     bean>
    31.  
    32.  
    33.  
    34.  
    35. beans>

            mybatis-config.xml改造后如下：

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    6. <configuration>
    7.     
    8.     <typeAliases>
    9.         <package name="com.yuan.pojo"/>
    10.     typeAliases>
    11.     
    12.  
    13.  
    14. configuration>

        4.实现接口

            UserMapperImpl.java

    1. import com.yuan.pojo.User;
    2. import org.mybatis.spring.SqlSessionTemplate;
    3.  
    4. import java.util.List;
    5.  
    6. public class UserMapperImpl implements UserMapper{
    7.     //我们的所有操作，都使用sqlSession来执行，在原来，现在都使用SqlSessionTemplate
    8.     private SqlSessionTemplate sqlSession;
    9.  
    10.     public void setSqlSession(SqlSessionTemplate sqlSession) {
    11.         this.sqlSession = sqlSession;
    12.     }
    13.  
    14.     @Override
    15.     public List selectUser() {
    16.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    17.         return mapper.selectUser();
    18.     }
    19. }

        5.配置bean

            这里不直接在spring-dao.xml中配置，为了保持spring-dao.xml的干净整洁，因为这个配置文件后续基本不变，新增再下面这里操作即可！

            applicationContext.xml

    1. "1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:aop="http://www.springframework.org/schema/aop"
    5.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    6.         https://www.springframework.org/schema/beans/spring-beans.xsd
    7.         http://www.springframework.org/schema/aop
    8.         https://www.springframework.org/schema/aop/spring-aop.xsd">
    9.  
    10.     <import resource="spring-dao.xml"/>
    11.  
    12.     <bean id="userMapper" class="com.yuan.mapper.UserMapperImpl">
    13.         <property name="sqlSession" ref="sqlSession"/>
    14.     bean>
    15.  
    16. beans>

        6.测试

    1. import com.yuan.mapper.UserMapper;
    2. import com.yuan.pojo.User;
    3.  
    4. import org.junit.Test;
    5. import org.springframework.context.ApplicationContext;
    6. import org.springframework.context.support.ClassPathXmlApplicationContext;
    7.  
    8.  
    9. public class MyTest {
    10.  
    11.  
    12.     @Test
    13.     public void test(){
    14.         ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
    15.         UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
    16.         for (User user : userMapper.selectUser()) {
    17.             System.out.println(user);
    18.         }
    19.     }
    20. }

    方式二：SqlSessionDaoSupport实现

            新增一个UserMapperImpl2.java

    1. import com.yuan.pojo.User;
    2. import org.apache.ibatis.session.SqlSession;
    3. import org.mybatis.spring.support.SqlSessionDaoSupport;
    4.  
    5. import java.util.List;
    6.  
    7. public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper{
    8.  
    9.  
    10.     @Override
    11.     public List selectUser() {
    12.         SqlSession sqlSession = getSqlSession();
    13.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    14.         return mapper.selectUser();
    15.     }
    16. }

            注入spring applicationContext.xml配置文件新增如下配置

    1.     <bean id="userMapper2" class="com.yuan.mapper.UserMapperImpl2">
    2.         <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    3.     bean>

            测试

    1. import com.yuan.mapper.UserMapper;
    2. import com.yuan.pojo.User;
    3.  
    4. import org.junit.Test;
    5. import org.springframework.context.ApplicationContext;
    6. import org.springframework.context.support.ClassPathXmlApplicationContext;
    7.  
    8.  
    9. public class MyTest {
    10.  
    11.  
    12.     @Test
    13.     public void test(){
    14.         ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
    15.         UserMapper userMapper = context.getBean("userMapper2", UserMapper.class);
    16.         for (User user : userMapper.selectUser()) {
    17.             System.out.println(user);
    18.         }
    19.     }
    20. }

  • 相关阅读:
    Apollo(阿波罗)分布式配置中心
    三篇卫星切换的论文
    数商云采购商城价格管理应用场景介绍 | 数字化采购助力汽配行业企业降本增效
    Web --- 端口协议
    音频学习笔记之音频播放
    java写一个用于生成雪花id的工具类
    SpringBoot 条件注解之：自定义条件注解
    源码编译perl5遇到的问题汇总
    【数据结构】——二叉树oj题详解
    UE5导入自定义MetaHuman虚拟人和服装并联动
  • 原文地址：https://blog.csdn.net/weixin_48426115/article/details/126885949