研究这XML写了一点错误的东西,请这里大虾们给改改啊.
谢.
以下这段代码只能读一行数据,"如果用另一个方法是可以全部读出来"不想使用
用以下一段代码怎么才能让它正常使用呢.谢谢了,一直在线等待import java.io.FileWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.Format;
import org.jdom.output.XMLOutputter;public class create_xml_sql
{ private Element Customer, oid, price, actual, tel; private String url = "jdbc:mysql://localhost/demo"; private Connection con = null; private Statement stm = null; private ResultSet rs = null; public create_xml_sql()
{
System.out.println("Open the DB.........");
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url, "root", "root");
stm = con.createStatement();
rs = stm.executeQuery("select * from demo_por"); Customer = new Element("customer"); Document mydocument = new Document(Customer); if (rs.next())
{
oid = new Element("oid");
price = new Element("pric");
actual = new Element("actual");
tel = new Element("tel"); oid.addContent(rs.getString("oid"));
price.addContent(rs.getString("price"));
actual.addContent(rs.getString("actual"));
tel.addContent(rs.getString("tel")); Customer.addContent(oid);
Customer.addContent(price);
Customer.addContent(actual);
Customer.addContent(tel);
}
XMLOutputter xml = new XMLOutputter();
FileWriter writer = new FileWriter("d:\\create.xml");
Format f = Format.getPrettyFormat();
xml.setFormat(f);
xml.output(mydocument, writer);
System.out.println("ok");
writer.close();
} catch (Exception e)
{
e.printStackTrace();
System.out.println(e);
}
} /**
* @param args
*/
public static void main(String[] args)
{
// TODO Auto-generated method
// stub
create_xml_sql sql = new create_xml_sql();
}}
谢.
以下这段代码只能读一行数据,"如果用另一个方法是可以全部读出来"不想使用
用以下一段代码怎么才能让它正常使用呢.谢谢了,一直在线等待import java.io.FileWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.Format;
import org.jdom.output.XMLOutputter;public class create_xml_sql
{ private Element Customer, oid, price, actual, tel; private String url = "jdbc:mysql://localhost/demo"; private Connection con = null; private Statement stm = null; private ResultSet rs = null; public create_xml_sql()
{
System.out.println("Open the DB.........");
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url, "root", "root");
stm = con.createStatement();
rs = stm.executeQuery("select * from demo_por"); Customer = new Element("customer"); Document mydocument = new Document(Customer); if (rs.next())
{
oid = new Element("oid");
price = new Element("pric");
actual = new Element("actual");
tel = new Element("tel"); oid.addContent(rs.getString("oid"));
price.addContent(rs.getString("price"));
actual.addContent(rs.getString("actual"));
tel.addContent(rs.getString("tel")); Customer.addContent(oid);
Customer.addContent(price);
Customer.addContent(actual);
Customer.addContent(tel);
}
XMLOutputter xml = new XMLOutputter();
FileWriter writer = new FileWriter("d:\\create.xml");
Format f = Format.getPrettyFormat();
xml.setFormat(f);
xml.output(mydocument, writer);
System.out.println("ok");
writer.close();
} catch (Exception e)
{
e.printStackTrace();
System.out.println(e);
}
} /**
* @param args
*/
public static void main(String[] args)
{
// TODO Auto-generated method
// stub
create_xml_sql sql = new create_xml_sql();
}}
<oid></oid>
<pric></pric>
<actual></actual>
<tel></tel>
<oid></oid>
<pric></pric>
<actual></actual>
<tel></tel>
</customer>我认为应改为:<customers>
<customer>
<oid></oid>
<pric></pric>
<actual></actual>
<tel></tel>
</customer>
<customer>
<oid></oid>
<pric></pric>
<actual></actual>
<tel></tel>
</customer>
</customer>Element root = new Element("customers");
Document mydocument = new Document(root);
if (rs.next()) {
Element customer = new Element("customer");
oid = new Element("oid");
price = new Element("pric");
actual = new Element("actual");
tel = new Element("tel"); oid.addContent(rs.getString("oid"));
price.addContent(rs.getString("price"));
actual.addContent(rs.getString("actual"));
tel.addContent(rs.getString("tel")); customer.addContent(oid);
customer.addContent(price);
customer.addContent(actual);
customer.addContent(tel); root.addContent(customer);
}