Java书籍

开发平台：

Java

GetQuestionBean.java：源码内容

							import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class GetQuestionBean
{
	Connection con = null;
	Statement stmt = null;
	ResultSet rs=null;
	HttpSession session=null;
	public GetQuestionBean()
	{
		
		try
		{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			con=DriverManager.getConnection("jdbc:mysql://127.0.0.1/exam");
			stmt= con.createStatement();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void getQuestion(HttpServletRequest request,int qno)
	{
		try
		{
		rs = stmt.executeQuery("Select * from table1");
		for(int i=0 ; i<qno ; i++)
			rs.next();
		
		request.getSession().setAttribute("question",rs.getString(1));
		request.getSession().setAttribute("option1",rs.getString(2));
		request.getSession().setAttribute("option2",rs.getString(3));
		request.getSession().setAttribute("option3",rs.getString(4));
		request.getSession().setAttribute("option4",rs.getString(5));
		request.getSession().setAttribute("answer",rs.getString(6));
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
};

						