readdb.bak

多用户银行系统

#include<stdio.h>
#include"../include/structs.h"
EXEC SQL INCLUDE SQLCA;
struct userinfo *readdb(int,struct userinfo *);
main()
{	
	static USER  infouser;
	readdb(1001,&infouser);
	printf("%s\n",infouser.name);
	printf("%d\n",infouser.money);
		
}
struct userinfo *readdb(int uid,struct userinfo *infouser)
{	
	// 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;

	int i = 0;
	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;
	//EXEC SQL declare emp_cursor cursor for 
	//	select name,pwd,id,money from scott.bankuser; 
	//EXEC SQL open emp_cursor;
	//EXEC SQL WHENEVER NOT FOUND DO break;
	//id = 1001;
	id=uid;
	//while(1)	
	//{	
		//EXEC SQL fetch emp_cursor into :name,:pwd,:id,:money;
		 //printf("the empno %d\n name is %s\n",id,name);
		//EXEC SQL INSERT INTO scott.bankuser VALUES(:name,:pwd,:id,:money);
		EXEC SQL SELECT name,pwd,id,money INTO :name,:pwd,:id,:money from scott.bankuser WHERE ID=:id;
		//EXEC SQL INSERT INTO scott.bankuser VALUES(:name,:pwd,:id,:money);
		
		
		strcpy(infouser->name,name);
		strcpy(infouser->pwd,pwd);
		infouser->id = id;
		infouser->money = money;
		//printf("name%s   money%d\n",name,money);
		//EXEC SQL fetch emp_cursor into name,pwd,id,money;
		printf("%d\n",getpid());
		//return &infouser;	
	//}
}