dbbean.java

来自「JSP写的通信薄管理系统里面有详细介绍。应该适合大家使用」· Java 代码 · 共 67 行

package dbBean;
import java.sql.*;
public class DBBean
{
	private String driverStr="sun.jdbc.odbc.JdbcOdbcDriver";
	private String connStr="jdbc:odbc:USER";
	private Connection conn=null;
	private Statement stmt=null;
	
	public DBBean()
	{
		try{
			//加载驱动程序
			
			Class.forName(driverStr);
			
		}
		catch(ClassNotFoundException ex){
			System.out.println(ex.getMessage());
		}
	}
	
	public ResultSet executeQuery(String sql)
	{
		ResultSet rs=null;
		try{
			//获取驱动程序对象和指定数据库之间的连接对象
			conn=DriverManager.getConnection("jdbc:odbc:USER","","");
			//建立语句对象
			stmt=conn.createStatement();
			//执行SQL语句，返回一个结果集对象
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
		return rs;
	}
	
	public int executeUpdate(String sql)
	{
		int result=0;
		try{
			conn=DriverManager.getConnection("jdbc:odbc:USER","","");
			stmt=conn.createStatement();
			result=stmt.executeUpdate(sql);
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
		return result;
	}
	
	public void close()
	{
		try{
			//关闭语句对象
			stmt.close();
			//关闭连接对象
			conn.close();
		}
		catch(SQLException ex){
			System.out.println(ex.getMessage());
		}
	}
}