<?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> -->
<configuration>
<!--将database.properties文件加载至该主配置文件进行统一管理-->
<properties resource="database.properties"></properties>
<!--设置项目的运行环境-->
<!--注意:default标签上填写的内容必须要和id属性的内容一致-->
<environments default="development">
<environment id="development">
<!--配置操作数据库的事务管理器-->
<transactionManager type="JDBC"></transactionManager>
<!--配置数据库连接池-->
<dataSource type="POOLED">
<property name="driver" value="${driver}"></property>
<property name="url" value="${url}"></property>
<property name="username" value="${user}"></property>
<property name="password" value="${password}"></property>
</dataSource>
</environment>
</environments>
</configuration>
<!--将映射文件导入到此文件中-->
<mappers>
<mapper resource="com/student/dao/Mapper.xml"></mapper>
<!--<mapper resource="com.student.dao.IStudentTest"></mapper>-->
<!--文件注册-->
</mappers>
<?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="com.student.dao.Mapper">
<select id="getStudentNumber" resultType="int">
select count(*) from student
</select>
</mapper>
package com.student.test;
import com.student.entity.Student;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;
评论0