package library.test;

import java.util.List;

import junit.framework.TestCase;
import library.hibernate.UserTable;

/**
 * 測(cè)試數(shù)據(jù)庫操作的用例
 * 
 * @author lianhw
 *
 */
public class TestDBSaveOrUpdate extends TestCase {

	/**
	 * 測(cè)試數(shù)據(jù)庫的插入、查詢、刪除和更新操作
	 */
	public void testDBOperation() {
		//創(chuàng)建DBOperation對(duì)象
		DBOperation db = new DBOperation();
		//創(chuàng)建UserTable對(duì)象
		UserTable userTable = new UserTable();
		//設(shè)置UserName屬性
		userTable.setUserName("王燕");
		//設(shè)置password屬性
		userTable.setPassword("123456");
		//設(shè)置Power屬性
		userTable.setPower("圖書管理員");
		//執(zhí)行插入或更新操作
		db.saveOrUpdate(userTable);
		//查詢語句
		String hql = "from UserTable where UserName='王燕' and Password='123456'";
		//執(zhí)行查詢語句
		List result = db.select(hql);
		//判斷返回的結(jié)果不為null
		assertNotNull(result);
		//判斷返回的結(jié)果包含剛插入的對(duì)象
		assertEquals("王燕", ((UserTable) result.get(0)).getUserName());
		//刪除特定的對(duì)象
		db.delete(userTable);
		//查詢已經(jīng)刪除的對(duì)象
		result = db.select(hql);
		//判斷返回結(jié)果的鏈表是否為空
		assertEquals(result.size(), 0);
	}
}