userreg.java

《J2EE企业级应用开发》一书的配套源代码

package com.j2eeapp.ch18;
import java.sql.*;
import javax.sql.DataSource;
import com.j2eeapp.util.DatabaseConn;
public class UserReg
{
	private Connection conn;
	private  String id,password,address,sex;
	private int age;
	public UserReg()throws Exception{
		try
		{
			this.conn=DatabaseConn.getConnection();
		}
		catch(SQLException e)
		{
			System.out.println(e.getMessage());
		}
	}
	//setter
	public void setId(String id){this.id=id;}
	public void setAge(int age){this.age=age;}
	public void setPassword(String password){
		this.password=password;
	}
	public void setAddress(String address){
		this.address=address;
	}
	public void setSex(String sex){
		this.sex=sex;
	}
	
	//getter
	public String getId(){return id;}
	public String getPassword(){return password;}
	public String getAddress(){return address;}
	public String getSex(){return sex;}
	public int getAge(){return age;}
	
	public boolean regUser()throws SQLException
	{
		String sql="insert into UserInfo values(?,?,?,?,?)";
		PreparedStatement prstmt=conn.prepareStatement(sql);
		prstmt.setString(1,id);
		prstmt.setString(2,password);
		prstmt.setString(3,address);
		prstmt.setString(4,sex);
		prstmt.setInt(5,age);
		boolean re=prstmt.execute();
		prstmt.close();
		conn.close();
		return re;
	}
}