ajax三级联动servlet端.docVIP

package ajax.hailong.linkage; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import ajax.hailong.db.DBUtil; /** * * @author yinhailong * */ public class Link extends HttpServlet { private static final long serialVersionUID = 1L; public Link() { super(); } /** * Destruction of the servlet. br */ public void destroy() { super.destroy(); // Just puts destroy string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding(utf-8); String idStr = request.getParameter(father_id); response.setContentType(text/html;charset=utf-8); PrintWriter out = response.getWriter(); int father_id; if(idStr != null !.equals(idStr)){ father_id = Integer.parseInt(idStr); }else{ father_id = 1; } String sql = select id,content from linkage where father_id = ?; try { Connection con = DBUtil.getConnection(); PreparedStatement pstmt = con.prepareStatement(sql); pstmt.setInt(1,father_id); ResultSet rs = pstmt.executeQuery(); StringBuffer allCitys = new StringBuffer(); response.setContentType(text/xml); allCitys.append(?xml version=\1.0\ encoding=\utf-8\?); allCitys.append(allSons); while (rs.next()) { allCitys.append(son); allCitys.append(sonId+rs.getInt(id)+/sonId); allCitys.append(sonName+rs.getString(content)+/sonName); allCitys.append(/son); } allCitys.append(/allSons); out.print(allCitys.toStrin