registerbean.java

一个购物网站

package register;
import java.sql.*;
import java.util.*;
public class RegisterBean {
	private Connection getConnection(){
		Connection con=null;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException ce){
			System.out.println("ClassNotFoundException:"+ce.getMessage());
		}
		try{
			con=DriverManager.getConnection("jdbc:odbc:gamezone");
		}catch(SQLException e){
			System.out.println("RegisterBean SQLException:"+e.getMessage());		
		}
		return con;
	}

	public boolean updateUser(String sql){
		Connection con=null;
		Statement stmt=null;
		try{
			con=getConnection();
			stmt=con.createStatement();
			stmt.executeUpdate(sql);
			stmt.close();
			stmt=null;			
		}catch(SQLException e){
			System.out.println("SQLException="+e.getMessage());
		}finally{
			if(con!=null){
				try{
					con.close();
				}catch(SQLException e){
					System.out.println("SQLException:"+e.getMessage());		
				}
			}
		}
		return true;
	}
	
public int getUserId(){
		Connection con=null;
		ResultSet rs=null;
		Statement stmt=null;
		int userid=0;
		try{
			con=getConnection();
			stmt=con.createStatement();
			rs=stmt.executeQuery("select userId from userInfo");
			while(rs.next()){
				userid=rs.getInt("userId");
			}
			rs.close();
			rs=null;
			stmt.close();
			stmt=null;			
		}catch(SQLException e){
			System.out.println("SQLException="+e.getMessage());
		}finally{
			if(con!=null){
				try{
					con.close();
				}catch(SQLException e){
					System.out.println("SQLException:"+e.getMessage());		
				}
			}
		}
		return userid;
	}

}