lzwbean.lzwuploadbean.java

jsp与数据库连接的图书馆管理系统

public void printOutputStreamFromDb(String tabName,String condition,String column,OutputStream outputStream){
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/mhm/person1.mdb;";
	Connection conn = null;
	ResultSet rs = null;
	public dbConn() {
		try {
			Class.forName(sDBDriver); 
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println( e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql) {
		try {
			conn = DriverManager.getConnection(sConnStr); 
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public int executeUpdate(String sql) {
		int result = 0;
		try {
			conn = DriverManager.getConnection(sConnStr); 
			Statement stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return result;
	}
}

}
}