connect.java

beginJsp2.0外文书籍源代码

package com.wrox.library;
import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class Connect {

  String stat = "Not Connected";

  public void init() {
    try {
      Context ctx = new InitialContext();
      if(ctx == null )
          throw new Exception("Oops - No Context");

      DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/BooksDB");

      if (ds != null) {
        Connection conn = ds.getConnection();

        if(conn != null) {
          stat = " Got Connection "+conn.toString();
          conn.close();
        }
      }
    } catch(Exception e) {
      e.printStackTrace();
    }
  }

  public String getstat() {
    return stat;
  }
}