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());
}
}