selectservlet.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.ajax;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Locale;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.db.ProxoolAction;

public class SelectServlet extends HttpServlet {

	private static final long serialVersionUID = -5252770256653976848L;
	/**
	 * Constructor of the object.
	 */
	public SelectServlet() {
		
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		

		response.setContentType("text/xml");
        response.setHeader("Cache-Control","no-cache");
        response.setCharacterEncoding("utf-8");
        
        PrintWriter out=response.getWriter();
        
        String targetId=request.getParameter("id");
        
        String xml_start="<selects>";
        String xml_end="</selects>";
        String sjlmmc="";
        
        StringBuilder sb=new StringBuilder();
        sb.append(xml_start);
        
        Connection conn=null;
        PreparedStatement stmt=null;
        ResultSet rs=null;
        try {
			conn=ProxoolAction.getConnection();
			stmt=conn.prepareStatement("select lmmc from w_lmb where lmid="+targetId);
			rs=stmt.executeQuery();
			while(rs.next())
			{
				sjlmmc=rs.getString(1);
			}
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			sb.append("<select><value>"+sjlmmc+"</value><text>"+sjlmmc+"</text></select>");
			
			stmt=conn.prepareStatement("select slmid,slmmc from w_sublmb where sjlmid="+targetId);
			rs=stmt.executeQuery();
			while (rs.next()) {	
				sb.append("<select><value>"+rs.getString(2)+"</value><text>"+rs.getString(2)+"</text></select>");
			}
		} catch (Exception e) {
			System.out.println(e.getLocalizedMessage());
		}finally{
			ProxoolAction.closeResultSet(rs);
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		sb.append(xml_end);
		String sbstr=sb.toString();
		sbstr=new String(sbstr.getBytes("utf-8"),"utf-8");
		out.println(sbstr);
		out.flush();
		out.close();	
	}
	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}