updatedb.pc

多用户银行系统

#include<stdio.h>
EXEC SQL INCLUDE SQLCA;
int updatedb(char uname[15],char upwd[10],int uid,int umoney)
{
	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);

	money=umoney;
	strcpy(name,uname);
	strcpy(pwd ,upwd);
	id = uid;
	

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