采用jdom生成xml

来源：互联网发布：opera连不上网络编辑：程序博客网时间：2024/06/06 01:20

首先采用jdom时要导入jdom的架包

package com.hait.createXml;

import org.jdom.*;
import java.sql.*;

import   org.jdom.output.XMLOutputter;
import   java.io.*;
import   java.util.Date;

public class XMLSpeed {

    public   void   process()   throws   Exception   {
        //载入jdbc   的驱动程序
        Connection   con;
        Class.forName("com.mysql.jdbc.Driver");

       con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/mydata?user=root&password=123456&useUnicode=true&characterEncoding=utf-8");    //连接数据库

        //创建一个statement
        Statement   stmt   =   con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

        String   sql   =   "select * from sun_commentmessage";   //定义查询的SQL语句

        ResultSet   rs   = stmt.executeQuery(sql);   //执行查询

        Document   document   =   new   Document(new   Element("PingLunInfos"));   //创建文档

        ResultSetMetaData   rsmd   =   rs.getMetaData();   //获取字段名

        int   numberOfColumns   =   rsmd.getColumnCount();   //获取字段数

        int   i   =   0,j=0;

        while(rs.next()){   //将查询结果取出
            j=j+1;
            //System.out.println(j);
            Element   element0   =   new   Element("PingLunInfo");   //创建元素   生成JDOM树
            document.getRootElement().addContent(element0);

            for   (i   =   1;   i   <=   numberOfColumns;   i++)   {
                String   OrgDate   =   rs.getString(i);
                 System.out.println(OrgDate);

                String   date   =   " ";
                if   (null   !=   OrgDate)   {
                    date   =   new   String(OrgDate.getBytes("UTF-8"), "UTF-8");   //代码转换
                }

                Element   element   =   new   Element(rsmd.getColumnName(i)).setText(date);
                element0.addContent(element);
            }
        }








                       rs.close();   //关闭结果集
                        stmt.close();   //关闭statement
                       con.close();   //关闭连接
        XMLOutputter   outp   =   new   XMLOutputter();

        outp.output(document,   new   FileOutputStream( "d:\\data.xml "));   //输出XML文档

}

    public   static   void   main(String[]   args)   {

        Date   x=   new   Date();

        XMLSpeed   xml =   new   XMLSpeed();

      try{
            xml.process();

        }catch(Exception   e){

        e.printStackTrace();
        }
      // System.out.println( "start   time= "+x);

     //   System.out.println( "--end   time= "+new   Date());
    }

}