mybatis-config配置文件
<?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="db.properties"/>
<typeAliases>
<package name="com.star.pojo"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<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>
<!--引入mapper配置文件-->
<package name="com.star.mapper"/>
</mappers>
</configuration>
mapper.xml
<?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接口地址"> <select id="接口名称" resultType="结果类型"> select *from users </select> <!--分页查询--> <select id="selectByLimit" resultType="users"> select *from users limit #{offset},#{limit} </select> <!--一对一关联查询--> <resultMap id="userMap" type="com.star.pojo.Users"> <id property="userid" column="id"/> <result property="username" column="name"/> <result property="userage" column="userage"/> <collection property="" javaType=""> <result property="" column=""/> </collection> </resultMap> <select id="selectUsersAll" resultMap="userMap"> select u.userid as id ,u.username as name ,u.userage as age from users u </select> </mapper>