Web工程中spring+ibatis的单元测试

您的位置：
门户
>> 文章精选
>> 软件测试技术
>> 单元测试
>> 查看资讯

发表于：2015-3-26 13:04

字体：大中小 | 上一篇 | 下一篇 | 我要投稿

作者：davidwang456 来源：51Testing软件测试网采编

　　三第二步中涉及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>

　　四 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">

</resultMap>

insert into wo_test(testid,orderid,wfid,testResult,testdate,testPerson,testDesc)

values(#testId#,#mpsWorkOrder.orderId#,#wfid#,#testResult#,#testDate#,#testPerson#,#testDesc#)

</insert>

delete from wo_test where testid=#value#

</delete>

select * from wo_test

</select>

select count(*) from wo_test

</select>

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);

}

32/3<123 >

《2023软件测试行业现状调查报告》独家发布~

搜索风云榜

测试技术了解

2023测试行业调查报告

挣点稿费

AI与软件测试

文章资料精选