• spring整合Mybatis-P23，24，25

    复习Mybatis（都是之前的内容，不再解释）

    6个需要修改或创建的文件

    UserMapper

    1. package com.Li.mapper;
    2.  
    3. import com.Li.pojo.User;
    4.  
    5. import java.util.List;
    6.  
    7. public interface UserMapper {
    8.     public List selectUser();
    9. }

    UserMapper.xml

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

    User

    1. package com.Li.pojo;
    2.  
    3. import lombok.Data;
    4.  
    5. @Data
    6. public class User {
    7.     private int id;
    8.     private String name;
    9.     private String pwd;
    10. }
    11.

    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">
    5. <configuration>
    6.  
    7.     <typeAliases>
    8.         <package name="com.Li.pojo"/>
    9.     typeAliases>
    10.  
    11.     <environments default="development">
    12.         <environment id="development">
    13.             <transactionManager type="JDBC"/>
    14.             <dataSource type="POOLED">
    15.                 <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
    16.                 <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=utf8"/>
    17.                 <property name="username" value="root"/>
    18.                 <property name="password" value="123456"/>
    19.             dataSource>
    20.         environment>
    21.     environments>
    22.  
    23.     <mappers>
    24.         <mapper resource="com/Li/mapper/UserMapper.xml"/>
    25.     mappers>
    26. configuration>

    MyTest

    1. import com.Li.mapper.UserMapper;
    2. import com.Li.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. import java.io.IOException;
    10. import java.io.InputStream;
    11. import java.util.List;
    12.  
    13. public class MyTest {
    14.     @Test
    15.     public void selectUser() throws IOException {
    16.  
    17.         String resource = "mybatis-config.xml";
    18.         InputStream inputStream = Resources.getResourceAsStream(resource);
    19.         SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    20.         SqlSession sqlSession = sqlSessionFactory.openSession();
    21.  
    22.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    23.  
    24.         List userList = mapper.selectUser();
    25.         for (User user: userList){
    26.             System.out.println(user);
    27.         }
    28.  
    29.         sqlSession.close();
    30.     }
    31.  
    32. }

    pom.xml

    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.LigroupId>
    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.     properties>
    18.  
    19.  
    20.     <dependencies>
    21.         <dependency>
    22.             <groupId>junitgroupId>
    23.             <artifactId>junitartifactId>
    24.             <version>4.12version>
    25.         dependency>
    26.         <dependency>
    27.             <groupId>mysqlgroupId>
    28.             <artifactId>mysql-connector-javaartifactId>
    29.             <version>8.0.29version>
    30.         dependency>
    31.         <dependency>
    32.             <groupId>org.mybatisgroupId>
    33.             <artifactId>mybatisartifactId>
    34.             <version>3.5.2version>
    35.         dependency>
    36.         <dependency>
    37.             <groupId>org.springframeworkgroupId>
    38.             <artifactId>spring-webmvcartifactId>
    39.             <version>5.3.23version>
    40.         dependency>
    41.         <dependency>
    42.             <groupId>org.springframeworkgroupId>
    43.             <artifactId>spring-jdbcartifactId>
    44.             <version>6.0.0version>
    45.         dependency>
    46.         <dependency>
    47.             <groupId>org.aspectjgroupId>
    48.             <artifactId>aspectjweaverartifactId>
    49.             <version>1.9.4version>
    50.         dependency>
    51.         <dependency>
    52.             <groupId>org.mybatisgroupId>
    53.             <artifactId>mybatis-springartifactId>
    54.             <version>2.0.7version>
    55.         dependency>
    56.         <dependency>
    57.             <groupId>org.projectlombokgroupId>
    58.             <artifactId>lombokartifactId>
    59.             <version>1.18.10version>
    60.         dependency>
    61.     dependencies>
    62.  
    63.     <build>
    64.         <resources>
    65.             <resource>
    66.                 <directory>src/main/javadirectory>
    67.                 <includes>
    68.                     <include>**/*.propertiesinclude>
    69.                     <include>**/*.xmlinclude>
    70.                 includes>
    71.                 <filtering>falsefiltering>
    72.             resource>
    73.             <resource>
    74.                 <directory>src/main/resourcesdirectory>
    75.                 <includes>
    76.                     <include>**/*.propertiesinclude>
    77.                     <include>**/*.xmlinclude>
    78.                 includes>
    79.                 <filtering>falsefiltering>
    80.             resource>
    81.         resources>
    82.  
    83.     build>
    84.  
    85.  
    86.  
    87.  
    88. project>

    测试：

    整合Mybatis方式一：（详解在代码中）

     UserMapperImpl：（接口的实现类，用来实现 UserMapper的Mybatis）

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

    mybatis-config.xml：（简化删减里面的内容，将里面的内容移至spring-dao.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">
    5. <configuration>
    6.  
    7.     <typeAliases>
    8.         <package name="com.Li.pojo"/>
    9.     typeAliases>
    10.  
    11.  
    12. configuration>

    spring-dao.xml（整合了mybatis-config.xml与spring-dao.xml，使两种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.     
    12.     
    13.     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    14.         <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    15.         <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8"/>
    16.         <property name="username" value="root"/>
    17.         <property name="password" value="123456"/>
    18.     bean>
    19.  
    20.  
    21.  
    22.     
    23.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    24.         <property name="dataSource" ref="dataSource"/>
    25.         
    26.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
    27.         
    28.         <property name="mapperLocations" value="classpath:com/Li/mapper/*.xml"/>
    29.     bean>
    30.  
    31.     
    32.     <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    33.         
    34.         <constructor-arg index="0" ref="sqlSessionFactory"/>
    35.     bean>
    36.  
    37.     <bean id="userMapper" class="com.Li.mapper.UserMapperImpl">
    38.         <property name="sqlSession" ref="sqlSession"/>
    39.     bean>
    40.  
    41.  
    42. beans>

    Mytest:(以spring的方式来做)

    1. import com.Li.mapper.UserMapper;
    2. import com.Li.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. import org.springframework.context.ApplicationContext;
    9. import org.springframework.context.support.ClassPathXmlApplicationContext;
    10.  
    11. import java.io.IOException;
    12. import java.io.InputStream;
    13. import java.util.List;
    14.  
    15. public class MyTest {
    16.     @Test
    17.     public void selectUser() throws IOException {
    18.  
    19.         ApplicationContext context = new ClassPathXmlApplicationContext("spring-dao.xml");
    20.  
    21.         UserMapper userMapper = context.getBean("userMapper", UserMapper.class);
    22.         for (User user : userMapper.selectUser()) {
    23.             System.out.println(user);
    24.         }
    25.  
    26.     }
    27.  
    28. }

     测试：

     Error loading class [org.springframework.jdbc.datasource.DriverManagerDataSource] for bean with name

    会出现这样的红字报错。

    直接改jar包的版本。。。这tm花了我好长时间找这个错误。。。无语

    2.         <dependency>
    3.             <groupId>org.springframeworkgroupId>
    4.             <artifactId>spring-jdbcartifactId>
    5.             <version>5.2.0.RELEASEversion>
    6.         dependency>

    成功！

    小结：你需要去对应MyTest的代码，来理解你每一步操作都是在干什么。

    方式二：（简化方式一）

    UserMapperImpl2：（继承实现）

    1. package com.Li.mapper;
    2.  
    3. import com.Li.pojo.User;
    4. import org.apache.ibatis.session.SqlSession;
    5. import org.mybatis.spring.support.SqlSessionDaoSupport;
    6.  
    7. import java.util.List;
    8. //继承SqlSessionDaoSupport，不需要创建sqlSession了，可以直接用
    9. public class UserMapperImpl2 extends SqlSessionDaoSupport implements UserMapper{
    10.     @Override
    11.     public List selectUser() {
    12.         SqlSession sqlSession = getSqlSession();
    13.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    14.         return mapper.selectUser();
    15.     }
    16. }

    applicationContext.xml：（将spring-dao.xml与mybatis-config.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.Li.mapper.UserMapperImpl">
    13.         <property name="sqlSession" ref="sqlSession"/>
    14.     bean>
    15.  
    16.     <bean id="userMapper2" class="com.Li.mapper.UserMapperImpl2">
    17.         <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    18.     bean>
    19.  
    20. beans>

    修改之后测试成功！

    重点在方式一的理解与掌握！

  • 相关阅读:
    【LeetCode刷题-滑动窗口】-- 795.区间子数组个数
    动态获取input框的值
    数据库系统工程师难考吗？
    【 OpenGauss源码学习 —— 列存储（update_pages_and_tuples_pgclass）】
    阿里技术官首发的Java核心框架指导手册，为了大厂得码住学起来~
    服务器Debian 12.x中安装Jupyer并配置远程访问
    已解决ValueError: If using all scalar values, you must pass an index
    英国G5生物医学类专业IB成绩要求多高？
    中级经济师考试题型有哪些？具体分值是多少？
    纯血鸿蒙APP实战开发——Canvas实现模拟时钟案例
  • 原文地址：https://blog.csdn.net/m0_54842832/article/details/128058519