Jdom读取数据库并生成xml文件示例_

1、Jdom读取数据库并生成xml文件示例_ 1.WriteXml.java: 代码如下: package .csrc.xml; import java.io.File; import java.io.FileWriter; import java.io.IOException; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Arrays; import java.util.L

2、ist; import org.jdom2.Document; import org.jdom2.Element; import org.jdom2.output.Format; import org.jdom2.output.XMLOutputter; import .csrc.jdbc.DatabaseConnection; /* * function 用法Jdom查询数据库把数据写入xml文件中 * author admin * */ public class WriteXml public static void WriterFileToXml() /创建一个xml文件 F

3、ile file = new File(D:/user.xml); /创建数据库连接 Connection conn = DatabaseConnection.getConn(); String sql = select * from user; try Statement st = conn.createStatement();/创建预处理对象 ResultSet rs = st.executeQuery(sql);/获得结果集 Element root = new Element(users);/创建根元素 while (rs.next() Element user = new Eleme

4、nt(user);/创建子元素 root.addContent(user);/添加子元素到根节点 Element id = new Element(ID);/创建叶子节点 id.setText(rs.getString(ID);/给叶子节点赋值 user.addContent(id);/添加叶子节点到父节点 Element ename = new Element(USERNAME); ename.setText(rs.getString(USERNAME);/给叶子节点赋值 user.addContent(ename); Element password = new Element(PASSW

5、ORD);/创建叶子节点 password.setText(rs.getString(PASSWORD);/给叶子节点赋值 user.addContent(password);/添加叶子节点到父节点 Element status = new Element(STATUS); status.setText(rs.getString(STATUS);/给叶子节点赋值 user.addContent(status); Element descn = new Element(DESCN); descn.setText(rs.getString(DESCN);/给叶子节点赋值 user.addConte

6、nt(descn); Document doc = new Document();/创建文本对象 doc.addContent(root);/添加树倒文本中 Format format= Format.getCompactFormat(); format.setIndent( ); XMLOutputter out = new XMLOutputter(format);/创建输出流 FileWriter fw = new FileWriter(file);/写数据 out.output(doc, fw);/输出到xml文件中 fw.close();/关闭写入流 catch (SQLExcept

7、ion e) e.printStackTrace(); catch (IOException e) e.printStackTrace(); public static void main(String args) /把数据库的数据写入xml文件中 WriteXml.WriterFileToXml(); 2.连接数据库java类：DatabaseConnection.java: 代码如下复制代码 package .csrc.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql

8、.SQLException; /* * 连接数据库 * * author admin * */ public class DatabaseConnection private static final String driverName = com.mysql.jdbc.Driver; private static final String url = jdbc:mysql:/localhost/springdb?autoReconnect=trueuseUnicode=truecharacterEncoding=UTF8; private static final String username = root; private static final String password = root; static try Class.forName(driverName); catch (ClassNotFoundException e) e.printStackTrace(); public static Connection getConn() Connection conn = null; try conn = DriverManager.getConnection(url, username, password); catch (SQLException e) e