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

一时失言乱红尘 2024-02-17 14:21 30阅读 0赞

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);
    	}
    }