guestdaotest.java.svn-base

来自「一个使用ssh+ext的例子。 希望对开发这个应用的人带来好处。仔细研究里面的」· SVN-BASE 代码 · 共 126 行

package com.hotelmaster.test.dao;

import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.List;

import net.sf.json.JSONArray;

import com.hotelmaster.home.dao.GuestDao;
import com.hotelmaster.home.domain.Guest;
import com.hotelmaster.home.domain.Page;
import com.hotelmaster.test.core.BaseDaoTests;

public class GuestDaoTest extends BaseDaoTests{
	private GuestDao guestDao;
	private Long count;
	public void testQuery(){
		Guest guest =(Guest) guestDao.query("GT3232");
		assertNotNull("guset doesn't exist",guest);
	}
	public GuestDao getGuestDao() {
		return guestDao;
	}

	public void setGuestDao(GuestDao guestDao) {
		this.guestDao = guestDao;
	}
	
	public void testFindAllGuests(){
		Page page=new Page(0);
		List<Guest> guests = guestDao.findAll(page);
		assertNotNull("success for test findAllGuests function ",guests);
	}
	
	public void testGetTotalCount(){
		long count = guestDao.getGuestTotalCount();
		assertEquals("0",count);
	}
	
	public void testAddNewGuest(){
		Guest testGuest = new Guest();
		Timestamp gtCreateTime = new Timestamp(0);
		testGuest.setGtAddress("testAddress");
		testGuest.setGtCardCatalog("testCardCatalog");
		testGuest.setGtCardId("testCardId");
		testGuest.setGtCompany("testCompany");
		testGuest.setGtCountry("testCountry");
		testGuest.setGtEmail("testEmail");
		testGuest.setGtGender("testGender");
		testGuest.setGtMobile("testMobile");
		testGuest.setGtName("testName");
		testGuest.setGtTelphone("testTelphone");
		testGuest.setGtType("testType");
		testGuest.setGtZip("testZip");
		testGuest.setGtCreateTime(gtCreateTime);
		boolean success = guestDao.addNewGuest(testGuest);
	}
	
	public void testDelGuest(){
		Guest testGuest = new Guest();
		Timestamp gtCreateTime = new Timestamp(0);
		testGuest.setGtAddress("testAddress");
		testGuest.setGtCardCatalog("testCardCatalog");
		testGuest.setGtCardId("testCardId");
		testGuest.setGtCompany("testCompany");
		testGuest.setGtCountry("testCountry");
		testGuest.setGtEmail("testEmail");
		testGuest.setGtGender("testGender");
		testGuest.setGtMobile("testMobile");
		testGuest.setGtName("testName");
		testGuest.setGtTelphone("testTelphone");
		testGuest.setGtType("testType");
		testGuest.setGtZip("testZip");
		testGuest.setGtCreateTime(gtCreateTime);
		boolean success = guestDao.delGuest(testGuest);
	}
	
	public void testFindGuest(){
		Guest testGuest = new Guest();
		String gtId = "402881e51a0a13e3011a0a14bf7b0001";
		testGuest = guestDao.findGuestByGtId(gtId);
	}
	
	public void testUpdateGuest(){
		Guest testGuest = new Guest();
		Timestamp gtCreateTime = new Timestamp(0);
		testGuest.setGtAddress("testId");
		testGuest.setGtAddress("testAddress");
		testGuest.setGtCardCatalog("testCardCatalog");
		testGuest.setGtCardId("testCardId");
		testGuest.setGtCompany("testCompany");
		testGuest.setGtCountry("testCountry");
		testGuest.setGtEmail("testEmail");
		testGuest.setGtGender("testGender");
		testGuest.setGtMobile("testMobile");
		testGuest.setGtName("testName");
		testGuest.setGtTelphone("testTelphone");
		testGuest.setGtType("testType");
		testGuest.setGtZip("testZip");
		testGuest.setGtCreateTime(gtCreateTime);
		guestDao.delGuest(testGuest);
		guestDao.addNewGuest(testGuest);
	}
	
	public void testQueryGuestInfo(){
		String value = "esperamier";
		JSONArray fields = new JSONArray();
		fields.add("gtId");
		guestDao.queryGuestInfo(value, fields);
	}
	
	public void testCalculateGuestsByMonth() throws ParseException{
		String start = "2008-5-1 00:00:00.000";
		//String end = "2008-6-1 00:00:00.000";
		String end = String.format("%s-%s-1 00:00:00.000","2008","6");
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss.SSS");
		java.util.Date date = sdf.parse(start);
		java.sql.Timestamp starttime = new java.sql.Timestamp(date.getTime());
		date = sdf.parse(end);
		java.sql.Timestamp endtime = new java.sql.Timestamp(date.getTime());
		count = guestDao.calculateGuestsByMonth(starttime, endtime);
		assertEquals("2",String.valueOf(count));
	}
}