databasecon.java

JSP课件以及一个网上书店系统程序,带数据库

package test.db;
import java.io.*;
import java.sql.*;
public class DatabaseCon  {
  public Connection con;
  public String URL = "jdbc:odbc:mybooks";
  public String Message;
  public boolean connection()   {
    try{
      //加载JDBC-ODBC桥驱动程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch(ClassNotFoundException ex){
      Message=ex.getMessage();
      System.exit(-1);
    }
    try{
      //试图通过JDBC-ODBC桥建立一个与myBooks数据源的连接
         con = DriverManager.getConnection(URL);
       //数据库连接成功
       return true;
    }
    catch(SQLException ex){
      Message=ex.getMessage();
      return false;
    }
  }
  //关闭数据库连接
  public boolean close(){
    try{
           con.close();
          return true;
    }
     catch(Exception ex){
          Message=ex.getMessage();
          return false;
      }
  }
  public ResultSet exeSQL(String sqlstr)   {
  try{
      connection();
      Statement stmt=con.createStatement();
      ResultSet rs=stmt.executeQuery(sqlstr);
      return rs;
  } catch(Exception ex){
    Message=ex.getMessage();
 }
  return null;
}
 }