userdb.java~4~

网上书店,JSP,MYSQL,struct,spring,hibernate

/** access mysql database through JDBC Driver */
package bookshoppingsys;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
import java.util.*;

public class UserDB {

  private ArrayList users;

  public UserDB () throws Exception{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  }

  public Connection getConnection()throws Exception{
      return java.sql.DriverManager.getConnection("jdbc:odbc:Shopping");
  }

  public void closeConnection(Connection con){
    try{
        if(con!=null) con.close();
      }catch(Exception e){
        e.printStackTrace();
      }
  }

  public void closePrepStmt(PreparedStatement prepStmt){
    try{
        if(prepStmt!=null) prepStmt.close();
      }catch(Exception e){
        e.printStackTrace();
      }
  }

  public void closeResultSet(ResultSet rs){
    try{
        if(rs!=null) rs.close();
      }catch(Exception e){
        e.printStackTrace();
      }
  }
  public UserDetails getUserDetails(String username) throws Exception {
    Connection con=null;
    PreparedStatement prepStmt=null;
    ResultSet rs =null;
    try {
      con=getConnection();
      String selectStatement = "select * from book where username = ? ";
      prepStmt = con.prepareStatement(selectStatement);
      prepStmt.setString(1, username);
//      prepStmt.setString(2, password);
      rs = prepStmt.executeQuery();

      if (rs.next()) {
        UserDetails ud = new UserDetails(rs.getInt(1), rs.getString(2), rs.getString(3),
         rs.getString(4),rs.getString(5), rs.getString(6), rs.getString(7),rs.getString(8),
         rs.getString(9));
        prepStmt.close();

        return ud;
      }
      else {
        return null;
      }
    }finally{
      closeResultSet(rs);
      closePrepStmt(prepStmt);
      closeConnection(con);
    }
  }
}