使用Jdom查询数据库后，把数据写入xml文件中

来源：互联网发布：c语言 const 编辑：程序博客网时间：2024/05/22 13:27

1.WriteXml.java:

package cn.gov.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.List;import org.jdom2.Document;import org.jdom2.Element;import org.jdom2.output.Format;import org.jdom2.output.XMLOutputter;import cn.gov.csrc.jdbc.DatabaseConnection;/** * @function 使用Jdom查询数据库把数据写入xml文件中 * @author admin *  */public class WriteXml {public static void WriterFileToXml(){//创建一个xml文件File 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 Element("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("PASSWORD");//创建叶子节点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.addContent(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 (SQLException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}}public static void main(String[] args) {//把数据库的数据写入xml文件中WriteXml.WriterFileToXml();}}

2.连接数据库java类：DatabaseConnection.java:

package cn.gov.csrc.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.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=true&useUnicode=true&characterEncoding=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.printStackTrace();}return conn;}public static void main(String[] args) {Connection conn = getConn();System.out.println(conn);}}

0 0