operdb.pc

多用户银行系统

#include<stdio.h>
#include"../include/structs.h"
EXEC SQL INCLUDE SQLCA;
main()
{
USER user1;
USER user2;
//USER user3;
//operdb(&user1,1003);
//strcpy(user1.name,"user5");
//strcpy(user1.pwd,"123456");
//user1.id = 1005;
//user1.money= 1000; 
 	
	//operdb(&user1,2);
	
	//operdb(&user1,1);
	operdb(&user2,1007);
	printf("name : %s\n" , user2.name);
	printf("pwd  : %s\n" , user2.pwd);
	printf("id   : %d\n" , user2.id);
	//operdb(&user2,1006);
	//printf("1006name : %s\n" , user2.name);
	//printf("pwd  : %s\n" , user2.pwd);
	//printf("id   : %d\n" , user2.id);
	//operdb(&user3,1007);
	//printf("1007name : %s\n" , user3.name);
	//printf("pwd : %s\n" , user3.pwd);
	//printf("id : %d\n" , user3.id);
	
}

int operdb(USER *userinfo,int flag)
{
	EXEC SQL BEGIN DECLARE SECTION;
	VARCHAR user[15],pass[15],tnsname[20];
	char name[10];
	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);
		
	//strcpy(name,userinfo->name);
	//strcpy(pwd,userinfo->pwd);
	//money = userinfo->money;
	//id = userinfo-> id;
	
	
	switch(flag)
	{
		
		
	case 1:	
		strcpy(name,userinfo->name);
		strcpy(pwd,userinfo->pwd);
		money = userinfo->money;
		id = userinfo-> id;
		EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;
		EXEC SQL UPDATE SCOTT.BANKUSER SET PWD =:pwd,MONEY = :money WHERE ID =:id;
		EXEC SQL COMMIT WORK;
		EXEC SQL COMMIT WORK RELEASE;
		break;
	

	case 2:
		
		strcpy(name,userinfo->name);
		strcpy(pwd,userinfo->pwd);
		money = userinfo->money;
		id = userinfo-> id;
		EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;
		EXEC SQL INSERT INTO scott.bankuser VALUES(:name,:pwd,:id,:money);
		EXEC SQL COMMIT WORK;
		EXEC SQL COMMIT WORK RELEASE;	
		break;
	
	
	
       default:	EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;
		//id=uid;
		id = flag;
		printf("default  %d\n",id);
		EXEC SQL SELECT name,pwd,id,money INTO :name,:pwd,:id,:money from scott.bankuser WHERE ID=:id;
		strcpy(userinfo->name,name);
		strcpy(userinfo->pwd,pwd);
		userinfo->id = id;
		userinfo->money = money;
		
		//printf("default %s\n",name);
		//printf("strcpy  %s\n",userinfo->name);
		//printf("default  %s\n",pwd);
		//printf("strcpy  %s\n",userinfo->pwd);			
			
	}
								
}