D语言新手问题 Dlang数据库操作

· Created 2019-12-31 · Last modified by blue replied at 2019-12-31 19:32:00 · 1452 times read

blue #1 · 2019-12-31

Dlang 插入数据

import std.stdio;

import hunt.database;

void main()
{
    auto db = new Database("mysql://root:123456@localhost:3306/test?charset=utf8mb4");

    int result = db.execute(`INSERT INTO user(username) VALUES("test")`);
    
    // 打印插入的ID
    writeln(result);

    db.close();
}

Dlang 查询数据

import std.stdio;

import hunt.database;

void main()
{
    auto db = new Database("mysql://root:123456@localhost:3306/test?charset=utf8mb4");

    foreach(row; db.query("SELECT * FROM user LIMIT 10"))
    {
        writeln(row["username"]);
    }

    db.close();
}