import java.sql.ResultSet;
import java.util.List;
import mockit.Mock;
import mockit.MockUp;
import org.junit.AfterClass;
import org.junit.BeforeClass;
import org.junit.Test;
import com.geezn.exception.GeeznException;
import com.runqian.mis2.util.DBAccess;
import com.runqianapp.ngr.data.model.MyLink;
import com.runqianapp.schedule.utils.PathUtils;

/**
 * @author RAQ
 *
 */
public class LinkDaoTest {
	private LinkDao linkDao = new LinkDao();
	/**
	 * 配置文件项目路径
	 */
	public static final String setProjectPath = "E:/workplace_link/LinkManagerJava/WebRoot";

	
	
	/**
	 * 初始化环境
	 */
	@BeforeClass
	public static void init() throws Exception {
		mockPathUtils();

	}
	/**
	 * @throws java.lang.Exception
	 */
	@BeforeClass
	public static void setUpBeforeClass() throws Exception {
		
	}

	/**
	 * @throws java.lang.Exception
	 */
	@AfterClass
	public static void tearDownAfterClass() throws Exception {
	}

	/**
	 * 测试删除批量超链接方法
	 * Test method for {@link com.runqianapp.ngr.link.dao.LinkDao#removeLinks(java.lang.String)}.
	 * @throws GeeznException 
	 */
	@Test
	public void testRemoveLinks() throws GeeznException {
		StringBuffer links = new StringBuffer();
		for(int i=21;i<1000;i++){
			links.append("/link").append(i).append(",");			
		}
		links.deleteCharAt(links.length()-1);
		linkDao.removeLinks(links.toString());
		for(int j=20;j<1000;j++){
			MyLink linkCheck = linkDao.getMyLinkByShortLink("/link"+j);
			assertEquals("判断删除超链接是否成功","",linkCheck.getShortLink());  //逐一验证超链接是否被成功删除
		}

	}

	/**
	 * 测试删除单个超链接方法
	 * Test method for {@link com.runqianapp.ngr.link.dao.LinkDao#removeLink(java.lang.String)}.
	 * @throws Exception 
	 */
	@Test
	public void testRemoveLink() throws Exception {
		JunitParamUtil junitUtil = new JunitParamUtil(System.getProperty("user.dir") + "/test/com/runqianapp/ngr/link/dao/removelinkparams",1);
		// 从参数文件中获取到的参数List
		List paramList = junitUtil.getParamList();
		for (int i = 0; i < paramList.size(); i++) {
			JunitParam param = (JunitParam) paramList.get(i);
			linkDao.removeLinks(param.getString(0));
			MyLink linkCheck = linkDao.getMyLinkByShortLink(param.getString(0));
			assertEquals("判断删除超链接是否成功","",linkCheck.getShortLink());
		}
	
	}

	/**
	 * 测试获取超链接方法
	 * Test method for {@link com.runqianapp.ngr.link.dao.LinkDao#getMyLinkByShortLink(java.lang.String)}.
	 * @throws Exception 
	 */
	@Test
	public void testGetMyLinkByShortLink() throws Exception {
		JunitParamUtil junitUtil = new JunitParamUtil(System.getProperty("user.dir") + "/test/com/runqianapp/ngr/link/dao/getmylinkbyshortlinkparams",1);
		// 从参数文件中获取到的参数List
		List paramList = junitUtil.getParamList();
		for (int i = 0; i < paramList.size(); i++) {
			JunitParam param = (JunitParam) paramList.get(i);
			MyLink linkCheck = linkDao.getMyLinkByShortLink(param.getString(0));
			assertEquals("判断获取到的超链接是否为空",false,linkCheck.getLinkName().equals(""));
		}
	}

	/**
	 * 测试修改超链接方法
	 * Test method for {@link com.runqianapp.ngr.link.dao.LinkDao#modifyMyLink(com.runqianapp.ngr.data.model.MyLink)}.
	 * @throws Exception 
	 */
	@Test
	public void testModifyMyLink() throws Exception {
		JunitParamUtil junitUtil = new JunitParamUtil(System.getProperty("user.dir") + "/test/com/runqianapp/ngr/link/dao/modifylinkparams",6);
		// 从参数文件中获取到的参数List
		List paramList = junitUtil.getParamList();
		for (int i = 0; i < paramList.size(); i++) {
			MyLink myLink = new MyLink(); 
			JunitParam param = (JunitParam) paramList.get(i);
			// 获取并设置参数
			myLink.setShortLink(param.getString(0));
			myLink.setLinkName(param.getString(1)); 
			myLink.setLinkUrl(param.getString(2));
			myLink.setLinkDes(param.getString(3));
			myLink.setIsRes(param.getInt(4)); 
			myLink.setParams(param.getString(5));
			linkDao.modifyMyLink(myLink);
			String linkName = linkDao.getMyLinkByShortLink(param.getString(0)).getLinkName();
			String linkUrl = linkDao.getMyLinkByShortLink(param.getString(0)).getLinkUrl();
			String linkDes = linkDao.getMyLinkByShortLink(param.getString(0)).getLinkDes();
			int linkIsRes = linkDao.getMyLinkByShortLink(param.getString(0)).getIsRes();
			String linkParams = linkDao.getMyLinkByShortLink(param.getString(0)).getParams();
			assertEquals("判断超链接名称是否已被修改",param.getString(1),linkName);
			assertEquals("判断超链接Url是否已被修改",param.getString(2),linkUrl);
			assertEquals("判断超链接描述是否已被修改",param.getString(3),linkDes);
			assertEquals("判断超链接引用是否已被修改",param.getInt(4),linkIsRes);
			assertEquals("判断超链接参数是否已被修改",param.getString(5),linkParams);
		}
	}

	/**
	 * 测试新增超链接方法
	 * Test method for {@link com.runqianapp.ngr.link.dao.LinkDao#saveLink(com.runqianapp.ngr.data.model.MyLink)}.
	 * @throws Exception 
	 */
	@Test
	public void testSaveLink() throws Exception {	
		// Junit参数工具类
		JunitParamUtil junitUtil = new JunitParamUtil(System.getProperty("user.dir") + "/test/com/runqianapp/ngr/link/dao/savelinkparams",6);
		// 从参数文件中获取到的参数List
		List paramList = junitUtil.getParamList();
		for (int i = 0; i < paramList.size(); i++) {
			MyLink myLink = new MyLink();
			// Junit参数类
			JunitParam param = (JunitParam) paramList.get(i);
			// 获取并设置参数
			myLink.setLinkName(param.getString(1)); 
			myLink.setLinkUrl(param.getString(2));
			myLink.setLinkDes(param.getString(3));
			myLink.setIsRes(param.getInt(4)); 
			myLink.setParams(param.getString(5));
			//根据数据总条数来获得最后一个超链接ID，用于断言
			DBAccess dba = new DBAccess();
			String shortLink = "";
	  		StringBuffer sql = new StringBuffer();		
	  		sql.append("select count(*) total from t_hyperlink");
	  		ResultSet rs  = dba.executeQuery(sql.toString());
	  		int total = 0;
	  		while(rs.next()){
	  			total = rs.getInt("total");
	  		}
	  		
			linkDao.saveLink(myLink);
			MyLink checkLink = linkDao.getMyLinkByShortLink("/link"+total);
			assertEquals("判断超链接名称",param.getString(1),checkLink.getLinkName());
			assertEquals("判断超链接URL",param.getString(2),checkLink.getLinkUrl());
			assertEquals("判断超链接描述",param.getString(3),checkLink.getLinkDes());
			assertEquals("判断超链接是否引用",param.getInt(4),checkLink.getIsRes());
			assertEquals("判断超链接参数",param.getString(5),checkLink.getParams());	
		}		
	    //压力测试	
//		for(int i = 20;i<1000;i++){
//			MyLink myLink = new MyLink();
//			myLink.setShortLink("/link100");
//			myLink.setLinkName("测试用例01"); 
//			myLink.setLinkUrl("http://www.runqian.com.cn");
//			myLink.setLinkDes("");
//			myLink.setIsRes(1); 
//			try {
//				linkDao.saveLink(myLink);
//				MyLink checkLink = linkDao.getMyLinkByShortLink("/link20");
//				assertEquals("判断超链接名称","测试用例01",checkLink.getLinkName());
//			} catch (GeeznException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}
//		}
		
	}

	
	/**
	 * 模拟PathUtils
	 */
	public  static void mockPathUtils() {
		new MockUp<PathUtils>() {
			@Mock
			public String getAppPhyPath() {
				return setProjectPath;
			}
		};
	}


}

单元测试示例--LinkDaoTest.java,布布扣,bubuko.com

单元测试示例--LinkDaoTest.java