faqbean.java

java 数据库编程源代码

package faq;
import java.sql.*;

/**
 * Title:        “常见问题及解答”Internet数据库应用系统
 * Description:  Java语言演示程序：“常见问题及解答”Internet数据库应用系统，用于北京师范大学计算机系Java课程教学示范。
 * Copyright:    Copyright (c) 2002
 * Company:      北京师范大学计算机系
 * @author 孙一林
 * @version 1.0
 */

public class faqBean {
    protected String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
    protected String dbURL = "jdbc:odbc:faq";
    protected String userID = "faq";
    protected String passwd = "123456";
    Driver d;
    Connection con;
    Statement stmt;
    ResultSet dbresults;
    public faqBean (){
      try{
        d = (Driver)Class.forName(driverName).newInstance();
      }
      catch(Exception e){
        System.out.println ("错误：" + e.getMessage ());
      }
    }
    public ResultSet MyExecuteQuery(String sql){
      dbresults = null;
      try{
        con = DriverManager.getConnection(dbURL, userID, passwd);
        stmt = con.createStatement();
        dbresults = stmt.executeQuery(sql);
      }
      catch(SQLException ex){
	System.err.println("SQL执行错误：" + ex.getMessage());
      }
      return dbresults;
    }
}