operdb.pc

多用户银行系统

#include<stdio.h>
#include"../include/structs.h"
EXEC SQL INCLUDE SQLCA;

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: // update	
		strcpy(name,userinfo->name);
		strcpy(pwd,userinfo->pwd);
		money = userinfo->money;
		id = userinfo-> id;
		EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;
		if (sqlca.sqlcode != 0)
		{
			printf("database isn't connected\n");
			return -1;
		}else{
			printf("database have connected\n");	
		}
		
		EXEC SQL UPDATE SCOTT.BANKUSER SET PWD =:pwd,MONEY = :money WHERE ID =:id;
		 if (sqlca.sqlcode != 0)
		 {
			printf("database isn't connected\n");
			return  -1;
		 }				
		
		EXEC SQL COMMIT WORK;
		EXEC SQL COMMIT WORK RELEASE;
		break;
	

	case 2://insert
		
		strcpy(name,userinfo->name);
		strcpy(pwd,userinfo->pwd);
		money = userinfo->money;
		id = userinfo-> id;
		EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;

		if (sqlca.sqlcode != 0)
		{
			printf("database isn't connected\n");
		 	return -1;
		}	
		EXEC SQL INSERT INTO scott.bankuser VALUES(:name,:pwd,:id,:money);
		
		if (sqlca.sqlcode != 0)
		{
			//printf("database isn't connected\n");
			return -1;
		}
		EXEC SQL COMMIT WORK;
		EXEC SQL COMMIT WORK RELEASE;	
		break;
	
	
	
       default:	EXEC SQL CONNECT:user IDENTIFIED BY:pass USING:tnsname;
		//id=uid;
		if (sqlca.sqlcode != 0)
		{
			 printf("database isn't connected\n");
			 return -1;
		}else{
			printf("database have connected\n");	
		}
		id = flag;
		EXEC SQL SELECT name,pwd,id,money INTO :name,:pwd,:id,:money from scott.bankuser WHERE ID=:id;
		if (sqlca.sqlcode != 0)
		{
			//printf("database isn't connected\n");
			return -1;
		}
		memset(userinfo->name,'\0',10);
		memset(userinfo->pwd,'\0',10);
		strcpy(userinfo->name,name);
		strcpy(userinfo->pwd,pwd);
		//(userinfo->name)[9]='\0';
		(userinfo->pwd)[6]='\0';
		userinfo->id = id;
		userinfo->money = money;
	}
}