最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
用JDOM实现数据库到XML的转换
时间：2022-07-02 11:44:32 编辑：袖梨 来源：一聚教程网
<%@page contentType="text/html;charset=GBK"%>
>
用JDOM实现数据库</a>到XML</a>的转换
<%@page import = "org.jdom.*"%>
<%@page import = "org.jdom.output.*"%>
<%@page import = "java.*"%>
<%@page import = "java.sql.*" %>
<%@page import = "DB.*" %>
<%@ page import="java.io.*" %>
<%
String sql = null;
ResultSet rs = null;
Document document=new Document(new Element("PUSH统计"));//创建文档
int count = 1;
String sElement = "用户";
try{
DBGAMEConnection cn = new DBGAMEConnection();
sql = "SELECT * FROM tbl_wappush WHERE length(sTUID)>20 ORDER BY dPushDate";
rs = cn.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData(); //获取字段名
int numberOfColumns = rsmd.getColumnCount(); //获取字段数
while (rs.next()){
sElement = "用户" + count;
Element element0=new Element(sElement); //创建元素 生成JDOM树
document.getRootElement().addContent(element0);
for (int i=1; i<=numberOfColumns;i++)
{
String date=rs.getString(i); //代码转换
Element element=new Element(rsmd.getColumnName(i)).setText(date);
element0.addContent(element);
}
count++;
}
rs.close();
}catch (SQLException e){
<%@page import = "org.jdom.*"%>
<%@page import = "org.jdom.output.*"%>
<%@page import = "java.*"%>
<%@page import = "java.sql.*" %>
<%@page import = "DB.*" %>
<%@ page import="java.io.*" %>
<%
String sql = null;
ResultSet rs = null;
Document document=new Document(new Element("PUSH统计"));//创建文档
int count = 1;
String sElement = "用户";
try{
DBGAMEConnection cn = new DBGAMEConnection();
sql = "SELECT * FROM tbl_wappush WHERE length(sTUID)>20 ORDER BY dPushDate";
rs = cn.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData(); //获取字段名
int numberOfColumns = rsmd.getColumnCount(); //获取字段数
while (rs.next()){
sElement = "用户" + count;
Element element0=new Element(sElement); //创建元素 生成JDOM树
document.getRootElement().addContent(element0);
for (int i=1; i<=numberOfColumns;i++)
{
String date=rs.getString(i); //代码转换
Element element=new Element(rsmd.getColumnName(i)).setText(date);
element0.addContent(element);
}
count++;
}
rs.close();
}catch (SQLException e){
相关文章
- 明末渊虚之羽黯淡红羽在哪里 含光禅院获取位置分享 08-04
- 人渣SCUM简易时钟怎么制作 简易时钟制作方法和作用分享 08-04
- 崩坏星穹铁道海瑟音怎么配队-海瑟音阵容搭配思路 08-04
- 明末渊虚之羽僰人之血怎么获得 僰人之血用途介绍 08-04
- 背包乱斗幸运游侠怎么玩 背包乱斗幸运游侠玩法介绍 08-04
- 妖怪金手指东皇核心机制及替换神将分享 08-04