初学ADO.NET时写的数据库访问类[2]

  /// <summary>
  /// 判断是否存在
  /// </summary>
  public int ExeIsExist(OleDbCommand oleDbCmd)
  {
   int nExist = -1;
   m_strError = "";
   oleDbCmd.Connection = m_oleDbCnn;
   try
   {
    OpenCnn();
    OleDbDataReader dr = oleDbCmd.ExecuteReader();
    if (dr.Read())
    {
     nExist = 1;
    }
    else
    {
     nExist = 0;
    }
   }
   catch (OleDbException ex)
   {
    nExist = -1;
    m_strError = ex.ToString();
   }
   finally
   {
    if (m_oleDbCnn.State==ConnectionState.Open)
    {
     m_oleDbCnn.Close();
    }
   }
   return nExist;
  }

  /// <summary>
  /// 执行ExecuteScalar
  /// </summary>
  public int ExeScalar(string strSql)
  {
   int nNum = -1;
   m_strError = "";
   OleDbCommand oleDbCmd = new OleDbCommand(strSql,m_oleDbCnn);
   try
   {
    OpenCnn();
    nNum = (int)oleDbCmd.ExecuteScalar();
   }
   catch (OleDbException ex)
   {
    nNum = -1;
    m_strError = ex.ToString();
   }
   finally
   {
    if (m_oleDbCnn.State==ConnectionState.Open)
    {
     oleDbCmd.Dispose();
     m_oleDbCnn.Close();
    }
   }
   return nNum;
  }

  /// <summary>
  /// 返回OleDbDataReader
  /// </summary>
  public OleDbDataReader ExeSqlDr(string strSql)
  {
   OleDbDataReader dr = null;
   m_strError = "";
   OleDbCommand oleDbCmd = new OleDbCommand(strSql,m_oleDbCnn);
   try
   {
    OpenCnn();
    dr = oleDbCmd.ExecuteReader();
   }
   catch (OleDbException ex)
   {
    dr = null;
    m_strError = ex.ToString();
   }
   finally
   {
    if (m_oleDbCnn.State==ConnectionState.Open)
    {
     oleDbCmd.Dispose();
    }
   }
   return dr;
  }

  /// <summary>
  /// 返回DataSet
  /// </summary>
  public DataSet ExeSqlDs(string strSql, string strTable)
  {
   m_strError = "";
   DataSet ds = new DataSet();
   OleDbDataAdapter oleDbAdapter = new OleDbDataAdapter(strSql,m_oleDbCnn);
   try
   {
    oleDbAdapter.Fill(ds,strTable);
   }
   catch (OleDbException ex)
   {
    ds = null;
    m_strError = ex.ToString();
   }
   return ds;
  }