#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;	}}