2、第一个MyBatis程序

最新推荐文章于 2024-10-18 13:02:57 发布

很皮的皮蛋瘦肉粥

最新推荐文章于 2024-10-18 13:02:57 发布

阅读量124

点赞数 1

分类专栏： MyBatis 文章标签： mybatis java

原文链接：https://www.bilibili.com/video/BV1NE411Q7Nx?p=2

版权

MyBatis 专栏收录该内容

13 篇文章 1 订阅

订阅专栏

文章目录

2.1、搭建环境
2.2、创建模块
2.3、编写代码
2.4、测试

思路：搭建环境–>导入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;

INSERT INTO `user`(`id`,`name`,`pwd`) VALUES
(1,'张三','123456'),
(2,'李四','123789'),
(3,'王五','456789')

新建项目

新建一个普通的Maven项目
删除src目录
导入maven依赖

    <!-- 导入依赖 -->
   <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、创建模块

编写mybatis的核心配置文件

<?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核心配置文件 -->
<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="root"/>
           </dataSource>
       </environment>
   </environments>
   
</configuration>

编写mybatis的工具类

package com.chen.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 --> sqlSession
public class MybatisUtils {

   private static SqlSessionFactory sqlSessionFactory;

   static {
       try {
           //使用Mybatis第一步：获取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 命令所需的所有方法。

   public static SqlSession getSqlSession(){
       return sqlSessionFactory.openSession();
   }
}

2.3、编写代码

实体类

package com.chen.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.chen.dao;

import com.chen.pojo.User;

import java.util.List;

public interface UserDao {
    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.chen.dao.UserDao">
  <!-- resultType：sql语句的返回值类型，返回的类型要用全限定类名 -->
  <!-- select查询语句 id对应接口中的方法名 -->
  <select id="getUserList" resultType="com.chen.pojo.User">
      select * from user;
</select>
</mapper>

核心配置文件中注册mappers

    <mappers>
       <mapper resource="com/chen/dao/UserMapper.xml"/>
   </mappers>

2.4、测试

junit测试

package com.chen.dao;

import com.chen.pojo.User;
import com.chen.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
       UserMapper mapper = sqlSession.getMapper(UserMapper.class);
       List<User> userList = mapper.getUserList();

   	   //方式二(了解即可，不推荐使用)
       //List<User> userList = sqlSession.selectList("com.chen.dao.UserMapper.getUserList");

       for (User user : userList) {
           System.out.println(user);
       }

       //关闭SqlSession
       sqlSession.close();
   }

}

可能遇到的问题：

配置文件没有注册
绑定接口不对
方法名不对
返回类型不对
Maven到处资源问题

注意：
可能遇到的异常一：
org.apache.ibatis.binding.BindingException: Type interface com.chen.dao.UserMapper is not known to the MapperRegistry.
解决方法：在pom文件中加入(问题5的解决办法)

    <!-- 在build中配置resources，来防止我们资源导出失败的问题 -->
    <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: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: 1 字节的 UTF-8 序列的字节 1 无效。
解决方法：将xml文件头部的