ericmobil项目代码文件.cc

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

                        break;
                case '5':
                        return;
                default:
                        cout<<"OPerate Error,Please Input 1-5 Number to Select Operate.\n";
                        break;
                }
        }
}

void App::AddProposer()
{
        Proposer proposer;

        cout<<"Please input proposer name:";
        cin>>proposer.vcProposerName;
        cout<<"\n";

        cout<<"Please input proposer sex:";
        cin>>proposer.cSex;
        cout<<"\n";
        cout<<"Please input proposer address:";
        cin>>proposer.vcAddr;
        cout<<"\n";

        cout<<"Please input proposer telephone:";
        cin>>proposer.vcTel;
        cout<<"\n";

        proposer.addinfo();
}
void App::UpdateProposer()
{

        Proposer proposer;

        cout<<"Please input proposer ID:";
        cin>>proposer.cProposerID;
        cout<<"\n";

        cout<<"Please input proposer name:";
        cin>>proposer.vcProposerName;
        cout<<"\n";

        cout<<"Please input proposer sex:";
        cin>>proposer.cSex;
        cout<<"\n";

        cout<<"Please input proposer address:";
        cin>>proposer.vcAddr;
        cout<<"\n";

        cout<<"Please input proposer telephone:";
        cin>>proposer.vcTel;
        cout<<"\n";

        proposer.updateinfo();

}
void App::DeleteProposer()
{
        Proposer proposer;

        cout<<"Please input proposer ID:";
        cin>>proposer.cProposerID;
        cout<<"\n";

        proposer.deleteinfo();


}
void App::AddStock()
{
        Stock stock;

        cout<<"Please input stock name:";
        cin>>stock.vcStockName;
        cout<<"\n";

        cout<<"Please input stock price:";
        cin>>stock.intStockPrice;;
        cout<<"\n";

        cout<<"Please input stock start accredit NO:";
        cin>>stock.cStartNO;
        cout<<"\n";

        cout<<"Please input stock end accredit NO:";
        cin>>stock.cEndNO;
        cout<<"\n";

        stock.addinfo();
}
void App::UpdateStock()
{
        Stock stock;

        cout<<"Please input stock ID:";
        cin>>stock.cStockID;
        cout<<"\n";

        cout<<"Please input stock name:";
        cin>>stock.vcStockName;
        cout<<"\n";

        cout<<"Please input stock price:";
        cin>>stock.intStockPrice;
        cout<<"\n";

        cout<<"Please input stock start accredit NO:";
        cin>>stock.cStartNO;
        cout<<"\n";

        cout<<"Please input stock end accredit NO:";
        cin>>stock.cEndNO;
        cout<<"\n";

        stock.updateinfo();
}
void App::DeleteStock()
{
        Stock stock;

        cout<<"Please input stock ID:";
        cin>>stock.cStockID;
        cout<<"\n";

        stock.deleteinfo();

}
void App::AddShareStock()
{
        ShareStock sharestock;

        cout<<"Please input proposer ID:";
        cin>>sharestock.cProposerID;
        cout<<"\n";

        cout<<"Please input stock ID:";
        cin>>sharestock.cStockID;
        cout<<"\n";

        cout<<"Please input share stock total:";
        cin>>sharestock.intStockTotal;
        cout<<"\n";

        cout<<"Please input share stock date:";
        cin>>sharestock.dShareDate;
        cout<<"\n";

        sharestock.addinfo();

}
void App::UpdateShareStock()
{
        ShareStock sharestock;

        cout<<"Please input proposer ID:";
        cin>>sharestock.cProposerID;
        cout<<"\n";

        cout<<"Please input stock ID:";
        cin>>sharestock.cStockID;
        cout<<"\n";

        cout<<"Please input share stock total:";
        cin>>sharestock.intStockTotal;
        cout<<"\n";

        cout<<"Please input share stock date:";
        cin>>sharestock.dShareDate;
        cout<<"\n";

        sharestock.updateinfo();
}
void App::DeleteShareStock()
{
        ShareStock sharestock;

        cout<<"Please input proposer ID:";
        cin>>sharestock.cProposerID;
        cout<<"\n";

        cout<<"Please input stock ID:";
        cin>>sharestock.cStockID;
        cout<<"\n";

        sharestock.deleteinfo();

}
void App::PrintTheMostShareList()
{
        Base base;
        base.PrintTheMostShareList();
}
void App::PrintshareList()
{
        Base base;
        base.PrintshareList();
}
void App::PrintDateShareList()
{
        Base base;
        base.PrintDateShareList();
}

void Base::execSQL(char* mysql)
{
        Connection con;
        con.connectDB();
        con.execStatement(mysql);
        con.disconnectDB();
}

void Base::PrintTheMostShareList()
{
        Connection con;
        int StockID;
        char StockName[50];
        int StockPrice;
        char StartNO[9];
        char EndNO[9];
        con.connectDB();
        con.execStatement("select 'Stock NO'=iStockID,'Stock Name'=vcStockName,'Stock Price'=fStockPrice,'Start NO'=cStartNO,'End NO'=cEndNO from niit24Stock");
        dbresults(dbconn);
        dbbind(dbconn,1,INTBIND,0,(BYTE*)&StockID);
        dbbind(dbconn,2,CHARBIND,0,(BYTE*)StockName);
        dbbind(dbconn,3,INTBIND,0,(BYTE*)&StockPrice);
        dbbind(dbconn,4,CHARBIND,0,(BYTE*)StartNO);
        dbbind(dbconn,5,CHARBIND,0,(BYTE*)EndNO);
        cout<<"Stock NO\tStock Name\tStock Price\tStart NO\tEnd NO"<<endl;
        while(dbnextrow(dbconn)!=NO_MORE_ROWS)
        {
                cout<<StockID<<"\t\t";
                cout<<StockName<<"\t\t";
                cout<<StockPrice<<"\t\t";
                cout<<StartNO<<"\t";
                cout<<EndNO<<"\n";
        }
        con.disconnectDB();
}
void Base::PrintshareList()
{
        Connection con;
        int StockID;
        char StockName[50];
        int StockTotal;
        con.connectDB();
        con.execStatement("select 'Stock NO'=ss.iStockID,'Stock Name'=vcStockName,'Share Stock Sum'=sum(iStockTotal) from niit24Stock s,niit24ShareStock ss where s.iStockID=ss.iStockID group by ss.iStockID,vcStockName");
        dbresults(dbconn);
        dbbind(dbconn,1,INTBIND,0,(BYTE*)&StockID);
        dbbind(dbconn,2,CHARBIND,0,(BYTE*)StockName);
        dbbind(dbconn,3,INTBIND,0,(BYTE*)&StockTotal);
        cout<<"Stock NO\tStock Name\tStock Total"<<endl;
        while(dbnextrow(dbconn)!=NO_MORE_ROWS)
        {
                cout<<StockID<<"\t\t";
                cout<<StockName<<"\t\t";
                cout<<StockTotal<<"\n";
        }
        con.disconnectDB();
}
void Base::PrintDateShareList()
{
        Connection con;
        char ShareDate[50];
        int StockTotal;
        con.connectDB();
        con.execStatement("select 'Share Stock Date'=dShareDate,'Share Stock Total'=sum(iStockTotal) from niit24ShareStock group by dShareDate");
        dbresults(dbconn);
        dbbind(dbconn,1,CHARBIND,0,(BYTE*)ShareDate);
        dbbind(dbconn,2,INTBIND,0,(BYTE*)&StockTotal);
        cout<<"Share Stock Date\tStock Total"<<endl;
        while(dbnextrow(dbconn)!=NO_MORE_ROWS)
        {
                cout<<ShareDate<<"\t\t";
                cout<<StockTotal<<"\n";
        }
        con.disconnectDB();
}

void Proposer::addinfo()
{
        char mysql[800];
        sprintf(mysql,"insert into niit24Proposer values('%s','%s','%s','%s')",vcProposerName,cSex,vcAddr,vcTel);
        execSQL(mysql);
}
void Proposer::updateinfo()
{
        char mysql[800];
        sprintf(mysql,"update niit24Proposer set vcProposerName='%s',cSex='%s',vcAddr='%s',vcTel='%s' where iProposerID='%d'",vcProposerName,cSex,vcAddr,vcTel,cProposerID);
        execSQL(mysql);
}
void Proposer::deleteinfo()
{
        char mysql[800];
        sprintf(mysql,"delete from niit24Proposer where iProposerID='%d'",cProposerID);
        execSQL(mysql);
}

void Stock::addinfo()
{
        char mysql[800];
        sprintf(mysql,"insert into niit24Stock values('%s','%f','%s','%s')",vcStockName,intStockPrice,cStartNO,cEndNO);
        execSQL(mysql);
}
void Stock::updateinfo()
{
        char mysql[800];
        sprintf(mysql,"update niit24Stock set vcStockName='%s',iStockPrice='%f',cStartNO='%s',cEndNO='%s' where iStockID='%d'",vcStockName,intStockPrice,cStartNO,cEndNO,cStockID);
        execSQL(mysql);
}
void Stock::deleteinfo()
{
        char mysql[800];
        sprintf(mysql,"delete from niit24Stock where iStockID='%d'",cStockID);
        execSQL(mysql);
}

void ShareStock::addinfo()
{
        char mysql[800];
        sprintf(mysql,"insert into niit24ShareStock values('%d','%d','%d','%s')",cProposerID,cStockID,intStockTotal,dShareDate);
        execSQL(mysql);
}
void ShareStock::updateinfo()
{
        char mysql[800];
        sprintf(mysql,"update niit24ShareStock set iStockTotal='%d',dShareDate='%s' where iProposerID='%d',iStockID='%d'",intStockTotal,dShareDate,cProposerID,cStockID);
        execSQL(mysql);
}
void ShareStock::deleteinfo()
{
        char mysql[800];
        sprintf(mysql,"delete from niit24ShareStock where iProposerID='%d',iStockID='%d'",cProposerID,cStockID);
        execSQL(mysql);
}

int main()
{
        App app;
        app.init();
}