conndb.java

一个完整的

package com.gforce.currency.web;
//package test;
import java.sql.*;
public class connDb {
	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr = "jdbc:odbc:webgrid";
	Connection conn = null;
	ResultSet rs = null;
	public connDb() {
		try {
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println("connDb(): " + 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("connDb.executeQuery: " + ex.getMessage());
		}
		return rs;
	}
}