List<User> getUserLimit(Map<String,Integer> map);
<select id="getUserLimit" resultMap="UserMap" parameterType="map">
select * from mybatis.user limit #{beginInex},#{pageSize}
</select>
//测试方法
@Test
public void selectUserLimit(){
SqlSession session=Mybatis.getSqlSession();
Mapper mapper = session.getMapper(Mapper.class);
HashMap<String,Integer> hh=new HashMap<String, Integer>();//是我草率了,动动脑袋,行吗
hh.put(“beginInex”,2);
hh.put(“pageSize”,2);
List userLimit = mapper.getUserLimit(hh);
for (User user : userLimit) {
System.out.println(user);
}
session.close();
}
//补充工具类Mybatis
package com.cheng.utils;
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 java.io.IOException;
import java.io.InputStream;
//sqlSessionfactory
public class Mybatis {
private static SqlSessionFactory sqlSessionFactory = null;
static {
try {
String resource = "mybatis-config.xml";
//使用mybatis第一步,先获取
InputStream inputStream = Resources.getResourceAsStream(resource);//这个resource是mybatis中的
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);//注意作用域,出了大括号就没用了
} catch (IOException e) {
e.printStackTrace();
}
}
// 既然有了 SqlSessionFactory,顾名思义,我们可以从中获得 SqlSession 的实例。SqlSession
// 提供了在数据库执行 SQL 命令所需的所有方法。
// 你可以通过 SqlSession 实例来直接执行已映射的 SQL 语句
public static SqlSession getSqlSession() {
return sqlSessionFactory.openSession();
}
}