实现以 xml 格式传参并返回
模拟客户端:
package servlet1;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileWriter;
import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.methods.EntityEnclosingMethod;
import org.apache.commons.httpclient.methods.PostMethod;
public class PostXMLClient {
public PostXMLClient() {
}
public static void main(String[] args) throws Exception {
File input = new File("E://jdeveloper//test.xml");
PostMethod post = new PostMethod(" http://172.17.2.85:8988/JavaServlets-Servlet1-context-root/servlet1");
//post.setParameter("theid","1");
post.setRequestBody(new FileInputStream(input));
if (input.length() < Integer.MAX_VALUE) {
post.setRequestContentLength(input.length());
}
else {
post.setRequestContentLength(EntityEnclosingMethod.CONTENT_LENGTH_CHUNKED);
}
post.setRequestHeader("Content-type", "text/xml; charset=UTF-8");
HttpClient httpclient = new HttpClient();
int result = httpclient.executeMethod(post);
System.out.println("Response status code: " + result);
System.out.println("Response body: ");
String strResult = post.getResponseBodyAsString();
post.releaseConnection();
System.out.println(strResult);
//write to file
BufferedWriter buffWriter = new BufferedWriter(new FileWriter("E://jdeveloper//result.xml",true));
for (int i = 0; i < strResult.length(); i++) {
buffWriter.write(strResult.charAt(i));
}
buffWriter.close();
}
}
servlet:
package servlet1;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.io.BufferedReader;
import javax.servlet.*;
import javax.servlet.http.*;
public class Servlet1 extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=Shift_JIS";
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
String strSQL = getSQL(request);
Connection con = connectToDB("servlets", "servlets", "172.17.3.111", "STUDY");
ResultSet rs=null;
Statement stmt =null;
try{
stmt = con.createStatement();
rs = stmt.executeQuery(strSQL);
generateXML(out, rs);
rs.close();
stmt.close();
con.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch(Exception ex) {
System.out.println(ex.getMessage());
}
out.close();
}
public String getSQL(HttpServletRequest request) {
String strSQL = "";
try {
BufferedReader buffReader = request.getReader();
String inputLine = "";
StringBuffer strBuff = new StringBuffer();
while ((inputLine = buffReader.readLine()) != null) {
strBuff.append(inputLine);
}
buffReader.close();
int a = strBuff.indexOf("<sql>");
int b = strBuff.indexOf("</sql>");
strSQL = strBuff.toString().substring(a+5,b);
} catch (IOException e) {
System.out.println(e);
}
return strSQL;
}
public Connection connectToDB(String userName, String passWord, String hostName, String sid) {
Connection con = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection("jdbc:oracle:thin:@" + hostName + ":1521:" + sid, userName, passWord);
} catch (java.sql.SQLException e) {
System.out.println("connect error " + e);
} catch (java.lang.ClassNotFoundException e) {
System.out.println("driver not found");
System.out.println("driver " + e);
} catch (IllegalAccessException e) {
System.out.println(e.getMessage());
} catch (InstantiationException e) {
System.out.println(e.getMessage());
}
return con;
}
public void generateXML(PrintWriter out, ResultSet rs) {
out.println("<?xml version=1.0 encoding=UTF-8 ?>");
out.println("<ser>");
try {
while (rs.next()){
out.println("<id>" + rs.getString("ID") + "</id>");
out.println("<value>" + rs.getString("VALUE") + "</value>");
out.println("<name>" + rs.getString("NAME") + "</name>");
}
} catch (SQLException e) {
out.println(e);
}
out.println("</ser>");
}
}
参考: http://www.xd-tech.com.cn/blog/article.asp?id=34
模拟客户端:
package servlet1;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileWriter;
import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.methods.EntityEnclosingMethod;
import org.apache.commons.httpclient.methods.PostMethod;
public class PostXMLClient {
public PostXMLClient() {
}
public static void main(String[] args) throws Exception {
File input = new File("E://jdeveloper//test.xml");
PostMethod post = new PostMethod(" http://172.17.2.85:8988/JavaServlets-Servlet1-context-root/servlet1");
//post.setParameter("theid","1");
post.setRequestBody(new FileInputStream(input));
if (input.length() < Integer.MAX_VALUE) {
post.setRequestContentLength(input.length());
}
else {
post.setRequestContentLength(EntityEnclosingMethod.CONTENT_LENGTH_CHUNKED);
}
post.setRequestHeader("Content-type", "text/xml; charset=UTF-8");
HttpClient httpclient = new HttpClient();
int result = httpclient.executeMethod(post);
System.out.println("Response status code: " + result);
System.out.println("Response body: ");
String strResult = post.getResponseBodyAsString();
post.releaseConnection();
System.out.println(strResult);
//write to file
BufferedWriter buffWriter = new BufferedWriter(new FileWriter("E://jdeveloper//result.xml",true));
for (int i = 0; i < strResult.length(); i++) {
buffWriter.write(strResult.charAt(i));
}
buffWriter.close();
}
}
servlet:
package servlet1;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.io.BufferedReader;
import javax.servlet.*;
import javax.servlet.http.*;
public class Servlet1 extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=Shift_JIS";
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
String strSQL = getSQL(request);
Connection con = connectToDB("servlets", "servlets", "172.17.3.111", "STUDY");
ResultSet rs=null;
Statement stmt =null;
try{
stmt = con.createStatement();
rs = stmt.executeQuery(strSQL);
generateXML(out, rs);
rs.close();
stmt.close();
con.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
} catch(Exception ex) {
System.out.println(ex.getMessage());
}
out.close();
}
public String getSQL(HttpServletRequest request) {
String strSQL = "";
try {
BufferedReader buffReader = request.getReader();
String inputLine = "";
StringBuffer strBuff = new StringBuffer();
while ((inputLine = buffReader.readLine()) != null) {
strBuff.append(inputLine);
}
buffReader.close();
int a = strBuff.indexOf("<sql>");
int b = strBuff.indexOf("</sql>");
strSQL = strBuff.toString().substring(a+5,b);
} catch (IOException e) {
System.out.println(e);
}
return strSQL;
}
public Connection connectToDB(String userName, String passWord, String hostName, String sid) {
Connection con = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection("jdbc:oracle:thin:@" + hostName + ":1521:" + sid, userName, passWord);
} catch (java.sql.SQLException e) {
System.out.println("connect error " + e);
} catch (java.lang.ClassNotFoundException e) {
System.out.println("driver not found");
System.out.println("driver " + e);
} catch (IllegalAccessException e) {
System.out.println(e.getMessage());
} catch (InstantiationException e) {
System.out.println(e.getMessage());
}
return con;
}
public void generateXML(PrintWriter out, ResultSet rs) {
out.println("<?xml version=1.0 encoding=UTF-8 ?>");
out.println("<ser>");
try {
while (rs.next()){
out.println("<id>" + rs.getString("ID") + "</id>");
out.println("<value>" + rs.getString("VALUE") + "</value>");
out.println("<name>" + rs.getString("NAME") + "</name>");
}
} catch (SQLException e) {
out.println(e);
}
out.println("</ser>");
}
}
参考: http://www.xd-tech.com.cn/blog/article.asp?id=34