mybatis 的核心步骤

一、mybatis核心依赖支持

<!-- 配置依赖支持 -->
 <dependencies>
     <dependency>
         <groupId>junit</groupId>
         <artifactId>junit</artifactId>
         <version>4.13.2</version>
     </dependency>
     <dependency>
         <groupId>mysql</groupId>
         <artifactId>mysql-connector-java</artifactId>
         <version>5.1.47</version>
     </dependency>
     <dependency>
         <groupId>org.mybatis</groupId>
         <artifactId>mybatis</artifactId>
         <version>3.5.6</version>
     </dependency>
     <dependency>
         <groupId>org.aspectj</groupId>
         <artifactId>aspectjweaver</artifactId>
         <version>1.9.7</version>
     </dependency>
     <dependency>
         <groupId>org.mybatis</groupId>
         <artifactId>mybatis-spring</artifactId>
         <version>2.0.6</version>
     </dependency>
      <dependency>
         <groupId>org.projectlombok</groupId>
         <artifactId>lombok</artifactId>
         <version>1.18.20</version>
         <scope>compile</scope>
     </dependency>
     <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc -->
     <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-webmvc</artifactId>
         <version>5.2.12.RELEASE</version>
     </dependency>
     <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
     <dependency>
         <groupId>org.springframework</groupId>
         <artifactId>spring-jdbc</artifactId>
         <version>5.2.9.RELEASE</version>
     </dependency>
    <!--maven 静态资源过滤-->
     <build>
         <resources>
             <resource>
                 <directory>src/main/java</directory>
                 <includes>
                     <include>**/*.properties</include>
                     <include>**/*.xml</include>
                 </includes>
                 <filtering>false</filtering>
             </resource>
             <resource>
                 <directory>src/main/resources</directory>
                 <includes>
                     <include>**/*.properties</include>
                     <include>**/*.xml</include>
                 </includes>
                 <filtering>false</filtering>
             </resource>
         </resources>
     </build>
</dependencies>

二、步骤内容

• 1.编写实体类

  // 实体类
  import lombok.Data;
  
  import java.util.Date;
  @Data
  public class User {
      private int id;
      private String name;
      private String password;
      private String email;
      private String user_code;
      private Date birthday;
  }
  

• ⒉.编写核心配置文件

  <?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>
      <typeAliases>
          <package name="com.pojo"/>
      </typeAliases>
      <!--configuration核心配置文件-->
      <environments default="development">
          <environment id="development">
              <transactionManager type="JDBC"></transactionManager>
              <dataSource type="POOLED">
                  <property name="driver" value="com.mysql.jdbc.Driver"/>
                  <property name="url" value="jdbc:mysql://127.0.0.1:3306/jdbc?serverTimezone=UTC&amp;characterEncoding=UTF-8&amp;useSSL=false"/>
                  <property name="username" value="root"/>
                  <property name="password" value="123&amp;"/>
              </dataSource>
          </environment>
      </environments>
      <mappers>
          <mapper class="com.mapper.UserMapper" />
      </mappers>
  </configuration>
  

• 3.编写接口

  // 接口类
  import com.pojo.User;
  
  import java.util.List;
  
  public interface UserMapper {
      public List<User> selectUser();
  }
  

• 4.编写Mapper.xml

  <?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.mapper.UserMapper">
      <select id="selectUser" resultType="user">
          select * from users;
      </select>
  </mapper>
  

• 5.测试

  import com.mapper.UserMapper;
  import com.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 test() throws IOException {
          String resources = "mybatis-config.xml";
          InputStream stream = Resources.getResourceAsStream(resources);
          SqlSessionFactory session = new SqlSessionFactoryBuilder().build(stream);
          SqlSession sqlSession = session.openSession(true);
          UserMapper mapper = sqlSession.getMapper(UserMapper.class);
          List<User> usersList = mapper.selectUser();
          for (User user:usersList){
              System.out.println(user.toString());
          }
      }
  }