Mybatis工程的基本配置，工具类MyBatisUtils，配置文件mybatis.xml，Maven依赖pom.xml

工具类MyBatisUtils

只获取一次sqlSessionFactory，并且用它获取sqlSession，不然每个sql方法的开头都要用这段代码

//myBatis获取sqlSession的工具类
public class MyBatisUtils {

    private static SqlSessionFactory factory = null;

    //SqlSessionFactory只需要获取一次
    static {
        try {
            //mybatis.xml需要和项目中的文件名一致
            InputStream is = Resources.getResourceAsStream("mybatis.xml");
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            factory = builder.build(is);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    //获取sqlSession的方法
    public static SqlSession getSqlSession(){

        SqlSession sqlSession = null;
        if (factory != null){
            sqlSession = factory.openSession();//手动提交事务
            //sqlSession = factory.openSession(true);自动提交事务
        }
        return sqlSession;
    }
}

配置文件mybatis.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>
    <typeAliases>
        <package name="com.bj.domain"/>
    </typeAliases>

    <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/bjpowernode"/>
                <property name="username" value="root"/>
                <property name="password" value="3333"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <package name="com.bj.dao"/>
    </mappers>
</configuration>

引入依赖pom.xml

 <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.3</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.40</version>
    </dependency>
  </dependencies>

  <build>
    <resources>
      <resource>
        <directory>src/main/java</directory>
        <includes>
          <include>**/*.properties</include>
          <include>**/*.xml</include>
        </includes>
        <filtering>false</filtering>
      </resource>
    </resources>
    
  </build>