firstservlet.java

flex与java通信的完整demo flex学习例子

/**
 * 输出XML响应的servlet
 */
package com.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.xml.XML;
public class FirstServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
	
	private XML xml = new XML() ;
	
	public FirstServlet() {
		super();
	}
	public void destroy() {
		super.destroy();
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//*************在数据库中取出数据****************//
		ResultSet result = null ;
		Connection con = null ;
		Statement stmt = null ;
		
		
		try {
			xml.init() ;
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") ;
			//*********建立数据库 名为flex*************//
			String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=flex" ;
			//**********换上你自己的用户名和密码信息************//
			con = DriverManager.getConnection(url, "sa", "sa") ;
		    stmt = con.createStatement() ;
		    //**********里面建表名为USERS  具体SQL语句见附件下载**********//
		    result = stmt.executeQuery("select * from USERS") ;
		} catch(Exception e) {
			e.printStackTrace() ;
		}
        //重要：设置响应格式为XML格式
		response.setContentType("text/xml") ;
		response.setCharacterEncoding("UTF-8") ;
		PrintWriter out = response.getWriter() ;
		
		try {
			while(result.next()) {
				String[] strs = new String[3] ;
				strs[0] = result.getString("name") ;
				strs[1] = result.getString("pwd") ;
				strs[2] = result.getString("school") ;
				//*****创建XMLdocument*******//
				xml.create(strs) ;
 			}
			result.close() ;
			stmt.close() ;
			con.close() ;
			//*******写XML文件到客户端********//
			xml.output(out) ;
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response) ;
	}

}