readdb.pc

来自「多用户银行系统」· PC 代码 · 共 36 行

#include<stdio.h>
#include"../include/structs.h"
EXEC SQL INCLUDE SQLCA;
		
int readdb(int uid,struct userinfo *infouser)
{	

	EXEC SQL BEGIN DECLARE SECTION;
	VARCHAR user[15],pass[15],tnsname[20];
	char name[15];
	char pwd[10];
	int  id;
	int  money;
	EXEC SQL END DECLARE SECTION;

	
	strcpy(user.arr,"scott");
	user.len = (unsigned short)strlen((char *)user.arr);
	strcpy(pass.arr,"tiger");
	pass.len=(unsigned short)strlen((char *)pass.arr);
	strcpy(tnsname.arr,"demo1");
	tnsname.len=(unsigned short)strlen((char *)tnsname.arr);

	EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;
	id=uid;
	EXEC SQL SELECT name,pwd,id,money INTO :name,:pwd,:id,:money from scott.bankuser WHERE ID=:id;
		
		
	strcpy(infouser->name,name);
	strcpy(infouser->pwd,pwd);
	infouser->id = id;
	infouser->money = money;
	//printf("%d\n",getpid());
	return 1;	
}