import org.jdom.output.*;
import org.jdom.input.*;
import org.jdom.*;
import java.io.*;
import java.lang.*;
import java.util.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.*;
public class Testxml {
String sql="";
String colName = "";
String sDBDriver = "";
String url = "";
String username="";
String password="";
private Connection conn ;
private Statement stmt ;
private ResultSet rs ;
public Testxml()
{
conn = null;
stmt = null;
//sDBDriver = "org.gjt.mm.mysql.Driver";
//url = "jdbc:mysql://localhost:3306/sgsite";
sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=database_tab";
username = "sa";
password = "123";
//username = "root";
//password = "123321";
sql = " select * from person ";
}
public void BuildXMLDoc() throws IOException,SQLException{
try{
//Class.forName( "org.gjt.mm.mysql.Driver" );
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
conn = DriverManager.getConnection(url, username, password );
stmt = conn.createStatement(); ///创建语句对象
rs = stmt.executeQuery(sql);
//System.out.println("数据库连接成功！");
}
catch(Exception sqlexception){
sqlexception.printStackTrace();
System.out.println("数据库连接发生异常！");
}
try{
Document document=new Document(new Element("alluserinfo")); //创建文档
ResultSetMetaData rsmd = rs.getMetaData(); //获取字段名
String fieldName = "";
int i=0;
int numberOfColumns = rsmd.getColumnCount(); //获取字段数
System.out.println(numberOfColumns);
while(rs.next()) //将查询结果取出
{
System.out.println("fdsfsd");
Element element0=new Element("userinfo"); //创建元素 生成JDOM树
document.getRootElement().addContent(element0);
//Element element2=new Element("userphone");
//element0.addContent(element2);
//Element element3=new Element("useraddress");
//element0.addContent(element3);
for(i=1; i<=numberOfColumns ;i++)
{
//colName=new String(rs.getString(i).getBytes("ISO-8859-1"),"gb2312"); //代码转换
colName = rs.getString(i);
// if(i>4&&i<8)//userinfo表中的第5,6,7个字段归为phone节点
// {
// Element element=new Element(rsmd.getColumnName(i)).setText(colName);
// // element2.addContent(element);
// }
// else if(i>7&&i<=9)//第8，第9个字段归为address节点
// {
// Element element=new Element(rsmd.getColumnName(i)).setText(colName);
// //element3.addContent(element);
// }
// else
// {
// Element element=new Element(rsmd.getColumnName(i)).setText(colName);
// element0.addContent(element);
// }
Element element=new Element(rsmd.getColumnName(i)).setText(colName);
element0.addContent(element);
}
}
//XMLOutputter outp = new XMLOutputter();//新元素不自动换行
XMLOutputter outp = new XMLOutputter();
outp.output(document, new FileOutputStream("e:\\userinfo.xml")); //输出XML文档
}
catch (Exception exp)
{
System.out.print("XML 文档生成失败！");
}
rs.close(); //关闭结果集
stmt.close(); //关闭statement
conn.close();
}
public static void main(String[] args) throws Exception
{
Testxml ex = new Testxml();
try
{
ex.BuildXMLDoc();
}
catch (Exception exp2)
{
System.out.print("调用异常！");
}
}
}
