Dao 层单元测试用例编写-白红宇

Dao 层单元测试用例编写

阅读量：6311 次

发布时间：2019-06-22

本文共 9857 字，大约阅读时间需要 32 分钟。

开发设计：ibatis 文件 pubMessageDraft.xml 写sql，PubMessageDraftDO写Model

，PubMessageDraftDao写方法 ： public List<PubMessageDraftDO> listByType(String pubUid, String type, int size, int offset) {

Map<String, Object> params = new HashMap<String, Object>();

params.put("type", type);

params.put("pubUid", pubUid);

params.put("size", size);

params.put("offset", offset);

return (List<PubMessageDraftDO>) this.getSqlMapClientTemplate().queryForList("pubMessageDraft.listByType", params);

}

public List<PubMessageDraftDO> listByIds(String pubUid,List<String> idList){

Map<String, Object> params = new HashMap<String, Object>();

params.put("pubUid", pubUid);

params.put("idList", idList);

return (List<PubMessageDraftDO>) this.getSqlMapClientTemplate().queryForList("pubMessageDraft.listByIds", params);

}

public PubMessageDraftDO getById(String id, String pubUid) {

Map<String, Object> params = new HashMap<String, Object>();

params.put("id", id);

params.put("pubUid", pubUid);

return (PubMessageDraftDO) this.getSqlMapClientTemplate().queryForObject("pubMessageDraft.getById", params);

}

public void insert(PubMessageDraftDO pubMessageDraftDO) {

this.getSqlMapClientTemplate().insert("pubMessageDraft.insert", pubMessageDraftDO);

}

public void update(PubMessageDraftDO pubMessageDraftDO) {

this.getSqlMapClientTemplate().insert("pubMessageDraft.update", pubMessageDraftDO);

}

public void delete(String id, String pubUid) {

Map<String, Object> params = new HashMap<String, Object>();

params.put("id", id);

params.put("pubUid", pubUid);

this.getSqlMapClientTemplate().delete("pubMessageDraft.delete", params);

}

单元测试设计：

需要的配置文件： daoTextContext.xml.

-------------

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="

http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

</beans>

--------------

daoSource.xml,

-----------------

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

xsi:schemaLocation="

http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

<list>

<value>classpath:jtester.properties</value>

</list>

</property>

</bean>

<property name="connectionProperties"><value>clientEncoding=UTF-8</value></property>

</bean>

<list>

<value>classpath:META-INF/ibatis/pp-sql-map-config.xml</value>

</list>

</property>

</bean>

</bean>

</bean>

</beans>

------------

jtester.properties

----------------------

# dbFit database test use

database.type=mysql

database.url=jdbc:mysql://10.20.153.58:3306/bbltest?useUnicode=true&characterEncoding=UTF-8

database.userName=test

database.password=test

database.driverClassName=com.mysql.jdbc.Driver

database.only.testdb.allowing=false

jdbc.url=jdbc:mysql://10.20.153.58:3306/bbltest?useUnicode=true&characterEncoding=UTF-8

jdbc.username=test

jdbc.password=test

DatabaseModule.Transactional.value.default=rollback

## jtester-ext custom configuration

# webx configuration

SpringModule.applicationContextFactory.implClassName=com.alibaba.china.testerx.jtester.ext.spring.JTesterxApplicationContextFactory

# database configuration

unitils.module.database.className=com.alibaba.china.testerx.jtester.ext.database.module.DatabasexModule

# lazy-init configuration

unitils.module.spring.className=com.alibaba.china.testerx.jtester.ext.spring.JTesterxSpringModule

# dbfit configuration

unitils.module.dbfit.className=com.alibaba.china.testerx.jtester.ext.database.module.DbFitxModule

------------

pp-dao.xml

------------

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"

default-lazy-init="true">

</beans>

----------

测试用例：

---------------

package com.alibaba.laiwang.pp;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import junit.framework.Assert;

import org.junit.Before;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.test.context.ContextConfiguration;

import org.springframework.test.context.junit4.SpringJUnit4Cla***unner;

import com.laiwang.pp.dal.dao.PubMessageDraftDao;

import com.laiwang.pp.dal.dataobject.PubMessageDraftDO;

@RunWith(SpringJUnit4Cla***unner.class)

@ContextConfiguration(locations = "classpath:daoTestContext.xml")

public class pubMessageDraftTest {

@Autowired

private PubMessageDraftDao pubMessageDraftDao;

@Before

public void before() {

}

@Test

public void test() {

//insert

PubMessageDraftDO pubMessageDraft = new PubMessageDraftDO();

pubMessageDraft.setId("id1");

pubMessageDraft.setPubUid("pubUid1");

pubMessageDraft.setMsgType("msgType");

pubMessageDraft.setAttachment("p_w_upload1");

pubMessageDraft.setGmtCreate(new Date());

pubMessageDraft.setGmtModified(new Date());

pubMessageDraftDao.insert(pubMessageDraft);

PubMessageDraftDO pubInsert = pubMessageDraftDao.getById("id1","pubUid1");

Assert.assertNotNull(pubInsert);

//update

pubMessageDraft.setMsgType("msgType111");

pubMessageDraft.setGmtModified(new Date());

pubMessageDraft.setPubUid("pubUid2");

pubMessageDraftDao.update(pubMessageDraft);

//getById

PubMessageDraftDO pub = pubMessageDraftDao.getById("id2","pubUid2");

Assert.assertEquals("p_w_upload1", pub.getAttachment());

Assert.assertEquals("msgType111", pub.getMsgType());

Assert.assertNotNull(pub.getGmtCreate());

Assert.assertNotNull(pub.getGmtModified());

//listByType

List<PubMessageDraftDO> pubListByType= pubMessageDraftDao.listByType("pubUid2", "p_w_upload1", 0, 10);

for (PubMessageDraftDO lb: pubListByType ){

Assert.assertEquals("p_w_upload1", lb.getAttachment());

Assert.assertEquals("msgType111",lb.getMsgType());

}

//listByIds

List<String> idList= new ArrayList();

idList.add("id2");

List<PubMessageDraftDO> listByIds= pubMessageDraftDao.listByIds("pubUid2", idList);

for(PubMessageDraftDO lbs:listByIds){

Assert.assertEquals("p_w_upload1", lbs.getAttachment());

Assert.assertEquals("msgType111",lbs.getMsgType());

}

//delete

pubMessageDraftDao.delete("id1","pubUid1");

PubMessageDraftDO pubDelete = pubMessageDraftDao.getById("id1","pubUid1");

Assert.assertNull(pubDelete);

}

转载于:https://blog.51cto.com/wendyjiangyue/1195283

你可能感兴趣的文章

在市场营销中使用敏捷方法：过程、团队与成功案例

查看>>

新书问答：Agile Management

针对Kubernetes软件栈有状态服务设计的思考

查看>>

你的可用性达标了吗？云端业务性能高可用的深度实践

查看>>

linux yum清缓存脚本

查看>>

基于epoll封装的事件回调miniserver

查看>>

天猫高管全面解读大快消2018新零售打法

查看>>

idea springboot热部署无效问题

查看>>

第八章进程间通信

查看>>

「镁客早报」AI可预测心脏病人死亡时间；机器人开始在美国送外卖

查看>>

MoQ(基于.net3.5,c#3.0的mock框架)简单介绍

查看>>

物联网全面升级，十年内推动工业进入智能化新阶段

查看>>

spring-通过ListFactory注入List