user.java

jsp2.0动态网站开发实例指南原代码

//user.java
package law;
import java.sql.*;
public class user{
	String id;
	String password;
	String login;//value->"true" or "false"
	public user(){
		id="";
		password="";
		login="false";
		}
	public String getId(){return id;}
	public String getPassword(){return password;}
	public String getLogin(){return login;}
	public void setId(String value){id=value;}
	public void setPassword(String value){password=value;}
	public void setLogin(String value){
		if(value.equals("true")||value.equals("false")){
			login=value;
		}
	}
	public void checkID(){
		login="false";
		if(!id.equals("")){
			Connection con;
  			Statement sql;
  			ResultSet rs;
			try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			      	con=DriverManager.getConnection("jdbc:odbc:law","","");
			     	sql=con.createStatement();
			      	String condition="SELECT * FROM user WHERE id="+"'"+id+"'";
			      	rs=sql.executeQuery(condition);
			      	String pwd;
			      	int rowcount=0;
	      			while(rs.next()){
	        			pwd=rs.getString("password");
	        			if(pwd.equals(password))
	        				rowcount++;
	        		}
	        		if((rowcount==1))
	        			login="true";
			      	con.close();
		    	}catch(SQLException e){
		    	}catch(ClassNotFoundException e){
			}
		}
	}
}