package pack;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;


public class Auto extends HttpServlet {
    
	public void init(ServletConfig config) throws ServletException {
    }
    
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    	//設置接收信息的字符集
    	request.setCharacterEncoding("UTF-8");
    	String id = request.getParameter("id");
    	
        response.setContentType("text/xml; charset=UTF-8");
        response.setHeader("Cache-Control", "no-cache");
        //創建輸出流對象
        PrintWriter out = response.getWriter();
        out.println ("<Products>");
        try {
        	DataAccess db = new DataAccess();
	        ResultSet rs = db.query("select * from Product");
	        while(rs.next()) {
	        	out.println ("<Product>");
	        	out.println("<ID>" + rs.getString(1) + "</ID>");
	        	out.println("<Name>" + rs.getString(2) + "</Name>");
	        	out.println("<Number>" + rs.getString(3) + "</Number>");
	        	out.println ("</Product>");
	        }
		}
		catch (Exception ex) {
			ex.printStackTrace();
        }
        out.println ("</Products>");
		out.close();
    }
    /*
     *  處理<POST> 請求方法.
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
       doGet(request, response);
    }
}