writedb.bak

多用户银行系统

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

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

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

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