HWDBTestCase

package com.huawei.oss.test.framework;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.InputStream;
import java.lang.reflect.Method;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Vector;

import org.apache.log4j.Logger;
import org.dbunit.Assertion;
import org.dbunit.DBTestCase;
import org.dbunit.DatabaseUnitException;
import org.dbunit.IDatabaseTester;
import org.dbunit.JdbcDatabaseTester;
import org.dbunit.PropertiesBasedJdbcDatabaseTester;
import org.dbunit.database.DatabaseConfig;
import org.dbunit.database.IDatabaseConnection;
import org.dbunit.database.QueryDataSet;
import org.dbunit.dataset.DataSetException;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset.ITable;
import org.dbunit.dataset.SortedTable;
import org.dbunit.dataset.xml.XmlDataSet;
import org.dbunit.ext.oracle.OracleDataTypeFactory;
import org.dbunit.operation.DatabaseOperation;

/**
 * 进一步封装dbunit
 * @author dKF16823
 *
 */
public abstract class HWDBTestCase extends DBTestCase
{
    private Vector<File> files = new Vector<File>(); // 备份数据库数据
   
    private String fileName = ""; // 当前数据
   
    private static boolean firstFlag = true;
   
    private static boolean lastFlag = true;
   
    private static int testCount = 0;
   
    private static int executeCount = 0;
   
    private static final String USER_TOPENG = "topeng";
   
    private static final String PWD_TOPENG = "topeng";
   
    private static final String USER_CCARE = "ccare";
   
    private static final String PWD_CCARE = "ccare";
   
    private static final String USER_BILLING = "billing";
   
    private static final String PWD_BILLING = "billing";
   
    private static final String USER_REPORT = "report";
   
    private static final String PWD_REPORT = "report";
   
    private HashMap<String, IDatabaseTester> hashmap = new HashMap<String, IDatabaseTester>();
   
    protected final String disableSql = "SELECT 'alter table '||table_name||' disable constraint '||constraint_name FROM user_constraints t where t.constraint_type='R'";
   
    protected final String enableSql = "SELECT 'alter table '||table_name||' enable constraint '||constraint_name FROM user_constraints t where t.constraint_type='R'";
   
    private IDatabaseTester tester = null;