Mybatis+mysql动态分页查询数据案例——测试类HouseDaoMybatisImplTest)

package cn.bdqn.mhouse.dao.impl;import static org.junit.Assert.*;import java.util.Date;import java.util.List;import org.junit.Test;import cn.bdqn.mhouse.dao.IHouseDao;import cn.bdqn.mhouse.entity.District;import cn.bdqn.mhouse.entity.House;import cn.bdqn.mhouse.entity.HouseCondition;import cn.bdqn.mhouse.entity.Street;import cn.bdqn.mhouse.entity.Types;import cn.bdqn.mhouse.entity.Users;import cn.bdqn.mhouse.util.Page;/** * *    * 项目名称：mhouse   * 类名称：HouseDaoMybatisImplTest   * 类描述：   测试房屋信息的测试类* 创建人：Mu Xiongxiong  * 创建时间：2017-3-15 下午8:20:44   * 修改人：Mu Xiongxiong   * 修改时间：2017-3-15 下午8:20:44   * 修改备注：   * @version    * */public class HouseDaoMybatisImplTest {IHouseDao houseDao=new HouseDaoMybatisImpl();HouseCondition houseC=new HouseCondition();District district=new District();House house=new House();Users users=new Users();Types types=new Types();Street street=new Street();/** * * @Title: testInsert* @Description: 该方法的主要作用：* @param   设定文件  * @return  返回类型：void   * @throws */@Testpublic void testInsert() {users.setId(1000);types.setId(1000);street.setId(1000);house.setUsers(users);house.setStreet(street);house.setTypes(types);house.setContact("穆雄雄");house.setDescription("描述");house.setFloorage(50);house.setPrice(2500F);house.setPubdate(new Date());house.setTitle("标题");int rel=houseDao.insert(house);if(rel>0){System.out.println("添加成功！");}else {System.out.println("添加失败！");}}/** * * @Title: reCount* @Description: 该方法的主要作用：动态查询总记录数* @param   设定文件  * @return  返回类型：void   * @throws */@Testpublic void reCount(){houseC.setPriceBegin(50);houseC.setPriceEnd(4000);houseC.setFloorageBegin(10);houseC.setFloorageEnd(6000);types.setId(1000);houseC.setTypes(types);street.setId(1000);houseC.setStreet(street);int count=houseDao.reCount(houseC);System.out.println("总记录数："+count);}/** * * @Title: reCount* @Description: 该方法的主要作用：分页查询房屋信息* @param   设定文件  * @return  返回类型：void   * @throws */@Testpublic void getHouseInfoByDymanic(){Page page=new Page();//houseC.setPriceBegin(50);                      //起始价格//houseC.setPriceEnd(4000);                      //结束价格//houseC.setFloorageBegin(10);                   //起始面积//houseC.setFloorageEnd(6000);                   //最终面积types.setId(1003);                             //房屋类型houseC.setTypes(types);street.setId(1003);   //所在的街道////street.setDistrict(district);houseC.setStreet(street);int pageIndex=3;page=houseDao.getHouseInfoByDymanic(houseC, pageIndex);System.out.println("当前页是："+page.getPageIndex());System.out.println("下一页是："+page.getNextPage());System.out.println("上一页是："+page.getPrePage());System.out.println("总记录数："+page.getRecord());System.out.println("总页数是："+page.getTotalPageCount());System.out.println("页大小是："+page.getPageSize());List<House> houselist=page.getHouseList();for (House house : houselist) {System.out.println("房屋标题："+house.getTitle());}}/** * * @Title: testGetHouseInfo* @Description: 查询所有的房屋 * @param     设定文件* @return void    返回类型* @throws */@Testpublic void testGetHouseInfo(){Page page=houseDao.getHouseInfo();List<House> housel=page.getHouseList();for (House house : housel) {System.out.println(house.getTitle());}}/** * * @Title: testGetAllHousePage* @Description: 该方法的主要作用：测试分页查询房屋信息* @param   设定文件  * @return  返回类型：void   * @throws */@Testpublic void testGetAllHousePage(){Page page=houseDao.getHousePage(1);       //当前第一页System.out.println("=====================test===================");System.out.println("当前页是："+page.getPageIndex());System.out.println("下一页是："+page.getNextPage());System.out.println("上一页是："+page.getPrePage());System.out.println("总记录数："+page.getRecord());System.out.println("总页数是："+page.getTotalPageCount());System.out.println("页大小是："+page.getPageSize());List<House> housel=page.getHouseList();for (House house : housel) {System.out.println(house.getTitle());}}}