MyBatis-Demo

说明

• 书接上回MyBatis-MyEclipse+MyBatis-Generator插件;

配置pom.xml

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.3.0</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.38</version>
</dependency>

配置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>
<!-- 定义别名 -->
<typeAliases>
    <typeAlias type="com.yan.po.Role" alias="role"/>
</typeAliases>
<!-- 定义数据库信息，默认使用development数据库构建环境 -->
<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/mysql"/>
<property name="username" value="root"/>
<property name="password" value="mysql"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/yan/mapper/RoleMapper.xml"/>
</mappers>
</configuration>

获取SqlSessionFactory

• SqlSessionFactory是单例的，因此编写类SqlSessionFactoryUtil来控制

public class SqlSessionFactoryUtil {
    private static SqlSessionFactory sqlSessionFactory=null;
    private static final Class<SqlSessionFactoryUtil> CLASS_LOCK=SqlSessionFactoryUtil.class;
    /**
     * 私有化构造参数
     */
    private SqlSessionFactoryUtil(){};

    public static SqlSessionFactory initSqlSessionFactory(){
        String resource="mybatis-config.xml";
        InputStream is=null;
        try{
            is=Resources.getResourceAsStream(resource);
        }catch(Exception e){
            Logger.getLogger(SqlSessionFactoryUtil.class.getName()).log(Level.SEVERE, null,e);
        }
        synchronized (CLASS_LOCK) {
            if(sqlSessionFactory==null){
                sqlSessionFactory=new SqlSessionFactoryBuilder().build(is);
            }
        }
        return sqlSessionFactory;
    }
    public static SqlSession openSqlSession() {
        if(sqlSessionFactory==null){
            initSqlSessionFactory();
        }
        return sqlSessionFactory.openSession();
    }
}

重写POJO的toString方法

• 为了更好地显示取出的POJO信息

@Override
    public String toString() {
        return "Role [id=" + id + ", roleName=" + roleName + ", note=" + note + "]";
    }

测试

public class MybatisTest {
public static void main(String[] args) {
    SqlSession sqlSession=null;
    try{
        sqlSession = SqlSessionFactoryUtil.openSqlSession();
        RoleMapper roleMapper=sqlSession.getMapper(RoleMapper.class);
//      Role role =new Role();
//      role.setId(1);
//      role.setRoleName("超级管理员");
//      role.setNote("admin");
//      roleMapper.insert(role);
//      sqlSession.commit();
        Role r =new Role();
        r=roleMapper.selectByPrimaryKey(1);
        System.out.println(r);
    }catch(Exception e){
        System.out.println(e.getMessage());
        sqlSession.rollback();
    }finally{
        if(sqlSession!=null){
            sqlSession.close();
        }
    }
}
}

代码结构