checkinfo.java

一个小型的BBS系统

package bean.check;

import java.sql.*;

public class checkinfo {
	private String name="";
	private String pwd="";
	private String subpwd="";
	private String tname="";
	Statement stmt;
	ResultSet rs;
	
	public checkinfo(){
		
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPwd() {
		return pwd;
	}
	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	public int checkname(Connection con){//检查信息是否合法 返回0：用户名重复 返回1：2次密码错误 返回2：正确
		try{
			stmt = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery("select id from UserID");
			while(rs.next()){
				String tempname=rs.getString(1);
				if(name.equals(tempname))
					return 0;//用户名重复
			}
			stmt.close();
			rs.close();
			if(!pwd.equals(subpwd))
				return 1;//2次密码不一致
			else if(pwd=="")
				return 4;//密码空
			rs = stmt.executeQuery("select name from UserID");
			while(rs.next()){
				String temptname =rs.getString(1);
				if(temptname.equals(tname))
					return 3;//昵称重复
			}
		}catch(SQLException s){
			System.out.println(s.toString());
		}
		return 2;//无错误
	}
	public String getSubpwd() {
		return subpwd;
	}
	public void setSubpwd(String subpwd) {
		this.subpwd = subpwd;
	}
	public String getTname() {
		return tname;
	}
	public void setTname(String tname) {
		this.tname = tname;
	}
	
}