把XML文件中的数据存储到Oracle数据库

发布时间：2020-12-15 23:42:12 所属栏目：百科来源：网络整理

导读：package com.cnwu.xml.todb; import java.io.File; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Iterator; import java.util

package com.cnwu.xml.todb;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.Node;
import org.dom4j.io.SAXReader;

public class XMLWritetoDB
{

public static void main(String[] args) throws DocumentException
{

SAXReader reader = new SAXReader();
Document document = reader.read(new File(
"D:workspacedemo1.3srccomcnwuxmltodbdemo.xml"));
Element element = document.getRootElement();
List<Element> list = element.elements();
Iterator<Element> iterator = list.iterator();
String database = element.getName();
while (iterator.hasNext())
{
Element e = iterator.next();
Iterator itor = e.elementIterator();
while (itor.hasNext())
{
Node idNode = (Node) itor.next();
String value1 = idNode.getText();
Node nameNode = (Node) itor.next();
String value2 = nameNode.getText();
insert(value1,value2);
}
}
}

public static String insert(String value1,String value2)
{
ResultSet rs = null;
ArrayList list = null;
Connection conn = null;
PreparedStatement stmt = null;
try
{
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String username = "scott";
String passwd = "tiger";
conn = DriverManager.getConnection(url,username,passwd);
stmt = conn
.prepareStatement("insert into map(id,name) values(?,?)");
stmt.setString(1,value1);
stmt.setString(2,value2);
stmt.execute();
return "insert successfully.";
}
catch (Exception e)
{
e.printStackTrace();
return e.toString();
}
}

}

//数据库表

//运行结果：

参考连接：http://hi.baidu.com/200770842223/item/21543d57d8b204c49f2667ea?qq-pf-to=pcqq.c2c

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!