c#-ACCESS数据库访问

最新推荐文章于 2021-03-25 17:41:47 发布

科学的发展-只不过是读大自然写的代码

最新推荐文章于 2021-03-25 17:41:47 发布

阅读量215

点赞数

分类专栏： c#

本文链接：https://blog.youkuaiyun.com/xie__jin__cheng/article/details/102628138

版权

c# 专栏收录该内容

192 篇文章

订阅专栏

本文详细介绍了一个使用C#语言实现的ACCESS数据库操作实例，包括插入、删除、更新和查询等基本操作，通过具体代码展示了如何使用OleDb连接数据库并执行SQL语句。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

数据结构

代码

using System;
using System.Data;
using System.Data.OleDb;

namespace ACCESS数据库
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("ACCESS数据库");
            DbAccess dbAccess = new DbAccess();
            dbAccess.select();
            dbAccess.insert();
            dbAccess.select();
            dbAccess.update();
            dbAccess.select();
            dbAccess.delete();
            dbAccess.select();
            Console.ReadLine();
        }
    }
    class DbAccess
    {
        OleDbConnection oleDb = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\projects\实体关系映射框架\实体关系映射框架\bin\Debug\数据库1.mdb");
        int id = 0;
        public DbAccess()
        {
            oleDb.Open();
            deleteAll();
            init();
        }
        ~DbAccess()
        {
            oleDb.Close();
        }
        public void insert()
        {
            Console.WriteLine("-----insert----------------------------------------");
            string sql = "insert into tb (myName) values ('name-insert')";
            OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDb);
            int id = oleDbCommand.ExecuteNonQuery(); 
        }
        public void delete()
        {
            Console.WriteLine("-----delete----------------------------------------");
            string sql = "delete from tb where myName='name-up'";
            OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDb);
            int i = oleDbCommand.ExecuteNonQuery();
        }
        public void update()
        {
            Console.WriteLine("-----update----------------------------------------");
            string sql = "update tb set myName='name-up' where myName='name-insert'";
            OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDb);
            int i = oleDbCommand.ExecuteNonQuery();
        }
        public void select()
        {
            string sql = "select * from tb";
            //获取表1中昵称为LanQ的内容
            OleDbDataAdapter dbDataAdapter = new OleDbDataAdapter(sql, oleDb); //创建适配对象
            DataTable dt = new DataTable(); //新建表对象
            dbDataAdapter.Fill(dt); //用适配对象填充表对象
            foreach (DataRow item in dt.Rows)
            {
                Console.WriteLine(item[0] + " | " + item[1]);
            }
        }
        public void deleteAll()
        {
            string sql = "delete from tb where 1=1";
            OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDb);
            int i = oleDbCommand.ExecuteNonQuery();
        }
        private void init()
        {
            for(int i = 0; i < 3; i++)
            {
                string sql = "insert into tb (myName) values ('name"+ i + "')";
                OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDb);
                oleDbCommand.ExecuteNonQuery();
            }
            
        }
    }
}

运行效果