從數(shù)據庫讀取數(shù)據，并生成xml文檔
public void createXMLFile(String tableName, String sql, String filePath) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection
conn=DriverManager.getConnection("jdbc:oracle:thin:@IP:端口號:serviceName", 用戶名, 密碼);
IDatabaseConnection connection = new DatabaseConnection(conn);
QueryDataSet query = new QueryDataSet(connection);
query.addTable(tableName, sql);
XmlDataSet.write(query, new FileOutputStream(filePath));
}
util.createXMLFile("tbl_XXX", "select * from tbl_XXX where fileds in ('','') ", "E://file1.xml");
posted on 2013-01-08 15:10
JavaBird 閱讀(210)
評論(0) 編輯 收藏 所屬分類:
JAVA