/**
 * 輸出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 {
		//*************在數(shù)據(jù)庫中取出數(shù)據(jù)****************//
		ResultSet result = null ;
		Connection con = null ;
		Statement stmt = null ;
		
		
		try {
			xml.init() ;
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver") ;
			//*********建立數(shù)據(jù)庫 名為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") ;
				//*****創(chuàng)建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) ;
	}

}