mybatis入门01

mybatis-01

mybatis中文文档：https://mybatis.org/mybatis-3/zh/getting-started.html

数据库

CREATE TABLE `user`(
	`id` INT(20) NOT NULL PRIMARY KEY,
	`name` VARCHAR(30) DEFAULT NULL,
	`pwd` VARCHAR(30) DEFAULT NULL
)ENGINE=INNODB DEFAULT CHARSET=utf8; 

1. 创建maven项目

2. 配置pom.xml依赖

   <dependencies>
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>8.0.15</version>
       </dependency>
       <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
       <dependency>
           <groupId>org.mybatis</groupId>
           <artifactId>mybatis</artifactId>
           <version>3.5.4</version>
       </dependency>
       <!-- https://mvnrepository.com/artifact/junit/junit -->
       <dependency>
           <groupId>junit</groupId>
           <artifactId>junit</artifactId>
           <version>4.12</version>
       </dependency>
   </dependencies>
   

3. resources目录下创建mybatis-config.xml

   这里需要注意driver，有的是com.mysql.jdbc.Driver

   url在8.0版本需要配置时区

   <?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>
       <environments default="development">
           <environment id="development">
               <transactionManager type="JDBC"/>
               <dataSource type="POOLED">
                   <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                   <property name="url" value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&amp;useUnicode=true&amp;characterEncoding=utf-8"/>
                   <property name="username" value="root"/>
                   <property name="password" value="123456"/>
               </dataSource>
           </environment>
       </environments>
       <!-- 每一个Mapper.xml都需要在mybatis核心配置文件中注册,路径用/分隔 -->
       <mappers>
           <mapper resource="com/yu/dao/UserMapper.xml"/>
       </mappers>
   </configuration>
   

4. 编写mybatis工具类

   package com.yu.utils;
   
   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 java.io.IOException;
   import java.io.InputStream;
   
   //sqlSessionFactory
   public class MybatisUtils {
       private static SqlSessionFactory sqlSessionFactory;
       static{
           try {
               //获取sqlSessionFactory对象
               String resource = "mybatis-config.xml";
               InputStream inputStream = Resources.getResourceAsStream(resource);
               sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
           } catch (IOException e) {
               e.printStackTrace();
           }
       }
   
       //既然有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。
       // SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。
       // 你可以通过 SqlSession 实例来直接执行已映射的 SQL 语句。
       public static SqlSession getSqlSession(){
           return sqlSessionFactory.openSession();
       }
   }
   

5. 编写代码

   • 实体类

     package com.yu.pojo;
     
     public class User {
         private int id;
         private String name;
         private String pwd;
     
         public User() {
         }
     
         public User(int id, String name, String pwd) {
             this.id = id;
             this.name = name;
             this.pwd = pwd;
         }
     
         public int getId() {
             return id;
         }
     
         public void setId(int id) {
             this.id = id;
         }
     
         public String getName() {
             return name;
         }
     
         public void setName(String name) {
             this.name = name;
         }
     
         public String getPwd() {
             return pwd;
         }
     
         public void setPwd(String pwd) {
             this.pwd = pwd;
         }
     
         @Override
         public String toString() {
             return "User{" +
                     "id=" + id +
                     ", name='" + name + '\'' +
                     ", pwd='" + pwd + '\'' +
                     '}';
         }
     }
     

   • dao接口

     package com.yu.dao;
     
     import com.yu.pojo.User;
     
     import java.util.List;
     
     public interface UserDao {
         List<User> getUserList();
     }
     

   • 接口实现类 由原来的UserDaoImpl转换为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">
     <!-- namespace=绑定一个对应的Dao/Mapper接口 -->
     <mapper namespace="com.yu.dao.UserDao">
         <select id="getUserList" resultType="com.yu.pojo.User">
         select * from mybatis.user
       </select>
     </mapper>
     

6. 编写测试类

   package com.yu.dao;
   
   import com.yu.pojo.User;
   import com.yu.utils.MybatisUtils;
   import org.apache.ibatis.session.SqlSession;
   import org.junit.Test;
   
   import java.util.List;
   
   public class UserDaoTest {
   
       @Test
       public void test(){
           //获得sqlSession对象
           SqlSession sqlSession = MybatisUtils.getSqlSession();
           //方式一:getMapper
           UserDao userDao = sqlSession.getMapper(UserDao.class);
           List<User> userList = userDao.getUserList();
           for (User user : userList) {
               System.out.println(user);
           }
           //关闭sqlSession
           sqlSession.close();
       }
   }
   

注意

1. maven导出资源问题

   要看target目录下有没有UserMapper.xml文件

   如果没有需要配置pom.xml 作用是包含resources和java目录下的properties和xml文件

   <build>
       <resources>
           <resource>
               <directory>src/main/resources</directory>
               <includes>
                   <include>**/*.properties</include>
                   <include>**/*.xml</include>
               </includes>
           </resource>
           <resource>
               <directory>src/main/java</directory>
               <includes>
                   <include>**/*.properties</include>
                   <include>**/*.xml</include>
               </includes>
               <filtering>false</filtering>
           </resource>
       </resources>
   </build>