Function tbl_select

lib_acl_cpp/samples/mysql/mysql.cpp:70–143

��ѯ������

// ��ѯ������
static int tbl_select(acl::db_handle& db, int n)
{
	const char* sql_fmt = "select * from group_tbl where"
		" group_name='%s-%d' and uvip_tbl='test'";

	acl::string sql;
	sql.format(sql_fmt,
		acl::strconv(__pre, strlen(__pre), "gbk", "utf8").c_str(), n);

	if (db.sql_select(sql.c_str()) == false) {
		printf("select sql error\r\n");
		return -1;
	}

	printf("\r\n---------------------------------------------------\r\n");

	// �г���ѯ�������һ
	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++) {
			if (n > 100) {
				continue;
			}
			const acl::db_row* row = rows[i];
			for (size_t j = 0; j < row->length(); j++) {
				printf("%s, ", (*row)[j]);
			}
			printf("\r\n");
		}
	}

	// �г���ѯ���������
	for (size_t i = 0; i < db.length(); i++) {
		if (n > 100) {
			continue;
		}
		const acl::db_row* row = db[i];

		// ȡ�����м�¼��ij���ֶε�ֵ
		const char* ptr = (*row)["group_name"];
		if (ptr == NULL) {
			printf("error, no group name\r\n");
			continue;
		}
		printf("group_name=%s: ", ptr);
		for (size_t j = 0; j < row->length(); j++) {
			printf("%s, ", (*row)[j]);
		}
		printf("\r\n");
	}

	// �г���ѯ���������
	const std::vector<acl::db_row*>* rows = db.get_rows();
	if (rows) {
		std::vector<acl::db_row*>::const_iterator cit = rows->begin();
		for (; cit != rows->end(); cit++) {
			if (n > 100) {