suboption.java

jsp+javabean的一个在线考试系统的设计（包含教学文档）

package tom;

import java.sql.*;
import java.io.*;
import tom.Getnum;

public class SubOption{
	private String csubject,csubanswer,jsubject,ckey,jkey;
	private static int chapter;
	Connection con=null;
	Statement st=null;
	ResultSet rs=null;
	
	public SubOption(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){
			e.printStackTrace(System.err);
		}
	}
		
	public void setCsubject(String csubject){
		this.csubject=csubject;
	}

	public String getCsubject(){
		return csubject;
	}

	public void setCsubanswer(String csubanswer){
		this.csubanswer=csubanswer;
	}

	public String getCsubanswer(){
		return csubanswer;
	}

	public void setJsubject(String jsubject){
		this.jsubject=jsubject;
	}

	public String getJsubject(){
		return jsubject;
	}

	public void setCkey(String ckey){
		this.ckey=ckey;
	}

	public String getCkey(){
		return this.ckey;
	}
	
	public void setJkey(String jkey){
		this.jkey=jkey;
	}
	
	public String getJkey(){
		return this.jkey;
	}
	
	public void setChapter(int chapter){
		this.chapter=chapter;
	}
	
	public int getChapter(){
		return this.chapter;
	}

	/*public void setJChapter(String jChapter){
		this.jChapter=jChapter;
	}
	
	public String getJChapter(){
		return this.jChapter;
	}
    */
    public boolean csubAdd(){
    	boolean judge;
    	Getnum amount=new Getnum();
    	int cid=amount.getC_amount()+1;
    	try{
    		con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
    		st=con.createStatement();
    		String sql="INSERT INTO choice VALUES ('"+cid+"','"+csubject+"','"+csubanswer+"','"+ckey+"',2,'"+chapter+"')";
    		st.executeUpdate(sql);
    		judge=true;
    		con.close();
    	}
    	catch(SQLException e){
    	    judge=false;	
    	}
    	
    	return judge;
    }
    
    public boolean jsubAdd(){
    	boolean judge;
    	Getnum amount=new Getnum();
    	int jid=amount.getJ_amount()+1;
    	try{
    		con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
    		st=con.createStatement();
    		String sql="INSERT INTO judge VALUES ('"+jid+"','"+jsubject+"','"+jkey+"',2,'"+chapter+"')";
    		st.executeUpdate(sql);
    		judge=true;
    		con.close();
    	}
    	catch(SQLException e){
    	    judge=false;	
    	}
    	
    	return judge;
    }
    
/*    public void subQuery(int subtype,javax.servlet.jsp.JspWriter out){
    	try{
    		con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
    		st=con.createStatement();
    		String sql1="SELECT * FORM choice WHERE chapter='"+chapter+"'";
    		String sql2="SELECT * FORM judge WHERE chapter='"+chapter+"'";
    		if(subtype==0){
    			
    			rs=st.executeQuery(sql1);
    			try{
    				out.print("<table>");
    			    while(rs.next()){
    			    
    				     String s1="<form action=delsub.jsp method=post>";
    				     String s2="<input type=hidden value="+rs.getInt("cid")+">";
    				     String s3="<input type=submit value=删除></form>";
    				     String s=s1+s2+s3;
    				     out.print("<tr>");
    				     out.print("<td>"+rs.getString("csub")+"<br>"+rs.getString("canswer")+"</td>");
    				     out.print("<td>"+s+"</td>");
    				     out.print("</tr>");
    				     
         			}
         			
         			out.print("</table>");
    			
    			}
    			catch(IOException e){
    			}
    		}
    		else if(subtype==1){
    			rs=st.executeQuery(sql2);
    			try{
    				out.print("<table>");
    			    while(rs.next()){
    				     String s1="<form action=delsub.jsp method=post>";
    				     String s2="<input type=hidden value="+rs.getInt("jid")+">";
    				     String s3="<input type=submit value=删除></form>";
    				     String s=s1+s2+s3;
    				     out.print("<tr>");
    				     out.print("<td>"+rs.getString("jsub")+"</td>");
    				     out.print("<td>"+s+"</td>");
    				     out.print("</tr>");
    				     
         			}
         			
         			out.print("</table>");
    			
    			}
    			catch(IOException e){
    			}
    		}
    		con.close();//********************
    	}
    	catch(SQLException e){
    	    }
  }*/
  public void subQuery1(javax.servlet.jsp.JspWriter out){
  	 try{
  	 	con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
        st=con.createStatement();
        String sql="SELECT * FROM choice WHERE chapter like'"+Integer.toString(chapter).trim()+"'";
        st.execute(sql);
        rs=st.getResultSet();
        try{
    		out.print("<table>");
    		while(rs.next()){
    		String s1="<form action=subDel.jsp method=post>";
    		String s2="<input type=hidden name=subid value="+rs.getInt("cid")+">";
    		String s4="<input type=hidden name=subtype value=0>";
    		String s3="<input type=submit value=删除></form>";
    		String s=s1+s2+s4+s3;
    		out.print("<tr>");
    		out.print("<p><td>"+rs.getString("csub")+"<br>"+rs.getString("canswer")+"</td>");
    		out.print("<td>"+s+"</td>");
    		out.print("</tr>");
    		    
         	}
         			
        out.print("</table>");
    			
    	}
    	catch(IOException e){
    			}
    			
    	con.close();
  	 }
  	 catch(SQLException e){
  	 }
  	 
  }
  
  public void subQuery2(javax.servlet.jsp.JspWriter out){
  	try{
  		con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
        st=con.createStatement();
        String sql="SELECT * FROM judge WHERE chapter like'"+Integer.toString(chapter).trim()+"'";
        st.execute(sql);
        rs=st.getResultSet();
        try{
    	   out.print("<table>");
    	   while(rs.next()){
    	   String s1="<form action=subDel.jsp method=post>";
    	   String s2="<input type=hidden name=subid value="+rs.getInt("jid")+">";
    	   String s4="<input type=hidden name=subtype value=1>";
    	   String s3="<input type=submit value=删除></form>";
    	   String s=s1+s2+s4+s3;
    	   out.print("<tr>");
    	   out.print("<p><td>"+rs.getString("jsub")+"</td>");
    	   out.print("<td>"+s+"</td>");
    	   out.print("</tr>");
    				     
           }
         			
         out.print("</table>");
    			
    	}
	catch(IOException e){
		}
		
	con.close();
  	}
  	catch(SQLException e){
  	}
  }
   
  public boolean delSub1(int csubid){
  	boolean judge;
  	//int newId=csubid;
  	 try{
  	 	con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
    	st=con.createStatement();
    	String sql="DELETE FROM choice WHERE cid='"+Integer.toString(csubid)+"'";
    	String sql1="UPDATE choice SET cid=cid-1 WHERE cid>'"+Integer.toString(csubid)+"'";
    	st.addBatch(sql);
    	st.addBatch(sql1);
    	st.executeBatch();
    	judge=true;
  	 	con.close();
  	 }
  	 catch(SQLException e){
  	 	judge=false;
  	 }
  	 return judge;
  }
  
  public boolean delSub2(int jsubid){
  	boolean judge;
  	
  	 try{
  	 	con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
    	st=con.createStatement();
    	String sql="DELETE FROM judge WHERE jid='"+Integer.toString(jsubid)+"'";
    	String sql1="UPDATE judge SET jid=jid-1 WHERE jid>'"+Integer.toString(jsubid)+"'";
    	st.addBatch(sql);
    	st.addBatch(sql1);
    	st.executeBatch();
    	judge=true;
  	 	con.close();
  	 }
  	 catch(SQLException e){
  	 	judge=false;
  	 }
  	 return judge;
  }
     
}