首页 > 代码库 > java从数据库中读取数据生成xml保存到TreeMap中
java从数据库中读取数据生成xml保存到TreeMap中
package data;import java.io.StringWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.HashMap;import javax.xml.parsers.DocumentBuilder;import javax.xml.parsers.DocumentBuilderFactory;import javax.xml.transform.Transformer;import javax.xml.transform.TransformerFactory;import javax.xml.transform.dom.DOMSource;import javax.xml.transform.stream.StreamResult;import org.w3c.dom.Document;import org.w3c.dom.Element;public class DataSet { private HashMap<String,String> tm = new HashMap<String,String>(); public void init() { try{ //1.加载驱动 Class.forName("com.mysql.jdbc.Driver"); //2、获取connection String url = "jdbc:mysql://localhost:3306/mydb"; Connection conn = DriverManager.getConnection( url,"neo","neo"); //3、创建statement Statement stmt =conn.createStatement(); //4、利用statement执行sql String sql = "select id, name, sex, age from user"; ResultSet rs = stmt.executeQuery(sql); DocumentBuilderFactory dFact = DocumentBuilderFactory.newInstance(); DocumentBuilder build = dFact.newDocumentBuilder(); TransformerFactory tFact = TransformerFactory.newInstance(); while(rs.next()){ Document doc = build.newDocument(); Element user = doc.createElement("user"); doc.appendChild(user); Element name = doc.createElement("name"); name.appendChild(doc.createTextNode(rs.getString(2))); user.appendChild(name); Element sex = doc.createElement("sex"); sex.appendChild(doc.createTextNode(rs.getString(3))); user.appendChild(sex); Element age = doc.createElement("age"); age.appendChild(doc.createTextNode(rs.getString(4))); user.appendChild(age); Transformer trans = tFact.newTransformer(); StringWriter writer = new StringWriter(); StreamResult result = new StreamResult(writer); DOMSource source = new DOMSource(doc); trans.transform(source, result); String skey = rs.getString(1); String sValue = http://www.mamicode.com/writer.toString();>
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。