ResultSet rs1=ps1.executeQuery(); Element customers=doc.createElement("customers"); while(rs1.next()) { String s_customerID=rs1.getString(1); Element customer=doc.createElement("customer"); Element customerID=doc.createElement("customerID"); Element customerName=doc.createElement("customerName"); Element sex=doc.createElement("sex"); customerID.appendChild(doc.createTextNode(s_customerID)); customerName.appendChild(doc.createTextNode(rs1.getString(2))); sex.appendChild(doc.createTextNode(rs1.getString(3)));
customer.appendChild(customerID); customer.appendChild(customerName); customer.appendChild(sex); System.out.println(s_customerID+"aaaaaaa"+customerName.getFirstChild().getNodeValue()); Element buySet=doc.createElement("buySet"); customer.appendChild(buySet); PreparedStatement ps2=con.prepareStatement("select * from buy where customerID='"+s_customerID+"'"); ResultSet rs2=ps2.executeQuery();
buySet.setAttribute("customerID", s_customerID); while (rs2.next()) { Element buyName=doc.createElement("buyName"); Element amount=doc.createElement("amount"); Element price=doc.createElement("price");
ResultSet rs1=ps1.executeQuery(); Element customers=doc.createElement("customers"); while(rs1.next()) { String s_customerID=rs1.getString(1); Element customer=doc.createElement("customer"); Element customerID=doc.createElement("customerID"); Element customerName=doc.createElement("customerName"); Element sex=doc.createElement("sex"); customerID.appendChild(doc.createTextNode(s_customerID)); customerName.appendChild(doc.createTextNode(rs1.getString(2))); sex.appendChild(doc.createTextNode(rs1.getString(3)));
customer.appendChild(customerID); customer.appendChild(customerName); customer.appendChild(sex); System.out.println(s_customerID+"aaaaaaa"+customerName.getFirstChild().getNodeValue()); Element buySet=doc.createElement("buySet"); customer.appendChild(buySet); PreparedStatement ps2=con.prepareStatement("select * from buy where customerID='"+s_customerID+"'"); ResultSet rs2=ps2.executeQuery();
buySet.setAttribute("customerID", s_customerID); while (rs2.next()) { Element buyName=doc.createElement("buyName"); Element amount=doc.createElement("amount"); Element price=doc.createElement("price");
不过你要自己建个xml文件先
相应的代码在JAVA中调试成功了~~也生成了XML文件~~~
但是就是在JSP中调试不成功~~~我郁闷啊~~
package xml;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;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.DOMResult;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;import org.w3c.dom.Document;
import org.w3c.dom.Element;import util.conManager;public class DBtoXML {
public static void main(String[] args) throws Exception{
DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
DocumentBuilder db=dbf.newDocumentBuilder();
Document doc=db.newDocument();
Connection con=conManager.gerCon();
PreparedStatement ps1=con.prepareStatement("select * from customer");
ResultSet rs1=ps1.executeQuery();
Element customers=doc.createElement("customers");
while(rs1.next())
{
String s_customerID=rs1.getString(1);
Element customer=doc.createElement("customer");
Element customerID=doc.createElement("customerID");
Element customerName=doc.createElement("customerName");
Element sex=doc.createElement("sex");
customerID.appendChild(doc.createTextNode(s_customerID));
customerName.appendChild(doc.createTextNode(rs1.getString(2)));
sex.appendChild(doc.createTextNode(rs1.getString(3)));
customer.appendChild(customerID);
customer.appendChild(customerName);
customer.appendChild(sex);
System.out.println(s_customerID+"aaaaaaa"+customerName.getFirstChild().getNodeValue());
Element buySet=doc.createElement("buySet");
customer.appendChild(buySet);
PreparedStatement ps2=con.prepareStatement("select * from buy where customerID='"+s_customerID+"'");
ResultSet rs2=ps2.executeQuery();
buySet.setAttribute("customerID", s_customerID);
while (rs2.next()) {
Element buyName=doc.createElement("buyName");
Element amount=doc.createElement("amount");
Element price=doc.createElement("price");
buyName.appendChild(doc.createTextNode(rs2.getString(2)));
amount.appendChild(doc.createTextNode(rs2.getString(3)));
price.appendChild(doc.createTextNode(rs2.getString(4)));
buySet.appendChild(buyName);
buySet.appendChild(amount);
buySet.appendChild(price);
}
rs2.close();
customers.appendChild(customer);
}
rs1.close();
con.close();
doc.appendChild(customers);
TransformerFactory tff=TransformerFactory.newInstance();
Transformer tformer=tff.newTransformer();
tformer.transform(new DOMSource(doc), new StreamResult("c://a.xml"));
}}
import java.sql.PreparedStatement;
import java.sql.ResultSet;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.DOMResult;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;import org.w3c.dom.Document;
import org.w3c.dom.Element;import util.conManager;public class DBtoXML {
public static void main(String[] args) throws Exception{
DocumentBuilderFactory dbf=DocumentBuilderFactory.newInstance();
DocumentBuilder db=dbf.newDocumentBuilder();
Document doc=db.newDocument();
Connection con=conManager.gerCon();
PreparedStatement ps1=con.prepareStatement("select * from customer");
ResultSet rs1=ps1.executeQuery();
Element customers=doc.createElement("customers");
while(rs1.next())
{
String s_customerID=rs1.getString(1);
Element customer=doc.createElement("customer");
Element customerID=doc.createElement("customerID");
Element customerName=doc.createElement("customerName");
Element sex=doc.createElement("sex");
customerID.appendChild(doc.createTextNode(s_customerID));
customerName.appendChild(doc.createTextNode(rs1.getString(2)));
sex.appendChild(doc.createTextNode(rs1.getString(3)));
customer.appendChild(customerID);
customer.appendChild(customerName);
customer.appendChild(sex);
System.out.println(s_customerID+"aaaaaaa"+customerName.getFirstChild().getNodeValue());
Element buySet=doc.createElement("buySet");
customer.appendChild(buySet);
PreparedStatement ps2=con.prepareStatement("select * from buy where customerID='"+s_customerID+"'");
ResultSet rs2=ps2.executeQuery();
buySet.setAttribute("customerID", s_customerID);
while (rs2.next()) {
Element buyName=doc.createElement("buyName");
Element amount=doc.createElement("amount");
Element price=doc.createElement("price");
buyName.appendChild(doc.createTextNode(rs2.getString(2)));
amount.appendChild(doc.createTextNode(rs2.getString(3)));
price.appendChild(doc.createTextNode(rs2.getString(4)));
buySet.appendChild(buyName);
buySet.appendChild(amount);
buySet.appendChild(price);
}
rs2.close();
customers.appendChild(customer);
}
rs1.close();
con.close();
doc.appendChild(customers);
TransformerFactory tff=TransformerFactory.newInstance();
Transformer tformer=tff.newTransformer();
tformer.transform(new DOMSource(doc), new StreamResult("c://a.xml"));
}}