jsp 串連oralce資料庫並顯示記錄

jsp教程 串連oralce資料庫教程並顯示記錄

public class UserDAO {
    private Connection conn = null;
  private Statement st = null;
 
  public UserDAO() {
 
  try {
  Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
  conn = DriverManager
  .getConnection
  ("jdbc:oracle:thin:@192.168.1.107:1521:ZHUH",
  "zucc","123456");
  } catch (Exception ex) {
  ex.printStackTrace();
  }
  }

  public synchronized void release() {
  if (st != null) {
  try {
  st.close();
  } catch (Exception e) {
  }
  }

  if (conn != null) {
  try {
  conn.close();
  } catch (Exception e) {
  }
  }

  }
  public synchronized boolean checkuser(ActFrmUsers user) throws Exception{
  boolean bl=false;
  try{
  st = conn.createStatement();//這句話放這裡
  ResultSet rs=st.executeQuery("select * from users");
  while(rs.next()){
 
  System.out.print("qw");
  }
  }
  catch(Exception ex){
  ex.printStackTrace();
  throw new Exception("資料庫查詢錯誤");
  }
  return bl;
  }
}