📄 model.jsp

📁 这是一个基于java
💻 JSP
字号:

<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.xml.transform.*"%>
<%@ page import="javax.xml.transform.stream.*"%>
<%@ page import="javax.xml.transform.dom.*"%>
<%@ page import="org.w3c.dom.*"%>
<%@ page import="javax.xml.parsers.*"%>
<%@ page import="java.io.*"%>
<html><head></head><body>
<%
           try{
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection con=DriverManager.getConnection("jdbc:odbc:example");
              Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
              ResultSet rs=st.executeQuery("select * from Client");
              rs.last();
              int j=rs.getRow();
              String str1[]=new String[j];
              String str2[]=new String[j];
              String str3[]=new String[j];
              String str4[]=new String[j];
              String str5[]=new String[j];
              rs=st.executeQuery("select * from Client");
               int i=0;
              while(rs.next()){
                 str1[i]=rs.getString(1);
                 str2[i]=rs.getString(2);
                 str3[i]=rs.getString(3);
                 str4[i]=rs.getString(4);
                 str5[i]=rs.getString(5);
                 i++;
               }
               
               DocumentBuilderFactory factory=DocumentBuilderFactory.newInstance();
          DocumentBuilder builder=factory.newDocumentBuilder();
          Document document=builder.newDocument();
          document.setXmlVersion("1.0");
          Element Client=document.createElement("Client");
          document.appendChild(Client);
          for(int k=1;k<=str1.length;k++){
                    Client.appendChild(document.createElement("client"));
                 }  
          NodeList nodeList=document.getElementsByTagName("client");
                 int size=nodeList.getLength();
                 for(int k=0;k<size;k++){
                    Node node=nodeList.item(k);
                    if(node.getNodeType()==Node.ELEMENT_NODE)
                        {
                          Element elementNode=(Element)node;
                          elementNode.appendChild(document.createElement("client_name"));
                          elementNode.appendChild(document.createElement("client_address"));
                          elementNode.appendChild(document.createElement("client_phone"));
                          elementNode.appendChild(document.createElement("client_love"));
                          elementNode.appendChild(document.createElement("client_job"));
                        }
                      }  
                   nodeList=document.getElementsByTagName("client_name");
                   size=nodeList.getLength();
                   for(int k=0;k<size;k++){
                      Node node=nodeList.item(k);
                      if(node.getNodeType()==Node.ELEMENT_NODE){
                         Element elementNode=(Element)node;
                         elementNode.appendChild(document.createTextNode(str1[k]));
                      }
                  }
                   nodeList=document.getElementsByTagName("client_address");
                   size=nodeList.getLength();
                   for(int k=0;k<size;k++){
                      Node node=nodeList.item(k);
                      if(node.getNodeType()==Node.ELEMENT_NODE){
                         Element elementNode=(Element)node;
                         elementNode.appendChild(document.createTextNode(str2[k]));
                      }
                  }     
                 nodeList=document.getElementsByTagName("client_phone");
                   size=nodeList.getLength();
                   for(int k=0;k<size;k++){
                      Node node=nodeList.item(k);
                      if(node.getNodeType()==Node.ELEMENT_NODE){
                         Element elementNode=(Element)node;
                         elementNode.appendChild(document.createTextNode(str3[k]));
                      }
                  }    
               nodeList=document.getElementsByTagName("client_love");
                   size=nodeList.getLength();
                   for(int k=0;k<size;k++){
                      Node node=nodeList.item(k);
                      if(node.getNodeType()==Node.ELEMENT_NODE){
                         Element elementNode=(Element)node;
                         elementNode.appendChild(document.createTextNode(str4[k]));
                      }
                  }    
               nodeList=document.getElementsByTagName("client_job");
                   size=nodeList.getLength();
                   for(int k=0;k<size;k++){
                      Node node=nodeList.item(k);
                      if(node.getNodeType()==Node.ELEMENT_NODE){
                         Element elementNode=(Element)node;
                         elementNode.appendChild(document.createTextNode(str5[k])); 
                      }
                  }    
            TransformerFactory transFactory=TransformerFactory.newInstance();
            Transformer transformer=transFactory.newTransformer();
            DOMSource domSource=new DOMSource(document); 
           
            File file=new File("C:/Apache Software Foundation/Tomcat 5.5/webapps/Example/Client.xml");
            
            StreamResult xmlResult=new StreamResult(new FileOutputStream(file));
            transformer.transform(domSource,xmlResult);
            }
          catch(Exception e){
              out.println(e);
         }
     
          out.println("数据库最新的信息已经被加载到了XML文件了");
%>

<body></html>
⌨️ 快捷键说明

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