DFfit+JTester+TestNG数据库操作测试示例（原创）

上一篇 / 下一篇 2011-03-21 17:49:57 / 个人分类：敏捷测试

---jtester.properties---
database.type=mysql
database.url=jdbc:mysql://localhost/creditcard?characterEncoding=UTF8
database.userName=root
database.password=hjq
database.schemaNames=creditcard
database.driverClassName=com.mysql.jdbc.Driver

---creditcard.when.wiki---
数据库连接，使用jtester.properties中配置好的属性
|connect|

清空creditcard表
|clean table|creditcard|

准备数据，往creditcard中插入2条测试使用的记录
|insert|creditcard|
|cardnumber|banknumber|amount|username|
|123456|987654321|500|qing|
|123456|987654321|500|huang|

提交数据
|commit|

---creditcard.then.wiki--
|connect|

根据条件查询记录，验证相应的字段
|query|select username from creditcard|
|username|
|qing|
|huang|
|junqinghuang|

----测试代码---
package creditcard.repay.mapper;

import mockit.Mock;

import org.testng.annotations.Test;

import java.io.IOException;
import java.sql.SQLException;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.jtester.testng.JTester;
import org.jtester.unitils.dbfit.DbFit;

import creditcard.repay.bean.Creditcard;
import creditcard.repay.util.MyBatisUtil;

public class CreditcardMapperDbfitTest extends JTester {

    static SqlSessionFactory sqlSessionFactory = null;
    static {
        sqlSessionFactory = MyBatisUtil.getSqlSessionFactory();
    }

    @Test(groups = "mapper2")
    @DbFit(when = "com/creditcard/wiki/creditcard.when.wiki", then = "com/creditcard/wiki/creditcard.then.wiki")
    public void insertCreditcardDbfitTest() throws SQLException, IOException {
        SqlSession sqlSession = sqlSessionFactory.openSession();
        try {
            ICreditcardMapper creditcardMapper = sqlSession
                    .getMapper(ICreditcardMapper.class);
            Creditcard creditcard = new Creditcard();
            creditcard.setAmount(300);
            creditcard.setBanknumber("555666");
            creditcard.setUsername("junqinghuang");
            creditcard.setCardnumber("4455");

            creditcardMapper.insertCreditcard(creditcard);

            sqlSession.commit();
        } finally {
            sqlSession.close();
        }
    }
}

收藏举报

TAG:

查看全部评论