package com.nokia.servlet;

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

import com.zte.database.Database;


public class GetTest extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public GetTest() {
		super();
	}

	public void init(ServletConfig config) throws ServletException {
    }
    
    /*
     *  處理<GET> 請求方法.
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    	//設(shè)置接收信息的字符集
    	request.setCharacterEncoding("UTF-8");
    	//接收瀏覽器端提交的信息
		String testid = request.getParameter("testid");
		//設(shè)置輸出信息的格式及字符集        
        response.setContentType("text/xml; charset=UTF-8");
        response.setHeader("Cache-Control", "no-cache");
        //創(chuàng)建輸出流對象
        PrintWriter out = response.getWriter();
        //依據(jù)驗(yàn)證結(jié)果輸出不同的數(shù)據(jù)信息
        out.println("<test>");		
        
        //數(shù)據(jù)庫操作
        Database db = new Database();
		ResultSet rs;
        String strSql=null;
        //根據(jù)省份編號(hào)查詢相關(guān)城市
        strSql = "select * from exam_question where qu_id="+testid;
		rs = db.query(strSql);
		try {
			while (rs.next()) {
				out.println("<quid>" + rs.getString("qu_id") + "</quid>");
			    out.println("<qutitle>" + rs.getString("qutitle") + "</qutitle>");
			    out.println("<quanswer>" + rs.getString("quanswer") + "</quanswer>");
			    out.println("<quscore>" + rs.getString("quscore") + "</quscore>");
			   System.out.println(rs.getString("qu_id") + "---" + rs.getString("qutitle") +"---" +  rs.getString("quscore"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	
		out.println("</test>");
		out.close();
    }

}