|
<%@page contentType="text/html;charset=GBK"%>
<HTML>
<HEAD>
<TITLE>用JDOM實現數據庫到XML的轉換</TITLE>
</HEAD>
<BODY>
<%@page import="org.jdom.*"%>
<%@page import="java.*"%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();??
String url="jdbc:microsoft:sqlserver://10.40.14.54:1433;DatabaseName=DB_CUSTOM";
//載入jdbc odbc的驅動程序
String user="lgz";
String password="lgz";
Connection conn= DriverManager.getConnection(url,user,password);?? //連接數據庫
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);??
//創建一個statement
String sql="select * from client";?? //定義查詢的SQL語句
ResultSet rs=stmt.executeQuery(sql);?? //執行查詢
Document document=new Document(new Element("聯系人列表"));//創建文檔
ResultSetMetaData rsmd = rs.getMetaData();? //獲取字段名
int numberOfColumns = rsmd.getColumnCount(); //獲取字段數
?int i=0;
?while(rs.next()){ //將查詢結果取出???????????????????????
??? Element element0=new Element("聯系人");? //創建元素 生成JDOM樹
??? document.getRootElement().addContent(element0);
??? for (i=1; i<=numberOfColumns;i++)
?{?? String date=new String(rs.getString(i).getBytes("ISO-8859-1"),"gb2312"); //代碼轉換
??? Element element=new Element(rsmd.getColumnName(i)).setText(date);
element0.addContent(element);
?}??
? }
?rs.close();??????????????????????????? //關閉結果集
?stmt.close();?????????????????????????????? //關閉statement
conn.close();?????????????????????????? //關閉連接
XMLOutputter outp = new XMLOutputter();
outp.output(document, new FileOutputStream("d:\\data.xml")); //輸出XML文檔
out.print("XML 文檔生成完畢！");
%>
<a href="file:///d|/data.xml">點擊打開產生的XML文檔 </a>
</BODY>
</HTML>
|