// sel_num.c
// VC++ 2010 Express
// マルチバイト文字セット
 
#define _CRT_SECURE_NO_WARNINGS
 
#include <Windows.h>
#include <sqlext.h>
#include <stdio.h>
 
#define DRIVER "Microsoft Access Driver (*.mdb)"
#define DATABASE "C:\\projects\\vc++\\odbctest\\odbctest.mdb"
 
int main()
{
	HENV henv;
	HDBC hdbc;
	HSTMT hstmt;
	SQLCHAR CompliteConnect[255];
	SWORD len;
	SQLCHAR sqlchar[256];
	SQLINTEGER strlen;
	RETCODE rc;
	char number[7+1];
	int i;
 
	// データベースへの接続
	rc = SQLAllocEnv(&henv);
	rc = SQLAllocConnect(henv, &hdbc);
	rc = SQLDriverConnect(hdbc, NULL,
		(SQLCHAR *)"Driver={"DRIVER"}; DBQ="DATABASE,
		SQL_NTS, CompliteConnect, _countof(CompliteConnect), &len, SQL_DRIVER_NOPROMPT);
	if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO) {
		fprintf(stderr, "データベースファイルを開けません\n");
		return 1;
	}
 
	// 検索
	while (1) {
		printf("7桁の郵便番号(qで終了)>");
		scanf("%7s", number);
		if (strcmp(number, "q") == 0) {
			break;
		}
		sprintf((char *)sqlchar,
			"select 住所 from 郵便番号データ where 郵便番号='%s'", number);
		rc = SQLAllocStmt(hdbc, &hstmt);
		rc = SQLExecDirect(hstmt, sqlchar, SQL_NTS);
		for (i = 0; ; i++) {
			rc = SQLFetch(hstmt);
			if (rc == SQL_NO_DATA) break;
			if (rc == SQL_ERROR) break;
			SQLGetData(hstmt, 1, SQL_C_CHAR, sqlchar, _countof(sqlchar), &strlen);
			printf("%s\n", sqlchar);
		}
		rc = SQLFreeStmt(hstmt, SQL_DROP);
		if (i == 0) {
			printf("該当するデータはありません\n");
		}
	}
 
	rc = SQLDisconnect(hdbc);
	rc = SQLFreeConnect(hdbc);
	rc = SQLFreeEnv(henv);
 
	return 0;
}
 

Ly8gc2VsX251bS5jCi8vIFZDKysgMjAxMCBFeHByZXNzCi8vIOODnuODq+ODgeODkOOCpOODiOaWh+Wtl+OCu+ODg+ODiAoKI2RlZmluZSBfQ1JUX1NFQ1VSRV9OT19XQVJOSU5HUwoKI2luY2x1ZGUgPFdpbmRvd3MuaD4KI2luY2x1ZGUgPHNxbGV4dC5oPgojaW5jbHVkZSA8c3RkaW8uaD4KCiNkZWZpbmUgRFJJVkVSICJNaWNyb3NvZnQgQWNjZXNzIERyaXZlciAoKi5tZGIpIgojZGVmaW5lIERBVEFCQVNFICJDOlxccHJvamVjdHNcXHZjKytcXG9kYmN0ZXN0XFxvZGJjdGVzdC5tZGIiCgppbnQgbWFpbigpCnsKCUhFTlYgaGVudjsKCUhEQkMgaGRiYzsKCUhTVE1UIGhzdG10OwoJU1FMQ0hBUiBDb21wbGl0ZUNvbm5lY3RbMjU1XTsKCVNXT1JEIGxlbjsKCVNRTENIQVIgc3FsY2hhclsyNTZdOwoJU1FMSU5URUdFUiBzdHJsZW47CglSRVRDT0RFIHJjOwoJY2hhciBudW1iZXJbNysxXTsKCWludCBpOwoKCS8vIOODh+ODvOOCv+ODmeODvOOCueOBuOOBruaOpee2mgoJcmMgPSBTUUxBbGxvY0VudigmaGVudik7CglyYyA9IFNRTEFsbG9jQ29ubmVjdChoZW52LCAmaGRiYyk7CglyYyA9IFNRTERyaXZlckNvbm5lY3QoaGRiYywgTlVMTCwKCQkoU1FMQ0hBUiAqKSJEcml2ZXI9eyJEUklWRVIifTsgREJRPSJEQVRBQkFTRSwKCQlTUUxfTlRTLCBDb21wbGl0ZUNvbm5lY3QsIF9jb3VudG9mKENvbXBsaXRlQ29ubmVjdCksICZsZW4sIFNRTF9EUklWRVJfTk9QUk9NUFQpOwoJaWYgKHJjICE9IFNRTF9TVUNDRVNTICYmIHJjICE9IFNRTF9TVUNDRVNTX1dJVEhfSU5GTykgewoJCWZwcmludGYoc3RkZXJyLCAi44OH44O844K/44OZ44O844K544OV44Kh44Kk44Or44KS6ZaL44GR44G+44Gb44KTXG4iKTsKCQlyZXR1cm4gMTsKCX0KCgkvLyDmpJzntKIKCXdoaWxlICgxKSB7CgkJcHJpbnRmKCI35qGB44Gu6YO15L6/55Wq5Y+3KHHjgafntYLkuoYpPiIpOwoJCXNjYW5mKCIlN3MiLCBudW1iZXIpOwoJCWlmIChzdHJjbXAobnVtYmVyLCAicSIpID09IDApIHsKCQkJYnJlYWs7CgkJfQoJCXNwcmludGYoKGNoYXIgKilzcWxjaGFyLAoJCQkic2VsZWN0IOS9j+aJgCBmcm9tIOmDteS+v+eVquWPt+ODh+ODvOOCvyB3aGVyZSDpg7Xkvr/nlarlj7c9JyVzJyIsIG51bWJlcik7CgkJcmMgPSBTUUxBbGxvY1N0bXQoaGRiYywgJmhzdG10KTsKCQlyYyA9IFNRTEV4ZWNEaXJlY3QoaHN0bXQsIHNxbGNoYXIsIFNRTF9OVFMpOwoJCWZvciAoaSA9IDA7IDsgaSsrKSB7CgkJCXJjID0gU1FMRmV0Y2goaHN0bXQpOwoJCQlpZiAocmMgPT0gU1FMX05PX0RBVEEpIGJyZWFrOwoJCQlpZiAocmMgPT0gU1FMX0VSUk9SKSBicmVhazsKCQkJU1FMR2V0RGF0YShoc3RtdCwgMSwgU1FMX0NfQ0hBUiwgc3FsY2hhciwgX2NvdW50b2Yoc3FsY2hhciksICZzdHJsZW4pOwoJCQlwcmludGYoIiVzXG4iLCBzcWxjaGFyKTsKCQl9CgkJcmMgPSBTUUxGcmVlU3RtdChoc3RtdCwgU1FMX0RST1ApOwoJCWlmIChpID09IDApIHsKCQkJcHJpbnRmKCLoqbLlvZPjgZnjgovjg4fjg7zjgr/jga/jgYLjgorjgb7jgZvjgpNcbiIpOwoJCX0KCX0KCglyYyA9IFNRTERpc2Nvbm5lY3QoaGRiYyk7CglyYyA9IFNRTEZyZWVDb25uZWN0KGhkYmMpOwoJcmMgPSBTUUxGcmVlRW52KGhlbnYpOwoKCXJldHVybiAwOwp9Cg==