querydaotest.java

利用STRUTS2+SPRING+HIBERNATE/IBATIS建立的基本开发框架

/**
 * 
 */
package test.com.sunwah.baseapp.dao;

import java.util.List;

import com.sunwah.baseapp.common.SqlConstants;
import com.sunwah.baseapp.dao.QueryDao;
import com.sunwah.baseapp.system.criteria.FunctionQueryCriteria;
import com.sunwah.baseapp.system.criteria.UserQueryCriteria;

/**
 * @author MARK
 * 
 */
public class QueryDaoTest extends BaseDaoTestCase {
	private QueryDao queryDao;

	public void setQueryDao(QueryDao queryDao) {
		this.queryDao = queryDao;
	}

	public void testGetUsers() throws Exception {
		List list = this.queryDao.queryForList("getUsers", 0, 10,
				new UserQueryCriteria());
		log.debug("size:" + list.size());
	}

	public void testGetUserCount() throws Exception {
		int count = this.queryDao.queryForCount("getUserCount",
				new UserQueryCriteria());
		log.debug("count:" + count);
	}

	public void testGetFunctions() throws Exception {
		List list = this.queryDao.queryForList("getFunctions", 0, 10,
				new FunctionQueryCriteria());
		log.debug("size:" + list.size());
	}

	public void testGetFunctionCount() throws Exception {
		int count = this.queryDao.queryForCount("getFunctionCount",
				new FunctionQueryCriteria());
		log.debug("count:" + count);
	}

	public void testGetAllAvailableMenus() throws Exception {
		List list = this.queryDao.queryForList(SqlConstants.GET_ALL_AVAILABLE_MENUS);
		log.debug("size:" + list.size());
	}

	public void testGetUserAvailableMenus() throws Exception {
		List list = this.queryDao.queryForList("getUserAvailableMenus",
				new FunctionQueryCriteria());
		log.debug("size:" + list.size());
	}

	public void testGetRoleFunctions() throws Exception {
		FunctionQueryCriteria criteria = new FunctionQueryCriteria();
		criteria.setRoleId(Long.valueOf("4"));
		List list = this.queryDao.queryForList("getRoleFunctions", criteria);
		log.debug("size:" + list.size());
	}

	public void testGetAvailablerRoles() throws Exception {
		List list = this.queryDao.queryForList("getAvailableRoles");
		log.debug("size:" + list.size());
	}

}