如何使用rusqlite在sqlite数据库中插入和获取数据？

use rusqlite::Connection;

fn main() {
    let conn = Connection::open("path/to/database.db").unwrap();
    // 这里的"path/to/database.db"是数据库文件的路径，可以根据实际情况进行修改
}

conn.execute(
    "INSERT INTO users (name, age) VALUES (?1, ?2)",
    &[&"John Doe", &30],
).unwrap();

use rusqlite::Result;

fn main() -> Result<()> {
    let conn = Connection::open("path/to/database.db")?;
    let mut stmt = conn.prepare("SELECT name, age FROM users")?;
    let rows = stmt.query_map([], |row| {
        Ok((row.get(0)?, row.get(1)?))
    })?;

    for row in rows {
        let (name, age): (String, i32) = row?;
        println!("Name: {}, Age: {}", name, age);
    }

    Ok(())
}