querydb.java

beginJsp2.0外文书籍源代码

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

public class Querydb {

  String title = "No title";
  float price=0.00f;

  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)  {
          Statement stmt = conn.createStatement();
          ResultSet rst = stmt.executeQuery("select * from book");
          if(rst.next()) {
            title=rst.getString(2);
            price=rst.getFloat("Price");
          }

          conn.close();
        }
      }
    } catch(Exception e) {
      e.printStackTrace();
    }
  }

  public String getTitle() { return title; }
  public float getPrice() { return price; }
}