gettest.java

用java+servlet实现在线考试系统

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 {
    	//设置接收信息的字符集
    	request.setCharacterEncoding("UTF-8");
    	//接收浏览器端提交的信息
		String testid = request.getParameter("testid");
		//设置输出信息的格式及字符集        
        response.setContentType("text/xml; charset=UTF-8");
        response.setHeader("Cache-Control", "no-cache");
        //创建输出流对象
        PrintWriter out = response.getWriter();
        //依据验证结果输出不同的数据信息
        out.println("<test>");		
        
        //数据库操作
        Database db = new Database();
		ResultSet rs;
        String strSql=null;
        //根据省份编号查询相关城市
        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();
    }

}