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
	 */
	@Test
	public 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
	 */
	@Test
	public 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
	 */
	@Test
	public 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
	 */
	@Test
	public 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
	 */
	@Test
	public 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());
		}
	}

}