classtest.java

基于java的jsp开发的在线考试系统 基于java的jsp开发的在线考试系统

package javaBeanClass.ClassTest;
import javaBeanClass.DatabaseConn;
import javaBeanClass.ClassTest.ClassTestData;
import java.util.*;
import java.sql.*;
public class ClassTest
{
	private DatabaseConn db;
	
	private int pageNumber=1;//要显示的页码数，默认为1
	private int totalPage;//总页数
	
	private int ID;
	private int ClassID;
	private int TestIndexID;
	private String TestRequestDate;
	private String TestStartDate;
	private String State;
	private String Del;
	private String TestIndexMemo;
	private String Project_CN;
	
	private int TestTypeID;//试题分类号，用于申请试卷
	private int TeacherID;//申请考试教师ID
	
	private String sql;
	
	public void setPageNumber(int pageNumber){this.pageNumber=pageNumber;}
	public int getPageNumber(){return this.pageNumber;}
	public void setTotalPage(int totalPage){this.totalPage=totalPage;}
	public int getTotalPage(){return this.totalPage;}
	
	public void setID(int ID){this.ID=ID;}
	public int getID(){return this.ID;}
	public void setClassID(int ClassID){this.ClassID=ClassID;}
	public int getClassID(){return this.ClassID;}
	public void setTestIndexID(int TestIndexID){this.TestIndexID=TestIndexID;}
	public int getTestIndexID(){return this.TestIndexID;}
	public void setTestRequestDate(String TestRequestDate){this.TestRequestDate=TestRequestDate;}
	public String getTestRequestDate(){return this.TestRequestDate;}
	public void setTestStartDate(String TestStartDate){this.TestStartDate=TestStartDate;}
	public String getTestStartDate(){return this.TestStartDate;}
	public void setState(String State){this.State=State;}
	public String getState(){return this.State;}
	public void setDel(String Del){this.Del=Del;}
	public String getDel(){return this.Del;}
	public void setTestIndexMemo(String TestIndexMemo){this.TestIndexMemo=TestIndexMemo;}
	public String getTestIndexMemo(){return this.TestIndexMemo;}
	public void setProject_CN(String Project_CN) throws Exception
	{try{this.Project_CN=new String(Project_CN.getBytes("8859_1"),"GB2312");}catch(Exception e){throw new Exception("编码失败！");}}
	
	public String getProject_CN(){return this.Project_CN;}
	
	public void setTestTypeID(int TestTypeID){this.TestTypeID=TestTypeID;}
	public int getTestTypeID(){return this.TestTypeID;}
	public void setTeacherID(int TeacherID){this.TeacherID=TeacherID;}
	public int getTeacherID(){return this.TeacherID;}
	
	public ClassTest(){db=new DatabaseConn();}
	
	public ClassTestData findByPrimaryKey()throws SQLException
	{
		sql="select * from View_ClassTest where ID=?";
		Connection con;
		PreparedStatement ps=null;
		ResultSet rs=null;
		try{con=db.connectToDB();}
		catch(Exception ex){throw new SQLException("Connect database failed!");}
		try
		{
			ps=con.prepareStatement(sql);
			ps.setInt(1,ID);
			rs=ps.executeQuery();
			if(rs.next())
			{return new ClassTestData(rs.getInt(1),rs.getInt(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getInt(9));}
		}
		catch(Exception ex)
		{
			System.out.println("FindByPrimaryKey ClassTest failed:"+ex.getMessage());
			throw new SQLException("FindByPrimaryKey ClassTest failed!");
		}
		finally
		{
			try{con.close();ps.close();}
			catch(SQLException sqlex){System.out.println("FindByPrimaryKey Close ClassTest Error:"+sqlex.getMessage());}
		}
		return null;
	}
	
	public Vector findAllTesting(int pageSizes)throws SQLException
	{
		System.out.println("adfa"+this.TeacherID);
		String tableName="View_ClassTest";
		String whereStr="where State='0' And Del='0' "+(this.ClassID==0?"":(" And ClassID="+this.ClassID))+
						(this.TeacherID==0?"":"  and TeacherID="+this.TeacherID);
		String orderByStr="order by TestRequestDate";
		System.out.println(whereStr);
		Vector vResults=new Vector(1,1);
		boolean bResult=false;
		//sql="select * from ClassTest where Del='0'";
		Connection con;
		CallableStatement ps=null;
		ResultSet rs=null;
		try{con=db.connectToDB();}
		catch(Exception ex){throw new SQLException("Connect database failed!");}
		try
		{
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);
			ps.setString(2,tableName);
			ps.setInt(3,88888888);//用于返回总页数
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.executeUpdate();//首先返回总页数,存储过程不能即返回总页数又返回记录集，具体用法还要再研究
			this.totalPage=ps.getInt(1);
						
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);//用于返回记录集，此参数可不带
			ps.setString(2,tableName);
			ps.setInt(3,pageNumber);
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.setString(6,orderByStr);
			
			rs=ps.executeQuery();
			bResult=rs.next();
			if(bResult)
			{
				do
				{
					vResults.add(new ClassTestData(rs.getInt(1),rs.getInt(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getInt(9)));
				}while(rs.next());
			}
		}
		catch(Exception ex)
		{
			System.out.println("FindAll ClassTest failed:"+ex.getMessage());
			throw new SQLException("FindAll ClassTest failed!");
		}
		finally
		{
			try{con.close();ps.close();}
			catch(SQLException sqlex){System.out.println("FindAll Close ClassTest Error:"+sqlex.getMessage());}
		}
		if(bResult)
		{return vResults;}
		else
		{return null;}
	}
	
	public Vector findAllTested(int pageSizes)throws SQLException
	{
		String tableName="View_ClassTest";
		String whereStr="where State='1' And Del='0' "+(this.ClassID==0?"":(" And ClassID="+this.ClassID))+(this.TeacherID==0?"":"  and TeacherID="+this.TeacherID);
		String orderByStr="order by TestRequestDate";
		
		Vector vResults=new Vector(1,1);
		boolean bResult=false;
		//sql="select * from ClassTest where Del='1'";
		Connection con;
		CallableStatement ps=null;
		ResultSet rs=null;
		try{con=db.connectToDB();}
		catch(Exception ex){throw new SQLException("Connect database failed!");}
		try
		{
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);
			ps.setString(2,tableName);
			ps.setInt(3,88888888);//用于返回总页数
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.executeUpdate();//首先返回总页数,存储过程不能即返回总页数又返回记录集，具体用法还要再研究
			this.totalPage=ps.getInt(1);
				
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);//用于返回记录集，此参数可不带
			ps.setString(2,tableName);
			ps.setInt(3,pageNumber);
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.setString(6,orderByStr);
			
			rs=ps.executeQuery();
			bResult=rs.next();
			if(bResult)
			{
				do
				{
					vResults.add(new ClassTestData(rs.getInt(1),rs.getInt(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getInt(9)));
				}while(rs.next());
			}
		}
		catch(Exception ex)
		{
			System.out.println("FindAllDeleted ClassTest failed:"+ex.getMessage());
			throw new SQLException("FindAllDeleted ClassTest failed!");
		}
		finally
		{
			try{con.close();ps.close();}
			catch(SQLException sqlex){System.out.println("FindAllDeleted Close ClassTest Error:"+sqlex.getMessage());}
		}
		if(bResult)
		{return vResults;}
		else
		{return null;}
	}
	
	public Vector findAllActivated(int pageSizes)throws SQLException
	{
		String tableName="View_ClassTest";
		String whereStr="where State='2' And Del='0' "+(this.ClassID==0?"":(" And ClassID="+this.ClassID))+(this.TeacherID==0?"":"  and TeacherID="+this.TeacherID);
		String orderByStr="order by TestRequestDate";
		
		Vector vResults=new Vector(1,1);
		boolean bResult=false;
		//sql="select * from ClassTest where Del='1'";
		Connection con;
		CallableStatement ps=null;
		ResultSet rs=null;
		try{con=db.connectToDB();}
		catch(Exception ex){throw new SQLException("Connect database failed!");}
		try
		{
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);
			ps.setString(2,tableName);
			ps.setInt(3,88888888);//用于返回总页数
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.executeUpdate();//首先返回总页数,存储过程不能即返回总页数又返回记录集，具体用法还要再研究
			this.totalPage=ps.getInt(1);
				
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);//用于返回记录集，此参数可不带
			ps.setString(2,tableName);
			ps.setInt(3,pageNumber);
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.setString(6,orderByStr);
			
			rs=ps.executeQuery();
			bResult=rs.next();
			if(bResult)
			{
				do
				{
					vResults.add(new ClassTestData(rs.getInt(1),rs.getInt(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getInt(9)));
				}while(rs.next());
			}
		}
		catch(Exception ex)
		{
			System.out.println("FindAllDeleted ClassTest failed:"+ex.getMessage());
			throw new SQLException("FindAllDeleted ClassTest failed!");
		}
		finally
		{
			try{con.close();ps.close();}
			catch(SQLException sqlex){System.out.println("FindAllDeleted Close ClassTest Error:"+sqlex.getMessage());}
		}
		if(bResult)
		{return vResults;}
		else
		{return null;}
	}
	
	public Vector findAllDeleted(int pageSizes)throws SQLException//查看做废试卷
	{
		String tableName="View_ClassTest";
		String whereStr="where Del='1' "+(this.ClassID==0?"":(" And ClassID="+this.ClassID))+(this.TeacherID==0?"":"  and TeacherID="+this.TeacherID);
		String orderByStr="order by TestRequestDate";
		
		Vector vResults=new Vector(1,1);
		boolean bResult=false;
		//sql="select * from ClassTest where Del='1'";
		Connection con;
		CallableStatement ps=null;
		ResultSet rs=null;
		try{con=db.connectToDB();}
		catch(Exception ex){throw new SQLException("Connect database failed!");}
		try
		{
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);
			ps.setString(2,tableName);
			ps.setInt(3,88888888);//用于返回总页数
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.executeUpdate();//首先返回总页数,存储过程不能即返回总页数又返回记录集，具体用法还要再研究
			this.totalPage=ps.getInt(1);
				
			ps=con.prepareCall("{call pr_splitPage(?,?,?,?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);//用于返回记录集，此参数可不带
			ps.setString(2,tableName);
			ps.setInt(3,pageNumber);
			ps.setInt(4,pageSizes);
			ps.setString(5,whereStr);
			ps.setString(6,orderByStr);
			
			rs=ps.executeQuery();
			bResult=rs.next();
			if(bResult)
			{
				do
				{
					vResults.add(new ClassTestData(rs.getInt(1),rs.getInt(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),rs.getInt(9)));
				}while(rs.next());
			}
		}
		catch(Exception ex)
		{
			System.out.println("FindAllDeleted ClassTest failed:"+ex.getMessage());
			throw new SQLException("FindAllDeleted ClassTest failed!");
		}
		finally
		{
			try{con.close();ps.close();}
			catch(SQLException sqlex){System.out.println("FindAllDeleted Close ClassTest Error:"+sqlex.getMessage());}
		}
		if(bResult)
		{return vResults;}
		else
		{return null;}
	}
	
	public int insert()throws SQLException
	{
		//sql="insert into ClassTest (ClassID,TestIndexID,TestRequestDate) values(?,?,getDate())";
		Connection con;
		CallableStatement ps=null;
		
		try{con=db.connectToDB();}
		catch(Exception ex){throw new SQLException("Connect database failed!");}
		boolean bTemp;
		try
		{
			ps=con.prepareCall("{?=call pr_CreateClassTest(?,?,?)}");
			ps.registerOutParameter(1,java.sql.Types.INTEGER);
			ps.setInt(2,ClassID);
			ps.setInt(3,TestTypeID);
			ps.setInt(4,TeacherID);
			ps.executeUpdate();
			int returnValue=ps.getInt(1);
			if(returnValue==-1)
			{
				throw new SQLException("申请失败：试卷库中没有你所要的试卷，请联系管理员增加试卷!");
			}
			else if(returnValue==-2)
			{