當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

web工程中spring+ibatis的单元测试--转载

發布時間：2025/4/5 编程问答 25 豆豆

生活随笔收集整理的這篇文章主要介紹了 web工程中spring+ibatis的单元测试--转载小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

為了保證代碼的正確,軟件的質量,單元測試幾乎是每個程序員都要面臨的工作了;而開發中大部分的工作都涉及數據庫的操作,也就是平時經常可以看到的DAO了;由于是對數據庫的操作,就必然有事務的問題了;如果是啟動應用服務器,然后再模擬一個請求來驗證Dao中的代碼寫得是否正確的話,那么面臨的問題首先就是速度的問題也就是效率的問題,如果你的應用很大的話那么但就tomcat的啟動就花費了一分鐘左右的時間,如果用的服務器是weblogic的話就更加不用說了其實就是問題的主次問題,我們現在要做的正事是測試Dao 但是如果放到服務器里面測試的話可能有些問題就不是dao的問題了,但是我們必須解決,這樣做顯然很多時候就有點本末倒置了 ;因此我采用的方法是利用spring+ibatis+junit在本地測試的方法大體步驟如下

一? 建立一個測試的基類 AbstractTestCase 代碼如下

? package com.skywin.workorder.dao;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import junit.framework.TestCase;

public abstract class AbstractTestCase extends TestCase {
??? protected ApplicationContext ctx = null;

??? public AbstractTestCase() {
??? ??? // 測試工作流
??? ??? //ctx = new ClassPathXmlApplicationContext("testApplicationContext.xml");
??? ??? // 測試DAO
??? ???? ?ctx =new ClassPathXmlApplicationContext(
??? ??? ?"_applicationContext-iBatis.xml");?
??? }
}

二第一步中文件?_applicationContext-iBatis.xml?的路徑為?工程名字\conf\_applicationContext-iBatis.xml?,是spring的配置文件進行事務屬性等相關配置? 代碼如下:

? <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">

<beans>


??? <import? resource="classpath:workorder-module.xml"/>
??? <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
??? ??? <property name="locations">
??? ??? ??? <list>
??? ??? ??? ???? <value>jdbc-template.properties</value>?
??? ??? ??? </list>
??? ??? </property>
??? </bean>

????<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
??? ??? <property name="dataSource" ref="dataSource"/>
??? </bean>?

???? <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
??? ??? <property name="driverClassName" value="${jdbc.driverClassName}"/>
??? ??? <property name="url" value="${jdbc.url}"/>
??? ??? <property name="username" value="${jdbc.username}"/>
??? ??? <property name="password" value="${jdbc.password}"/>
??? ??? <property name="initialSize" value="${jdbc.initialSize}"/>
??? ??? <property name="maxActive" value="${jdbc.maxActive}"/>
??? </bean>?


????<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
??? ??? <property name="configLocation" value="sqlmap-config-template.xml"/>
??? ??? <property name="dataSource" ref="dataSource"/>
??? </bean>?

????<bean id="baseTxService" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"?
??? ??? abstract="true">?
??? ??? <property name="transactionManager" ref="transactionManager"/>?
??? ??? <property name="proxyTargetClass" value="true"/>?
??? ??? <property name="transactionAttributes">?
??? ??? ??? <props>?
??? ??? ??? ??? <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>?
??? ??? ??? ??? <prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>?
??? ??? ??? ??? <prop key="save*">PROPAGATION_REQUIRED</prop>?
??? ??? ??? ??? <prop key="remove*">PROPAGATION_REQUIRED</prop>?
??? ??? ??? ??? <prop key="update*">PROPAGATION_REQUIRED</prop>
??? ??? ??? ??? 
??? ??? ??? </props>?
??? ??? </property>?
??? </bean>?

</beans>

三第二步中涉及DataSource,其配置信息包含在?jdbc-template.properties?文件中文件路徑為

工程目錄\conf\jdbc-template.properties?代碼如下

# Properties file with JDBC-related settings.
# Applied by PropertyPlaceholderConfigurer from "applicationContext.xml".
# Targeted at system administrators, to avoid touching the context XML files.

#jdbc.driverClassName=com.mysql.jdbc.Driver
#jdbc.url=jdbc:mysql://localhost:3306/mps
#jdbc.username=root
#jdbc.password=skywin

jdbc.initialSize=1
jdbc.maxActive=10?

jdbc.driverClassName=oracle.jdbc.OracleDriver?
#jdbc.url=jdbc:oracle:thin:@10.244.112.130:41521:gmcctes
#jdbc.url=jdbc:oracle:thin:@10.244.112.130:1521:gmccmpp
jdbc.url=jdbc:oracle:thin:@192.168.100.235:1521:mpptest
jdbc.username=gmcc
jdbc.password=skywin?
#imageDatabase.lobHandler=oracleLobHandler

三第二步中的?? <property name="configLocation" value="sqlmap-config-template.xml"/>?為ibatis的中樞文件文件路徑是?? 工程目錄\conf\sqlmap-config-template.xml 代碼如下:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig??????
??? PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"??????
??? "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
??? <sqlMap resource="ibatis-conf/MpsAppendixInf.xml" />
??? <sqlMap resource="ibatis-conf/MpsDispatchLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsFunctionType.xml" />
??? <sqlMap resource="ibatis-conf/MpsFundType.xml" />
??? <sqlMap resource="ibatis-conf/MpsInGatewayInf.xml" />
??? <sqlMap resource="ibatis-conf/MpsModuleInf.xml" />
??? <sqlMap resource="ibatis-conf/MpsOperationType.xml" />
??? <sqlMap resource="ibatis-conf/MpsOrderClaimant.xml" />
??? <sqlMap resource="ibatis-conf/MpsPayType.xml" />
??? <sqlMap resource="ibatis-conf/MpsProcessApproveLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsProcessLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsProcessRemark.xml" />
??? <sqlMap resource="ibatis-conf/MpsReceiveOrderLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsServiceInfo.xml" />
??? <sqlMap resource="ibatis-conf/MpsUploadFile.xml" />
??? <sqlMap resource="ibatis-conf/MpsUrgentLevel.xml" />
??? <sqlMap resource="ibatis-conf/MpsVerifyLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsWorkOrder.xml" />
??? <sqlMap resource="ibatis-conf/MpsWorkOrderCancelLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsWorkOrderCloseLog.xml" />
??? <sqlMap resource="ibatis-conf/MpsWorkOrderType.xml" />
??? <sqlMap resource="ibatis-conf/MpsOperatorInf.xml" />
??? <sqlMap resource="ibatis-conf/MpsOrderServiceInfo.xml" />
??? <sqlMap resource="ibatis-conf/MpsTree.xml" />
??? <sqlMap resource="ibatis-conf/MpsOperatorTree.xml" />
????<sqlMap resource="ibatis-conf/MpsTest.xml" />?
??? <sqlMap resource="ibatis-conf/MpsSpInfo.xml" />
</sqlMapConfig>

四 ormpping文件,這里以MpsTest.xml文件為例子,該文件路徑是

???????工程目錄/conf\ibatis-conf\MpsTest.xml?代碼如下:

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

<!DOCTYPE sqlMap??????
??? PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"??????
??? "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="MpsTest">

??? <resultMap id="result" class="com.skywin.workorder.model.MpsTest">
??? ??? <result property="testId" column="testid" columnIndex="1" />
??? ??? <result property="mpsWorkOrder.orderId" column="orderid" columnIndex="2" />
??? ??? <result property="wfid" column="wfid" columnIndex="3" />
??? ??? <result property="testResult" column="testResult" columnIndex="4" />
??? ??? <result property="testDate" column="testdate" columnIndex="5" />
??? ??? <result property="testPerson" column="testPerson" columnIndex="6" />
??? ??? <result property="testDesc" column="testDesc" columnIndex="7" />
??? </resultMap>
????
????<insert id="saveMpsTest">
??? ???? insert into wo_test(testid,orderid,wfid,testResult,testdate,testPerson,testDesc)
??? ???? values(#testId#,#mpsWorkOrder.orderId#,#wfid#,#testResult#,#testDate#,#testPerson#,#testDesc#)
??? </insert>?
????
??? <delete id="deleteMpsTestById">
??? ?? delete from wo_test where testid=#value#
??? </delete>
????
??? <select id="findAllMpsTest" resultMap="result">
??? ??? select * from wo_test
??? </select>
????
??? <select id="findAllMpsTestCount" resultClass="Long">
??? ?? select count(*) from wo_test
??? </select>
????
??? <select id="findMpsTestNextSeq" resultClass="Long">
??? ???? select wo_test_seq.nextval from dual
??? </select>
????
????
????
????
</sqlMap>

五 dao實現類代碼:

package com.skywin.workorder.dao.Impl;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.skywin.workorder.dao.MpsTestDao;
import com.skywin.workorder.model.MpsTest;
import com.skywin.workorder.util.ListResult;

public class MpsTestDaoImpl extends SqlMapClientDaoSupport implements MpsTestDao {

??? public int deleteMpsTestById(Long testId) {
??? ??? return getSqlMapClientTemplate().delete("deleteMpsTestById", testId);
??? }

??? public List findAllMpsTest(int pagesize, int pageIndex) {
??? ??? return getSqlMapClientTemplate().queryForList("findAllMpsTest", null, pageIndex*pagesize, pagesize);
??? }

??? public Long findAllMpsTestCount() {
??? ??? return (Long) getSqlMapClientTemplate().queryForObject("findAllMpsTestCount", null);
??? }

??? public ListResult pageAllMpsTest(int pagesize, int pageIndex) {
??? ??? ListResult listResult=new ListResult();
??? ??? listResult.setResult(findAllMpsTest(pagesize,pageIndex));
??? ??? listResult.setCount(findAllMpsTestCount());
??? ??? return listResult;
??? }

????public MpsTest saveMpsTest(MpsTest mpsTest) {
??? ??? getSqlMapClientTemplate().insert("saveMpsTest",mpsTest);
??? ??? return mpsTest;
??? }?

??? public Long findMpsTestNextSeq() {
??? ??? return (Long) getSqlMapClientTemplate().queryForObject("findMpsTestNextSeq", null);
??? }

}

六實體bean代碼(MpsTest)

package com.skywin.workorder.model;

import java.io.Serializable;
import java.util.Date;

/**測試記錄*/
public class MpsTest implements Serializable{
????
????/**主鍵*/
??? private Long testId;
????
??? /**關聯工單*/
??? private MpsWorkOrder mpsWorkOrder;
????
??? /**工作流id*/
??? private Long wfid;
????
??? /**測試人*/
??? private String testPerson;
????
??? /**測試是否通過*/
??? private int testResult;
????
??? /**測試結果描述*/
??? private String testDesc;
????
??? /**測試日期*/
??? private Date testDate;?

??? public MpsWorkOrder getMpsWorkOrder() {
??? ??? return mpsWorkOrder;
??? }

??? public void setMpsWorkOrder(MpsWorkOrder mpsWorkOrder) {
??? ??? this.mpsWorkOrder = mpsWorkOrder;
??? }

????

??? public String getTestDesc() {
??? ??? return testDesc;
??? }

??? public void setTestDesc(String testDesc) {
??? ??? this.testDesc = testDesc;
??? }

??? public String getTestPerson() {
??? ??? return testPerson;
??? }

??? public void setTestPerson(String testPerson) {
??? ??? this.testPerson = testPerson;
??? }

??? public int getTestResult() {
??? ??? return testResult;
??? }

??? public void setTestResult(int testResult) {
??? ??? this.testResult = testResult;
??? }

??? public Date getTestDate() {
??? ??? return testDate;
??? }

??? public void setTestDate(Date testDate) {
??? ??? this.testDate = testDate;
??? }

??? public Long getTestId() {
??? ??? return testId;
??? }

??? public void setTestId(Long testId) {
??? ??? this.testId = testId;
??? }

??? public Long getWfid() {
??? ??? return wfid;
??? }

??? public void setWfid(Long wfid) {
??? ??? this.wfid = wfid;
??? }
????
????

}

七建立一個jUnit測試類測試第六步中dao的方法其實改類本質上也是一個java類要想成功的測試某個方法則方法名字不以test開頭代碼如下 :

package com.skywin.workorder.dao;

import java.util.Date;
import java.util.List;

import com.skywin.workorder.model.MpsTest;
import com.skywin.workorder.model.MpsWorkOrder;
import com.skywin.workorder.util.ListResult;

public class MpsTestDaoTest extends AbstractTestCase?{
??? MpsTestDao dao;
??? public MpsTestDaoTest(){
??? ??? super();
??? ????dao=(MpsTestDao) ctx.getBean("woTestDao");
??? ??? System.out.println("dao"+dao);
??? ????
??? }
????
???? public void? testsaveMpsTest(){?
??? ??? System.out.println("go go go");
??? ???? MpsTest t=new MpsTest();?
????
??? ??? t.setTestId(new Long(-105));
??? ??? t.setWfid(new Long(-15));
??? ??? System.out.println("2222222");
??? MpsWorkOrder mpsWorkOrder=new MpsWorkOrder();
??? ??? mpsWorkOrder.setOrderId(new Long(-20));
??? ??? t.setMpsWorkOrder(mpsWorkOrder);
??? ????
??? ??? t.setTestResult(-50);
??? ??? t.setTestPerson("kkkkk");
??? ??? t.setTestDesc("hao hao");
??? ??? t.setTestDate(new Date());
??? ????dao.saveMpsTest(t);?
??? }
????
??? public void _testfindAllMpsTestCount(){
??? ??? Long c=dao.findAllMpsTestCount();
??? ??? System.out.println("c---"+c);
??? }
????
??? public void _testfindAllMpsTest(){
??? ??? List? list=dao.findAllMpsTest(3, 1);
??? ??? for(int i=0;i<list.size();i++){
??? ??? ??? MpsTest t=(MpsTest) list.get(i);
??? ??? ??? System.out.println(t.getTestId());
??? ??? }
??? ??? System.out.println(list);
??? }
????
????
??? public void _testpageAllMpsTest(){
??? ??? ListResult l=dao.pageAllMpsTest(3, 1);
??? ??? System.out.println(l.getCount());
??? }
????
??? public void _testfindMpsTestNextSeq(){
??? ??? Long s=dao.findMpsTestNextSeq();
??? ?? System.out.println("s---"+s);
??? }
????
????
????
??? public void test(){
??? ??? dao.deleteMpsTestById(new Long(-100));
??? }
}

完成以上步驟后運行JUnit就可以了,結果是紅條還是綠條就看你dao實現類代碼是否正確了。

原文地址：http://kai2008.iteye.com/blog/324145

轉載于:https://www.cnblogs.com/davidwang456/p/4290728.html

總結

以上是生活随笔為你收集整理的web工程中spring+ibatis的单元测试--转载的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： eclipse 中修改 M2_REPO的
下一篇： schedule() 和 schedul