// 添加表数据 static bool tbl_insert(acl::db_handle& db, int n) { acl::query query; query.create_sql("insert into group_tbl(group_name, uvip_tbl," " update_date) values(:group, :test, :date)") .set_format("group", "group:%d", n) .set_parameter("test", "test") .set_date("date", time(NULL), "%Y-%m-%d"); if (db.exec_update(query) == false) return (false); const acl::db_rows* result = db.get_result(); if (result) { const std::vector<acl::db_row*>& rows = result->get_rows(); for (size_t i = 0; i < rows.size(); i++) { const acl::db_row* row = rows[i]; for (size_t j = 0; j < row->length(); j++) printf("%s, ", (*row)[j]); printf("\r\n"); } } db.free_result(); return (true); }
// 删除表数据 static bool tbl_delete(acl::db_handle& db, int n) { acl::query query; query.create_sql("delete from group_tbl where group_name=:group") .set_format("group", "group-%d", n); if (db.exec_update(query) == false) { printf("delete sql error\r\n"); return (false); } for (size_t i = 0; i < db.length(); i++) { const acl::db_row* row = db[i]; for (size_t j = 0; j < row->length(); j++) printf("%s, ", (*row)[j]); printf("\r\n"); } // 释放查询结果 db.free_result(); return (true); }