Mybatis 备忘

配置文件

<?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="cn.entity"/>
	</typeAliases>

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

	<mappers>
		<mapper resource="cn/dao/SampleMapper.xml"/>
	</mappers>
</configuration>

jdbc.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/sample
jdbc.username=root
password=pwd

SampleMapper.xml ※select要写resultType

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

SampleServiceImpl.java

String resource="";
SqlSession sqlSession=null;
//链接多个数据库时使用不用配置文件
public CertServiceImpl(String resource){
	this.resource=resource+"-config.xml";
}

public List<Sample> getPage(int index, int size) {
    List<Sample> result=null;
    try{
        InputStream is = Resources.getResourceAsStream(resource);
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
        sqlSession=factory.openSession();
        result=sqlSession.getMapper(SampleMapper.class).getPage(index, size);
    }catch(Exception e){
        e.printStackTrace();
    }finally{
        sqlSession.close();
    }
    return result;
}