webservice XML字符串传值

有两种写法

第一种:自己拼装xml格式字符串

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class TaskList {
 public String getTaskList(Integer userID) throws Exception {
  StringBuilder xmlString=new StringBuilder();
  try {
   Class.forName("com.mysql.jdbc.Driver");
   System.out.println("数据库驱动加载成功!");
  } catch (java.lang.ClassNotFoundException ce) {
   System.out.println("数据库驱动加载失败!");
   System.out.println(ce.getMessage());
  }
  Connection conn = DriverManager
    .getConnection("jdbc:mysql://192.168.0.1/test?user=root&password=admin");
  Statement stat = conn.createStatement();
  String selectSQL = "select * from USER_INFO WHERE USER_ID = /"" + userID + "/";";
  System.out.println(selectSQL);
  ResultSet rs = stat.executeQuery(selectSQL);
  xmlString.append("<userList>");
  while (rs.next()) {
   xmlString.append("<userItem taskId=/"");
   xmlString.append(rs.getString("USER_ID"));
   xmlString.append("/">");
   xmlString.append("<userName>");
   xmlString.append(rs.getString("USER_NAME"));
   xmlString.append("</userName>");
   xmlString.append("</userItem >");
  }
  xmlString.append("</userList>");
  rs.close();
  conn.close();
  System.out.println(xmlString.toString());
  return xmlString.toString();
 }
}

 

第二种:调用org.dom4j

 

import java.io.FileWriter;
import java.io.IOException;
import java.io.StringWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.io.OutputFormat;
import org.dom4j.io.XMLWriter;
import view.TaskList;

 

public class Test1 {
 public static Document GetDocument(ResultSet rs) throws Exception {
  Document document = DocumentHelper.createDocument();
  Element root = document.addElement("taskList");
  Element author1 = root.addElement("taskItem");
  int count = 1;
  while (rs.next()) {
   author1.addAttribute("userId", rs.getString("TASK_ID"));
   Element author1 = author1.addElement("taskName");
   author1.addText(rs.getString("TASK_NAME"));
  }
  return document;
 }

 public static String GetXMLString(ResultSet rs) throws Exception {
  StringWriter sw = new StringWriter();
  XMLWriter writer = null;
  OutputFormat format = OutputFormat.createPrettyPrint();
  format.setEncoding("UTF-8");
  try {
   writer = new XMLWriter(format);
   writer.setWriter(sw);
   writer.write(GetDocument(rs));
   writer.close();
  } catch (IOException e) {
   e.printStackTrace();
  }
  return sw.toString();
 }
 public static void main(String[] args) throws IOException, Exception {
  String xmlString="";
  int userID = 2;
  try {
   Class.forName("com.mysql.jdbc.Driver");
   System.out.println("数据库驱动加载成功!");
  } catch (java.lang.ClassNotFoundException ce) {
   System.out.println("数据库驱动加载失败!");
   System.out.println(ce.getMessage());
  }
  Connection conn = DriverManager
    .getConnection("jdbc:mysql://192.168.0.1/zhc?user=root&password=admin");
  Statement stat = conn.createStatement();
  String selectSQL = "select * from USER_INFO WHERE USER_ID = /"" + userID + "/";";
  System.out.println(selectSQL);
  ResultSet rs = stat.executeQuery(selectSQL);
  TaskList taskList = new TaskList();
  xmlString = GetXMLString(rs);
  rs.close();
  conn.close();
  System.out.println(xmlString);
 }
}

打完

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值