test.java

该工程文件在Eclipse3.2+MyEclipse 5.0下调试成功我使用的是MSSQL

package com.tocow.test;

import java.util.Hashtable;
import java.util.Properties;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.xmlmiddleware.xmldbms.tools.XMLDBMSProps;

import com.tocow.dataSourceParser.InitJDBCParam;
import com.tocow.logic.BOExportData2XML;
import com.tocow.logic.BOImportData2DB;

import junit.framework.TestCase;

public class Test extends TestCase{
	
	private final String dbConfig = "D:/workspace/xmldbmsProject/web/WEB-INF/dbconfig.xml";
	
	private Log log = null;
	
	protected void setUp() throws Exception {
		// TODO Auto-generated method stub
		super.setUp();
		
		log = LogFactory.getLog(this.getClass());
		
		log.info("系统正在初始化...【必须在下面的打印行中看到“系统初始化完毕！”的字样，系统才算成功启动】");
		
		System.setProperty("dbConfig",dbConfig);		
		
		InitJDBCParam initParams = new InitJDBCParam();
		initParams.setJDBCParam(); 
		
		log.info("系统初始化完毕！");
	}

	protected void tearDown() throws Exception {
		// TODO Auto-generated method stub
		super.tearDown();
	}
	
	public void testExportData(){
		try{
			log.debug("正在测试从数据库中导出XML数据文件...");
			
			Properties configProps = new Properties();
			configProps.put(XMLDBMSProps.ENCODING, "GBK");
			Hashtable params = new Hashtable();
			
			BOExportData2XML boDB2XML = new BOExportData2XML();
			boDB2XML.db2xml(configProps, params, "data-export.xml");
		}catch(Exception exp){
			exp.printStackTrace();
		}
	}
	
	// 注意每个表我只导入了一行测试数据，请用sql语句到数据库中查询是否正确导入了本条数据
	public void teeestImportData(){
		try{
			log.debug("正在测试把XML数据文件导入数据库中...");
			
			Properties configProps = new Properties();
			configProps.put(XMLDBMSProps.ENCODING, "GBK");
			configProps.put(XMLDBMSProps.KEYGENERATORNAME, "UID");
			configProps.put(XMLDBMSProps.KEYGENERATORCLASS, "com.tocow.utilities.KeyGen");
			
			BOImportData2DB boXML2DB = new BOImportData2DB();
			boXML2DB.xml2db(configProps, "data-import.xml");
		}catch(Exception exp){
			exp.printStackTrace();
		}
	}
	
}