import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class ResultSetToXML {
/**
* @param ResultSet
* rs输入的结果集
* @return String 返回XML串
* @exception SQLException
*/
public String generateXML(final ResultSet rs) throws SQLException {
final StringBuffer buffer = new StringBuffer(1024 * 4);
if (rs == null)
return "";
buffer.append("<?xml version=\"1.0\" encoding=\"GB2312\"?>\n"); // XML的头部信息
buffer.append("<ResultSet>\n");
ResultSetMetaData rsmd = rs.getMetaData(); // 得到结果集的定义结构
int colCount = rsmd.getColumnCount(); // 得到列的总数
// 对放回的全部数据逐一处理
for (int id = 1; rs.next(); id++) {
// 格式为row id , col name, col context
buffer.append("\t<row id=\"").append(id).append("\">\n");
for (int i = 1; i <= colCount; i++) {
String type = rsmd.getColumnTypeName(i); // 获取字段类型
buffer.append("\t\t<col name=\"" + rsmd.getColumnName(i)
+ "\">");
buffer.append(getValue(rs, i, type));
buffer.append("</col>\n");
}
buffer.append("\t</row>\n");
}
buffer.append("</RowSet>");
rs.close();
return buffer.toString();
}
/**
* This method gets the value of the specified column
* 通用的读取结果集某一列的值并转化为String表达
*
* @param ResultSet
* rs 输入的纪录集
* @param int
* colNum 第几列
* @param int
* type 数据类型
*/
private String getValue(final ResultSet rs, int colNum, String type)
throws SQLException {
Object value = null;
if (type.equals("nchar") || type.equals("nvarchar"))
value = rs.getString(colNum);
else
value = rs.getObject(colNum);
if (value != null)
return value.toString().trim();
return "null";
}
public static void main(String args[]) {
ResultSet result;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:MyDataSource", "sa", "123456");
// 普通查询
Statement stat = con.createStatement();
result = stat.executeQuery("Select * from Orders");
JDBCToXML obj = new JDBCToXML();
String res = obj.generateXML(result);
FileOutputStream fswriter = new FileOutputStream("result.xml", true);
fswriter.write(res.getBytes());
fswriter.close();
con.close();
} catch (Exception e) {
System.out.println("Error" + e);
}
}
}