Mybatis05-idea设置Mybatis配置文件的模板

1、在IDEA中设置Mybatis核心配置文件的模板

1.1、进入IDEA的设置（进入设置将下面的代码复制一下）

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

   <typeAliases>
       <package name=""/>
   </typeAliases>

   <environments default="development">
       <environment id="development">
           <transactionManager type="JDBC"/>
           <dataSource type="POOLED">
               <property name="driver" value="${jdbc.driver}"/>
               <property name="url" value="${jdbc.url}"/>
               <property name="username" value="${jdbc.username}"/>
               <property name="password" value="${jdbc.password}"/>
           </dataSource>
       </environment>
   </environments>
   
   <mappers>
       <package name=""/>
   </mappers>
</configuration>

1.2、打开Editor -> File and Code Templates

1.3、将模板的文件名、后缀和内容填写好，内容为：第一步的代码

1.4、点击APPLY，新建文件测试效果

2、在IDEA中设置Mybatis映射文件的模板

2.1、进入IDEA的设置（进入设置将下面的代码复制一下）

<?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="">
   
</mapper>

2.2、打开Editor -> File and Code Templates

2.3、将模板的文件名、后缀和内容填写好，内容为：第一步的代码

2.4、点击APPLY，新建文件测试效果

3、封装SqlSessionUtil工具类并测试功能

3.1、工具类代码

/**
 * SqlSessionUtils：获取SQLSession
 */
public class SqlSessionUtils {

   public static SqlSession getSqlSession() {
       SqlSession sqlSession = null;
       try {
           InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
           SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
           sqlSession = sessionFactory.openSession(true);
       } catch (IOException e) {
           e.printStackTrace();
       }
       return sqlSession;
   }
}

3.2、实体类

public class User {

   private Integer id;

   private String name;

   private String password;

   private Integer age;

   private String sex;

   public User() {

   }

   public User(Integer id, String name, String password, Integer age, String sex) {
       this.id = id;
       this.name = name;
       this.password = password;
       this.age = age;
       this.sex = sex;
   }

   public Integer getId() {
       return id;
   }

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

   public String getName() {
       return name;
   }

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

   public String getPassword() {
       return password;
   }

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

   public Integer getAge() {
       return age;
   }

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

   public String getSex() {
       return sex;
   }

   public void setSex(String sex) {
       this.sex = sex;
   }

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

3.3、接口及其对应的映射文件

• 接口

public interface UserMapper {

   /**
    * 查询所有的用户信息
    */
   List<User> getAllUser();
}

• 映射文件

<mapper namespace="com.sweet.mybatis.mapper.UserMapper">

   <!-- List<User> getAllUser(); -->
   <select id="getAllUser" resultType="User">
       select * from user
   </select>
</mapper>

3.4、测试类的代码以及测试结果

public class UserMapperTest {

   @Test
   public void test() {
       SqlSession sqlSession = SqlSessionUtils.getSqlSession();
       UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
       List<User> list = userMapper.getAllUser();
       list.forEach(System.out :: println);
   }  
}

测试结果