linklogin.pc

pro C的一个关于零件交易系统的源码

#include <stdio.h> 
#include <string.h>
#include <stdlib.h>
#include <sqlca.h>
#include <conio.h>
#include <process.h>

void connMenu();
void connect(char* user,char* pw,char* dblink);
int error();
void bus_Menu();
extern int insert_pro(char* ID,char* Name,char* Address,char* Tel,char* Intro);
extern void bus_modifyMenu();
extern void part_modify_menu();
extern void advice_bussiness();
extern void registerBussiness();
main()
{
	connMenu();
	bus_Menu();
}/*main()*/

void connMenu()
{	
	char temp;
  	char username[20]; 
  	char password[20];
  	char dblinkname[20];	

	printf("正在启动交易员服务端......\n\n\n");
	printf("\t\t---请选择连接方式---\n\n");
	printf("\t\t 1. 默认方式\n");
	printf("\t\t 2. 手动连接\n");
	printf("\t\t ...任意键退出\n\n");

/*	do {*/
		
		printf("请选择连接方式(1 or 2 ,quit with any other key):");
		temp=getchar();
		fflush(stdin);//break;
		/*putchar(temp);*/
/*	   }while(temp!='1'&&temp!='2');*/

		switch(temp) {
			case '1':	
					connect("system","manager","willim");
					break;
					/*默认*/
				
				
			case '2':	
					printf("输入连接用户名:");
					gets(username);
					printf("输入连接口令:");
					gets(password);
					printf("输入连接字符串:");
					gets(dblinkname);
					connect(username,password,dblinkname);
					break;
					/*手动*/
				
			case '0':	exit(1); /*退出*/
			default :	printf("Exit the system!\n");exit(1);/*退出系统*/
			}/*switch*/
	      
}/*connectMenu()*/

void connect(char* user,char* pw,char* dblink)
{
	EXEC SQL BEGIN DECLARE SECTION; 
  	char username[20]; 
  	char password[20];
  	char dblinkname[20];
	EXEC SQL END DECLARE SECTION;	
			
	strcpy(username,user);
      	strcpy(password,pw);
      	strcpy(dblinkname,dblink);
  	EXEC SQL WHENEVER SQLERROR DO error(); /*错误处理*/
  	EXEC SQL CONNECT :username IDENTIFIED BY :password USING :dblinkname; 
  	printf("\nConnected to ORACLE as user:%s\n",username); 
	printf("你已成功登录本系统\n");

}/*Conn()*/

int error()
{
	printf("发生了一些错误,sorry,还没完成错误处理功能!");
	EXEC SQL WHENEVER SQLERROR CONTINUE;    
   	printf("\nORACLE error detected:\n"); 
   	printf("\n%.70s\n",sqlca.sqlerrm.sqlerrmc); 
   	EXEC SQL ROLLBACK RELEASE; 
   	return 1; 
	connMenu();	
	return 0;
}/*error()*/

/*void flash() 已无用
{
	int c;
	while( (c=getchar()) != '\n')
		;
	
}/*flash()*/  

void bus_Menu()
{
	char temp;
	fflush(stdin);
	/*clrscr(void); */
	system("cls");
	puts("\n\n交易中心服务器端\n\n");
	puts("\n\n\t\t\t主功能菜单\n\n");
	printf("\t1.系统维护\n");
	printf("\t2.零件信息维护\n");
	printf("\t3.推荐交易\n");
	printf("\t4.确认交易\n");	
	printf("\t....任意键退出\n\n");
	
	do {
		
		printf("请选择(1 - 4 ,quit with any other key):");
		temp=getchar();
		fflush(stdin);
		
	   }while(temp==1||temp==2||temp==3||temp==4);

		switch(temp) {
			case '1': 
				bus_modifyMenu();break;
			case '2':
				part_modify_menu();break;
			case '3':
				advice_bussiness();break;
			case '4':
				registerBussiness();break;
/*			case '5':*/
					
			}
}/*bus_Menu()*/