opendb.java

实例大全

package opendb;  //定义包opendb
import java.sql.*;   //引入java.sql.*

//包中的类opendb
public class opendb {    
	String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";  //数据库连接字符串:jdbc-odbc桥
	String sConnStr="jdbc:odbc:myuser";
	Connection conn=null;
	ResultSet rs=null;

	//定义打开数据库连接的函数
	public opendb() {
		try
		{
			Class.forName(sDBDriver);
		}
		catch (Java.lang.ClassNotFoundException e)
		{
			System.err.println("opendb():"+e.getMessage());
		}
	}

	//定义执行sql语句的函数
	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;//返回sql语句的执行结果
	}
}