userMapper.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="com.kuang.dao.userMapper"> <resultMap id="userMap" type="user"> <result column="id" property="id"/> <result column="name" property="username"/> <result column="sex" property="sex"/> </resultMap> <select id="selectById" resultType="user" resultMap="userMap"> select * from mybatis.user where id =#{id} </select> <!-- 分页 --> <select id="select" parameterType="map" resultType="user" resultMap="userMap"> select *from mybatis.user limit #{startIndex},#{pageSize} </select> </mapper>
userMapper
package com.kuang.dao; import com.kuang.pojo.User; import java.util.List; import java.util.Map; public interface userMapper { User selectById(int id); //分页 List<User> select(Map<String,Object> map); }
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> <properties resource="db.properties"/> <settings> <setting name="logImpl" value="LOG4J"/> </settings> <typeAliases> <package name="com.kuang.pojo"/> </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="${username}"/> <property name="password" value="${password}"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/kuang/dao/userMapper.xml"/> <!-- <mapper class="com.kuang.dao.userMapper"/>--> </mappers> </configuration>
userDaoTest
@Test public void testSelect(){ SqlSession sqlSession = MybatisUtils.getSqlSession(); userMapper mapper = sqlSession.getMapper(userMapper.class); Map<String, Object> map = new HashMap<>(); map.put("startIndex",1); map.put("pageSize",2); List<User> select = mapper.select(map); for (User user : select) { System.out.println(user); } }