【mybatis】 mybatis源码搭建demo

王佑辉

已于 2023-04-14 16:27:47 修改

阅读量125

点赞数

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

于 2023-04-13 22:40:54 首次发布

本文链接：https://blog.csdn.net/qq_32088869/article/details/130141812

版权

mybatis 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

文章展示了Mybatis的配置过程，包括jdbc.properties、mybatis-config.xml和CarMapper的相关代码。还提供了数据库表创建语句及一个简单的Java测试主程序。在错误说明中提到了解决mysql驱动找不到的问题。

摘要由CSDN通过智能技术生成

<?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>

  <properties resource="jdbc.properties"/>

  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"></transactionManager>
      <dataSource type="POOLED">
        <property name="driver" value="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="org/apache/ibatis/learning/mapper/CarMapper.xml"></mapper>
  </mappers>
</configuration>

3.CarMapping.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">
<mapper namespace="org.apache.ibatis.learning.mapper.CarMapper">
    <select id="selectCar" resultType="org.apache.ibatis.learning.mapper.Car">
        select * from car where id = #{id}
    </select>
</mapper>

4.CarMapper.java

package org.apache.ibatis.learning.mapper;
public interface CarMapper {
  	Car selectOne(int id);
}

5.Car.java

package org.apache.ibatis.learning.mapper;

import lombok.Data;

/**
 * @Author wangyouhui
 * @Description 实例类
 **/
@Data
public class Car {
  private String id;
  private String name;
}

6.创建表语句

CREATE TABLE `car` (
  `id` varchar(100) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

7.MybatisMain.java

package org.apache.ibatis.learning;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.learning.mapper.Car;
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;

/**
 * @Author wangyouhui
 * @Description 测试方法
 **/
public class MybatisMain {
  public static void main(String[] args) throws IOException {
    String resource = "mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    SqlSession sqlSession = sqlSessionFactory.openSession();
    Car car = (Car)sqlSession.selectOne("org.apache.ibatis.learning.mapper.CarMapper.selectCar", 1);
    System.out.println(car.getName());
  }
}

三、错误说明

1.如果报mysql的驱动类Driver找不到，可以把pom.xml中的mysql-connector-java的scope注释掉

<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.29</version>
<!--      <scope>test</scope>-->
    </dependency>