或者你看看这个,输出到一个文件里面,看看结果好了。import org.w3c.dom.*;
import org.xml.sax.*;
import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.dom.*;
import javax.xml.transform.sax.*;
import javax.xml.transform.stream.*;
import java.sql.*;
import java.io.*;
import java.util.*;public class Test{public static final String XALAN_INDENT_AMOUNT = "{http://xml.apache.org/xslt}indent-amount";
public static void serialize(Node node, Object out)
throws Exception { // Create the transformer factory
TransformerFactory factory =
TransformerFactory.newInstance(); // Create the transformer object
Transformer serializer = factory.newTransformer(); // Configure the transformer
Properties props = new Properties();
props.put(OutputKeys.METHOD, "xml");
props.put(OutputKeys.INDENT, "yes");
props.put(XALAN_INDENT_AMOUNT, "2");
serializer.setOutputProperties(props); // Create the source and result objects
Source source = new DOMSource(node);
Result result = null;
if (out instanceof String) {
result = new StreamResult((String) out);
} else if (out instanceof File) {
result = new StreamResult((File) out);
} else if (out instanceof OutputStream) {
result = new StreamResult((OutputStream) out);
} else if (out instanceof Writer) {
result = new StreamResult((Writer) out);
} else if (out instanceof ContentHandler) {
result = new SAXResult((ContentHandler) out);
} if (result != null) {
// Ask the serializer to produce the output
serializer.transform(source, result);
}
}
public static void main(String [] args){
Document dataDoc = null; try {
//Create the document builder
DocumentBuilderFactory dbfactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docbuilder = dbfactory.newDocumentBuilder();
//Create the new document(s)
dataDoc = docbuilder.newDocument();
} catch (Exception e) {
System.out.println("Problem creating document: "+e.getMessage());
} Connection db = null;
Statement statement = null;
ResultSet resultset = null;
ResultSetMetaData resultmetadata = null;
Element dataRoot = dataDoc.createElement("visit");
try {
String strConn="jdbc:mysql://localhost/xkp";
String strDriver="org.gjt.mm.mysql.Driver";
String db_usr="root";
String db_password="123455";
Class.forName(strDriver).newInstance();
db = DriverManager.getConnection(strConn,db_usr,db_password);
statement = db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
resultset = statement.executeQuery("select * from test1");
resultmetadata = resultset.getMetaData();
int numCols = resultmetadata.getColumnCount();
while (resultset.next())
{
Element rowEl = dataDoc.createElement("row");
for (int i=1; i <= numCols; i++)
{
//Get name and value
String colName = resultmetadata.getColumnName(i);
String colValue = resultset.getString(i);
Element columnEl = dataDoc.createElement(colName);
columnEl.appendChild(dataDoc.createTextNode(colValue));
rowEl.appendChild(columnEl);
}
//Add the row element to the root
dataRoot.appendChild(rowEl);
}
//Add the root to the document
dataDoc.appendChild(dataRoot);
System.out.println(dataDoc.getDocumentElement().toString());
statement.close(); serialize(dataDoc,new File("Save.xml"));
} catch (Exception e) {
System.out.println("Error: "+e.getMessage());
}
finally
{
try
{
db.close();
}
catch (Exception e)
{
System.out.println("Error closing connection: "+e.getMessage());
}
}
}}
import org.xml.sax.*;
import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.dom.*;
import javax.xml.transform.sax.*;
import javax.xml.transform.stream.*;
import java.sql.*;
import java.io.*;
import java.util.*;public class Test{public static final String XALAN_INDENT_AMOUNT = "{http://xml.apache.org/xslt}indent-amount";
public static void serialize(Node node, Object out)
throws Exception { // Create the transformer factory
TransformerFactory factory =
TransformerFactory.newInstance(); // Create the transformer object
Transformer serializer = factory.newTransformer(); // Configure the transformer
Properties props = new Properties();
props.put(OutputKeys.METHOD, "xml");
props.put(OutputKeys.INDENT, "yes");
props.put(XALAN_INDENT_AMOUNT, "2");
serializer.setOutputProperties(props); // Create the source and result objects
Source source = new DOMSource(node);
Result result = null;
if (out instanceof String) {
result = new StreamResult((String) out);
} else if (out instanceof File) {
result = new StreamResult((File) out);
} else if (out instanceof OutputStream) {
result = new StreamResult((OutputStream) out);
} else if (out instanceof Writer) {
result = new StreamResult((Writer) out);
} else if (out instanceof ContentHandler) {
result = new SAXResult((ContentHandler) out);
} if (result != null) {
// Ask the serializer to produce the output
serializer.transform(source, result);
}
}
public static void main(String [] args){
Document dataDoc = null; try {
//Create the document builder
DocumentBuilderFactory dbfactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docbuilder = dbfactory.newDocumentBuilder();
//Create the new document(s)
dataDoc = docbuilder.newDocument();
} catch (Exception e) {
System.out.println("Problem creating document: "+e.getMessage());
} Connection db = null;
Statement statement = null;
ResultSet resultset = null;
ResultSetMetaData resultmetadata = null;
Element dataRoot = dataDoc.createElement("visit");
try {
String strConn="jdbc:mysql://localhost/xkp";
String strDriver="org.gjt.mm.mysql.Driver";
String db_usr="root";
String db_password="123455";
Class.forName(strDriver).newInstance();
db = DriverManager.getConnection(strConn,db_usr,db_password);
statement = db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
resultset = statement.executeQuery("select * from test1");
resultmetadata = resultset.getMetaData();
int numCols = resultmetadata.getColumnCount();
while (resultset.next())
{
Element rowEl = dataDoc.createElement("row");
for (int i=1; i <= numCols; i++)
{
//Get name and value
String colName = resultmetadata.getColumnName(i);
String colValue = resultset.getString(i);
Element columnEl = dataDoc.createElement(colName);
columnEl.appendChild(dataDoc.createTextNode(colValue));
rowEl.appendChild(columnEl);
}
//Add the row element to the root
dataRoot.appendChild(rowEl);
}
//Add the root to the document
dataDoc.appendChild(dataRoot);
System.out.println(dataDoc.getDocumentElement().toString());
statement.close(); serialize(dataDoc,new File("Save.xml"));
} catch (Exception e) {
System.out.println("Error: "+e.getMessage());
}
finally
{
try
{
db.close();
}
catch (Exception e)
{
System.out.println("Error closing connection: "+e.getMessage());
}
}
}}
连接MySQL啊?
在我这里虽然在ClassPath里面
有MySQL驱动的路径,不过在
TomCat里面用不了,要把那个驱动
copy过去
好像是在Web-inf那个路径里面的
class里面,具体名字我不太记得了。