用Java实现从Xml抽取数据到关系型数据库

import org.jdom.output.*;
import org.jdom.input.*;
import org.jdom.*;
import java.io.*;
import java.util.*;
import org.jdom.*;
import org.jdom.output.*;
import java.*;
import java.sql.*;
import java.io.*;
import java.math.*;

public class ReadXml {
 public static void main(String[] args) throws Exception {
  SAXBuilder builder = new SAXBuilder();
  Document read_doc = builder.build("TextXml.xml");
  Element stu = read_doc.getRootElement();
  List list = stu.getChildren("用户1");
  System.out.println("=================test===================");
  for (int i = 0; i < list.size(); i++) {
   Element e = (Element) list.get(i);
   String MPID = e.getChildText("MPID");
   String MPSQID = e.getChildText("MPSQID");
   String MPH = e.getChildText("MPH");  
   String MPMC = e.getChildText("MPMC");
   String MPGG = e.getChildText("MPGG");
   String XZQ = e.getChildText("XZQ");
   String PCS = e.getChildText("PCS");
   String JWH = e.getChildText("JWH");
   String TBRQ = e.getChildText("TBRQ");
   String SQR = e.getChildText("SQR");
   String SCCZ = e.getChildText("SCCZ");
   String RESERVATION04 = e.getChildText("RESERVATION04");
   String RESERVATION05 = e.getChildText("RESERVATION05");
  
System.out.println("=================门楼牌数据=====================");
   System.out.println("MPID:" + MPID);
   System.out.println("MPSQID:" + MPSQID);
   System.out.println("MPH:" + MPH);
   System.out.println("MPMC:" + MPMC);
   System.out.println("MPGG:" + MPGG);
   System.out.println("XZQ:" + XZQ);
   System.out.println("PCS:" + PCS);
   System.out.println("JWH:" + JWH);
   System.out.println("TBRQ:" + TBRQ);
   System.out.println("SQR:" + SQR);
   System.out.println("SCCZ:" + SCCZ);
   System.out.println("RESERVATION04:" + RESERVATION04);
   System.out.println("RESERVATION05:" + RESERVATION05);
System.out.println("===============================================");

   String sql = null;
   ResultSet rs = null;   
   try {
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    String xDb_Conn_Str = "jdbc:oracle:thin:@192.168.14.27:1521:nh";
    // 载入jdbc odbc的驱动程序
    String user = "mlp";
    String password = "a";
    Connection conn = DriverManager.getConnection(xDb_Conn_Str,
      user, password); // 连接数据库
    Statement stmt = conn.createStatement(
      ResultSet.TYPE_SCROLL_SENSITIVE,
      ResultSet.CONCUR_UPDATABLE);
    double flag = Math.random();
    MPID = flag + "";
    sql = "insert into t_mlp_mpxxb(MPID,MPSQID,MPH,MPMC,MPGG) "
      + "values('" + MPID + "','" + MPSQID + "','" + MPH + "','" + MPMC +"','" + MPGG + "')";
    System.out.println(sql);
    rs = stmt.executeQuery(sql);    
   } catch (SQLException temp) {
    if (rs != null)
     rs.close();
    temp.printStackTrace();
   }
  }
 }
}