userbean.java

我参加SUN JAVA 初级比赛的答卷 一个注册模块

package org.dyq.math.connDB;

public class userBean {
	private String username;
	private String realname;
	private String userpwd;
	private String email;
	private String sex;
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getRealname() {
		return realname;
	}
	public void setRealname(String realname) {
		this.realname = realname;
	}
	public String getUserpwd() {
		return userpwd;
	}
	public void setUserpwd(String userpwd) {
		this.userpwd = userpwd;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public boolean isExit(String username){
		boolean isExit=false;
		ConnDB db=new ConnDB();
		if(db.createConn()){
			String sql="select * from users where username='"+username+"'";
			db.query(sql);
			if(db.next())isExit=true;
		}
		db.closeConn();
		return isExit;
	}
	public void add(String username,String realname,String userpwd,String email,String sex){
		ConnDB db=new ConnDB();
		if(db.createConn()){
			if(!isExit(username)){
				String sql="insert into users(username,realname,userpwd,email,sex) values('"+username+"','"+
											  realname+"','"+userpwd+"','"+email+"','"+sex+"')";
				db.update(sql);
				db.closeConn();
			}
		}
	}

}