mybatis 基础第一天

1:第一个mybatis程序

 https://mybatis.net.cn/configuration.html#settings  官方文档

1.1:创建一个空的的maven项目

1.2:引入基础的jar包坐标

        mybatis 的ja坐标
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.15</version>
        </dependency>
        数据库连接的坐标
        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <version>8.2.0</version>
        </dependency>
        junit 测试工具的坐标
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
            <scope>test</scope>
        </dependency>
        

1.3:添加核心配置文件和对象映射文件

核心配置文件 这个配置文件需要放在类路径下
<?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">
<!--核心文件，主要配置mybatis的核心内容，配置数据库的环境和加载映射（映射文件中需要使用到的别名也在此定义）-->
<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://ip:3306/dbName?useSSL=false&amp;allowMultiQueries=true&amp;characterEncoding=UTF-8&amp;serverTimeZone=Asia/Shanghai"/>
                <property name="username" value="user"/>
                <property name="password" value="passwd"/>
            </dataSource>
        </environment>
    </environments>
    <!--加载映射文件-->
    <mappers>
        <mapper resource="mapper/userMapper.xml"/>
    </mappers>
</configuration>

映射配置文件
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="user">
    <select id="queryUserById" parameterType="java.lang.String" resultType="org.wl.pojo.User">
        select * from t_user where id = #{id}
    </select>
</mapper>

1.4:编写数据库连接工具类 测试映射对象 User/dao/dao实现

package org.wl.util;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class SqlSessionUtil {
    private SqlSessionUtil() {
    }
    private static SqlSessionFactory sqlSessionFactory;
    /**
     * 类加载时初始化sqlSessionFactory对象
     * 一个SqlSessionFactory对象对应一个environment，一个environment对应一个数据库
     */
    static {
        try {
            SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
            sqlSessionFactory = sqlSessionFactoryBuilder.build(Resources.getResourceAsStream("sqlMapConfig.xml"));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    /**
     * 每调用一次getSqlSession()可获取一个新的会话，需要手动提交
     * @return 新的会话对象
     */
    public static SqlSession getSqlSession() {
        return sqlSessionFactory.openSession();
    }
}


package org.wl.pojo;

public class User {
  private String id;
  private String name;
  private Integer age;

  public User() {
  }

  public String getId() {
    return id;
  }

  public void setId(String id) {
    this.id = id;
  }

  public String getName() {
    return name;
  }

  public void setName(String name) {
    this.name = name;
  }

  public Integer getAge() {
    return age;
  }

  public void setAge(Integer age) {
    this.age = age;
  }

  @Override
  public String toString() {
    return "User{" +
      "id='" + id + '\'' +
      ", name='" + name + '\'' +
      ", age=" + age +
      '}';
  }
}

package org.wl.service;
import org.wl.pojo.User;
public interface UserDao {
    User queryUserById(String id);
}


package org.wl.impl;
import org.apache.ibatis.session.SqlSession;
import org.wl.pojo.User;
import org.wl.service.UserDao;
import org.wl.util.SqlSessionUtil;

public class UserDaoImpl implements UserDao {
    @Override
    public User queryUserById(String id) {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        User user = sqlSession.selectOne("user.queryUserById",id);
        sqlSession.close();
        return user;
    }
}

1.5 编写测试类

public class UserTest {
    @Test
    public void testQueryUserById(){
        UserDao userDao = new UserDaoImpl();
        User user = userDao.queryUserById("e9d97a78-9c1e-4520-bdc1-efc8b8903ccb");
        System.out.println("result is: "+user);
    }
}