package dbbean;/** * Title:			JSP頁面使用JavaBean連接數(shù)據(jù)庫 * Description:			教學(xué)示范 * Copyright:			Copyright (c) 2003 * Company:			北京師范大學(xué)計(jì)算機(jī)系 * @author			孫一林 * @version			1.0 */import java.io.*;import java.sql.*;import java.util.*;public class dbBean {  private Connection connection = null;                //定義與數(shù)據(jù)庫進(jìn)行連接的Connection對象  private Statement statement = null;                  //定義查詢數(shù)據(jù)庫的Statement對象  private ResultSet rs = null;                         //定義數(shù)據(jù)庫查詢的結(jié)果集  public dbBean() {  }  public ResultSet getTableData(String tableName)      //根據(jù)用戶指定的表名取出表中數(shù)據(jù)并返回  {    try    {      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");   //指定與數(shù)據(jù)庫連接使用JDBC-ODBC橋驅(qū)動(dòng)程序      String url = "jdbc:odbc:student";                   //指定數(shù)據(jù)源名      connection = DriverManager.getConnection(url);   //與數(shù)據(jù)源建立連接      String sql = "select * from " + tableName;       //創(chuàng)建取出用戶指定表中所有數(shù)據(jù)的SQL語句      Statement statement = connection.createStatement();  //創(chuàng)建Statement接口實(shí)例      ResultSet rs = statement.executeQuery(sql);          //將數(shù)據(jù)存入結(jié)果集中      return rs;    }    catch(SQLException ex){                            //捕捉異常      System.out.println("\nERROR:----- SQLException -----\n");      while (ex != null) {        System.out.println("Message:   " + ex.getMessage());        System.out.println("SQLState:  " + ex.getSQLState());        System.out.println("ErrorCode: " + ex.getErrorCode());        ex = ex.getNextException();      }    }    catch(Exception ex ) {      ex.printStackTrace();    }    return null;  }}