Function tbl_insert

lib_acl_cpp/samples/db/mysql_query/main.cpp:108–147

���ӱ�����

// ���ӱ�����
static bool tbl_insert(acl::db_handle& db, int n)
{
	if (db.begin_transaction() == false)
	{
		printf("begin transaction false: %s\r\n", db.get_error());
		return false;
	}

	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);

	if (db.commit() == false)
	{
		printf("commit error: %s\r\n", db.get_error());
		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 int tbl_select(acl::db_handle& db, int n)