DBUnit学习总结.docx

DBUnit1 . 概念DbUnit是为数据库驱动的项目提供的一个对JUnit 的扩展，除了提供一些常用功能，它可以将你的数据库置于一个测试轮回之间的状态。2 . Maven集成DBUnit2.1 导包 !-- dbunit --dependencygroupIdorg.dbunit/groupIdartifactIddbunit/artifactIdversion2.5.0/version/dependency!-- logback --dependencygroupIdch.qos.logback/groupIdartifactIdlogback-access/artifactIdversion1.1.3/version/dependencydependencygroupIdch.qos.logback/groupIdartifactIdlogback-classic/artifactIdversion1.1.3/version/dependency!-- 数据库驱动 --dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion5.1.37/version/dependency2.2 创建数据文件夹1）创建dbunit文件夹。存放dbunit所有数据信息2）在dbunit文件夹下创建backup文件夹。存放数据库备份数据文件3）创建test文件夹。存放所有测试数据文件2.3 代码整理2.3.1 DBUnitBase基类DBUnit说明：设置数据库连接信息设置数据库数据备份路径设置测试数据文件路径数据备份方法和数据恢复方法package com.zzwx.test.dbunit.base;import java.io.File;import java.io.FileWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.List;import org.dbunit.database.DatabaseConnection;import org.dbunit.database.DatabaseDataSet;import org.dbunit.database.IDatabaseConnection;import org.dbunit.database.QueryDataSet;import org.dbunit.dataset.IDataSet;import org.dbunit.dataset.xml.FlatXmlDataSet;import org.dbunit.operation.DatabaseOperation;/** * @author Roger * @desc DBUnit基类 */public abstract class DBUnitBase {/** * JDBC数据库连接 */protected Connection conn = null;/** * DBUnit数据库连接 */protected IDatabaseConnection connection = null;/** * 备份数据目录 */protected String backupDataPath = src/test/resources/dbunit/backup/;/** * 测试数据文件目录 */protected String testDataPath = src/test/resources/dbunit/test/;/** * 数据备份文件 */protected File file = null;/** * 所有备份文件 */protected ListFile files = null;/** * 获取数据库连接 * * @return java.sql.Connection * @throws Exception */protected Connection getConnection() throws Exception {Class.forName(com.mysql.jdbc.Driver);// 连接DBConnection conn = DriverManager.getConnection(jdbc:mysql://localhost:3306/zzwx?useUnicode=truecharacterEncoding=UTF-8,root, 123456);return conn;}/** * 通过表名备份数据 * * @param ta