在mapper.xml的添加
测试使用
<select id="selectBylimit" resultType="com.mybatis.Test">
SELECT testid,testcontent
FROM haodf_doctorInfo ORDER BY doctorinfoid LIMIT #{offset},#{limit} <!--这里修改了-->
</select>
在mapper.java中添加
List<Test> selectBylimit(@Param("offset") int offset, @Param("limit") int limit);
测试使用
SqlSession session = null;
try {
session = MybatisSessionFactory.sessionFactory().openSession(ExecutorType.BATCH,true);
HaodfDoctorinfoMapper mapper = session.getMapper(TestMapper.class) ;
List<Test> lsdoc= mapper.selectByPage(0, 100);
for(Test docinfo:lsdoc){
System.out.println(docinfo.getTestid()+":"+docinfo.getTestcontent()) ;
}
}catch(PersistenceException e){
}finally {
if(session!=null){
session.close() ;
}
}