register.java

来自「一个日程管理和通讯录管理的软件,采用的Access数据库,其中用到了三个自已写的」· Java 代码 · 共 76 行

package myBeans;
import java.sql.*;

public class Register {
	String Eno,name,password,email,phone;
	String eno1;
	String message;
	Connection con;
	Statement sql;
	ResultSet rs;
	public Register(){
		//加载桥接器
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
	}
	//设置属性值、获取属性值的方法
	public void setEno(String num){
		Eno=num;
	}
	public String getEno(){
		return Eno;
	}
	public void setName(String name){
		this.name=name;
	}
	public String getName(){
		return name;
	}
	public void setPassword(String str){
		password=str;
	}
	public String getPassword(){
		return password;
	}
	public void setEmail(String em){
		email=em;
	}
	public String getEmail(){
		return email;
	}
	public void setPhone(String ph){
		phone=ph;
	}
	public String getphone(){
		return phone;
	}
	public String getMessage(){
		return message;
	}
	
	//添加记录到数据库的User表
	public void addItem(){
		try{
			con=DriverManager.getConnection("jdbc:odbc:bysj","","");
			sql=con.createStatement();
			String s="'"+eno1+"',"+"'"+name+"',"+"'"+password
			+"',"+"'"+email+"',"+"'"+phone+"'";
			String condition="INSERT INTO users VALUES"+"("+s+")";
			System.out.println(condition);
			sql.executeUpdate(condition);
			message="注册成功！";
			con.close();
		}catch(SQLException e){
			message="你还没有注册，或该用户已经存在，请你更换一个名字";
		}
	}
	public String getEno1() {
		return eno1;
	}
	public void setEno1(String eno1) {
		this.eno1 = eno1;
	}
	
}