使用DbUnit，可以用Ant的任务来实现，也可以直接写DbUnit的测试代码实现

最新推荐文章于 2024-08-29 11:09:52 发布

YuLimin

最新推荐文章于 2024-08-29 11:09:52 发布

阅读量167

点赞数

文章标签： Ant MySQL Mobile junit JDBC

Ant： http://ant.apache.org/

Apache Ant is a Java-based build tool. In theory, it is kind of like Make, but without Make's wrinkles.

DbUnit：http://www.dbunit.org/

DbUnit is a JUnit extension (also usable with Ant) targeted for database-driven projects that, among other things, puts your database into a known state between test runs. This is an excellent way to avoid the myriad of problems that can occur when one test case corrupts the database and causes subsequent tests to fail or exacerbate the damage.

DbUnit has the ability to export and import your database data to and from XML datasets. Since version 2.0, DbUnit can works with very large dataset when use in streaming mode. DbUnit can also helps you to verify that your database data match expected set of values.

JUnitDoclet：http://www.junitdoclet.org/

Why wasn't this tested before? This question often arises shortly before a deadline. Our answer: Because testing was not easy enough.

Especially creating and maintaining a test structure is often used as an excuse. JUnitDoclet lowers the step toward JUnit. It generates skeletons of TestCases based on your application source code. And it supports you to reorganize tests during refactoring. Suddenly all the excuses don't count any longer.

MySQL数据库：Pagination，表：Persioninfo信息如下：

# Host: localhost
# Database: pagination
# Table: 'personinfo'
#
CREATE TABLE `personinfo` (
`id` varchar(100) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`sex` tinyint(1) NOT NULL default '0',
`mobile` varchar(50) NOT NULL default '0',
`address` varchar(50) NOT NULL default '',
`memo` varchar(50) default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

一、用Ant的任务来实现

　　１、DataSelt.xml内容如下：

　　２、Ant 的 build.xml内容如下，请进行相应的改动：

３、运行：ant或ant initdb或ant export或ant select不同的任务

二、直接写DbUnit的测试代码实现，DbUnitTest.java的代码如下：

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;

import org.dbunit.DatabaseTestCase;
import org.dbunit.database.DatabaseConnection;
import org.dbunit.database.IDatabaseConnection;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset.xml.FlatXmlDataSet;
import org.dbunit.operation.DatabaseOperation;

/**
*

Title: 运行DbUnit测试将数据导入数据库。

*
*

Description: 运行DbUnit测试将数据导入数据库。

*
*

Company: Beyond DayBreak Office

* @author YuLimin
* @version 1.0
*/
public class DbUnitTest extends DatabaseTestCase
{
    public DbUnitTest(String name)
    {
        super(name);
    }

    /**
     *
     * @see org.dbunit.DatabaseTestCase#getConnection()
     * @throws Exception
     * @return IDatabaseConnection
     */
    protected IDatabaseConnection getConnection() throws Exception
    {
        Class driverClass = Class.forName("com.mysql.jdbc.Driver");
        Connection jdbcConnection = DriverManager.getConnection("jdbc:mysql://localhost/Pagination","root","password");
        return new DatabaseConnection(jdbcConnection);
    }

    /**
     *
     * @see org.dbunit.DatabaseTestCase#getDataSet()
     * @throws Exception
     * @return IDataSet
     */
    protected IDataSet getDataSet() throws Exception
    {
        return new FlatXmlDataSet(new FileInputStream("DataSet.xml"));
    }

    /**
     * getSetUpOperation
     *
     * @return DatabaseOperation
     * @throws Exception
     */
    protected DatabaseOperation getSetUpOperation() throws Exception
    {
        return DatabaseOperation.REFRESH;
    }

    /**
     * getTearDownOperation
     *
     * @return DatabaseOperation
     * @throws Exception
     */
    protected DatabaseOperation getTearDownOperation() throws Exception
    {
        return DatabaseOperation.NONE;
    }

    /**
     * 运行DbUnit测试将数据导入数据库。
     */
    public void testDbUnit()
    {
        System.out.println("DbUnit Testing...");
    }
}

YuLimin

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
使用DbUnit，可以用Ant的任务来实现，也可以直接写DbUnit的测试代码实现

Ant： http://ant.apache.org/Apache Ant is a Java-based build tool. In theory, it is kind of like Make, but without Make's wrinkles. DbUnit：http://www.dbunit.org/DbUnit is a JUnit extension (also usable...
复制链接

扫一扫