score.java

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

package tom;

import java.sql.*;

public class Score{
	private String username,time;
	private int score1,score2,score;
	
	public Score(){
		try{
			    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }
			 catch(ClassNotFoundException e){}
	}
	
	public void setUsername(String username){
		this.username=username;
	}
	
	public String getUsername(){
		return this.username;
	}
	
	public void setTime(String time){
		this.time=time;
	}
	
	public String getTime(){
		return this.time;
	}
	
		public void setScore(int score){
		this.score=score;
	}
	
	public int getScore(){
		return this.score;
	}
	
		public void setScore1(int score1){
		this.score1=score1;
		}
	
	public int getScore1(){
		return this.score1;
	}
	
	public void setScore2(int score2){
		this.score2=score2;
	}
	
	public int getScore2(){
		return this.score2;
	}
	
	 public void update(){
	   
			try{
		    Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="INSERT INTO score VALUES"+"('"+username+"','"+score1+"','"+score2+"','"+score+"','"+time+"')";
		    st.executeUpdate(sql);
		
		    }
		catch(SQLException e){
			e.printStackTrace(System.err);
						
		} }
/*	public boolean checkRefurbish(String username,String time){
		boolean check;
		try{
			
		    Connection con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			Statement st=con.createStatement();
			String sql="SELECT * WHERE username='"+username+"'AND time='"+time+"'";
			ResultSet rs=st.executeQuery(sql);
			if(!rs.next())
			    check=true;
			else
			    check=false;
	      }
	      catch(SQLException e){
			e.printStackTrace(System.err);
			check=true;
		  }
		  return check;
		  }*/
}