sql:
select * from table for xml autoor other db:
public static String record2xml(ResultSet records){
try{
ResultSetMetaData rsmd=records.getMetaData();
int _i=0;
String _xmlRecord="<?xml version=\"1.0\" encoding=\"gb2312\" ?>";
_xmlRecord+="<root>"; while(records.next()){
_xmlRecord+="<data ";
for(int i=1;i<rsmd.getColumnCount()+1;i++)
{
_xmlRecord+=" "; _xmlRecord+=rsmd.getColumnName(i); _xmlRecord+="=\""; String _te=records.getString(i);
if(_te!=null) _te.trim();
_xmlRecord+=_te; _xmlRecord+="\" ";
}
_xmlRecord+=" />\n";
}
_xmlRecord+="</root>";
return _xmlRecord;
}catch(Exception e){
System.out.println("record2xml of InnerInvoke function is error:"+e);
return "";
}
}DOM 在前台调用用msxml
DOM 在后台用apache的w3c标准解析,j2sdk1.4自带至于使用取舍,采用方法灵活
select * from table for xml autoor other db:
public static String record2xml(ResultSet records){
try{
ResultSetMetaData rsmd=records.getMetaData();
int _i=0;
String _xmlRecord="<?xml version=\"1.0\" encoding=\"gb2312\" ?>";
_xmlRecord+="<root>"; while(records.next()){
_xmlRecord+="<data ";
for(int i=1;i<rsmd.getColumnCount()+1;i++)
{
_xmlRecord+=" "; _xmlRecord+=rsmd.getColumnName(i); _xmlRecord+="=\""; String _te=records.getString(i);
if(_te!=null) _te.trim();
_xmlRecord+=_te; _xmlRecord+="\" ";
}
_xmlRecord+=" />\n";
}
_xmlRecord+="</root>";
return _xmlRecord;
}catch(Exception e){
System.out.println("record2xml of InnerInvoke function is error:"+e);
return "";
}
}DOM 在前台调用用msxml
DOM 在后台用apache的w3c标准解析,j2sdk1.4自带至于使用取舍,采用方法灵活
解决方案 »
- struts2批量删除的问题
- The requested resource (Servlet action is not available) is not available.
- 关于 appfuse(hibernate+spring)多表查询
- 寻找有JAVA EE 架构师
- 急,Resin中出现Server connection failure during transaction
- hibernate+Mysql 存储过程出错
- 请各位解答一下,有关cmp的问题!
- 如何写包含多个checkbox的表单对应的ActionForm?
- java 程序在编译的时候有什么优化选项吗?
- 求救!!有关wap、xml和wml的问题!!
- 请教很急
- 救命,我在部署EJB的时候出错。
非常感谢Mr.wu:!
最后的“
DOM 在前台调用用msxml
DOM 在后台用apache的w3c标准解析,j2sdk1.4自带”
能不能解释一下!
另外,你写的程序是从数据库转换成XML,可以反过来呢?能不能也给个程序示例?
万分感谢! 另外,有个问题本来应该问板主的,也顺路求教一下:是不是只有结帖时才能散分,其他时候如果想向好的回帖给分,有没有办法?
一般ie6带有msxml3.0
目前4.0后台用xml我一般都是db输出xml
至于用xml转成db,那个都有点雷同看你用dom还是sax方式,具体代码我倒是最近没太空做
http://expert.csdn.net/Expert/TopicView1.asp?id=1566988
http://expert.csdn.net/Expert/TopicView1.asp?id=1557939
http://expert.csdn.net/Expert/TopicView1.asp?id=1567700
http://expert.csdn.net/Expert/TopicView1.asp?id=1539687
-------------------------------------------------------------------------------
useinfo.xml
-------------------------------------------------------------------------------
<?xml version="1.0" encoding="GB2312"?>
<!DOCTYPE table SYSTEM "useinfo.dtd">
<table>
<name>useinfo</name>
<descript>用户信息表表的名字</descript>
<cols>
<col>
<name>id</name>
<type>number</type>
<descript>用户编号</descript>
</col>
<col>
<name>name</name>
<type>varchar2(50)</type>
<descript>姓名</descript>
</col>
<col>
<name>password</name>
<type>varchar2(50)</type>
<descript>密码</descript>
</col>
</cols>
</table>
-------------------------------------------------------------------------------
useinfo.dtd:
-------------------------------------------------------------------------------
<?xml version="1.0" encoding="GB2312" ?>
<!ELEMENT col ( name, type, descript ) ><!ELEMENT name ( #PCDATA ) ><!ELEMENT type ( #PCDATA ) ><!ELEMENT table ( name, descript, cols ) ><!ELEMENT cols ( col+ ) ><!ELEMENT descript ( #PCDATA ) >
-------------------------------------------------------------------------------
useinfo.map:
-------------------------------------------------------------------------------
<?xml version='1.0' ?>
<!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd" ><XMLToDBMS Version="1.0">
<Options>
</Options>
<Maps>
<ClassMap>
<ElementType Name="col"/>
<ToClassTable>
<Table Name="col"/>
</ToClassTable>
<PropertyMap>
<ElementType Name="name"/>
<ToColumn>
<Column Name="name"/>
</ToColumn>
<OrderColumn Name="nameOrder" Generate="Yes"/>
</PropertyMap>
<PropertyMap>
<ElementType Name="type"/>
<ToColumn>
<Column Name="type"/>
</ToColumn>
<OrderColumn Name="typeOrder" Generate="Yes"/>
</PropertyMap>
<PropertyMap>
<ElementType Name="descript"/>
<ToColumn>
<Column Name="descript"/>
</ToColumn>
<OrderColumn Name="descriptOrder" Generate="Yes"/>
</PropertyMap>
</ClassMap>
<ClassMap>
<ElementType Name="table"/>
<ToRootTable>
<Table Name="table"/>
<CandidateKey Generate="Yes">
<Column Name="tablePK"/>
</CandidateKey>
<OrderColumn Name="tableOrder" Generate="Yes"/>
</ToRootTable>
<PropertyMap>
<ElementType Name="name"/>
<ToColumn>
<Column Name="name"/>
</ToColumn>
<OrderColumn Name="nameOrder" Generate="Yes"/>
</PropertyMap>
<PropertyMap>
<ElementType Name="descript"/>
<ToColumn>
<Column Name="descript"/>
</ToColumn>
<OrderColumn Name="descriptOrder" Generate="Yes"/>
</PropertyMap>
<RelatedClass KeyInParentTable="Candidate">
<ElementType Name="cols"/>
<CandidateKey Generate="Yes">
<Column Name="tablePK"/>
</CandidateKey>
<ForeignKey>
<Column Name="tableFK"/>
</ForeignKey>
<OrderColumn Name="colsOrder" Generate="Yes"/>
</RelatedClass>
</ClassMap>
<ClassMap>
<ElementType Name="cols"/>
<ToClassTable>
<Table Name="cols"/>
</ToClassTable>
<RelatedClass KeyInParentTable="Candidate">
<ElementType Name="col"/>
<CandidateKey Generate="Yes">
<Column Name="colsPK"/>
</CandidateKey>
<ForeignKey>
<Column Name="colsFK"/>
</ForeignKey>
<OrderColumn Name="colOrder" Generate="Yes"/>
</RelatedClass>
</ClassMap>
</Maps>
</XMLToDBMS>
-------------------------------------------------------------------------------
useinfo.
-------------------------------------------------------------------------------
CREATE TABLE "col" ("colOrder" INTEGER, "typeOrder" INTEGER, "colsFK" INTEGER, "name" VARCHAR(255), "nameOrder" INTEGER, "descriptOrder" INTEGER, "type" VARCHAR(255), "descript" VARCHAR(255));
CREATE TABLE "table" ("tablePK" INTEGER, "name" VARCHAR(255), "nameOrder" INTEGER, "descriptOrder" INTEGER, "tableOrder" INTEGER, "descript" VARCHAR(255));
CREATE TABLE "cols" ("colsOrder" INTEGER, "colsPK" INTEGER, "tableFK" INTEGER);
CREATE TABLE XMLDBMSKey (HighKey Integer);
INSERT INTO XMLDBMSKey VALUES (0);
-------------------------------------------------------------------------------