xml2db.java

使用dom2,sax2解析xml,使用解析器生成、转化xml

package xmloperation;
import java.sql.*;
import javax.xml.parsers.*;
import org.w3c.dom.*;

public class xml2db
{
  static Connection con;
  static String name,address,tel,fax,email,sql;

  public xml2db() {}

  public static void main(String[] args)
  {
    try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection("jdbc:odbc:SocketTest","liu","liu");
      Statement stmt = con.createStatement();

      DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
      DocumentBuilder builder = factory.newDocumentBuilder();
      Document doc = builder.parse("candidate.xml");

      NodeList nl = doc.getElementsByTagName("PERSON");

      for(int i = 0; i < nl.getLength(); i++)
      {
        Element node = (Element)nl.item(i);

        name = node.getElementsByTagName("NAME").item(0).getFirstChild().getNodeValue();
        address = node.getElementsByTagName("ADDRESS").item(0).getFirstChild().getNodeValue();
        tel = node.getElementsByTagName("TEL").item(0).getFirstChild().getNodeValue();
        fax = node.getElementsByTagName("FAX").item(0).getFirstChild().getNodeValue();
        email = node.getElementsByTagName("EMAIL").item(0).getFirstChild().getNodeValue();
        sql = "insert into people values(\'" + name + "\',\'" + address + "\',\'" + tel + "\',\'" + fax + "\',\'" + email + "\')";
        int rec = stmt.executeUpdate(sql);
      }
      stmt.close();
      con.close();
    }
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
}