Mybatis 笔记-02

2. 第一个MyBatis 程序

​ 思路： 搭建环境 --> 导入MyBatis --> 编写代码 --> 测试。

2.1 搭建环境

​ 搭建数据库：

CREATE DATABASE mybatis;

USE mybatis;

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;mybatisuser

INSERT INTO USER(id, NAME, pwd) VALUES 
(1, '张三', '123456'),
(2, '李四', '123456'),
(3, '王五', '123456');

SELECT * FROM USER;

新建项目：

1. 创建一个普通的maven项目（注意配置Maven）
   
   

2. 删除 src 目录

3. 导入依赖

   <!-- 导入依赖 -->
       <dependencies>
           <!-- mysql 驱动 -->
           <dependency>
               <groupId>mysql</groupId>
               <artifactId>mysql-connector-java</artifactId>
               <version>5.1.47</version>
           </dependency>
           <!-- mybatis -->
           <dependency>
               <groupId>org.mybatis</groupId>
               <artifactId>mybatis</artifactId>
               <version>3.5.2</version>
           </dependency>
           <!-- junit -->
           <dependency>
               <groupId>junit</groupId>
               <artifactId>junit</artifactId>
               <version>4.12</version>
           </dependency>
       </dependencies>
   

2.2 创建一个模块

• 添加 mytais-config.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>
      <environments default="development">
          <environment id="development">
              <transactionManager type="JDBC"/>
              <dataSource type="POOLED">
                  <property name="driver" value="com.mysql.jdbc.Driver"/>
                  <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
                  <property name="username" value="root"/>
                  <property name="password" value="123456"/>
              </dataSource>
          </environment>
      </environments>
      <mappers>
  
      </mappers>
  </configuration>
  

• 编写mybatis工具类

  public class MybatisUtils {
      private static SqlSessionFactory sqlSessionFactory = null;
      static {
  
          // 获取SqlSessionFactory 对象
          try {
              String resource = "mybatis-config.xml";
              InputStream inputStream = Resources.getResourceAsStream(resource);
              sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
          } catch (IOException e) {
              e.printStackTrace();
          }
      }
  
      //有了 SqlSessionFactory，顾名思义，我们可以从中获得 SqlSession 的实例。
      // SqlSession 提供了在数据库执行 SQL 命令所需的所有方法。
      public static SqlSession getSqlSession() {
          return sqlSessionFactory.openSession();
      }
  }
  

2.3 编写代码

• 实体类

  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 + '\'' +
                  '}';
      }
  }
  

• 接口

  public interface UserDao {
      /**
       * 获取用户信息
       * @return
       */
      List<User> getUserList();
  
  }
  

• 接口实现类由原来的UserDaoImpl 装变成一个Mapper 配置文件。

  <?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.javacto.dao.UserDao">
      <!-- select 查询语句，  id 相当于重写方法 id=具体方法名  resultType：返回类型-->
      <select id="getUserList" resultType="com.javacto.pojo.User">
      select * from mybatis.user;
    </select>
  </mapper>
  

2.4 测试

• 编写测试类

  public class UserDaoTest {
  
      @Test
      public void  test() {
          //第一步 ， 获取 SqlSession对象
          SqlSession sqlSession = MybatisUtils.getSqlSession();
          //第二步，第一种方式：getMapper(); 执行SQL语句
          UserDao userDao = sqlSession.getMapper(UserDao.class);
          List<User> userList = userDao.getUserList();
          
          //遍历
          for (User user : userList) {
              System.out.println(user);
          }
  
          //释放资源
          sqlSession.close();
  
      }
  }
  

org.apache.ibatis.binding.BindingException: Type interface com.javacto.dao.UserDao is not known to the MapperRegistry.

• 原因是没有在核心配置文件pom.xml中注册Mapper.xml

  <!-- 注册 Mapper.xml  -->
      <mappers>
          <mapper resource="com/javacto/dao/UserMapper.xml"></mapper>
      </mappers>
  

  Error building SqlSession.
  The error may exist in com.javacto.dao.UserMapper.xml

<!-- 在 build 中配置resource， 来防止我们资源导出失败的问题。-->
    <build>
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

Cause: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceExcep

原因是 ;idea 编码用的不是utf-8 ,但我们的声明式utf-8 导致出现遍码错误。

解决方法：

1. 在pom文件中加入下面代码

   <properties>
           <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
       </properties>
   

2. 修改idea 编码格式为utf-8

   [外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-GmkgusDE-1629878136029)(C:\Users\LiFangQing\Desktop\笔记\MyBatis\MyBatis01.assets\1.png)]