ibaties 增删改查分页

import java.util.Iterator; import java.util.List; import org.apache.ibatis.session.SqlSession; import org.qianye.entity.Clazz; import org.qianye.service.ClazzService; import org.qianye.service.impl.ClazzServiceImpl; import org.qianye.util.IBatisUtil; import org.qianye.util.Page; public class Main { private static ClazzService clazzService = new ClazzServiceImpl(); public static void main(String[] args) throws Exception { Clazz cla = new Clazz(); cla.setClaname("华中科技"); cla.setClaremark("华中科技大学"); //增 //clazzService.add(cla); //查 //Clazz cla1=clazzService.getClazzs(new Long(162)); //System.out.println(cla1.getClaname()); //删 //clazzService.delete(new Long(162)); //查询所有 // List<Clazz> list=clazzService.getClazzs(); // // for (Iterator iterator = list.iterator(); iterator.hasNext();) { // Clazz clazz = (Clazz) iterator.next(); // System.out.println(clazz.getClaname()); // } // //addClazz(); Page page = new Page(); page.setLimit(2); page.conditions.put("table", "clazz"); page.conditions.put("primarykey", "claid"); page.conditions.put("condition", ""); page.conditions.put("field", "claname"); page.conditions.put("ordertype", "desc"); page.conditions.put("curPage", page.getPageIndex()); page.conditions.put("pageLimt", page.getLimit()); page.conditions.put("totalRecords", 0); page.conditions.put("totalPages", 0); clazzService.getClazzs(page); System.out.println("当前页："+page.getPageIndex()); System.out.println("每页显示：："+page.getLimit()); System.out.println("总页数："+page.getPageCount()); System.out.println("总记录："+page.getRecordCount()); List list=page.getData(); for (Iterator iterator = list.iterator(); iterator.hasNext();) { Clazz c = (Clazz) iterator.next(); System.out.println(c.getClaname()); } } private static void testPage() throws Exception { SqlSession session = IBatisUtil.openSession(); // session.selectOne("ClazzMapper.proc_page", map); // System.out.println(map.get("totalRecords")); // System.out.println(map.get("totalPages")); // List<Clazz> list = (List<Clazz>) map.get("res"); // for (Iterator iterator = list.iterator(); iterator.hasNext();) { // Clazz clazz = (Clazz) iterator.next(); // System.out.println(clazz.getClaname()); // } } /** * 修改班级 * * @throws Exception */ private static void updateClazz() throws Exception { Clazz cla = getClazz(); cla.setClaname("千叶"); cla.setClaremark("heh"); SqlSession session = IBatisUtil.openSession(); int index = session.update("ClazzMapper.updateClazz", cla); System.out.println(index); session.commit(); session.close(); } /** * 删除班级 * * @throws Exception */ private static void deleteClazz() throws Exception { SqlSession session = IBatisUtil.openSession(); int index = session.delete("ClazzMapper.deleteClazz", 105); System.out.println(index); session.commit(); session.close(); } /** * 查询单个班级 * * @return * @throws Exception */ private static Clazz getClazz() throws Exception { SqlSession session = IBatisUtil.openSession(); Clazz cla = (Clazz) session.selectOne("ClazzMapper.selectWithID", 104); System.out.println(cla.getClaname()); session.close(); return cla; } /** * 添加班级 * * @throws Exception */ private static void addClazz() throws Exception { Clazz cla = new Clazz(); cla.setClaname("不好"); cla.setClaremark("java1"); SqlSession session = IBatisUtil.openSession(); int index = session.insert("ClazzMapper.insertClazz", cla); session.commit(); System.out.println(index); session.close(); } /** * 查询所有的班级信息 * * @throws Exception */ private static void queryClazz() throws Exception { SqlSession session = IBatisUtil.openSession(); List<Clazz> list = session.selectList("ClazzMapper.selectAll"); for (Iterator iterator = list.iterator(); iterator.hasNext();) { Clazz clazz = (Clazz) iterator.next(); System.out.print(clazz.getClaid()); System.out.print(clazz.getClaname()); System.out.println(clazz.getClaremark()); } session.close(); } }