Access数据库操作，连接数据库、执行SQL语句等

逃离我推掉我的手 2022-08-13 16:40 243阅读 0赞

public static string sOleDbPath = Assembly.GetExecutingAssembly().Location + "\\..\\..\\奚学长的后宫.mdb";

1.获得数据库连接

/// <summary>
    /// 获得数据库连接
    /// </summary>
    /// <param name="OleDbPath">数据库存储路径</param>
    /// <returns></returns>
    public static OleDbConnection GetDataBaseConnection(string OleDbPath)
    {
    	string sOleDbConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + OleDbPath;
    	OleDbConnection OleDbConn = new OleDbConnection(sOleDbConn);
    	OleDbConn.Open();
    	return OleDbConn;
    }

2.执行SQL并返回数据表

/// <summary>
    /// 执行SQL并返回数据表 
    /// </summary>
    /// <param name="OleDbConn">数据库连接</param>
    /// <param name="Sql">SQL语句</param>
    /// <returns></returns>
    public static System.Data.DataTable ExecuteQuery(OleDbConnection OleDbConn, string Sql)
    {
    	System.Data.DataTable dt = new System.Data.DataTable();
    	OleDbDataAdapter da = new OleDbDataAdapter(Sql, OleDbConn);
    	da.Fill(dt);
    	OleDbConn.Close();
    	return dt;
    }

3.执行SQL，返回是否执行成功

/// <summary>
    /// 执行SQL，返回是否执行成功
    /// </summary>
    /// <param name="OleDbConn">数据库连接</param>
    /// <param name="Sql">SQL语句</param>
    /// <returns></returns>
    public static bool ExecuteNoneQuery(OleDbConnection OleDbConn, string Sql)
    {
    	bool bResult = true;
    	if (OleDbConn == null)
    	{
    		return false;
    	}
    
    	if (OleDbConn.State == ConnectionState.Closed)
    	{
    		OleDbConn.Open();
    	}
    
    	OleDbCommand oleDBcmd = new OleDbCommand(Sql, OleDbConn);
    	if (oleDBcmd.ExecuteNonQuery() > 0)
    	{
    		bResult = true;
    	}
    	else
    	{
    		bResult = false;
    	}
    
    	return bResult;
    
    }

4.判断数据表是否存在

/// <summary>
    /// 判断数据表是否存在
    /// </summary>
    /// <param name="OleDbConn"></param>
    /// <param name="TableName"></param>
    /// <returns></returns>
    public static bool IsExistsTable(OleDbConnection OleDbConn, string TableName)
    {
    	bool bResult = true;
    	int iResult = 0;
    	DataTable schemaTable =OleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] { null, null, null, "TABLE" });
    
    	if(schemaTable!=null)
    	{
    		foreach(DataRow dr in schemaTable.Rows)
    		{
    			string sCurTableName = dr["TABLE_NAME"] != null ? dr["TABLE_NAME"].ToString() : string.Empty;
    			if(TableName==sCurTableName)
    			{
    				iResult++;
    				break;
    			}
    		}
    	}
    
    	if (iResult == 0)
    	{
    		bResult = false;
    	}
    	else
    	{
    		bResult = true;
    	}
    	return bResult;
    	
    }