checkinfo_idpwd.java

一个小型的BBS系统

package bean.check;
import java.sql.*;
public class Checkinfo_idpwd {
	private String name;
	private String password;
	Statement stmt;
	ResultSet rs;
	public Checkinfo_idpwd(){
		this.name="";
		this.password="";
	}
	
	
	public String getName() {
		return name;
	}


	public void setName(String name) {
		this.name = name;
	}


	public String getPassword() {
		return password;
	}


	public void setPassword(String password) {
		this.password = password;
	}

	//用户登陆检测
	public int Check_login(Connection con,String id,String pwd){
		try{
			id=id.trim();
			pwd=pwd.trim();
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			String sql="select ID from UserID where ID='"+id+"'";
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				name = rs.getString(1).trim();
			}
			if(name.equals("")||!name.equals(id)){
				return 0;//用户名无效
			}
			else{
				sql = "select PWD from UserID where ID='"+id+"'";
				rs =stmt.executeQuery(sql);
				while(rs.next()){
					password = rs.getString(1).trim();
				}
				if(password.equals(pwd)){
					int control=0;
					sql = "select Control from UserID where ID='"+id+"'";
					rs = stmt.executeQuery(sql);
					while(rs.next()){
						control = rs.getInt(1);
					}
					if(control==1)
						return 1;//用户名密码正确 版主
					else if(control==0)
						return 3;//普通用户
					else return 4;//超级用户
				}
				else return 2;//密码错误
			}
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
		return 3;//逻辑错误 以上都没发生
	}
	
	
	
}