————存个档，自用———–
import java.sql.*;
import javax.xml.transform.*;
import javax.xml.transform.dom.*;
import javax.xml.transform.stream.*;import org.w3c.dom.*;
import javax.xml.parsers.*;
import java.io.*;public class access {
public static void main(String[] args) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=
DriverManager.getConnection("jdbc:odbc:test");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from 用户表");
int i=0,j=0;
while(rs.next()) j++;
String str1[]=new String[j];
String str2[]=new String[j];
String str3[]=new String[j];
rs=st.executeQuery("select * from 用户表");
while (rs.next()){
str1[i]=rs.getString(1);
str2[i]=rs.getString(2);
str3[i]=rs.getString(3);
i++;
}
DocumentBuilderFactory domFactory=
DocumentBuilderFactory.newInstance();
DocumentBuilder dom=
domFactory.newDocumentBuilder();
Document doc=dom.newDocument();
doc.setXmlVersion("1.0");
Element 用户表=doc.createElement("用户表");
doc.appendChild(用户表);
for(i=0;i<str1.length;i++){
用户表.appendChild(doc.createElement("用户"));
}NodeList nl=doc.getElementsByTagName("用户");
int size=nl.getLength();for(i=0;i<size;i++){
Node node=nl.item(i);
if(node.getNodeType()==Node.ELEMENT_NODE){
Element elementNode=(Element)node;
elementNode.appendChild(doc.createElement("姓名"));
elementNode.appendChild(doc.createElement("密码"));
elementNode.appendChild(doc.createElement("权限"));
}
}
NodeList nl1=doc.getElementsByTagName("姓名");
for(i=0;i<nl1.getLength();i++){
Node node=nl1.item(i);
if(node.getNodeType()==Node.ELEMENT_NODE){
Element elementNode=(Element)node;
elementNode.appendChild(doc.createTextNode(str1[i]));
}
}
nl1=doc.getElementsByTagName("密码");
for(i=0;i<nl1.getLength();i++){
Node node=nl1.item(i);
if(node.getNodeType()==Node.ELEMENT_NODE){
Element elementNode=(Element)node;
elementNode.appendChild(doc.createTextNode(str2[i]));
}
}
nl1=doc.getElementsByTagName("权限");
for(i=0;i<nl1.getLength();i++){
Node node=nl1.item(i);
if(node.getNodeType()==Node.ELEMENT_NODE){
Element elementNode=(Element)node;
elementNode.appendChild(doc.createTextNode(str3[i]));
}
}
TransformerFactory transf=TransformerFactory.newInstance();
Transformer trans=transf.newTransformer();
Source in=new DOMSource(doc);
Result out=new StreamResult(new FileOutputStream("用户表.xml"));
trans.transform(in,out);
}
catch (Exception e){
e.printStackTrace();
}
}
}
——-jdk1.6 配置存档——-
Path
C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\Program Files\VistaMaster;C:\Program Files\Java\jdk1.6.0_13\bin
classpath
C:\Program Files\Java\jdk1.6.0_13\lib\dt.jar;C:\Program Files\Java\jdk1.6.0_13\lib\tools.jar;.
坐上沙发