我要做一个按钮,当单击此按钮时,后台会自动生成一个XML文件。不知该如何实现?下面是java代码:
import org.jdom.*;
import org.jdom.output.*;
import java.sql.*;
import java.io.*;
public class SQLServer {
public SQLServer () {
}
public static void main(String[] args) throws Exception {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url ="jdbc:microsoft:sqlserver://localhost:1433;databaseName=Projects;selectMethod=cursor;";
Connection conn = DriverManager.getConnection(url, "sa", "");
PreparedStatement pstmt = conn.prepareStatement(
"select * from project ", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = pstmt.executeQuery();
ResultSetMetaData rmd = rs.getMetaData();
Document document = new Document(new Element("Project"));
//创建文档ROOT元素
int colcount = rmd.getColumnCount();
while (rs.next()) {
Element RowElement = new Element("ROW");
for (int i = 1; i <= colcount; i++) {
Element TempElement=new Element(rmd.getColumnName(i).toString());
TempElement.setText(rs.getString(i));
RowElement.addContent(TempElement);
}
document.getRootElement().addContent(RowElement);
}
rs.close();
pstmt.close();
conn.close();
XMLOutputter outp = new XMLOutputter(Format.getPrettyFormat());
//格式华输出,产生缩进和换行
Format format = outp.getFormat();
format.setEncoding("UTF-8"); //设置语言
format.setExpandEmptyElements(true);
//设置输出空元素为<sample></sample>格式
outp.setFormat(format);
outp.output(document, new FileOutputStream("SQLServer.xml"));
//输出XML文档
System.out.print("XML文档生成完毕!");
}
}
import org.jdom.*;
import org.jdom.output.*;
import java.sql.*;
import java.io.*;
public class SQLServer {
public SQLServer () {
}
public static void main(String[] args) throws Exception {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url ="jdbc:microsoft:sqlserver://localhost:1433;databaseName=Projects;selectMethod=cursor;";
Connection conn = DriverManager.getConnection(url, "sa", "");
PreparedStatement pstmt = conn.prepareStatement(
"select * from project ", ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = pstmt.executeQuery();
ResultSetMetaData rmd = rs.getMetaData();
Document document = new Document(new Element("Project"));
//创建文档ROOT元素
int colcount = rmd.getColumnCount();
while (rs.next()) {
Element RowElement = new Element("ROW");
for (int i = 1; i <= colcount; i++) {
Element TempElement=new Element(rmd.getColumnName(i).toString());
TempElement.setText(rs.getString(i));
RowElement.addContent(TempElement);
}
document.getRootElement().addContent(RowElement);
}
rs.close();
pstmt.close();
conn.close();
XMLOutputter outp = new XMLOutputter(Format.getPrettyFormat());
//格式华输出,产生缩进和换行
Format format = outp.getFormat();
format.setEncoding("UTF-8"); //设置语言
format.setExpandEmptyElements(true);
//设置输出空元素为<sample></sample>格式
outp.setFormat(format);
outp.output(document, new FileOutputStream("SQLServer.xml"));
//输出XML文档
System.out.print("XML文档生成完毕!");
}
}
楼主【wga0feng】截止到2008-07-11 17:11:21的历史汇总数据(不包括此帖):
发帖的总数量:12 发帖的总分数:120 每贴平均分数:10
回帖的总数量:6 得分贴总数量:0 回帖的得分率:0%
结贴的总数量:12 结贴的总分数:120
无满意结贴数:6 无满意结贴分:130
未结的帖子数:0 未结的总分数:0
结贴的百分比:100.00% 结分的百分比:100.00%
无满意结贴率:50.00 % 无满意结分率:108.33%
敬礼!