Chinaunix首页 | 论坛 | 博客

oops

首页　| 　博文目录　| 　关于我

王贤才

  • 博客访问： 1049174
  • 博文数量： 573
  • 博客积分： 0
  • 博客等级： 民兵
  • 技术积分： 66
  • 用 户 组： 普通用户
  • 注册时间： 2016-06-28 16:21
文章分类

全部博文（573）

文章存档

2018年（3）

2016年（48）

2015年（522）

我的朋友
最近访客
推荐博文
相关博文
C嵌入SQL，实现资金管理系统

分类： C/C++

2015-12-02 19:49:07

makefile文件

点击(此处)折叠或打开

  1. CC=esql
  2. all:test clean
  3. test:test.ec
  4.     $(CC) test.ec
  5. clean:
  6.     rm -f *.o *.c
test.ec文件

点击(此处)折叠或打开

  1. #include <string.h>
  2. #include <stdio.h>
  3. #include <stdlib.h>
  4. #include <malloc.h>
  5. #include <time.h>

  7. EXEC SQL INCLUDE SQLCA;
  8. EXEC SQL BEGIN DECLARE SECTION;
  9. typedef struct TSAccInfo /*个人帐户信息表*/
  10. {
  11.     char fs_idtype[1+1]; /*证件类型 1:身份证，2：军人证，3：其他*/
  12.     char fs_idnum[18+1]; /*证件号码*/
  13.     char fs_name[20+1]; /*姓名*/
  14.     char fs_addr[40+1]; /*家庭住址*/
  15.     char fs_phone[12+1]; /*家庭电话*/
  16.     char fs_cellno[11+1]; /*移动电话*/
  17.     char fs_pwd[6+1]; /*帐户密码*/
  18.     char fs_accno[9+1]; /*帐号*/
  19.     float fs_bal; /*余额*/
  20.     char fs_astate[1+1]; /*帐号状态*/
  21. }ACCINFO;

  23. typedef struct TSTrade /*交易明细表*/
  24. {
  25.     char fs_trdate[8+1]; /*交易日期*/
  26.     char fs_trtime[6+1]; /*交易时间*/
  27.     char fs_accno[9+1]; /*账户号*/
  28.     char fs_tradetype[1+1];/*交易类型(1:用户开户，2：用户销户，3：存款，4：取款)*/
  29.     float fs_amt; /*发生额*/
  30.     char fs_sqno[32+1]; /*交易流水号*/
  31.     float fs_bal; /*余额*/
  32. }TRADE;

  34. typedef struct TsysPara /*流水号分配表*/
  35. {
  36.     char fs_date[8+1]; /*日期*/
  37.     int fs_seqno; /*交易流水号*/
  38. }YSPARA;
  39. int accno; /*自动生成的账号*/
  40. EXEC SQL END DECLARE SECTION;

  42. void main_menu(); /*系统主菜单*/
  43. void save_draw_menu(); /*存取款菜单*/
  44. void create_drop_menu(); /*开销户菜单*/
  45. void main_login(); /*系统主登录*/
  46. void create_drop_login(); /*开销户登录*/
  47. void save_draw_login(); /*存取款登录*/

  49. int create_acct(); /*用户开户*/
  50. int drop_acct(); /*用户销户*/
  51. int save_acct(); /*用户存款*/
  52. int draw_acct(); /*用户取款*/
  53. int query_acct(); /*查询明细*/

  55. int connect_db(); /*数据库连接*/
  56. int systeminit(); /*系统初始化*/
  57. int number_test(); /*输入编号测试*/
  58. char * myTrim(char * str); /*去掉字符串首位空格*/
  59. int GetFormatTime( char *FormatTime, int iLen, const char *Format ); /*获取格式化时间*/
  60. int getSeqno(char * chseqno); /*生成流水号*/

  62. int main(int argc, char ** argv)
  63. {
  64.     systeminit(); /*系统初始化*/
  65.     main_login(); /*系统主菜单登录*/
  66.     return 0;
  67. }

  69. void main_menu() /*系统主菜单*/
  70. {
  71.     printf(" -------1,开销账户--------\n");
  72.     printf(" -------2,存取款----------\n");
  73.     printf(" -------3,查询明细--------\n");
  74.     printf(" -------4,退出系统--------\n");
  75.     fflush(stdin);
  76. }

  78. void create_drop_menu() /*开销户菜单*/
  79. {
  80.     printf(" -------1,用户开户--------\n");
  81.     printf(" -------2,用户销户--------\n");
  82.     printf(" -------3,返回上一级菜单--\n");
  83.     fflush(stdin);
  84. }

  86. void save_draw_menu() /*存取款菜单*/
  87. {
  88.     printf(" -------1,用户存款--------\n");
  89.     printf(" -------2,用户取款--------\n");
  90.     printf(" -------3,返回上一级菜单--\n");
  91.     fflush(stdin);
  92. }

  94. void main_login() /*系统主菜单登录*/
  95. {
  96.     int num; /*存放菜单编号*/
  97.     int flag = 1;
  98.     main_menu(); /*系统主菜单*/
  99.     printf("请选择菜单：");
  100.     fflush(stdin);
  101.     do
  102.     {
  103.         num = number_test(); /*输入编号测试*/
  104.         printf("\n");
  105.         switch ((int)num)
  106.         {
  107.             case 1:
  108.             {
  109.                 create_drop_login(); /*用户开销户登录*/
  110.                 flag=0;
  111.                 break;
  112.             }
  113.             case 2:
  114.             {
  115.                 save_draw_login(); /*用户存取款登录*/
  116.                 flag=0;
  117.                 break;
  118.             }
  119.             case 3:
  120.             {
  121.                 printf("账户查询明细\n");
  122.                 query_acct(); /*查询明细*/
  123.                 main_login(); /*系统主菜单登录*/
  124.                 flag=0;
  125.                 break;
  126.             }
  127.             case 4:
  128.             {
  129.                 printf("退出系统！\n");
  130.                 exit(0);
  131.             }
  132.             default :
  133.             {
  134.                 printf("输入有误，请重新输入菜单编号：");
  135.                 break;
  136.             }
  137.         }
  138.     }
  139.     while(flag);
  140. }
  141.  

  143. void create_drop_login() /*用户开销户登录*/
  144. {
  145.     int num; /*存放菜单编号*/
  146.     int flag = 1;
  147.     create_drop_menu(); /*开销户菜单*/
  148.     printf("请选择菜单：");
  149.     fflush(stdin);
  150.     do
  151.     {
  152.         num = number_test(); /*输入编号测试*/
  153.         printf("\n");
  154.         switch ((int)num)
  155.         {
  156.             case 1:
  157.             {
  158.                 printf("用户开户\n");
  159.                 create_acct(); /*用户开户*/
  160.                 create_drop_login(); /*返回到用户开销户登录菜单*/
  161.                 flag=0;
  162.                 break;
  163.             }
  164.             case 2:
  165.             {
  166.                 printf("用户销户\n");
  167.                 drop_acct(); /*用户销户*/
  168.                 flag=0;
  169.                 break;
  170.             }
  171.             case 3:
  172.             {
  173.                 main_login(); /*返回上一级:系统主菜单登录*/
  174.                 flag=0;
  175.                 break;
  176.             }
  177.             default :
  178.             {
  179.                 printf("输入有误，请重新输入菜单编号：");
  180.                 break;
  181.             }
  182.         }
  183.     }
  184.     while(flag);
  185. }

  187. void save_draw_login() /*存取款登录*/
  188. {
  189.     int num; /*存放菜单编号*/
  190.     int flag = 1;
  191.     save_draw_menu();/*存取款菜单*/    
  192.     printf("请选择菜单：");
  193.     fflush(stdin);
  194.     do
  195.     {
  196.         num = number_test(); /*输入编号测试*/
  197.         printf("\n");
  198.         switch ((int)num)
  199.         {
  200.             case 1:
  201.             {
  202.                 printf("用户存款!\n");
  203.                 save_acct(); /*用户存款*/
  204.                 main_login(); /*返回上一级登录主菜单*/
  205.                 flag=0;
  206.                 break;
  207.             }
  208.             case 2:
  209.             {
  210.                 printf("用户取款\n");
  211.                 draw_acct(); /*用户取款*/
  212.                 main_login(); /*返回上一级登录主菜单*/
  213.                 flag=0;
  214.                 break;
  215.             }
  216.             case 3:
  217.             {
  218.                 main_login(); /*返回上一级登录主菜单*/
  219.                 flag=0;
  220.                 break;
  221.             }
  222.             default :
  223.             {
  224.                 printf("输入有误，请重新输入菜单编号：");
  225.                 break;
  226.             }
  227.         }
  228.     }
  229.     while(flag);
  230. }

  232. int connect_db() /*连接数据库*/
  233. {
  234.     EXEC SQL BEGIN DECLARE SECTION;
  235.     char dbname[32];
  236.     EXEC SQL END DECLARE SECTION;
  237.     memset(dbname, 0, sizeof(dbname));
  238.     sprintf(dbname,"%s","dbtbank");
  239.     EXEC SQL CONNECT TO :dbname;
  240.     if(0!=sqlca.sqlcode)
  241.     {
  242.         printf("connect error! sqlcode=[%d]\n",sqlca.sqlcode);
  243.         return -1;
  244.     }
  245.     else
  246.     {
  247.         printf("connect success!\n");
  248.         return 1;
  249.     }
  250.     EXEC SQL execute immediate "SET LOCK MODE TO WAIT 1";
  251. }
  252. int systeminit() /*系统初始化*/
  253. {
  254.     printf("\n");
  255.     printf("\n");
  256.     printf("\n");
  257.     printf("\n");
  258.     printf("\n");
  259.     printf(" **********************\n");
  260.     printf(" 欢迎使用资金管理系统\n");
  261.     printf(" 王贤才\n");
  262.     printf(" 20130123\n");
  263.     printf(" **********************\n");
  264.     printf("\n");
  265.     printf("\n");
  266.     printf("\n");
  267.     printf("\n");
  268.     printf("\n");
  269.     fflush(stdout);
  270.     connect_db();
  271.     EXEC SQL SELECT accno into :accno FROM tsaccnoinfo;
  272.     if(0 != sqlca.sqlcode)
  273.     {
  274.         printf("查询账号表失败，sqlcode = [%d]\n", sqlca.sqlcode);
  275.         EXEC SQL DISCONNECT CURRENT;
  276.         return -1;
  277.     }
  278.     return 0;
  279. }

  281. int number_test() /*输入编号测试*/
  282. {
  283.     int number = 0;
  284.     char num[20];
  285.     scanf("%s",num);
  286.     if(num[1] != '\0') /*不为空*/
  287.     {
  288.         number = 0;
  289.     }
  290.     else if((num[0]>=49) && (num[0]<=57))
  291.     {
  292.         number = num[0]-48;
  293.     }
  294.     return number;    
  295. }

  297. int GetFormatTime( char *FormatTime, int iLen, const char *Format ) /*获取格式化时间*/
  298. {
  299.     time_t clock;
  300.     int iRc;

  302.     clock = time ( (time_t *) 0 );
  303.     iRc= strftime ( FormatTime, iLen , Format , localtime ( &clock ) );
  304.     return ( iRc );
  305. }

  307. char * myTrim(char * str) /*去掉字符串首尾*/
  308. {
  309.     if(NULL == str)
  310.     {
  311.         return NULL;
  312.     }
  313.     char * head = str;
  314.     char * tail = str + strlen(str) -1;
  315.     while((*head == ' ')&&(head < tail))head++;
  316.     while((*tail == ' ')&&(tail > head))tail--;
  317.     *(tail + 1) = '\0';
  318.     memcpy(str, head, sizeof(char) * (tail - head + 2));
  319.     return str;
  320. }

  322. int getSeqno(char * chseqno) /*生成流水号*/
  323. {
  324.     EXEC SQL BEGIN DECLARE SECTION;
  325.     char trdate[8+1];
  326.     int fs_seqno; /*从数据库读取出来的*/
  327.     char fs_date[8+1]; /*从数据库读取出来的*/
  328.     EXEC SQL END DECLARE SECTION;
  329.     char temp[32];
  330.     fs_seqno = 0;
  331.     memset(trdate, 0, sizeof(trdate));
  332.     memset(temp, 0x00, sizeof(temp));
  333.     GetFormatTime(temp, 9, "%Y%m%d"); /*日期*/
  334.     strncpy(trdate, temp, 8);
  335.     myTrim(trdate);
  336.     EXEC SQL SELECT fs_date, fs_seqno INTO :fs_date, :fs_seqno FROM tsyspara;
  337.     if(0 != sqlca.sqlcode)
  338.     {
  339.         printf("查询表tsyspara失败，sqlcode = [%d]\n", sqlca.sqlcode);
  340.         EXEC SQL DISCONNECT CURRENT;
  341.         return -1;
  342.     }
  343.     myTrim(fs_date);
  344.     if(strncmp(fs_date, trdate, strlen(trdate)) != 0) /*不是同一天,更新日期，流水号也从0开始计*/
  345.     {
  346.         EXEC SQL UPDATE tsyspara SET fs_date = :trdate, fs_seqno = 0;
  347.         if(0 != sqlca.sqlcode)
  348.         {
  349.             printf("更新表tsyspara失败，sqlcode = [%d]\n", sqlca.sqlcode);
  350.             EXEC SQL DISCONNECT CURRENT;
  351.             return -2;
  352.         }
  353.     }
  354.     fs_seqno++;
  355.     sprintf(chseqno, "%018d", fs_seqno);
  356.     printf("获取的流水号是：[%s]\n", chseqno);
  357.     return fs_seqno;
  358. }

  360. int create_acct() /*用户开户*/
  361. {
  362.     char temp[32];
  363.     EXEC SQL BEGIN DECLARE SECTION;
  364.     ACCINFO accinfo;
  365.     TRADE trade;
  366.     char idtype[18+1];
  367.     char chseqno[18+1]; /*流水号*/
  368.     int seqno;
  369.     EXEC SQL END DECLARE SECTION;
  370.     seqno = 0;
  371.     memset(&accinfo, 0, sizeof(accinfo));
  372.     printf("请输入用户信息：\n");
  373.     printf("证件类型：（1?：身份证，2：军人证，3其他)\n");
  374.     scanf("%s", accinfo.fs_idtype);
  375.     memset(idtype, 0 ,sizeof(idtype));
  376.     if(strncmp(accinfo.fs_idtype, "1", sizeof(char)) == 0)
  377.     {
  378.         strncpy(idtype, "身份证", strlen("身份证"));
  379.     }
  380.     else if(strncmp(accinfo.fs_idtype, "2", sizeof(char)) == 0)
  381.     {
  382.         strncpy(idtype, "军人证", strlen("军人证"));
  383.     }
  384.     else
  385.     {
  386.         strncpy(idtype, "其他", strlen("其他"));
  387.     }
  388.     printf("证件号码:\n");
  389.     scanf("%s", accinfo.fs_idnum);
  390.     fflush(stdin);
  391.     printf("姓名：\n");
  392.     scanf("%s", accinfo.fs_name);
  393.     fflush(stdin);
  394.     printf("家庭地址:\n");
  395.     scanf("%s", accinfo.fs_addr);
  396.     fflush(stdin);
  397.     printf("家庭电话:\n");
  398.     scanf("%s", accinfo.fs_phone);
  399.     fflush(stdin);
  400.     printf("移动电话:\n");
  401.     scanf("%s", accinfo.fs_cellno);
  402.     fflush(stdin);
  403.     printf("帐户密码(6位):\n");
  404.     scanf("%s", accinfo.fs_pwd);
  405.     fflush(stdin);

  407.     accno++;
  408.     printf("自动生成的账户号：[%d]\n", accno);
  409.     sprintf(accinfo.fs_accno, "%09d", accno);
  410.     accinfo.fs_bal=0.00; /*余额*/
  411.     strncpy(accinfo.fs_astate, "1", sizeof(char));
  412.     printf("是否确认保存用户信息?(y/n)\n");

  414.     EXEC SQL UPDATE tsaccnoinfo SET accno = :accno;
  415.     if(0 != sqlca.sqlcode)
  416.     {
  417.         printf("更新表tsaccnoinfo失败，sqlcode = [%d]\n", sqlca.sqlcode);
  418.         EXEC SQL DISCONNECT current;
  419.         return -1;
  420.     }
  421.     
  422.     myTrim(accinfo.fs_idtype);
  423.     myTrim(accinfo.fs_idnum);
  424.     myTrim(accinfo.fs_name);
  425.     myTrim(accinfo.fs_addr);
  426.     myTrim(accinfo.fs_phone);
  427.     myTrim(accinfo.fs_cellno);
  428.     myTrim(accinfo.fs_pwd);
  429.     myTrim(accinfo.fs_accno);
  430.     myTrim(accinfo.fs_astate);

  432.     printf("\n用户开户信息如下：\n");
  433.     printf("证件类型：[%s]\n", idtype);
  434.     printf("证件号码: [%s]\n", accinfo.fs_idnum);
  435.     printf("姓名：[%s]\n", accinfo.fs_name);
  436.     printf("家庭住址：[%s]\n", accinfo.fs_addr);
  437.     printf("家庭电话：[%s]\n", accinfo.fs_phone);
  438.     printf("移动电话：[%s]\n", accinfo.fs_cellno);
  439.     printf("账户密码：[%s]\n", accinfo.fs_pwd);
  440.     printf("账号：[%s]\n", accinfo.fs_accno);
  441.     printf("余额：[%f]\n", accinfo.fs_bal);
  442.     printf("账号状态：[%s]\n", "正常");

  444.     EXEC SQL SET LOCK MODE TO WAIT 3; /*最长等待3秒*/
  445.     EXEC SQL BEGIN WORK; /*开启事务*/
  446.     EXEC SQL insert into tsaccinfo values(:accinfo); /*插入个人账户信息表*/
  447.     if(0 != sqlca.sqlcode) /*exec sql插入语句执行失败*/
  448.     {
  449.         printf("信息保存到个人账户信息表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  450.         EXEC SQL DISCONNECT current;
  451.         EXEC SQL ROLLBACK WORK;
  452.         return -2;
  453.     }
  454.     printf("信息已保存到个人账户信息表！\n");
  455.     
  456.     memset(&trade, 0, sizeof(trade)); /*初始化交易明细表结构体*/
  457.     memset(temp, 0, sizeof(temp));
  458.     GetFormatTime(temp, 7, "%H%M%S");
  459.     strncpy(trade.fs_trtime, temp, 6); /*时间*/
  460.     memset(temp, 0x00, sizeof(temp));
  461.     GetFormatTime(temp, 9, "%Y%m%d"); /*日期*/
  462.     strncpy(trade.fs_trdate, temp, 8);
  463.     strncpy(trade.fs_accno, accinfo.fs_accno, sizeof(accinfo.fs_accno)); /*账户号*/
  464.     strncpy(trade.fs_tradetype, "1", sizeof("1")); /*交易类型:1:用户开户*/
  465.     trade.fs_amt = 0; /*发生额*/
  466.     trade.fs_bal = 0; /*余额*/
  467.     memset(chseqno, 0, sizeof(chseqno));
  468.     seqno = getSeqno(chseqno); /*获取流水号*/
  469. /*    strcat(trade.fs_sqno, trade.fs_trdate);
  470.     myTrim(trade.fs_sqno);
  471.     strcat(trade.fs_sqno, trade.fs_trtime);
  472.     myTrim(trade.fs_sqno); */
  473.     strcat(trade.fs_sqno, chseqno); /*交易流水号*/

  475.     myTrim(trade.fs_trtime);
  476.     myTrim(trade.fs_trdate);
  477.     myTrim(trade.fs_tradetype);
  478.     myTrim(trade.fs_accno);
  479.     myTrim(trade.fs_sqno);

  481.     printf("\n交易明细表数据:\n");
  482.     printf("时间:[%s]\n",trade.fs_trtime);
  483.     printf("日期:[%s]\n", trade.fs_trdate);
  484.     printf("账户号：[%s]\n", trade.fs_accno);
  485.     printf("交易类型:[%s]\n", trade.fs_tradetype);
  486.     printf("发生额:[%f]\n", trade.fs_amt);
  487.     printf("余额:[%f]\n", trade.fs_bal);
  488.     printf("交易流水号:[%s]\n", trade.fs_sqno);

  490.     EXEC SQL insert into TSTrade values( :trade); /*插入交易明细表*/
  491.     if(0 != sqlca.sqlcode)
  492.     {
  493.         printf("信息保存到交易明细表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  494.         EXEC SQL DISCONNECT current;
  495.         EXEC SQL ROLLBACK WORK;
  496.         return -3;
  497.     }
  498.     printf("信息已保存到交易明细表！\n");
  499.     EXEC SQL UPDATE tsyspara SET fs_seqno = :seqno; /*更新最大号流水表*/
  500.     if(0 != sqlca.sqlcode)
  501.     {
  502.         printf("更新最大号流水表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  503.         EXEC SQL ROLLBACK WORK;
  504.         return -4;
  505.     }
  506.     EXEC SQL COMMIT WORK;
  507.     return 0;
  508. }

  510. int drop_acct() /*用户销户*/
  511. {
  512.     int ret = -1;
  513.     char temp[32];
  514.     EXEC SQL BEGIN DECLARE SECTION;
  515.     char accno[9+1]; /*用户输入的账号*/
  516.     char passwd[6+1]; /*用户输入的账号密码*/
  517.     ACCINFO accinfo; /*个人帐户信息表*/
  518.     TRADE trade; /*交易明细表*/
  519.     char chseqno[18+1]; /*流水号*/
  520.     int seqno;
  521.     EXEC SQL END DECLARE SECTION;
  522.     seqno = 0;

  524.     do
  525.     {
  526.         do
  527.         {
  528.             printf("请输入账号：");
  529.             fflush(stdout);
  530.             memset(accno, 0, sizeof(accno));
  531.             ret = read(0, accno, sizeof(accno)); /*从键盘接受数据*/
  532.             if(ret < 0)
  533.             {
  534.                 printf("接受账号失败！\n");
  535.                 continue;
  536.             }
  537.             if (accno[0] == '\n') /*键盘输入异常判断*/
  538.             {
  539.                 continue;
  540.             }
  541.             else
  542.             {
  543.                 accno[ret -1] = '\0';
  544.                 myTrim(accno);    
  545.                 break;
  546.             }
  547.         }
  548.         while(1);

  550.         do
  551.         {
  552.             printf("请输入账号密码：");
  553.             fflush(stdout);
  554.             ret = read(0, passwd, sizeof(passwd));
  555.             if(ret < 0)
  556.             {
  557.                 printf("接受账号密码失败！\n");
  558.                 continue;
  559.             }
  560.             if (passwd[0] == '\n') /*键盘输入异常判断*/
  561.             {
  562.                 continue;
  563.             }
  564.             else
  565.             {
  566.                 passwd[ret - 1] = '\0';
  567.                 myTrim(passwd);
  568.                 break;
  569.             }
  570.         }
  571.         while(1);

  573.         memset(&accinfo, 0, sizeof(accinfo));
  574.         EXEC SQL SELECT * INTO :accinfo FROM tsaccinfo WHERE fs_accno = :accno;
  575.         if(0 != sqlca.sqlcode)
  576.         {
  577.             if(100 == sqlca.sqlcode) /*查询结果为空*/
  578.             {
  579.                 printf("您输入的账号不存在，请重新输入！\n");
  580.                 continue;
  581.             }
  582.             printf("查询表tsaccinfo账号密码和状态失败，sqlcode = [%d]\n", sqlca.sqlcode);
  583.             EXEC SQL DISCONNECT current;
  584.         }
  585.         myTrim(accinfo.fs_pwd);
  586.         myTrim(accinfo.fs_astate);
  587.         myTrim(accinfo.fs_name);
  588.         if(strncmp(accinfo.fs_pwd, passwd, strlen(accinfo.fs_pwd)) != 0) /*判断密码是否正确*/
  589.         {
  590.             printf("您输入的密码不正确，请重新输入！\n");
  591.             continue;
  592.         }
  593.         break;
  594.     }
  595.     while(1);

  597.     printf("账号和密码有效，可以继续下一步操作！\n");
  598.     if(strncmp(accinfo.fs_astate, "0", strlen(accinfo.fs_astate)) == 0) /*判断账户状态*/
  599.     {
  600.         printf("账号状态已经为注销状态！\n");
  601.         return -1;
  602.     }

  604.     EXEC SQL SET LOCK MODE TO WAIT 3; /*最长等待3秒*/
  605.     EXEC SQL BEGIN WORK;
  606.     EXEC SQL UPDATE tsaccinfo SET fs_bal = 0, fs_astate = '0' WHERE fs_accno = :accno;
  607.     if(0 != sqlca.sqlcode)
  608.     {
  609.         printf("更新表tsaccinfo余额和账号状态失败，sqlcode = [%d]\n", sqlca.sqlcode);
  610.         EXEC SQL DISCONNECT current;
  611.         EXEC SQL ROLLBACK WORK;
  612.         return -2;
  613.     }
  614.     printf("\n账户注销已成功！\n");

  616.     memset(&trade, 0, sizeof(trade));
  617.     memset(temp, 0, sizeof(temp));
  618.     GetFormatTime(temp, 7, "%H%M%S");
  619.     strncpy(trade.fs_trtime, temp, 6); /*时间*/
  620.     memset(temp, 0x00, sizeof(temp));
  621.     GetFormatTime(temp, 9, "%Y%m%d"); /*日期*/
  622.     strncpy(trade.fs_trdate, temp, 8);
  623.     strncpy(trade.fs_tradetype, "2", sizeof("2")); /*交易类型,2:用户注销账户*/
  624.     trade.fs_amt = accinfo.fs_bal; /*发生额 = 余额*/
  625.     trade.fs_bal = 0; /*余额为0*/
  626.     strncpy(trade.fs_accno, accinfo.fs_accno, sizeof(accinfo.fs_accno)); /*账户号*/
  627.     memset(chseqno, 0, sizeof(chseqno));
  628.     seqno = getSeqno(chseqno); /*获取流水号*/
  629. /*    strcat(trade.fs_sqno, trade.fs_trdate);
  630.     myTrim(trade.fs_sqno);
  631.     strcat(trade.fs_sqno, trade.fs_trtime);
  632.     myTrim(trade.fs_sqno);
  633.     */
  634.     strcat(trade.fs_sqno, chseqno); /*交易流水号*/

  636.     myTrim(trade.fs_trtime);
  637.     myTrim(trade.fs_trdate);
  638.     myTrim(trade.fs_tradetype);
  639.     myTrim(trade.fs_accno);
  640.     myTrim(trade.fs_sqno);

  642.     printf("\n交易明细表数据如下:\n");
  643.     printf("时间:[%s]\n",trade.fs_trtime);
  644.     printf("日期:[%s]\n", trade.fs_trdate);
  645.     printf("交易类型:[%s]\n", trade.fs_tradetype);
  646.     printf("发生额:[%f]\n", trade.fs_amt);
  647.     printf("余额:[%f]\n", trade.fs_bal);
  648.     printf("账户号：[%s]\n", trade.fs_accno);
  649.     printf("交易流水号:[%s]\n", trade.fs_sqno);

  651.     EXEC SQL INSERT INTO TSTrade VALUES( :trade); /*插入交易明细表*/
  652.     if(0 != sqlca.sqlcode)
  653.     {
  654.         printf("信息保存到交易明细表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  655.         EXEC SQL DISCONNECT current;
  656.         EXEC SQL ROLLBACK WORK;
  657.         return -3;
  658.     }
  659.     printf("信息已保存到交易明细表！\n");
  660.     
  661.     EXEC SQL UPDATE tsyspara SET fs_seqno = :seqno; /*更新最大号流水表*/
  662.     if(0 != sqlca.sqlcode)
  663.     {
  664.         printf("更新最大号流水表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  665.         EXEC SQL ROLLBACK WORK;
  666.         return -4;
  667.     }
  668.     EXEC SQL COMMIT WORK;
  669. }

  671. int save_acct() /*用户存款*/
  672. {
  673.     int ret = -1;
  674.     char temp[32];
  675.     EXEC SQL BEGIN DECLARE SECTION;
  676.     char accno[9+1]; /*用户输入的账号*/
  677.     char passwd[6+1]; /*用户输入的账号密码*/
  678.     float amt; /*用户输入的存款金额*/
  679.     ACCINFO accinfo; /*个人帐户信息表*/
  680.     TRADE trade; /*交易明细表*/
  681.     char chseqno[18+1]; /*流水号*/
  682.     int seqno;
  683.     EXEC SQL END DECLARE SECTION;
  684.     seqno = 0;
  685.     do
  686.     {
  687.         do
  688.         {
  689.             printf("请输入账号：");
  690.             fflush(stdout);
  691.             memset(accno, 0, sizeof(accno));
  692.             ret = read(0, accno, sizeof(accno)); /*从键盘接受数据*/
  693.             if(ret < 0)
  694.             {
  695.                 printf("接受账号失败！\n");
  696.                 continue;
  697.             }
  698.             if (accno[0] == '\n') /*键盘输入异常判断*/
  699.             {
  700.                 continue;
  701.             }
  702.             else
  703.             {
  704.                 accno[ret -1] = '\0';
  705.                 myTrim(accno);    
  706.                 break;
  707.             }
  708.         }
  709.         while(1);

  711.         do
  712.         {
  713.             printf("请输入账号密码：");
  714.             fflush(stdout);
  715.             ret = read(0, passwd, sizeof(passwd));
  716.             if(ret < 0)
  717.             {
  718.                 printf("接受账号密码失败！\n");
  719.                 continue;
  720.             }
  721.             if (passwd[0] == '\n') /*键盘输入异常判断*/
  722.             {
  723.                 continue;
  724.             }
  725.             else
  726.             {
  727.                 passwd[ret - 1] = '\0';
  728.                 myTrim(passwd);
  729.                 break;
  730.             }
  731.         }
  732.         while(1);

  734.         memset(&accinfo, 0, sizeof(accinfo));
  735.         EXEC SQL SELECT * INTO :accinfo FROM tsaccinfo WHERE fs_accno = :accno;
  736.         if(0 != sqlca.sqlcode)
  737.         {
  738.             if(100 == sqlca.sqlcode) /*查询结果为空*/
  739.             {
  740.                 printf("您输入的账号不存在，请重新输入！\n");
  741.                 continue;
  742.             }
  743.             printf("查询表tsaccinfo账号密码和状态失败，sqlcode = [%d]\n", sqlca.sqlcode);
  744.             EXEC SQL DISCONNECT current;
  745.         }
  746.         myTrim(accinfo.fs_pwd);
  747.         myTrim(accinfo.fs_astate);
  748.         myTrim(accinfo.fs_name);
  749.         if(strncmp(accinfo.fs_pwd, passwd, strlen(accinfo.fs_pwd)) != 0) /*判断密码是否正确*/
  750.         {
  751.             printf("您输入的密码不正确，请重新输入！\n");
  752.             continue;
  753.         }
  754.         break;
  755.     }
  756.     while(1);
  757.     printf("账号和密码有效，可以继续下一步操作！\n");

  759.     if(strncmp(accinfo.fs_astate, "1", strlen(accinfo.fs_astate)) != 0) /*判断账户状态*/
  760.     {
  761.         printf("账号状态为注销状态，不能使用！\n");
  762.         return -1;
  763.     }
  764.     printf("请输入存款金额：");
  765.     fflush(stdout);
  766.     scanf("%f", &amt);
  767.     printf("账户名为：[%s], 存款金额为：[%f]元\n", accinfo.fs_name, amt);
  768.     printf("确认请按(1),取消请按(2)!\n\n");

  770.     accinfo.fs_bal = accinfo.fs_bal + amt;

  772.     EXEC SQL SET LOCK MODE TO WAIT 3; /*最长等待3秒*/
  773.     EXEC SQL BEGIN WORK;
  774.     EXEC SQL UPDATE tsaccinfo SET fs_bal = :accinfo.fs_bal WHERE fs_accno = :accno;
  775.     if(0 != sqlca.sqlcode)
  776.     {
  777.         printf("更新表tsaccinfo余额失败，sqlcode = [%d]\n", sqlca.sqlcode);
  778.         EXEC SQL ROLLBACK WORK;
  779.         EXEC SQL DISCONNECT current;
  780.         return -2;
  781.     }
  782.     printf("存款已成功!\n");

  784.     memset(&trade, 0, sizeof(trade)); /*初始化交易明细表结构体*/
  785.     memset(temp, 0, sizeof(temp));
  786.     GetFormatTime(temp, 7, "%H%M%S");
  787.     strncpy(trade.fs_trtime, temp, 6); /*时间*/
  788.     memset(temp, 0, sizeof(temp));
  789.     GetFormatTime(temp, 9, "%Y%m%d"); /*日期*/
  790.     strncpy(trade.fs_trdate, temp, 8);
  791.     strncpy(trade.fs_tradetype, "3", sizeof("3")); /*交易类型,3:用户存款*/
  792.     trade.fs_amt = amt; /*发生额*/
  793.     trade.fs_bal = accinfo.fs_bal; /*余额*/
  794.     strncpy(trade.fs_accno, accinfo.fs_accno, sizeof(accinfo.fs_accno)); /*账户号*/
  795.     memset(chseqno, 0, sizeof(chseqno));
  796.     seqno = getSeqno(chseqno); /*获取流水号*/
  797. /*    strcat(trade.fs_sqno, trade.fs_trdate);
  798.     myTrim(trade.fs_sqno);
  799.     strcat(trade.fs_sqno, trade.fs_trtime);
  800.     myTrim(trade.fs_sqno);
  801.     */
  802.     strcat(trade.fs_sqno, chseqno);

  804.     myTrim(trade.fs_trtime);
  805.     myTrim(trade.fs_trdate);
  806.     myTrim(trade.fs_tradetype);
  807.     myTrim(trade.fs_accno);
  808.     myTrim(trade.fs_sqno);

  810.     printf("\n交易明细表数据如下:\n");
  811.     printf("时间:[%s]\n",trade.fs_trtime);
  812.     printf("日期:[%s]\n",trade.fs_trdate);
  813.     printf("交易类型:[%s]\n", trade.fs_tradetype);
  814.     printf("发生额:[%f]\n", trade.fs_amt);
  815.     printf("余额:[%f]\n", trade.fs_bal);
  816.     printf("账户号：[%s]\n", trade.fs_accno);
  817.     printf("交易流水号:[%s]\n", trade.fs_sqno);

  819.     EXEC SQL INSERT INTO TSTrade VALUES( :trade); /*插入交易明细表*/
  820.     if(0 != sqlca.sqlcode)
  821.     {
  822.         printf("信息保存到交易明细表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  823.         EXEC SQL ROLLBACK WORK;
  824.         EXEC SQL DISCONNECT current;
  825.         return -3;
  826.     }
  827.     printf("信息已保存到交易明细表！\n");

  829.     EXEC SQL UPDATE tsyspara SET fs_seqno = :seqno; /*更新最大号流水表*/
  830.     if(0 != sqlca.sqlcode)
  831.     {
  832.         printf("更新最大号流水表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  833.         EXEC SQL ROLLBACK WORK;
  834.         EXEC SQL DISCONNECT current;
  835.         return -4;
  836.     }
  837.     EXEC SQL COMMIT WORK;
  838.     return 0;
  839. }

  841. int draw_acct() /*用户取款*/
  842. {
  843.     int ret = -1;
  844.     char temp[32];
  845.     EXEC SQL BEGIN DECLARE SECTION;
  846.     char accno[9+1]; /*用户输入的账号*/
  847.     char passwd[6+1]; /*用户输入的账号密码*/
  848.     float amt; /*用户输入的存款金额*/
  849.     ACCINFO accinfo; /*个人帐户信息表*/
  850.     TRADE trade; /*交易明细表*/
  851.     char chseqno[18+1]; /*流水号*/
  852.     int seqno;
  853.     EXEC SQL END DECLARE SECTION;
  854.     seqno = 0;
  855.     do
  856.     {
  857.         do
  858.         {
  859.             printf("请输入账号：");
  860.             fflush(stdout);
  861.             memset(accno, 0, sizeof(accno));
  862.             ret = read(0, accno, sizeof(accno)); /*从键盘接受数据*/
  863.             if(ret < 0)
  864.             {
  865.                 printf("接受账号失败！\n");
  866.                 continue;
  867.             }
  868.             if (accno[0] == '\n') /*键盘输入异常判断*/
  869.             {
  870.                 continue;
  871.             }
  872.             else
  873.             {
  874.                 accno[ret -1] = '\0';
  875.                 myTrim(accno);    
  876.                 break;
  877.             }
  878.         }
  879.         while(1);

  881.         do
  882.         {
  883.             printf("请输入账号密码：");
  884.             fflush(stdout);
  885.             ret = read(0, passwd, sizeof(passwd));
  886.             if(ret < 0)
  887.             {
  888.                 printf("接受账号密码失败！\n");
  889.                 continue;
  890.             }
  891.             if (passwd[0] == '\n') /*键盘输入异常判断*/
  892.             {
  893.                 continue;
  894.             }
  895.             else
  896.             {
  897.                 passwd[ret - 1] = '\0';
  898.                 myTrim(passwd);
  899.                 break;
  900.             }
  901.         }
  902.         while(1);

  904.         memset(&accinfo, 0, sizeof(accinfo));
  905.         EXEC SQL SELECT * INTO :accinfo FROM tsaccinfo WHERE fs_accno = :accno;
  906.         if(0 != sqlca.sqlcode)
  907.         {
  908.             if(100 == sqlca.sqlcode) /*查询结果为空*/
  909.             {
  910.                 printf("您输入的账号不存在，请重新输入！\n");
  911.                 continue;
  912.             }
  913.             printf("查询表tsaccinfo账号密码和状态失败，sqlcode = [%d]\n", sqlca.sqlcode);
  914.             EXEC SQL DISCONNECT current;
  915.         }
  916.         myTrim(accinfo.fs_pwd);
  917.         myTrim(accinfo.fs_astate);
  918.         myTrim(accinfo.fs_name);
  919.         if(strncmp(accinfo.fs_pwd, passwd, strlen(accinfo.fs_pwd)) != 0) /*判断密码是否正确*/
  920.         {
  921.             printf("您输入的密码不正确，请重新输入！\n");
  922.             continue;
  923.         }
  924.         break;
  925.     }
  926.     while(1);
  927.     printf("账号和密码有效，可以继续下一步操作！\n");

  929.     if(strncmp(accinfo.fs_astate, "1", strlen(accinfo.fs_astate)) != 0) /*判断账户状态*/
  930.     {
  931.         printf("账号状态为注销状态，不能使用！\n");
  932.         return -1;
  933.     }
  934.     printf("请输入取款金额(最低可取1元)：");
  935.     fflush(stdout);
  936.     scanf("%f", &amt);
  937.     printf("账户名为：[%s],取款金额为：[%f]\n", accinfo.fs_name, amt);
  938.     printf("确认请按(1),取消请按(2)!\n");
  939.     accinfo.fs_bal = accinfo.fs_bal - amt;

  941.     EXEC SQL SET LOCK MODE TO WAIT 3; /*最长等待3秒*/
  942.     EXEC SQL BEGIN WORK;
  943.     EXEC SQL UPDATE tsaccinfo SET fs_bal = :accinfo.fs_bal WHERE fs_accno = :accno;
  944.     if(0 != sqlca.sqlcode)
  945.     {
  946.         printf("更新表tsaccinfo余额失败，sqlcode = [%d]\n", sqlca.sqlcode);
  947.         EXEC SQL DISCONNECT current;
  948.         EXEC SQL ROLLBACK WORK;
  949.         return -2;
  950.     }
  951.     printf("取款已成功！\n");    

  953.     memset(&trade, 0, sizeof(trade)); /*初始化交易明细表结构体*/
  954.     memset(temp, 0, sizeof(temp));
  955.     GetFormatTime(temp, 7, "%H%M%S");
  956.     strncpy(trade.fs_trtime, temp, 6); /*时间*/
  957.     memset(temp, 0x00, sizeof(temp));
  958.     GetFormatTime(temp, 9, "%Y%m%d"); /*日期*/
  959.     strncpy(trade.fs_trdate, temp, 8);
  960.     strncpy(trade.fs_tradetype, "4", sizeof("4")); /*交易类型,4:用户取款*/
  961.     trade.fs_amt = amt; /*发生额*/
  962.     trade.fs_bal = accinfo.fs_bal; /*余额*/
  963.     strncpy(trade.fs_accno, accinfo.fs_accno, sizeof(accinfo.fs_accno)); /*账户号*/
  964.     memset(chseqno, 0, sizeof(chseqno));
  965.     seqno = getSeqno(chseqno); /*获取流水号后面部分*/
  966. /*    strcat(trade.fs_sqno, trade.fs_trdate);
  967.     myTrim(trade.fs_sqno);
  968.     strcat(trade.fs_sqno, trade.fs_trtime);
  969.     myTrim(trade.fs_sqno);
  970.     */
  971.     strcat(trade.fs_sqno, chseqno); /*交易流水号*/

  973.     myTrim(trade.fs_trtime);
  974.     myTrim(trade.fs_trdate);
  975.     myTrim(trade.fs_tradetype);
  976.     myTrim(trade.fs_accno);
  977.     myTrim(trade.fs_sqno);

  979.     printf("\n交易明细表数据如下:\n");
  980.     printf("时间:[%s]\n",trade.fs_trtime);
  981.     printf("日期:[%s]\n", trade.fs_trdate);
  982.     printf("交易类型:[%s]\n", trade.fs_tradetype);
  983.     printf("发生额:[%f]\n", trade.fs_amt);
  984.     printf("余额:[%f]\n", trade.fs_bal);
  985.     printf("账户号：[%s]\n", trade.fs_accno);
  986.     printf("交易流水号:[%s]\n", trade.fs_sqno);

  988.     EXEC SQL INSERT INTO TSTrade VALUES( :trade); /*插入交易明细表*/
  989.     if(0 != sqlca.sqlcode)
  990.     {
  991.         printf("信息保存到交易明细表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  992.         EXEC SQL DISCONNECT current;
  993.         EXEC SQL ROLLBACK WORK;
  994.         return -3;
  995.     }
  996.     printf("信息已保存到交易明细表！\n");

  998.     EXEC SQL UPDATE tsyspara SET fs_seqno = :seqno; /*更新最大号流水表*/
  999.     if(0 != sqlca.sqlcode)
  1000.     {
  1001.         printf("更新最大号流水表失败！sqlcode = [%d]\n", sqlca.sqlcode);
  1002.         EXEC SQL ROLLBACK WORK;
  1003.         return -4;
  1004.     }
  1005.     EXEC SQL COMMIT WORK;
  1006.     return 0;
  1007. }

  1009. int query_acct() /*查询明细*/
  1010. {
  1011.     EXEC SQL BEGIN DECLARE SECTION;
  1012.     char accno[9+1]; /*用户输入的账号*/
  1013.     char passwd[6+1]; /*用户输入的账号密码*/
  1014.     char pwd[6+1]; /*查询出的账户密码*/
  1015.     char sqlStmt[128]; /**/
  1016.     char sqlStr[128];
  1017.     float amt; /*用户输入的存款金额*/
  1018.     TRADE trade; /*交易明细表*/
  1019.     int iCount; /*满足条件的记录数*/
  1020.     EXEC SQL END DECLARE SECTION;
  1021.     int iNum = 0;
  1022.     int ret = -1;
  1023.     do
  1024.     {
  1025.         do
  1026.         {
  1027.             printf("请输入账号：");
  1028.             fflush(stdout);
  1029.             memset(accno, 0, sizeof(accno));
  1030.             ret = read(0, accno, sizeof(accno)); /*从键盘接受数据*/
  1031.             if(ret < 0)
  1032.             {
  1033.                 printf("接受账号失败！\n");
  1034.                 continue;
  1035.             }
  1036.             if (accno[0] == '\n') /*键盘输入异常判断*/
  1037.             {
  1038.                 continue;
  1039.             }
  1040.             else
  1041.             {
  1042.                 accno[ret -1] = '\0';
  1043.                 myTrim(accno);    
  1044.                 break;
  1045.             }
  1046.         }
  1047.         while(1);

  1049.         do
  1050.         {
  1051.             printf("请输入账号密码：");
  1052.             fflush(stdout);
  1053.             ret = read(0, passwd, sizeof(passwd));
  1054.             if(ret < 0)
  1055.             {
  1056.                 printf("接受账号密码失败！\n");
  1057.                 continue;
  1058.             }
  1059.             if (passwd[0] == '\n') /*键盘输入异常判断*/
  1060.             {
  1061.             continue;
  1062.             }
  1063.             else
  1064.             {
  1065.                 passwd[ret - 1] = '\0';
  1066.                 myTrim(passwd);
  1067.                 break;
  1068.             }
  1069.         }
  1070.         while(1);

  1072.         EXEC SQL SELECT fs_pwd INTO :pwd FROM tsaccinfo WHERE fs_accno = :accno;
  1073.         if(0 != sqlca.sqlcode)
  1074.         {
  1075.             if(100 == sqlca.sqlcode) /*查询结果为空*/
  1076.             {
  1077.                 printf("您输入的账号不存在，请重新输入！\n");
  1078.                 continue;
  1079.             }
  1080.             printf("查询表tsaccinfo账号密码和状态失败，sqlcode = [%d]\n", sqlca.sqlcode);
  1081.             EXEC SQL DISCONNECT current;
  1082.         }
  1083.         myTrim(pwd);
  1084.         if(strncmp(pwd, passwd, strlen(pwd)) != 0)
  1085.         {
  1086.             printf("您输入的密码不正确，请重新输入！\n");
  1087.             continue;
  1088.         }
  1089.         break;
  1090.     }
  1091.     while(1);
  1092.     printf("账号和密码有效，可以继续下一步操作！\n");

  1094.     iCount = 0;
  1095.     EXEC SQL SELECT COUNT(*) INTO :iCount FROM tstrade WHERE fs_accno = :accno;
  1096.     if(0 != sqlca.sqlcode)
  1097.     {
  1098.         printf("查询记录条数失败, sqlcode = [%d]\n", sqlca.sqlcode);
  1099.         return -1;
  1100.     }
  1101.     printf("查询明细表，满足条件的记录数为：%d\n", iCount);
  1102.     memset(sqlStmt, 0, sizeof(sqlStmt));
  1103.     memset(sqlStr, 0, sizeof(sqlStr));
  1104.     sprintf(sqlStr, "SELECT * FROM tstrade WHERE fs_accno = %s", accno);
  1105.     myTrim(sqlStr);
  1106.     printf("sqlStr = (%s)\n", sqlStr);
  1107.     EXEC SQL PREPARE sqlStmt FROM :sqlStr;
  1108.     if(0 != sqlca.sqlcode)
  1109.     {
  1110.         printf("prepare err! sqlcode = [%d]\n", sqlca.sqlcode);
  1111.         EXEC SQL DISCONNECT CURRENT;
  1112.         return -2;
  1113.     }
  1114.     EXEC SQL DECLARE cur CURSOR for sqlStmt;
  1115.     if(0 != sqlca.sqlcode)
  1116.     {
  1117.         printf("declare cur err! sqlcode = [%d]\n", sqlca.sqlcode);
  1118.         EXEC SQL DISCONNECT CURRENT;
  1119.         return -3;
  1120.     }
  1121.     EXEC SQL OPEN cur;
  1122.     if(0 != sqlca.sqlcode)
  1123.     {
  1124.         if(100 == sqlca.sqlcode)
  1125.         {
  1126.             printf("查询的记录数为0！\n");
  1127.             return -4;
  1128.         }
  1129.         printf("open cur err! sqlcode = [%d]\n", sqlca.sqlcode);
  1130.         EXEC SQL CLOSE cur;
  1131.         EXEC SQL FREE cur;
  1132.         EXEC SQL DISCONNECT CURRENT;
  1133.         return -5;
  1134.     }
  1135.     printf("\n查询明细表的结果如下：\n");
  1136.     while(1)
  1137.     {
  1138.         memset(&trade, 0, sizeof(trade));
  1139.         EXEC SQL FETCH cur INTO :trade;
  1140.         if(0 != sqlca.sqlcode)
  1141.         {
  1142.             if(100 == sqlca.sqlcode)
  1143.             {
  1144.                 printf("数据已取完\n");
  1145.                 break;
  1146.             }
  1147.             printf("fetch cur err! sqlcode = [%d]\n", sqlca.sqlcode);
  1148.             EXEC SQL CLOSE cur;
  1149.             EXEC SQL FREE cur;
  1150.             EXEC SQL DISCONNECT CURRENT;
  1151.             return -6;
  1152.         }
  1153.         iNum++;

  1155.         myTrim(trade.fs_trdate);
  1156.         myTrim(trade.fs_trtime);
  1157.         myTrim(trade.fs_accno);
  1158.         myTrim(trade.fs_tradetype);
  1159.         myTrim(trade.fs_sqno);

  1161.         printf("\n查询的第[%d]条记录如下：\n", iNum);
  1162.         printf("交易日期:[%s]\n", trade.fs_trdate);
  1163.         printf("交易时间:[%s]\n", trade.fs_trtime);
  1164.         printf("帐户号:[%s]\n", trade.fs_accno);
  1165.         printf("交易类型:[%s]\n", trade.fs_tradetype);
  1166.         printf("发生额:[%f]\n", trade.fs_amt);
  1167.         printf("交易流水号:[%s]\n", trade.fs_sqno);
  1168.         printf("余额:[%f]\n", trade.fs_bal);
  1169.     }
  1170.     return 0;
  1171. }
accno_create.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. DROP table TSAccNoInfo;
  3. create table TSAccNoInfo
  4. (accno integer not null
  5.  )lock mode row;
  6. !
accno_init.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. delete from tsaccnoinfo;
  3. insert into tsaccnoinfo values(0);
  4. select * from tsaccnoinfo;
  5. !
database.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. --create database zjglsystem;
  3. drop database zjglsystem;
  4. !
TSAcctInfo_create.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. DROP table TSAccInfo;
  3. create table TSAccInfo
  4. (fs_Idtype char(1) not null,
  5.  fs_Idnum char(18) not null,
  6.  fs_Name char(20) not null,
  7.  fs_Addr char(40),
  8.  fs_Phone char(12),
  9.  fs_Cellno char(11),
  10.  fs_Pwd char(6) not null,
  11.  fs_Accno char(9) not null,
  12.  fs_Bal decimal(16,2) not null,
  13.  fs_Astate char(1) not null,
  14.  primary key(fs_Accno)
  15.  )lock mode row;
  16. !
TSAcctInfo_delete.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. delete from TSAccInfo;
  3. !
TSAcctInfo_select.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. select * from TSAccInfo;
  3. !
TSTrade_create.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. DROP table TSTrade;
  3. create table TSTrade
  4. (fs_TrDate char(8) not null,
  5.  fs_TrTime char(6) not null,
  6.  fs_Accno char(9) not null,
  7.  fs_Tradetype char(1) not null,
  8.  fs_Amt decimal(16,2) not null,
  9.  fs_Sqno char(32) not null,
  10.  fs_Bal decimal(16,2) not null,
  11.  primary key(fs_Accno,fs_TrTime)
  12.  )lock mode row
TSTrade_delete.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. delete from TSTrade;
  3. !
TSTrade_select.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. select * from TSTrade;
  3. !
TSYspara_create.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. DROP table TSYsPara;
  3. create table TSYsPara
  4. (fs_date char(8) not null,
  5.  fs_seqno integer not null,
  6.  primary key(fs_date, fs_seqno)
  7. )lock mode row;
  8. !
TSYspara_delete.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. delete from tsyspara;
  3. insert into tsyspara values('20130224',0);
  4. select * from tsyspara;
  5. !
TSYspara_select.sql文件

点击(此处)折叠或打开

  1. dbaccess dbtbank <<!
  2. select * from tsyspara;
  3. !






阅读(826) | 评论(0) | 转发(0) |
0

上一篇：C嵌入SQL编程(informix数据库)

下一篇：C语言使用xmllib2创建XML文件

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6