C++를 사용하여 데이터베이스 연결 및 작업을 처리하는 방법은 무엇입니까?

#include <dao.h>

int main()
{
    try
    {
        // 打开数据库文件
        Database db("mydb.mdb");

        // or
        Database db(L"c:\\mydb\\mydb.mdb", DB_SHARED_DENY);

        return 0;
    }
    catch (const DatabaseException& e)
    {
        std::cerr << "Error connecting to the database: " << e.what() << std::endl;
        return 1;
    }
}

#include <dao.h>

int main()
{
    try
    {
        // 打开数据库文件
        Database db("mydb.mdb");

        // 创建一个Recordset对象来执行SQL查询
        Recordset rs = db.OpenRecordset("SELECT * FROM Customers");

        // 遍历并打印结果
        while (!rs.IsEOF())
        {
            std::cout << "Customer ID: " << rs("CustomerID").lVal << std::endl;
            std::cout << "Customer Name: " << rs("CustomerName").StringValue << std::endl;
            std::cout << "Customer Email: " << rs("CustomerEmail").StringValue << std::endl;

            rs.MoveNext();
        }

        return 0;
    }
    catch (const DatabaseException& e)
    {
        std::cerr << "Error executing SQL query: " << e.what() << std::endl;
        return 1;
    }
}

#include <dao.h>

int main()
{
    try
    {
        // 打开数据库文件
        Database db("mydb.mdb");

        // 创建一个Recordset对象来插入新记录
        Recordset rs = db.OpenRecordset("Customers");

        rs.AddNew();
        rs("CustomerID") = 4;
        rs("CustomerName") = "New Customer";
        rs("CustomerEmail") = "new-customer@email.com";

        // 更新记录
        rs.Update();

        return 0;
    }
    catch (const DatabaseException& e)
    {
        std::cerr << "Error inserting new record: " << e.what() << std::endl;
        return 1;
    }
}

#include <dao.h>

int main()
{
    try
    {
        // 打开数据库文件
        Database db("mydb.mdb");

        // 创建一个Recordset对象来执行SQL查询
        Recordset rs = db.OpenRecordset("SELECT * FROM Customers WHERE CustomerID = 4");

        // 更新记录
        if (!rs.IsEOF())
        {
            rs.Edit();
            rs("CustomerEmail") = "updated-new-customer@email.com";
            rs.Update();
        }

        return 0;
    }
    catch (const DatabaseException& e)
    {
        std::cerr << "Error updating existing record: " << e.what() << std::endl;
        return 1;
    }
}