一个通用数据库访问类.docVIP

使用ADO.NET时，每次数据库操作都要设置connection属性、建立connection、使用command、事务处理等，比较繁琐，有很多重复工作。能不能把这些繁琐的、常用的操作再封装一下，以更方便、安全地使用。下面这个类就是一种尝试：using System;using System.Data.SqlClient;using System.Text;using System.Data;using System.Collections;using System.Configuration;public class DBAccess{/// summary/// Declare the ole db required objects/// /summary/// summary/// An ole db adapter to act as the bridge to the database/// /summaryprivate SqlDataAdapter dbDataAdapter;/// summary/// The connection to the database/// /summaryprivate SqlConnection dbConnection;/// summary/// The command for doing the inserts/// /summaryprivate SqlCommand dbInsertCommand;/// summary/// The command for doing the deletes/// /summaryprivate SqlCommand dbDeleteCommand;/// summary/// The command for doing the updates/// /summaryprivate SqlCommand dbUpdateCommand;/// summary/// The command for doing the Selects/// /summaryprivate SqlCommand dbSelectCommand;private SqlCommand dbSelectCommandofAdapter;/// summary/// The command for get dataset/// /summaryprivate SqlDataAdapter dataAdapterCommand;/// summary/// The data reader for the application/// /summarypublic SqlDataReader dbDataReader;/// summary/// Declare an enum to allow internal tracking of commands /// /summaryenum COMMAND{ NONE, INSERT, UPDATE, DELETE, SELECT,DATASET };/// summary/// Internal member for tracking command progress/// /summaryprivate COMMAND command;/// summary/// String to hold error messages if a command fails/// /summaryprivate string error;/// summary/// Get a stored error message if ExecuteCommand fails/// /summarypublic string ErrorMessage{get{return error;}}/// summary/// bool holder for is open/// /summaryprivate bool bOpen;/// summary/// Check to see if a data base is open/// /summarypublic bool IsOpen{get{return bOpen;}}/// summary/// Declare a string object for the insert command/// /summarypublic string InsertCommand {get{retu