toxml.java

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

import java.sql.*;
import org.w3c.dom.*;
import org.apache.xerces.dom.*;
import org.apache.xml.serialize.*;
import java.io.*;
public class TOXML
{
       public static void main (String arg [])
       {
               
                        try 
               {
                        String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
			String sConnStr="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=Lujing1.mdb";
			Connection conn=null;
			try
			{
				Class.forName(sDBDriver);
				conn=DriverManager.getConnection(sConnStr); 
			}
			catch(Exception e)
			{
				e.printStackTrace();
			}
			System.out.println("connection success!");
			Statement stmt = conn.createStatement ();
			System.out.println("connection success!"); 
			String sql = "SELECT ID FROM Lujing order by ID";
		//	System.out.println("sql success!");
                       //执行查询，查询结果放在ResultSet的对象中
                       ResultSet lujingRS = stmt.executeQuery (sql);
               //        System.out.println("sql success!");
                       String OUTPUTFILE = "f:\\lujing.xml";
                       Document xmlDoc = buildLujingXML (lujingRS);
                       File outputFile = new File(OUTPUTFILE);
                       printDOM (xmlDoc, outputFile);
                       conn.close (); 
                        } 
                     //找不到驱动程序，捕捉异常。如发生该错误，请检查JDK版本是不是在1.1以上
                       catch (ClassNotFoundException e)
                        {
                          System.out.println("错误："+ e);
                        }
                       catch (SQLException e)
                        {
                          System.out.println("错误："+ e);
                        }
                       catch (Exception e)
                        {
                          System.out.println("错误："+ e);
                        } 
           }


private static Document buildLujingXML (ResultSet _lujingRS) throws Exception
  {
   Document xmlDoc=new DocumentImpl ();
   Element rootElement=xmlDoc.createElement ("LUJINGRS");
   xmlDoc.appendChild (rootElement);
   while (_lujingRS.next ())
      {
        Element lujing=xmlDoc.createElement ("LUJING");
        lujing.setAttribute ("ID", _lujingRS.getString ("ID"));
       
        rootElement.appendChild (lujing);
       }
        return xmlDoc;
    }
 
private static void printDOM(Document _xmlDoc, File _outputFile) throws Exception
  {
    OutputFormat outputFormat = new OutputFormat ("XML","gb2312", true);
    FileWriter fileWriter = new FileWriter (_outputFile);
    XMLSerializer xmlSerializer = new XMLSerializer (fileWriter, outputFormat);
    xmlSerializer.asDOMSerializer ();
    xmlSerializer.serialize (_xmlDoc.getDocumentElement ());
   }
 }