?? user_modify.c
字號:
/* Result Sets Interface */
#ifndef SQL_CRSR
# define SQL_CRSR
struct sql_cursor
{
unsigned int curocn;
void *ptr1;
void *ptr2;
unsigned long magic;
};
typedef struct sql_cursor sql_cursor;
typedef struct sql_cursor SQL_CURSOR;
#endif /* SQL_CRSR */
/* Thread Safety */
typedef void * sql_context;
typedef void * SQL_CONTEXT;
/* Object support */
struct sqltvn
{
unsigned char *tvnvsn;
unsigned short tvnvsnl;
unsigned char *tvnnm;
unsigned short tvnnml;
unsigned char *tvnsnm;
unsigned short tvnsnml;
};
typedef struct sqltvn sqltvn;
struct sqladts
{
unsigned int adtvsn;
unsigned short adtmode;
unsigned short adtnum;
sqltvn adttvn[1];
};
typedef struct sqladts sqladts;
static struct sqladts sqladt = {
1,1,0,
};
/* Binding to PL/SQL Records */
struct sqltdss
{
unsigned int tdsvsn;
unsigned short tdsnum;
unsigned char *tdsval[1];
};
typedef struct sqltdss sqltdss;
static struct sqltdss sqltds =
{
1,
0,
};
/* File name & Package Name */
struct sqlcxp
{
unsigned short fillen;
char filnam[69];
};
static const struct sqlcxp sqlfpn =
{
68,
"F:\\數據庫\\課程設計\\課程設計zhu\\server1.2\\systemModify\\user_modify.pc"
};
static unsigned long sqlctx = 1620568733;
static struct sqlexd {
unsigned int sqlvsn;
unsigned int arrsiz;
unsigned int iters;
unsigned int offset;
unsigned short selerr;
unsigned short sqlety;
unsigned int occurs;
const short *cud;
unsigned char *sqlest;
const char *stmt;
sqladts *sqladtp;
sqltdss *sqltdsp;
void **sqphsv;
unsigned int *sqphsl;
int *sqphss;
void **sqpind;
int *sqpins;
unsigned int *sqparm;
unsigned int **sqparc;
unsigned short *sqpadto;
unsigned short *sqptdso;
void *sqhstv[4];
unsigned int sqhstl[4];
int sqhsts[4];
void *sqindv[4];
int sqinds[4];
unsigned int sqharm[4];
unsigned int *sqharc[4];
unsigned short sqadto[4];
unsigned short sqtdso[4];
} sqlstm = {10,4};
/* SQLLIB Prototypes */
extern void sqlcxt (void **, unsigned long *,
struct sqlexd *, const struct sqlcxp *);
extern void sqlcx2t(void **, unsigned long *,
struct sqlexd *, const struct sqlcxp *);
extern void sqlbuft(void **, char *);
extern void sqlgs2t(void **, char *);
extern void sqlorat(void **, unsigned long *, void *);
/* Forms Interface */
static const int IAPSUCC = 0;
static const int IAPFAIL = 1403;
static const int IAPFTL = 535;
extern void sqliem(char *, int *);
static const char *sq0006 =
"select * from Customer where ID=:b0 ";
static const char *sq0010 =
"select ID from Customer where ID=:b0 ";
typedef struct { unsigned short len; unsigned char arr[1]; } VARCHAR;
typedef struct { unsigned short len; unsigned char arr[1]; } varchar;
/* cud (compilation unit data) array */
static const short sqlcud0[] =
{10,4130,852,0,0,
5,0,0,1,46,0,3,77,0,0,4,4,0,1,0,1,97,0,0,1,97,0,0,1,97,0,0,1,97,0,0,
36,0,0,2,0,0,29,79,0,0,0,0,0,1,0,
51,0,0,3,35,0,2,127,0,0,1,1,0,1,0,1,97,0,0,
70,0,0,4,0,0,29,128,0,0,0,0,0,1,0,
85,0,0,5,0,0,31,139,0,0,0,0,0,1,0,
100,0,0,6,47,0,9,206,0,0,1,1,0,1,0,1,97,0,0,
119,0,0,6,0,0,13,212,0,0,4,0,0,1,0,2,97,0,0,2,97,0,0,2,97,0,0,2,97,0,0,
150,0,0,6,0,0,15,229,0,0,0,0,0,1,0,
165,0,0,7,62,0,5,311,0,0,4,4,0,1,0,1,97,0,0,1,97,0,0,1,97,0,0,1,97,0,0,
196,0,0,8,0,0,29,313,0,0,0,0,0,1,0,
211,0,0,9,0,0,31,324,0,0,0,0,0,1,0,
226,0,0,10,48,0,9,360,0,0,1,1,0,1,0,1,97,0,0,
245,0,0,10,0,0,13,364,0,0,1,0,0,1,0,2,97,0,0,
};
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <sqlca.h>
#include <process.h>
extern bus_modifyMenu();
void bus_Menu();
extern int error();
void menu_query_cus();
int query_cus(char* tID);
void menu_insert_cus();
int insert_cus(char* tID,char* tName,char* tAddress,char* tTel);
void menu_delete_cus();
int delete_cus( char* tID );
void menu_update_cus();
int update_cus( char* tID,char* tName,char* tAddress,char* tTel );
int query_cusID_unique(char* tID);
void menu_insert_cus()
{
char t,m;
char ID[10];
char Name[30];
char Address[30];
char Tel[16];
while(1)
{
printf("\t\t添加顧客信息\n\n");
printf("請錄入顧客信息：\n\n");
printf("\t顧客號->");
scanf("%s",ID);
if( query_cusID_unique(ID) ){
printf("顧客號%s已經存在,請選擇另外的顧客號或者輸入n退出\n",ID);
fflush(stdin);
m=getchar();
if(m=='N'||m=='n') break;
else continue;
}/*if*/ else{
printf("\t顧客名->");
scanf("%s",Name);
printf("\t地址->");
scanf("%s",Address);
printf("\t電話->");
scanf("%s",Tel);
printf("\n");
fflush(stdin);
if(!insert_cus(ID,Name,Address,Tel))
printf("成功添加顧客信息！");
else printf("ERROR:(menu_insert_cus)");
}/*while*/
printf("繼續添加？(Y/N)");
t=getchar();
if(t=='N'||t=='n')break;
}
bus_modifyMenu();
}/*menu_insert_cus()*/
int insert_cus(char* tID,char* tName,char* tAddress,char* tTel)
{
/* EXEC SQL BEGIN DECLARE SECTION; */
char ID[10];
char Name[20];
char Address[30];
char Tel[16];
/* EXEC SQL END DECLARE SECTION; */
strcpy(ID,tID);
strcpy(Name,tName);
strcpy(Address,tAddress);
strcpy(Tel,tTel);
/* EXEC SQL WHENEVER SQLERROR DO error(); */
/* EXEC SQL INSERT INTO Customer
VALUES(:ID,:Name,:Address,:Tel); */
{
struct sqlexd sqlstm;
sqlstm.sqlvsn = 10;
sqlstm.arrsiz = 4;
sqlstm.sqladtp = &sqladt;
sqlstm.sqltdsp = &sqltds;
sqlstm.stmt = "insert into Customer values (:b0,:b1,:b2,:b3)";
sqlstm.iters = (unsigned int )1;
sqlstm.offset = (unsigned int )5;
sqlstm.cud = sqlcud0;
sqlstm.sqlest = (unsigned char *)&sqlca;
sqlstm.sqlety = (unsigned short)256;
sqlstm.occurs = (unsigned int )0;
sqlstm.sqhstv[0] = ( void *)ID;
sqlstm.sqhstl[0] = (unsigned int )10;
sqlstm.sqhsts[0] = ( int )0;
sqlstm.sqindv[0] = ( void *)0;
sqlstm.sqinds[0] = ( int )0;
sqlstm.sqharm[0] = (unsigned int )0;
sqlstm.sqadto[0] = (unsigned short )0;
sqlstm.sqtdso[0] = (unsigned short )0;
sqlstm.sqhstv[1] = ( void *)Name;
sqlstm.sqhstl[1] = (unsigned int )20;
sqlstm.sqhsts[1] = ( int )0;
sqlstm.sqindv[1] = ( void *)0;
sqlstm.sqinds[1] = ( int )0;
sqlstm.sqharm[1] = (unsigned int )0;
sqlstm.sqadto[1] = (unsigned short )0;
sqlstm.sqtdso[1] = (unsigned short )0;
sqlstm.sqhstv[2] = ( void *)Address;
sqlstm.sqhstl[2] = (unsigned int )30;
sqlstm.sqhsts[2] = ( int )0;
sqlstm.sqindv[2] = ( void *)0;
sqlstm.sqinds[2] = ( int )0;
sqlstm.sqharm[2] = (unsigned int )0;
sqlstm.sqadto[2] = (unsigned short )0;
sqlstm.sqtdso[2] = (unsigned short )0;
sqlstm.sqhstv[3] = ( void *)Tel;
sqlstm.sqhstl[3] = (unsigned int )16;
sqlstm.sqhsts[3] = ( int )0;
sqlstm.sqindv[3] = ( void *)0;
sqlstm.sqinds[3] = ( int )0;
sqlstm.sqharm[3] = (unsigned int )0;
sqlstm.sqadto[3] = (unsigned short )0;
sqlstm.sqtdso[3] = (unsigned short )0;
sqlstm.sqphsv = sqlstm.sqhstv;
sqlstm.sqphsl = sqlstm.sqhstl;
sqlstm.sqphss = sqlstm.sqhsts;
sqlstm.sqpind = sqlstm.sqindv;
sqlstm.sqpins = sqlstm.sqinds;
sqlstm.sqparm = sqlstm.sqharm;
sqlstm.sqparc = sqlstm.sqharc;
sqlstm.sqpadto = sqlstm.sqadto;
sqlstm.sqptdso = sqlstm.sqtdso;
sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);
if (sqlca.sqlcode < 0) error();
}
/* EXEC SQL COMMIT; */
{
struct sqlexd sqlstm;
sqlstm.sqlvsn = 10;
sqlstm.arrsiz = 4;
sqlstm.sqladtp = &sqladt;
sqlstm.sqltdsp = &sqltds;
sqlstm.iters = (unsigned int )1;
sqlstm.offset = (unsigned int )36;
sqlstm.cud = sqlcud0;
sqlstm.sqlest = (unsigned char *)&sqlca;
sqlstm.sqlety = (unsigned short)256;
sqlstm.occurs = (unsigned int )0;
sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);
if (sqlca.sqlcode < 0) error();
}
return 0;
}/*insert_cus()*/
void menu_delete_cus()
{
char t;
char ID[10];
while(1)
{
printf("\t\t刪除顧客信息\n\n");
printf("請錄入預刪除的顧客號：\n\n");
printf("\t顧客號->");
scanf("%s",ID);
fflush(stdin);
if( query_cus( ID ) )
printf("WARING:(menu_delete_cus)Customer %s does not exist.\t\n\n",ID);
else{
if( !delete_cus( ID ) )
printf("成功刪除顧客號為%s的信息！",ID);
else printf("WARING:(menu_delete_cus)Customer %s does not exist.\t",ID);
}/*else*/
printf("還要刪除嗎？(Y/N)");
t=getchar();
if(t=='N'||t=='n')break;
}/*while*/
bus_modifyMenu();
}/*menu_delete_cus()*/
int delete_cus( char* tID)
{
/* EXEC SQL BEGIN DECLARE SECTION; */
char seekID[10];
/* EXEC SQL END DECLARE SECTION; */
/* char ID[10];
char Name[20];
char Address[30];
char Tel[16];
char Intro[100];*/
strcpy(seekID,tID);
/* EXEC SQL WHENEVER SQLERROR GOTO sqlerr; */
/* EXEC SQL WHENEVER NOT FOUND GOTO notfound; */
/* EXEC SQL DELETE FROM Customer WHERE ID=:seekID; */
{
struct sqlexd sqlstm;
sqlstm.sqlvsn = 10;
sqlstm.arrsiz = 4;
sqlstm.sqladtp = &sqladt;
sqlstm.sqltdsp = &sqltds;
sqlstm.stmt = "delete from Customer where ID=:b0";
sqlstm.iters = (unsigned int )1;
sqlstm.offset = (unsigned int )51;
sqlstm.cud = sqlcud0;
sqlstm.sqlest = (unsigned char *)&sqlca;
sqlstm.sqlety = (unsigned short)256;
sqlstm.occurs = (unsigned int )0;
sqlstm.sqhstv[0] = ( void *)seekID;
sqlstm.sqhstl[0] = (unsigned int )10;
sqlstm.sqhsts[0] = ( int )0;
sqlstm.sqindv[0] = ( void *)0;
sqlstm.sqinds[0] = ( int )0;
sqlstm.sqharm[0] = (unsigned int )0;
sqlstm.sqadto[0] = (unsigned short )0;
sqlstm.sqtdso[0] = (unsigned short )0;
sqlstm.sqphsv = sqlstm.sqhstv;
sqlstm.sqphsl = sqlstm.sqhstl;
sqlstm.sqphss = sqlstm.sqhsts;
sqlstm.sqpind = sqlstm.sqindv;
sqlstm.sqpins = sqlstm.sqinds;
sqlstm.sqparm = sqlstm.sqharm;
sqlstm.sqparc = sqlstm.sqharc;
sqlstm.sqpadto = sqlstm.sqadto;
sqlstm.sqptdso = sqlstm.sqtdso;
sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);
if (sqlca.sqlcode == 1403) goto notfound;
if (sqlca.sqlcode < 0) goto sqlerr;
}
/* EXEC SQL COMMIT; */
{
struct sqlexd sqlstm;
sqlstm.sqlvsn = 10;
sqlstm.arrsiz = 4;
sqlstm.sqladtp = &sqladt;
sqlstm.sqltdsp = &sqltds;
sqlstm.iters = (unsigned int )1;
sqlstm.offset = (unsigned int )70;
sqlstm.cud = sqlcud0;
sqlstm.sqlest = (unsigned char *)&sqlca;
sqlstm.sqlety = (unsigned short)256;
sqlstm.occurs = (unsigned int )0;
sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);
if (sqlca.sqlcode < 0) goto sqlerr;
}
printf("%s dropped.\n",seekID);
return 0;
notfound:
printf("WARING:(delete_cus)Customer %s does not exist.\t",seekID);
return -1;
sqlerr:
printf("%70s\n",sqlca.sqlerrm.sqlerrmc);
/* EXEC SQL WHENEVER SQLERROR CONTINUE; */
/* EXEC SQL ROLLBACK; */
{
struct sqlexd sqlstm;
sqlstm.sqlvsn = 10;
sqlstm.arrsiz = 4;
sqlstm.sqladtp = &sqladt;
sqlstm.sqltdsp = &sqltds;
sqlstm.iters = (unsigned int )1;
sqlstm.offset = (unsigned int )85;
sqlstm.cud = sqlcud0;
sqlstm.sqlest = (unsigned char *)&sqlca;
sqlstm.sqlety = (unsigned short)256;
sqlstm.occurs = (unsigned int )0;
sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);
}
return -1;
/* EXEC SQL DECLARE del_pro SCROLL CURSOR FOR
SELECT ID,Name,Address,Tel,Intro FROM Provider WHERE ID=:seekID FOR UPDATE;
EXEC SQL OPEN del_pro;
EXEC SQL WHENEVER NOT FOUND DO BREAK;
EXEC SQL FETCH FIRST del_pro INTO :ID,:Name,:Address,:Tel,:Intro;
EXEC SQL DELETE FROM Provider WHERE CURRENT OF del_pro;*/
/* EXEC SQL PREPARE stat FROM
'DELETE Provider WHERE ID=:a';
EXEC SQL EXECUTE stat USING :ID;*/
/* EXEC SQL WHENEVER SQLERROR DO error();
EXEC SQL DELETE FROM Provider
WHERE ID=:ID;*/
/* EXEC SQL COMMIT;
EXEC SQL CLOSE del_pro;
return 0; */
}/*delete_cus(...)*/
void menu_query_cus()
{
int more=1;
char t;
char ID[10];
while(more)
{
fflush(stdin);
printf("\n\n\t\t查詢顧客信息\n\n");
printf("請錄入要查詢的顧客號：\n\n");
printf("\t顧客號->");
scanf("%s",ID);
fflush(stdin);
if( query_cus( ID ) )
printf("WARING:(menu_query_cus)Customer %s does not exist.\t\n\n",ID);
/* if( !delete_cus( ID ) )
printf("成功刪除顧客號為%s的信息！",ID);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -