java genrate xml file use data from database
来源:互联网 发布:安卓软件编程工具 编辑:程序博客网 时间:2024/05/21 23:38
public static void main(String[] args) {
Connection con = ConDB.Con();
PreparedStatement pst = null;
ResultSet rs = null;
String colName;
try {
pst = con.prepareStatement("SELECT * FROM master");
rs = pst.executeQuery();
Document document = new Document(new Element("根元素")); //创建文档,并设根元素
ResultSetMetaData rsmd = rs.getMetaData(); //获取字段名,返回ResultSetMetaData对像
int numberOfColumns = rsmd.getColumnCount();
while (rs.next()) {
Element element0 = new Element("users"); //创建元素 生成JDOM树
document.getRootElement().addContent(element0);
// Element element2 = new Element("userphone");
// element0.addContent(element2);
for (int i = 1; i <= numberOfColumns; i++) {
try {
colName = new String(rs.getString(i));
//构造元素节点和文本节点
Element element = new Element(rsmd.getColumnName(i)).setText(colName);
element0.addContent(element);
} catch (Exception ex1) {
}
}
}
//org.jdom.output.XMLOutputter
XMLOutputter outp = new XMLOutputter(Format.getPrettyFormat());
try {
//生成XML文件路径
outp.output(document,new FileOutputStream("aa.xml"));
} catch (IOException ex2) {
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
然后再用以下代码读取XML里面的元素
public static void main(String[] args) {
Connection con = ConDB.Con();
PreparedStatement pst = null;
try {
BufferedReader br = new BufferedReader(new FileReader(
"aaa.xml"));
DOMParser parser = new DOMParser();
parser.parse(new InputSource(br));
org.w3c.dom.Document doc = parser.getDocument();
org.w3c.dom.NodeList nl = doc.getElementsByTagName("*");
for (int i = 0; i < nl.getLength(); i++) {
Node n = nl.item(i);
System.out.println(n.getNodeName());
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
- java genrate xml file use data from database
- Use jQuery To Retrieve Data From An XML File
- How to transfer the data from CSV file to Oracle database use the PL/SQL developer tool
- Generating XML Data from the Database
- Import Data from csv file to Azure SQL DATABASE
- 94.You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader
- How to: Generate XML file from database table
- Using Databases with Python -Musical Track Database (produce database from XML file)
- clear test data from database;
- select data from another database
- Generating XML from SQL Database
- Generating XML from SQL Database
- argparse load data from file
- Get Data from Database without definited Structure
- Use pandas to read data from files
- Retore database from a back up file.
- Generate the java class from XML Schema file using JAXB
- asp get data from xml
- http://blog.csdn.net/Eray/archive/2007/04/23/1575302.aspx
- 软件测评中心实习(二)
- 配置Middlegen-Hibernate和hibernate-extensions以产生hbm映射文件和POJO
- 程序员面试之葵花宝典
- 软件版本的分类
- java genrate xml file use data from database
- HTTP Response Headers
- 今天开张
- 如何在客户器端判断上传文件的大小
- 网络创业成功之路(转载自网上,原文出处不详)
- C标准中的一些新术语
- 制作Tab的两个例子[html+javascript]
- 25条哈佛成功金言
- Java & .net之间的桥