dbcon.java~8~

一个看上去不错的JAVA毕业设计作品

package zcgl;
/*
 *DbConn.java:建立数据库的连接。
 */

import java.sql.*;
import java.math.*;
public class DbCon {
   private Connection conn;
   public DbCon() {
      try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn = DriverManager.getConnection("jdbc:odbc:MyDatabase","","");
      }
      catch (java.sql.SQLException s) {
        System.out.println("exception: " + s.getMessage());
      }catch(ClassNotFoundException s){s.getMessage();}
   }
   public Connection getConnection() {
        return conn;
   }
   public ResultSet execute(String sqlstr){
       ResultSet rs=null;
    try {
        Statement smt = getConnection().createStatement();
        rs=smt.executeQuery(sqlstr);

    } catch (SQLException ex) {
    }
    return rs;
   }
}