tooracle.java

orecal 与 xml互转 大家看了就知道了 希望对大家有用

//package javax.servlet;
//import oracle.sql.*;
import java.io.*;
import java.sql.*;
//import oracle.jdbc.*;
import oracle.xml.sql.dml.OracleXMLSave;
//import oracle.xml.sql.query.*;
//import org.w3c.dom.*;
import oracle.xml.parser.v2.*;
//import oracle.xml.*;
import java.net.URL;
//import javax.xml.transform.*;
public class toOracle
{
	public static void main(String []args)
				throws SQLException,FileNotFoundException
	{
		//加载驱动程序，连接数据库
		String sDBDriver="oracle.jdbc.driver.OracleDriver";
		String sConnStr="jdbc:oracle:thin:@localhost:1521:SAMPLE";
		Connection conn=null;		
		try
		{
			Class.forName(sDBDriver);
			conn=DriverManager.getConnection(sConnStr,"scott","tiger"); 
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		//输入要导入数据的表的名字
		String tableName=null;		
		BufferedReader putInto=new BufferedReader(new InputStreamReader(System.in));   
		System.out.println("Please enter the name of the table: ");
		try
		{
			tableName=putInto.readLine(); 
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		////输入要导入的xml文档
		String fileName=null;
		BufferedReader putIn=new BufferedReader(new InputStreamReader(System.in));
		System.out.println("Please enter the name of the XMLFile: ");
		try
		{
		fileName=putIn.readLine();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		//创建OracleXMLSave对象
		OracleXMLSave save = null;		
		save=new OracleXMLSave(conn,"scott."+tableName);
		//得到要导入的XML文档的位置
		URL url=save.getURL(fileName);
		//使用DOM解析
		DOMParser parser = new DOMParser();
		try
		{
			parser.parse(url);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}		
		XMLDocument domdoc=parser.getDocument();
		//插入数据
		save.setRowTag("ROW");
		int rowCount=save.insertXML(domdoc);
		//System.out.println(rowCount);
		System.out.println("successfully inserted "+rowCount+" rows into "+tableName);
		//关闭连接
		conn.close();		
	}	
}