dbconn.java

来自「网上银行 JSP开发~JAVASript貌似有点多」· Java 代码 · 共 50 行

package pp;

import java.sql.*;
public class dbconn{
  String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr = "jdbc:odbc:FirstBank";
  Connection conn = null;
  ResultSet rs = null;
  public dbconn() {
    try {
      Class.forName(sDBDriver);
    }
    catch(java.lang.ClassNotFoundException e) {
      System.err.println("sunshine(): " + e.getMessage());
    }
  }
  public ResultSet executeQuery(String sql) {
  	rs = null;
		try {
			conn = DriverManager.getConnection(sConnStr);
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		}
		catch(SQLException ex) {
			System.err.println("aq.executeQuery: " + ex.getMessage());
		}
		return rs;
	}
  public void executeUpdate(String sql) {
		try {
			conn = DriverManager.getConnection(sConnStr);
			Statement stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			System.out.println(sql);
		}
		catch(SQLException ex) {
			System.err.println("aq.executeUpdate: " + ex.getMessage());
		}
	}
  public void closeConn()
  {
		try {
			conn.close();	
		}
		catch(SQLException ex) {
			System.err.println("aq.executeQuery: " + ex.getMessage());
		}
  }
}