javaweb mybatis搭建步骤

1. 搭建一个maven web项目

2. 配置pom.xml 加载依赖

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <groupId>org.example</groupId>

  <artifactId>mybatis-01</artifactId>

  <version>1.0-SNAPSHOT</version>

  <packaging>war</packaging>

  <dependencies>

    <!--mysql 驱动-->

    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

    <dependency>

      <groupId>mysql</groupId>

      <artifactId>mysql-connector-java</artifactId>

      <version>5.1.47</version>

    </dependency>

    <!-- 导入mybatis 包 -->

    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->

    <dependency>

      <groupId>org.mybatis</groupId>

      <artifactId>mybatis</artifactId>

      <version>3.5.4</version>

    </dependency>

    <!--Junit -->

    <dependency>

      <groupId>junit</groupId>

      <artifactId>junit</artifactId>

      <version>4.13</version>

    </dependency>

  </dependencies>

</project>

3. 在资源目录下（resources）创建 mybatis-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/smb?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>
  
</configuration>

4. 创建一个工具类MybatisUtils.java， 加载mybatis-config.xml配置文件，构建SqlSessionFactory对象,创建sqlsession实例

package top.soeasy.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;

public class MybatisUtils {
  private static SqlSessionFactory sqlSessionFactory;
  static {
    try {
      String resource = "mybatis-config.xml";
      InputStream inputStream = Resources.getResourceAsStream(resource);
      sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    } catch (IOException e) {
      e.printStackTrace();
    }
  }
  // 返回sqlsession 实例
  public static SqlSession getSqlSession(){
    return sqlSessionFactory.openSession();
  }

}

5. 编写数据库实体类 pojo目录下对应数据库表

package top.soeasy.pojo;

public class User {
  private int id;
  private String username;
  private String password;

  public User() {
  }

  public User(int id, String username, String password) {
    this.id = id;
    this.username = username;
    this.password = password;
  }

  public int getId() {
    return id;
  }

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

  public String getUsername() {
    return username;
  }

  public void setUsername(String username) {
    this.username = username;
  }

  public String getPassword() {
    return password;
  }

  public void setPassword(String password) {
    this.password = password;
  }
}

6. 编写dao(mapper)层类实体类

package top.soeasy.dao;

import top.soeasy.pojo.User;

import java.util.List;

public interface UserDao {
  public List<User> getUserList();
}

7.在任意目录下创建UserMapper.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">
<!--绑定dao/mapper接口-->
<mapper namespace="top.soeasy.dao.UserDao">
<!--id 对应接口中的方法名 resultType 写返回对象的泛型类型-->
  <select id="getUserList" resultType="top.soeasy.pojo.User" >
    select * from smb.user
  </select>
</mapper>

8.修改mybatis-config.xml配置文件,绑定UserMapper.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/smb?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF-8"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="top/soeasy/dao/UserMapper.xml" />
  </mappers>
</configuration>

9.测试,编写测试类，代码如下：

package top.soeasy.mapper;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import top.soeasy.pojo.User;
import top.soeasy.utils.MyUtils;

import java.util.List;

public class UserMapperTest {
    @Test
    public void test()
    {
        SqlSession sqlSession = MyUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = mapper.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }
}

maven扫描资源文件问题：在pom.xml中配置如下代码

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

10.最终目录结构如下