databaseconn.java

J2EE指南

package javaBeanClass;
import java.sql.*;
public class DatabaseConn
{
	String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr="jdbc:odbc:onLineTest";
	Connection conn=null;
	ResultSet rs=null;
	public DatabaseConn()
	{
		try
		{
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("JDBC-ODBC桥驱动无法加载,错误信息:"+e.getMessage());
		}
	}
	public Connection connectToDB()throws SQLException//连接数据库的方法
	{
		Connection con=DriverManager.getConnection(sConnStr,"","");
		return con;
	}
	public ResultSet executeQuery(String sql)
	{
		rs=null;
		try
		{
			conn=connectToDB();
			Statement stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException se)
		{
			if (!se.getMessage().equals("No ResultSet was produced"))
			System.err.println("无法进行SQL连接和查询，错误信息:"+se.getMessage());
		}
		finally
		{
			try{conn.close();rs.close();}
			catch(SQLException sqlex){System.out.println("Error:"+sqlex.getMessage());}
		}
		return rs;
	}
}