java如何使sql查询的数据返回xml格式

你想输出什么样的XML格式

String s=null;

while(rsnext()){

s+=(rsgetString("member")+rsgetString("content"));

}

outprint(s);

修改成：

outprintln("<xml version=\"10\" encoding=\"gbk\">");

outprintln("<XmlMembers>");

while(rsnext()){

outprintln("<XmlMember>");

outprintln("<member><![CDATA[");

outprintln(rsgetString("member"));

outprintln("]]</member>");

outprintln("<content><![CDATA[");

outprintln(rsgetString("content"));

outprintln("]]</content>");

outprintln("</XmlMember>");

}

outprintln("</XmlMembers>");

rsclose();

读XML的速度没有读数据库快

下面的是discuz中的的方法,你看看行不行

public abstract class XMLComponent

{

//源数据表

private DataTable sourceDT = null;

public DataTable SourceDataTable

{

set{sourceDT = value;}

get{return sourceDT;}

}

//文件输出路径

private string fileOutputPath = @"";

public string FileOutPath

{

set

{ //保证路径字符串变量的合法性

if (valueLastIndexOf("\\") != (valueLength-1))

fileOutputPath = value + "\\";

}

get{return fileOutputPath;}

}

//文件编码

private string fileEncode = "utf-8";

public string FileEncode

{

set{fileEncode = value;}

get{return fileEncode;}

}

//文件缩进

private int indentation = 6;

public int Indentation

{

set{indentation = value;}

get{return indentation;}

}

//文件缩进

private string version = "20";

public string Version

{

set{version = value;}

get{return version;}

}

//开始元素

private string startElement = "channel";

public string StartElement

{

set{startElement = value;}

get{return startElement;}

}

//XSL链接

private string xslLink = null;

public string XslLink

{

set{xslLink = value;}

get{return xslLink;}

}

//文件名

private string fileName = "MyFilexml";

public string FileName

{

set{fileName = value;}

get{return fileName;}

}

//表中指向父记录的字段名称

private string parentField = "Item";

public string ParentField

{

set{parentField = value;}

get{return parentField;}

}

//表中一个主键的值

private string key = "ItemID";

public string Key

{

set{key = value;}

get{return key;}

}

//写入文件

public abstract string WriteFile();

//写入StringBuilder对象

public abstract StringBuilder WriteStringBuilder();

public XmlDocument xmlDoc_Metone = new XmlDocument();

#region 构XML树

protected void BulidXmlTree(XmlElement tempXmlElement,string location)

{

DataRow tempRow = thisSourceDataTableSelect(thisKey + "=" + location)[0];

//生成Tree节点

XmlElement treeElement = xmlDoc_MetoneCreateElement(thisParentField);

tempXmlElementAppendChild(treeElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

if ((cCaptionToString()ToLower() != thisParentFieldToLower()))

thisAppendChildElement(cCaptionToString()Trim()ToLower(),tempRow[cCaptionTrim()]ToString()Trim(),treeElement);

}

foreach (DataRow dr in thisSourceDataTableSelect(thisParentField + "=" + location))

{

if(thisSourceDataTableSelect("item=" + dr[thisKey]ToString())Length >= 0)

{

thisBulidXmlTree(treeElement,dr[thisKey]ToString()Trim());

}

else continue;

}

}

#endregion

#region 追加子节点

/// <summary>

/// 追加子节点

/// </summary>

/// <param name="strName">节点名字</param>

/// <param name="strInnerText">节点内容</param>

/// <param name="parentElement">父节点</param>

/// <param name="xmlDocument">XmlDocument对象</param>

protected void AppendChildElement(string strName , string strInnerText , XmlElement parentElement, XmlDocument xmlDocument )

{

XmlElement xmlElement = xmlDocumentCreateElement(strName) ;

xmlElementInnerText = strInnerText ;

parentElementAppendChild(xmlElement);

}

/// <summary>

/// 使用默认的频道Xml文档

/// </summary>

/// <param name="strName"></param>

/// <param name="strInnerText"></param>

/// <param name="parentElement"></param>

protected void AppendChildElement(string strName , string strInnerText , XmlElement parentElement )

{

AppendChildElement(strName,strInnerText,parentElement,xmlDoc_Metone);

}

#endregion

#region 创建存储生成XML的文件夹

public void CreatePath()

{

if (thisFileOutPath != null)

{

string path = thisFileOutPath; //;ServerMapPath("");

if (!DirectoryExists(path))

{

UtilsCreateDir(path);

}

}

else

{

string path = @"C:\"; //;ServerMapPath("");

string NowString = DateTimeNowToString("yyyy-M")Trim();

if (!DirectoryExists(path + NowString))

{

UtilsCreateDir(path + "\\" + NowString);

}

}

}

#endregion

}

//无递归直接生成XML

class ConcreteComponent : XMLComponent

{

private string strName;

public ConcreteComponent(string s)

{

strName = s;

}

//写入StringBuilder对象

public override StringBuilder WriteStringBuilder()

{

//string xmlData = stringFormat("<xml version='10' encoding='{0}'><xml-stylesheet type=\"text/xsl\" href=\"{1}\"><{3} version='{2}'></{3}>",thisFileEncode,thisXslLink,thisVersion,thisSourceDataTableTableName);

string xmlData = stringFormat("<xml version='10' encoding='{0}'><{3} ></{3}>",thisFileEncode,thisXslLink,thisVersion,thisSourceDataTableTableName);

thisxmlDoc_MetoneLoad(new StringReader(xmlData));

//写入channel

foreach(DataRow r in thisSourceDataTableRows) //依次取出所有行

{

//普通方式生成XML

XmlElement treeContentElement = thisxmlDoc_MetoneCreateElement(thisStartElement);

xmlDoc_MetoneDocumentElementAppendChild(treeContentElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

thisAppendChildElement(cCaptionToString()ToLower(),r[c]ToString()Trim(),treeContentElement);

}

}

return new StringBuilder()Append(xmlDoc_MetoneInnerXml);

}

public override string WriteFile()

{

if (thisSourceDataTable != null)

{

DateTime filenamedate = DateTimeNow;

string filename = thisFileOutPath + thisFileName;

XmlTextWriter PicXmlWriter = null;

Encoding encode = EncodingGetEncoding(thisFileEncode);

CreatePath();

PicXmlWriter = new XmlTextWriter (filename,encode);

try

{

PicXmlWriterFormatting = FormattingIndented;

PicXmlWriterIndentation = thisIndentation;

PicXmlWriterNamespaces = false;

PicXmlWriterWriteStartDocument();

//PicXmlWriterWriteDocType("文档类型", null, "xml", null);

//PicXmlWriterWriteComment("按在数据库中记录的ID进行记录读写");

PicXmlWriterWriteProcessingInstruction("xml-stylesheet","type='text/xsl' href='" + thisXslLink + "'") ;

PicXmlWriterWriteStartElement(thisSourceDataTableTableName);

PicXmlWriterWriteAttributeString("", "version", null, thisVersion);

//写入channel

foreach(DataRow r in thisSourceDataTableRows) //依次取出所有行

{

PicXmlWriterWriteStartElement("",thisStartElement,"");

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

PicXmlWriterWriteStartElement("",cCaptionToString()Trim()ToLower(),"");

PicXmlWriterWriteString(r[c]ToString()Trim());

PicXmlWriterWriteEndElement();

}

PicXmlWriterWriteEndElement();

}

PicXmlWriterWriteEndElement();

PicXmlWriterFlush();

thisSourceDataTableDispose();

}

catch (Exception e) { ConsoleWriteLine ("异常：{0}", eToString()); }

finally

{

ConsoleWriteLine("对文件 {0} 的处理已完成。");

if (PicXmlWriter != null)

PicXmlWriterClose();

}

return filename;

}

else

{

ConsoleWriteLine("对文件 {0} 的处理未完成。");

return "";

}

}

}

//无递归直接生成XML

public class TreeNodeComponent : XMLComponent

{

private string strName;

public TreeNodeComponent(string s)

{

strName = s;

}

//写入StringBuilder对象

public override StringBuilder WriteStringBuilder()

{

//string xmlData = stringFormat("<xml version='10' encoding='{0}'><xml-stylesheet type=\"text/xsl\" href=\"{1}\"><{3} version='{2}'></{3}>",thisFileEncode,thisXslLink,thisVersion,thisSourceDataTableTableName);

string xmlData = stringFormat("<xml version='10' encoding='{0}'><{3} ></{3}>",thisFileEncode,thisXslLink,thisVersion,thisSourceDataTableTableName);

thisxmlDoc_MetoneLoad(new StringReader(xmlData));

//写入channel

foreach(DataRow r in thisSourceDataTableRows) //依次取出所有行

{

//普通方式生成XML

XmlElement treeContentElement = thisxmlDoc_MetoneCreateElement(thisStartElement);

xmlDoc_MetoneDocumentElementAppendChild(treeContentElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

thisAppendChildElement(cCaptionToString()ToLower(),r[c]ToString()Trim(),treeContentElement);

}

}

return new StringBuilder()Append(xmlDoc_MetoneInnerXml);

}

public override string WriteFile()

{

if (thisSourceDataTable != null)

{

DateTime filenamedate = DateTimeNow;

string filename = thisFileOutPath + thisFileName;

XmlTextWriter PicXmlWriter = null;

Encoding encode = EncodingGetEncoding(thisFileEncode);

CreatePath();

PicXmlWriter = new XmlTextWriter (filename,encode);

try

{

PicXmlWriterFormatting = FormattingIndented;

PicXmlWriterIndentation = thisIndentation;

PicXmlWriterNamespaces = false;

PicXmlWriterWriteStartDocument();

//PicXmlWriterWriteDocType("文档类型", null, "xml", null);

//PicXmlWriterWriteComment("按在数据库中记录的ID进行记录读写");

PicXmlWriterWriteStartElement(thisSourceDataTableTableName);

string content = null;

//写入channel

foreach(DataRow r in thisSourceDataTableRows) //依次取出所有行

{

content = " Text=\"" + r[0]ToString()Trim() + "\" ImageUrl=\"//editor/images/smilies/" + r[1]ToString()Trim() + "\"";

PicXmlWriterWriteStartElement("",thisStartElement+content,"");

PicXmlWriterWriteEndElement();

content = null;

}

PicXmlWriterWriteEndElement();

PicXmlWriterFlush();

thisSourceDataTableDispose();

}

catch (Exception e)

{

ConsoleWriteLine ("异常：{0}", eToString());

}

finally

{

ConsoleWriteLine("对文件 {0} 的处理已完成。");

if (PicXmlWriter != null)

PicXmlWriterClose();

}

return filename;

}

else

{

ConsoleWriteLine("对文件 {0} 的处理未完成。");

return "";

}

}

}

//RSS生成

public class RssXMLComponent : XMLComponent

{

private string strName;

public RssXMLComponent(string s)

{

strName = s;

FileEncode ="gb2312";

Version = "20";

StartElement = "channel";

}

//写入StringBuilder对象

public override StringBuilder WriteStringBuilder()

{

string xmlData = stringFormat("<xml version='10' encoding='{0}'><xml-stylesheet type=\"text/xsl\" href=\"{1}\"><rss version='{2}'></rss>",thisFileEncode,thisXslLink,thisVersion);

thisxmlDoc_MetoneLoad(new StringReader(xmlData));

string Key = "-1";

//写入channel

foreach(DataRow r in thisSourceDataTableRows) //依次取出所有行

{

if ((thisKey != null) && (thisParentField != null)) //递归进行XML生成

{

if ((r[thisParentField]ToString()Trim() == "")||(r[thisParentField]ToString()Trim() == "0"))

{

XmlElement treeContentElement = thisxmlDoc_MetoneCreateElement(thisStartElement);

xmlDoc_MetoneDocumentElementAppendChild(treeContentElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

if ((cCaptionToString()ToLower() == thisParentFieldToLower()))

{

Key = r[thisKey]ToString()Trim();

}

else

{

if ((r[thisParentField]ToString()Trim() == "")||(r[thisParentField]ToString()Trim() == "0"))

{

thisAppendChildElement(cCaptionToString()ToLower(),r[c]ToString()Trim(),treeContentElement);

}

}

}

foreach(DataRow dr in thisSourceDataTableSelect(thisParentField + "=" + Key))

{

if(thisSourceDataTableSelect(thisParentField + "=" + dr[thisKey]ToString())Length >= 0)

thisBulidXmlTree(treeContentElement,dr["ItemID"]ToString()Trim());

else

continue;

}

}

}

else //普通方式生成XML

{

XmlElement treeContentElement = thisxmlDoc_MetoneCreateElement(thisStartElement);

xmlDoc_MetoneDocumentElementAppendChild(treeContentElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

thisAppendChildElement(cCaptionToString()ToLower(),r[c]ToString()Trim(),treeContentElement);

}

}

}

return new StringBuilder()Append(xmlDoc_MetoneInnerXml);

}

public override string WriteFile()

{

CreatePath();

string xmlData = stringFormat("<xml version='10' encoding='{0}'><xml-stylesheet type=\"text/xsl\" href=\"{1}\"><rss version='{2}'></rss>",thisFileEncode,thisXslLink,thisVersion);

thisxmlDoc_MetoneLoad(new StringReader(xmlData));

string Key = "-1";

//写入channel

foreach(DataRow r in thisSourceDataTableRows) //依次取出所有行

{

if ((thisKey != null)&&(thisParentField != null)) //递归进行XML生成

{

if ((r[thisParentField]ToString()Trim() == "")||(r[thisParentField]ToString()Trim() == "0"))

{

XmlElement treeContentElement = thisxmlDoc_MetoneCreateElement(thisStartElement);

xmlDoc_MetoneDocumentElementAppendChild(treeContentElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

if ((cCaptionToString()ToLower() == thisParentFieldToLower()))

Key = r[thisKey]ToString()Trim();

else

{

if ((r[thisParentField]ToString()Trim() == "")||(r[thisParentField]ToString()Trim() == "0"))

{

thisAppendChildElement(cCaptionToString()ToLower(),r[c]ToString()Trim(),treeContentElement);

}

}

}

foreach(DataRow dr in thisSourceDataTableSelect(thisParentField + "=" + Key))

{

if(thisSourceDataTableSelect(thisParentField + "=" + dr[thisKey]ToString())Length >= 0)

thisBulidXmlTree(treeContentElement,dr["ItemID"]ToString()Trim());

else

continue;

}

}

}

else //普通方式生成XML

{

XmlElement treeContentElement = thisxmlDoc_MetoneCreateElement(thisStartElement);

xmlDoc_MetoneDocumentElementAppendChild(treeContentElement);

foreach(DataColumn c in thisSourceDataTableColumns) //依次找出当前记录的所有列属性

{

thisAppendChildElement(cCaptionToString()ToLower(),r[c]ToString()Trim(),treeContentElement);

}

}

}

string fileName = thisFileOutPath+thisFileName;

xmlDoc_MetoneSave(fileName);

return fileName;

}

}

//装饰器类

public class XMLDecorator : XMLComponent

{

protected XMLComponent ActualXMLComponent;

private string strDecoratorName;

public XMLDecorator (string str)

{

// how decoration occurs is localized inside this decorator

// For this demo, we simply print a decorator name

strDecoratorName = str;

}

public void SetXMLComponent(XMLComponent xc)

{

ActualXMLComponent = xc;

//ConsoleWriteLine("FileEncode - {0}", xcFileEncode);

GetSettingFromComponent( xc);

}

//将被装入的对象的默认设置为当前装饰者的初始值

public void GetSettingFromComponent(XMLComponent xc)

{

thisFileEncode = xcFileEncode;

thisFileOutPath = xcFileOutPath;

thisIndentation = xcIndentation;

thisSourceDataTable = xcSourceDataTable;

thisStartElement = xcStartElement;

thisVersion = xcVersion;

thisXslLink = xcXslLink;

thisKey = xcKey;

thisParentField = xcParentField;

}

public override string WriteFile()

{

if (ActualXMLComponent != null)

ActualXMLComponentWriteFile();

return null;

}

//写入StringBuilder对象

public override StringBuilder WriteStringBuilder()

{

if (ActualXMLComponent != null)

return ActualXMLComponentWriteStringBuilder();

return null;

}

}

我的思路是，直接使用动态的xml，让flash读取这个文档，这样就不用实时的去生成xml文件了。当然，这个xml文件是php格式的，所以你必须在flash中吧读取的文件地址改成php的，就跟你写一个php页面一样，不同的是这个php文件输出的内容是一个xml格式的文本。

比如你现在建立文件 xmlphp

<php

echo "<xml version=\"10\" encoding=\"utf-8\">

<gallery>

<settings>";

//若此处也有动态信息 按需要进行调用

echo"</settings>

<items>";

//在此循环你的数据

$data =

while( $data ) {

echo "<item source=\""$data['source']"\" description=\""$data['description']"\" />";

}

echo '</items>';

>

以上就是关于java如何使sql查询的数据返回xml格式全部的内容，包括:java如何使sql查询的数据返回xml格式、如何从数据库表中生成xml文件、如何用php从数据库读取数据并生成xml文件等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！