Spring整合MyBatis01

1、Spring整合MyBatis

步骤：

1. 导入相关jar包；

   • junit；

   • mybatis；

   • mysql数据库；

   • spring相关的；

   • aop织入；

   • mybatis-spring【new知识点】

     <dependencies>
             <dependency>
                 <groupId>junit</groupId>
                 <artifactId>junit</artifactId>
                 <version>4.13.1</version>
                 <scope>test</scope>
             </dependency>
             <!--连接数据库 https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
             <dependency>
                 <groupId>mysql</groupId>
                 <artifactId>mysql-connector-java</artifactId>
                 <version>8.0.20</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-webmvc -->
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-webmvc</artifactId>
                 <version>5.3.4</version>
             </dependency>
             <dependency>
                 <groupId>org.springframework</groupId>
                 <artifactId>spring-jdbc</artifactId>
                 <version>5.3.4</version>
             </dependency>
             <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
             <dependency>
                 <groupId>org.aspectj</groupId>
                 <artifactId>aspectjweaver</artifactId>
                 <version>1.9.6</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>
         </dependencies>
     
     <!--在build中配置resources,来防止我们资源导出失败的问题-->
         <build>
             <resources>
                 <resource>
                     <directory>src/main/resources</directory>
                     <includes>
                         <include>**/*.properties</include>
                         <include>**/*.xml</include>
                     </includes>
                     <filtering>false</filtering>
                 </resource>
                 <resource>
                     <directory>src/main/java</directory>
                     <includes>
                         <include>**/*.properties</include>
                         <include>**/*.xml</include>
                     </includes>
                     <filtering>false</filtering>
                 </resource>
             </resources>
         </build>
     

2. 编写实体类，UserMapper接口，UserMapper.xml文件，配置文件；

3. 测试。

2、回忆mybatis

1. 编写实体类；

   package com.beyond.pojo;
   
   import lombok.Data;
   
   @Data
   public class User {
       private int id;
       private String name;
       private String pwd;
   }
   

2. 编写接口；

   package com.beyond.mapper;
   
   import com.beyond.pojo.User;
   
   import java.util.List;
   
   public interface UserMapper {
       public List<User> selectUser();
   }
   

3. 编写mybatis-config.xml，Mapper.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:mybatis核心配置文件-->
   <configuration>
       <!--别名-->
       <typeAliases>
           <package name="com.beyond.pojo.User"/>
       </typeAliases>
   
   </configuration>
   

   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE mapper
           PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
           "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   
   <mapper namespace="com.beyond.mapper.UserMapper">
       <select id="selectUser" resultType="com.beyond.pojo.User">
           select * from user
       </select>
   </mapper>
   

4. 测试。

   import com.beyond.mapper.UserMapper;
   import com.beyond.pojo.User;
   import org.apache.ibatis.io.Resources;
   import org.apache.ibatis.session.SqlSession;
   import org.apache.ibatis.session.SqlSessionFactory;
   import org.apache.ibatis.session.SqlSessionFactoryBuilder;
   import org.junit.Test;
   
   import java.io.IOException;
   import java.io.InputStream;
   import java.util.List;
   
   public class MyTest {
       @Test
       public void test01() throws IOException {
           String resource="mybatis-config.xml";
           InputStream in= Resources.getResourceAsStream(resource);
           SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
           SqlSession sqlSession = sessionFactory.openSession(true);
   
           UserMapper mapper = sqlSession.getMapper(UserMapper.class);
           List<User> userList=mapper.selectUser();
           for (User user:userList) {
               System.out.println(user);
           }
       }
   }