📄 demo(软件结构).cpp
字号:
#include <iostream.h>
#include <unistd.h>
#include <sys/param.h>
#include <sybfront.h>
//使用DB-Library函数编程需要使用的头文件
#include <sybdb.h>
#include <syberror.h>
#include <stdio.h>
#define UID "niit" //登陆数据库用户名
#define PWD "niit" //登陆数据库密码
#define DBSERVER "192.168.1.67:1433" //SQL Server IP地址和链接端口
#define DBNAME "project" //数据库名称
#define MAXHOSTNAMELEN 256 //主机名称长度
//由用户名和口令组成的环境信息的结构体指针
LOGINREC *login;
//SQL Server 与应用程序通信的结构体指针
DBPROCESS *dbconn;
//数据库链接类
class Connection
{
public:
//链接数据库
void connectDB();
//断开数据库链接
void disconnectDB();
//执行SQL语句
void execStatement(char* statement);
};
//应用程序类
class App
{
private:
void insert();
public:
void menu();
};
//数据库链接类实现
//参考SM1"项目执行"部分内容
void Connection::connectDB()
{
char hostname[MAXHOSTNAMELEN];
int max_len = MAXHOSTNAMELEN;
if(dbinit() == FAIL)
{
cout<<"initialize DB error";
cout<<endl;
}
if((login = dblogin())==FAIL)
{
cout<<"initialize dblogin() structure error";
}
DBSETLUSER(login, UID);
DBSETLPWD(login, PWD);
if(gethostname(hostname, max_len)==0)
{
DBSETLHOST(login,hostname);
}
if((dbconn=dbopen(login,DBSERVER))==NULL)
{
cout<<"connect to the DB server error: "<<DBSERVER<<endl;
}
if((dbuse(dbconn, DBNAME)) == FAIL)
{
cout<<"Open database error"<<DBNAME<<" in "<< DBSERVER ;
cout<<endl;
}
dbloginfree(login);
}
void Connection::disconnectDB()
{
dbfreebuf(dbconn);
dbclose(dbconn);
dbexit();
}
void Connection::execStatement(char* statement)
{
dbcmd(dbconn, statement);
if (!dbsqlexec(dbconn)==FAIL)
{
cout<<"Query executed successfully"<<endl;
}
else
{
cout<<"Error in execution"<<endl;
}
}
void App::menu()
{
char pOp;
char cOp;
while (true)
{
system("clear");
cout<<"$$$$$$$$$$$ShareAccounting System$$$$$$$$$$\n";
cout<<"$ $\n";
cout<<"$>>>>>>>>>>>>>>>>>MainMenu<<<<<<<<<<<<<<<<$\n";
cout<<"$ $\n";
cout<<"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$\n";
cout<<"$ 1 Proposer Information Management $\n";
cout<<"$ 2 Stock Information Management $\n";
cout<<"$ 3 Share Stock Information Management $\n";
cout<<"$ 4 Reporter Print $\n";
cout<<"$ 5 Exit System $\n";
cout<<"$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$\n";
cout<<"\n";
cout<<"Please Select Operate(1-5)$";
cin>>pOp;
cout<<"\n";
switch pOp
{
case '1':
system("clear");
cout<<"########## ShareAccounting System #########\n";
cout<<"# #\n";
cout<<"#>>>>>Proposer Information Management<<<<<#\n";
cout<<"# #\n";
cout<<"###########################################\n";
cout<<"# 1 Add Proposer Information #\n";
cout<<"# 2 Update Proposer Information #\n";
cout<<"# 3 Delete Proposer Information #\n";
cout<<"# 4 Return MainMenu #\n";
cout<<"###########################################\n";
cout<<"\n";
while(true)
{
cout<<">>>>>Proposer Information Management<<<<<\n";
cout<<"Please Select Operate(1-4)#";
cin>>cOp;
cout<<"\n";
switch cOp
{
case '1':
break;
case '2':
break;
case '3':
break;
default
}
if(cOp=='4')break;
}
break;
case '2':
system("clear");
cout<<"########## ShareAccounting System #########\n";
cout<<"# #\n";
cout<<"#>>>>>>>Stock Information Management<<<<<<#\n";
cout<<"# #\n";
cout<<"###########################################\n";
cout<<"# 1 Add Stock Information #\n";
cout<<"# 2 Update Stock Information #\n";
cout<<"# 3 Delete Stock Information #\n";
cout<<"# 4 Return MainMenu #\n";
cout<<"###########################################\n";
cout<<"\n";
while(true)
{
cout<<">>>>>Stock Information Management<<<<<\n";
cout<<"Please Select Operate(1-4)#";
cin>>cOp;
cout<<"\n";
switch cOp
{
case '1':
break;
case '2':
break;
case '3':
break;
default
}
if(cOp=='4')break;
}
break;
case '3':
system("clear");
cout<<"########## ShareAccounting System #########\n";
cout<<"# #\n";
cout<<"#>>>>Share Stock Information Management<<<#\n";
cout<<"# #\n";
cout<<"###########################################\n";
cout<<"# 1 Add Share Stock Information #\n";
cout<<"# 2 Update Share Stock Information #\n";
cout<<"# 3 Delete Share Stock Information #\n";
cout<<"# 4 Return MainMenu #\n";
cout<<"###########################################\n";
cout<<"\n";
while(true)
{
cout<<">>>>>Share Stock Information Management<<<<<\n";
cout<<"Please Select Operate(1-4)#";
cin>>cOp;
cout<<"\n";
switch cOp
{
case '1':
break;
case '2':
break;
case '3':
break;
default
}
if(cOp=='4')break;
} break;
case '4':
system("clear");
cout<<"########## ShareAccounting System #########\n";
cout<<"# #\n";
cout<<"#>>>>>>>>>>>>>>Reportor Print<<<<<<<<<<<<<#\n";
cout<<"# #\n";
cout<<"###########################################\n";
cout<<"# 1 Print Class The Most Share List #\n";
cout<<"# 2 Print Class Share List #\n";
cout<<"# 3 Print Date Share List #\n";
cout<<"# 4 Return MainMenu #\n";
cout<<"###########################################\n";
cout<<"\n";
while(true)
{
cout<<">>>>>>>>>Reportor Print<<<<<<<<<<<\n";
cout<<"Please Select Operate(1-4)#";
cin>>cOp;
cout<<"\n";
switch cOp
{
case '1':
break;
case '2':
break;
case '3':
break;
default
}
if(cOp=='4')break;
} break;
break;
case '5':
return;
default
}
}
}
//.........................................................
void App::insert()
{
}
int main()
{
App app;
app.menu_app();
return 0;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -