userlogin.java

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

package tom;
import java.sql.*;
public class Userlogin{
	static String username;
	String password,success="false";
	String type;
	boolean judge;
	Connection con;
	Statement st;
	ResultSet rs;
	
	public Userlogin(){
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){
			e.printStackTrace(System.err);
		};
	}
	
	public void setUsername(String username){
		this.username=username;
	}
	public String getUsername(){
		return this.username;
	}
	public void setPassword(String password){
		this.password=password;
	}
	public String getPassword(){
		return this.password;
	}
	public String getSuccess(){
		return this.success;
	}
	public void setType(String type){
		this.type=type;
	}
	public String getType(){
		return this.type;
	}
	
	public boolean checkValue(){
		try{
			con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			st=con.createStatement();
			String sql="SELECT * FROM userinfo WHERE username='"+this.username+"'";
			rs=st.executeQuery(sql);
			
			int rowCount=0;
			String ps=null;
			while(rs.next()){
				rowCount++;
				username=rs.getString("username");
				ps=rs.getString("password");
			}
			if(rowCount==1&&password.equals(ps)){       
			     
				            success="ok";
					        judge=true;
			     					
			}
			else {
				
			    success="false";
				judge=false;
			}
			con.close();
			return judge;
			}
					
		
		catch(SQLException e){
			e.printStackTrace(System.err);
			success="false";
			judge = false;
			return judge;	}
	    
	   
	    
	}
	public boolean checkType(){
		try{
			con=DriverManager.getConnection("jdbc:odbc:grad","xiaoyan","");
			st=con.createStatement();
			String sql="SELECT type FROM userinfo WHERE username='"+this.username+"'";
			rs=st.executeQuery(sql);
			
			String t=null;
			while(rs.next()){
				t=rs.getString("type");
			    
			}
			if(type.equals(t)){
				return true;
			}
			else{
				return false;
			}
			
		}
		catch(SQLException e){
			e.printStackTrace(System.err);
			return false;
		}
	}
	
}