单元测试示例--LinkDaoTest.java

发表于:2014-4-02 11:33

字体: | 上一篇 | 下一篇 | 我要投稿

 作者:真理孤独    来源:51Testing软件测试网采编

分享:
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;
}
};
}
}
《2023软件测试行业现状调查报告》独家发布~

关注51Testing

联系我们

快捷面板 站点地图 联系我们 广告服务 关于我们 站长统计 发展历程

法律顾问:上海兰迪律师事务所 项棋律师
版权所有 上海博为峰软件技术股份有限公司 Copyright©51testing.com 2003-2024
投诉及意见反馈:webmaster@51testing.com; 业务联系:service@51testing.com 021-64471599-8017

沪ICP备05003035号

沪公网安备 31010102002173号