ericmobil项目代码文件.cc

DOS下的开发,仅供参考,对于新的学习的学生C的学习有用

#include <iostream.h>
#include <unistd.h>
#include <sys/param.h>
#include <sybfront.h>
#include <sybdb.h>
#include <syberror.h>
#include <stdio.h>

#define UID "niit"
#define PWD "niit"
#define DBSERVER "192.168.1.69:1433"
#define DBNAME "project"

LOGINREC *login;
DBPROCESS *dbconn;

class Connection
{
public:
    void connectDB();
    void disconnectDB();
    void execStatement(char* statement);

};

class Base
{
        private:

        protected:
                void execSQL(char* mysql);

        public:
                void PrintTheMostShareList();
                void PrintshareList();
                void PrintDateShareList();

};

class Proposer:public Base
{
        private:

        public:
                int cProposerID;
                char vcProposerName[20];
                char cSex[2];
                char vcAddr[50];
                char vcTel[20];
                void addinfo();
                void updateinfo();
                void deleteinfo();


};

class Stock:public Base
{
        private:

        public:
                int cStockID;
                char vcStockName[50];
                float intStockPrice;
                char cStartNO[9];
                char cEndNO[9];
                void addinfo();
                void updateinfo();
                void deleteinfo();
};

class ShareStock:public Base
{
        private:

        public:
                int cProposerID;
                int cStockID;
                int intStockTotal;
                char dShareDate[8];
                void addinfo();
                void updateinfo();
                void deleteinfo();

};

class App
{
        private:
                void insert();
                void menu();
                                void AddProposer();
                                void UpdateProposer();
                                void DeleteProposer();
                                void AddStock();
                                void UpdateStock();
                                void DeleteStock();
                                void AddShareStock();
                                void UpdateShareStock();
                                void DeleteShareStock();
                                void PrintTheMostShareList();
                                void PrintshareList();
                                void PrintDateShareList();
        public:

                void init();

};


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::init()
{
        menu();
}

void App::menu()
{
        char pOp;
        char cOp;
        system("clear");
        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':
                                                                                        AddProposer();
                                            break;
                                        case '2':
                                                                                        UpdateProposer();
                                            break;
                                        case '3':
                                                                                        DeleteProposer();
                                            break;
                                        default:
                                                break;
                                }
                                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':
                                                                                        AddStock();
                                            break;
                                        case '2':
                                                                                        UpdateStock();
                                            break;
                                        case '3':
                                                                                        DeleteStock();
                                            break;
                                        default:
                                                break;
                                }
                                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':
                                                                                        AddShareStock();
                                            break;
                                        case '2':
                                                                                        UpdateShareStock();
                                            break;
                                        case '3':
                                                                                        DeleteShareStock();
                                            break;
                                        default:
                                                break;
                                }
                                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':
                                                                                        PrintTheMostShareList();
                                            break;
                                        case '2':
                                                                                        PrintshareList();
                                            break;
                                        case '3':
                                                                                        PrintDateShareList();
                                            break;
                                        default:
                                                break;
                                }
                                if(cOp=='4')break;
                        }