displayformbean.java

JAVA数据库编程实例随书源码

package displayform;
import java.sql.*;
import java.util.Vector;

/**
 * Title:        JSP显示数据库数据
 * Description:  Java语言演示程序：JSP显示数据库数据，用于北京师范大学计算机系Java课程教学示范。
 * Copyright:    Copyright (c) 2002
 * Company:      北京师范大学计算机系
 * @author 孙一林
 * @version 1.0
 */

public class DisplayFormBean {
    protected String driverName = "interbase.interclient.Driver";
    protected String dbURL = "jdbc:interbase:student.gdb";
    protected String userID = "SYSDBA";
    protected String passwd = "masterkey";
    Driver d;
    Connection con;
    Statement stmt;
    ResultSet dbresults;
    private Vector result;
    public DisplayFormBean() {
      result = new Vector();
    } // constructor DisplayFormBean
    public String connect() {
      try {
        d = (Driver)Class.forName(driverName).newInstance();
        return "加载数据库驱动程序成功！";
      } catch (Exception E) {
        return "加载数据库驱动程序失败！";
      }
    }
    public String select() {
      try {
        con = DriverManager.getConnection(dbURL, userID, passwd);
        stmt = con.createStatement();
        dbresults = stmt.executeQuery("SELECT * from studentbase");
        while (dbresults.next()) {
          result.addElement(dbresults.getString(1));
        }
        dbresults.close();    // Clean up
        stmt.close();
        con.close();
        return "连接数据库成功！";
      } catch (SQLException E) {
        return "连接数据库错误"+"SQLException: " + E.getMessage();
      }
    }
    public Vector getResult() {
      return result;
    }
    public void setResult(Vector avector) {
      result = avector;
    }
} // class DisplayFormBean