java從資料庫中讀取資料產生xml儲存到TreeMap中

標籤：blog   java   os   io   資料   for   ar   cti   

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、擷取connectionString url = "jdbc:mysql://localhost:3306/mydb";Connection conn = DriverManager.getConnection(url,"neo","neo");//3、建立statementStatement stmt =conn.createStatement();//4、利用statement執行sqlString 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 = writer.toString();tm.put(skey, sValue);}conn.close();}catch(Exception e){e.printStackTrace();}}public String getValue(String key){return tm.get(key);}}