dbconn.java

来自「代码是自己我的代码不是网上down的。是自己写的。里面有很多值得学习的知识点。还」· Java 代码 · 共 46 行

package zcgl;
import java.sql.*;
import java.math.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DBConn {
    private Connection conn;
    public DBConn() throws ClassNotFoundException {
        try
        {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn=DriverManager.getConnection("jdbc:odbc:MyDatabase","sa","");
        }
        catch(SQLException ex)
        {
            System.out.println("exception: " + ex.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;
   }


}