📄 dbtoxml.jsp

📁 J2EE独立开发制作
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*,javax.xml.parsers.*,org.w3c.dom.*,java.io.*" %>
<%@ page import="javax.xml.transform.*,javax.xml.transform.dom.DOMSource,javax.xml.transform.stream.StreamResult" %>
<HTML>
<HEAD> 
<TITLE>用DOM实现数据库到XML的转换</TITLE> 
</HEAD> 
<BODY>
<% 
    Document doc;
    Element people = null;
    Element person = null; 
    Element name = null; 
    Element address = null; 
    Element email = null; 


    try{
            Class.forName("org.gjt.mm.mysql.Driver");
            String dbURL =
 "jdbc:mysql://localhost/company?useUnicode=true&characterEncoding=GB2312";
            String username = "root";
            String password = "sun";
       Connection con = DriverManager.getConnection(dbURL, username, password);
       Statement stmt = con.createStatement();
      ResultSet results = stmt.executeQuery("SELECT * FROM employee");  
      DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();
      DocumentBuilder builder=dbf.newDocumentBuilder();
      doc = builder.newDocument();
      people = doc.createElement("PEOPLE"); 
      while (results.next()) { 
        person = doc.createElement("PERSON");
        people.appendChild(person);
        name = doc.createElement("NAME");
        name.appendChild(doc.createTextNode(results.getString("name")));
        person.appendChild(name);

        address = doc.createElement("ADDRESS");
        address.appendChild(doc.createTextNode(results.getString("address")));
        person.appendChild(address);


        email = doc.createElement("EMAIL");
        email.appendChild(doc.createTextNode(results.getString("email")));
        person.appendChild(email);
      }
      doc.appendChild(people);
      System.setProperty("javax.xml.transform.TransformerFactory", "com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl");
      TransformerFactory tFactory =TransformerFactory.newInstance(); 
Transformer transformer = tFactory.newTransformer(); 
DOMSource source = new DOMSource(doc); 
StreamResult result = new StreamResult(new java.io.File("webapps/dbtoxml/employee.xml")); 
transformer.transform(source, result); 

      
        
        }
        catch(SQLException e){
            System.out.println(e);
        }
        //catch(Exception e){
           // System.out.println(e);
        //}
        
 
 %>
 <a href="./employee.xml">点击打开产生的XML文档 </a></BODY>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -