MyBatis应用

MyBatis使用结构MyBatis独立使用Spring集成MyBatis

java目录下:com.taichi.dao.TestMapper.java接口

public interface TestMapper{
	Pojo selectPojoById(Integer id);
}

resources目录下:com.taichi.dao.TestMapper.xml配置文件

    
    	select * from pojo where id = #{id}
    

全局配置文件MyBatisConfig.xml

java目录下:com.taichi.dao.impl.TestMapperImpl.java实现类

public class TestMapperImpl implements TestMapper{
	private SqlSession sqlSession;

	@Override
	public Pojo selectPojoById(Integer id){
		Pojo pojo;
		sqlSession = this.open();
        pojo = sqlSession.selectOne("TestMapper.selectPojoById",id);
        this.close();
        return pojo;
	}
	//SqlSession开启方法
	private SqlSession open(){
        try {
            InputStream resourceAsStream = Resources.getResourceAsStream("MyBatisConfig.xml");
            SqlSessionFactory sqlSessionFactory= new SqlSessionFactoryBuilder().build(resourceAsStream);
            sqlSession = sqlSessionFactory.openSession(true);
            resourceAsStream.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return sqlSession;
    }
	//SqlSession关闭方法
    private void close(){
        if (sqlSession != null){
            sqlSession.close();
        }
    }
}

Spring配置文件applicationContext.xml