dbaction.java

小型简单的旅馆预订系统. 客户:预定,更改,撤销,会员积分累积,查询预定,会员. 后台:会员更改,房间更改,预定更改,预定信息统计.

package servlet;

import java.sql.*;


public class dbAction
{
	String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
	String sConnStr = "jdbc:odbc:bka"; 
	String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
	String driver = "Driver={Microsoft Access Driver (*.mdb)}";
	String connectionString = "jdbc:odbc:"+driver+";"+dbq;
	Connection conn = null; 
	Statement stmt = null;
	ResultSet rs = null; 
	
	public dbAction(){
		try { 
			Class.forName(sDBDriver); 
			} 
			catch(java.lang.ClassNotFoundException e) { 
			System.err.println("bka(): " + e.getMessage()); 
			} 


	}
	public ResultSet executeQuery(String sql) { 
		rs = null; 
		try { 
		conn = DriverManager.getConnection(connectionString);
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		rs = stmt.executeQuery(sql); 
		} 
		catch(SQLException ex) { 
		System.err.println("aq.executeQuery: " + ex.getMessage()); 
		} 
		return rs; 
		 
		}
	public Boolean updateQuery(String sql) { 
		rs = null; 
		boolean su;
		try { 
		conn = DriverManager.getConnection(connectionString);
        stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		stmt.executeUpdate(sql); 
		su = true;
		} 
		catch(SQLException ex) { 
		System.err.println("aq.executeQuery: " + ex.getMessage()); 
		su=false;
		} 
		return su; 
		 
		}
	public void closeStmt()
	{
		try
		{
			stmt.close();
		}
		catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public void closeLink()
	{
		try
		{
			conn.close();
		}
		catch (SQLException e)
		{
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}