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

Python012

java如何使sql查询的数据返回xml格式,第1张

你想输出什么样的XML格式

String s=null

while(rs.next()){

s+=(rs.getString("member")+rs.getString("content"))

}

out.print(s)

修改成:

out.println("<?xml version=\"1.0\" encoding=\"gbk\"?>")

out.println("<XmlMembers>")

while(rs.next()){

out.println("<XmlMember>")

out.println("<member><![CDATA[")

out.println(rs.getString("member"))

out.println("]]</member>")

out.println("<content><![CDATA[")

out.println(rs.getString("content"))

out.println("]]</content>")

out.println("</XmlMember>")

}

out.println("</XmlMembers>")

rs.close()

URL url = new URL(requestUrl)

HttpsURLConnection httpUrlConn = (HttpsURLConnection) url.openConnection()

httpUrlConn.setRequestMethod(“POST”)

OutputStream outputStream = httpUrlConn.getOutputStream()

outputStream.write(xml)

outputStream.close()

InputStream inputStream = httpUrlConn.getInputStream()

InputStreamReader inputStreamReader = new InputStreamReader(inputStream)

BufferedReader bufferedReader = new BufferedReader(inputStreamReader)

String str = null

while ((str = bufferedReader.readLine()) != null) {

buffer.append(str)

}

bufferedReader.close()

inputStreamReader.close()

// 释放资源

inputStream.close()

inputStream = null

httpUrlConn.disconnect()