?? writedb.pc
字號:
#include<stdio.h>EXEC SQL INCLUDE SQLCA;int writedb(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 INSERT INTO scott.bankuser VALUES(:name,:pwd,:id,:money); EXEC SQL COMMIT WORK; EXEC SQL COMMIT WORK RELEASE;}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -