Question

用jdom将数据库中的数据表转换为xml的纯java代码

如题了，希望大家帮帮忙，小弟新注册的没什么积分。。
就是用纯java代码实现从oracle读取表并转换为xml文档输出，重点是怎么转换为xml~

Answer 1

我用的mysql数据库，自己把配置改成orcale import java.io.FileOutputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.jdom.Element; import org.jdom.Document; import org.jdom.output.XMLOutputter; public class CreateXml { /** * @param args * @throws ClassNotFoundException * @throws SQLException */ public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql:///myProject","root",""); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select * from login"); try{ Element root = new Element("list"); Document Doc = new Document(root); int i=0; while(rs.next()) { Element elements = new Element("login"); elements.setAttribute("id", "" + i); elements.addContent(new Element("username").setText(rs.getString(1))); elements.addContent(new Element("password").setText(rs.getString(2))); root.addContent(elements); i++; } XMLOutputter XMLOut = new XMLOutputter(); XMLOut.output(Doc, new FileOutputStream("c:/login.xml")); }catch(Exception e){ e.printStackTrace(); } } }