mybatis准备环境

mybatis快速入門

1.导入jar包

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.5.5</version>
</dependency>

2.导入mysql驱动

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

3.构建mybatis-config.xml文件

<mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>

resource是你的sql映射文件的名字，注意是否是同一级别如果不是需要加路径

<?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="${driver}"/>
        <property name="url" value="${url}"/>
        <property name="username" value="${username}"/>
        <property name="password" value="${password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
      <!--加载sql映射文件 -->
    <mapper resource="UserMapper.xml"/>
  </mappers>
</configuration>

4.创建sql映射文件UserMapper.xml User建议是表名

<mapper namespace="test">
<select id="selectAll" resultType="com.wc.pojo.User">
    select * from tb_user
  </select>

usermapper.xml文件

namespace是你选择调用的哪一个sql

resultType是你的实体类

id是你查询这个数据的名字

<?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="test">
  <select id="selectAll" resultType="com.wc.pojo.User">
    select * from tb_user where id = #{id}
  </select>
</mapper>

5.测试

   //获取sqlSessionFactory对象
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //获取sqlSession执行sql语句对象
        SqlSession ss = sqlSessionFactory.openSession();
        //UserMapper.xml中的<mapper namespace="test">和他的唯一id
        List<User> lis = ss.selectList("test.selectAll");
        lis.forEach(System.out::println);

通过resultMap映射实现sql起别名

<mapper namespace="test">
    <resultMap id="userResultMap" type="com.wc.pojo.User">
        //此处的id和resultMap对应，type是你的类
        //id是主键的映射
       <id column="id" property="userId"/>
		//result是非主键的映射
        <result column="name" property="userName"/>
    </resultMap>
    <select id="selectAll" resultMap="userResultMap">
        select * from tb_user;
    </select>
</mapper>