employee.java

来自「j2ee 小例子内容包含 javabean、xml 在java中的应用、 集」· Java 代码 · 共 39 行

package employees;

import java.sql.*;
import javax.xml.parsers.*;
import java.io.*;
import org.w3c.dom.*;
import org.xml.sax.*;

public class Employee {
  public static void main(String[] args) {
    try{
      String empid;
      String empname;
      String sql;
      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@newer","scott","tiger");
      Statement st = con.createStatement();
      File ff = new File("emp1.xml");
      DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
      DocumentBuilder db = dbf.newDocumentBuilder();
      Document d = db.parse(ff);
      NodeList n1 = d.getElementsByTagName("Employee");
      for(int i=0;i<n1.getLength();i++){
        Element node = (Element)n1.item(i);
        empid = node.getElementsByTagName("empid").item(0).getFirstChild().getNodeValue();
        empname = node.getElementsByTagName("empname").item(0).getFirstChild().getNodeValue();
        sql = "insert into emp1 values('"+empid+"','"+empname+"')";
        st.executeUpdate(sql);
      }
      st.close();
      con.close();
      System.out.println("success");
    }catch(Exception em){
      System.out.println(em);
    }
  }

}