11嵌入式鮮奶配送系統(tǒng)設(shè)計(jì)報(bào)告

嵌入式系統(tǒng)課程設(shè)計(jì)報(bào)告11鮮奶配送系統(tǒng)專 業(yè)： 計(jì)算機(jī)科學(xué)與技班 級(jí)：姓 名：學(xué) 號(hào)指導(dǎo)教師：11鮮奶配送系統(tǒng)1設(shè)計(jì)目的SQLiteWINCE數(shù)據(jù)庫(kù)的安裝與使用方法。2、開發(fā)環(huán)境VisualStudio2005C++MFCSQLite數(shù)據(jù)庫(kù)實(shí)現(xiàn)數(shù)據(jù)表的建立。3、設(shè)計(jì)任務(wù)及要求在VisualStudio2005環(huán)境下，編寫WINCE對(duì)話框程序。在程序中添加SQLite數(shù)據(jù)庫(kù)文件，使用SQLite數(shù)據(jù)庫(kù)。設(shè)計(jì)要求：數(shù)據(jù)庫(kù)設(shè)計(jì)：訂單列表：牛奶單號(hào)，客戶id，奶品名稱，奶品單價(jià)，奶品數(shù)量。4、實(shí)現(xiàn)過(guò)程硬件DMA-6410開發(fā)平臺(tái)/CHSINTWINCE6.0模擬器驅(qū)動(dòng)程序設(shè)計(jì)1、界面設(shè)計(jì)2、添加成員3、刪除成員4、修改成員用戶應(yīng)用程序設(shè)計(jì)//mysqlitesDlg.cpp:實(shí)現(xiàn)文件//#include"stdafx.h"#include"mysqlites.h"#include"mysqlitesDlg.h"#ifdef_DEBUG#definenewDEBUG_NEW#endif//CmysqlitesDlg對(duì)話框CmysqlitesDlg::CmysqlitesDlg(CWnd*pParent/*=NULL*/):CDialog(CmysqlitesDlg::IDD,pParent),m_edit(_T("")){m_hIcon=AfxGetApp()->LoadIcon(IDR_MAINFRAME);}voidCmysqlitesDlg::DoDataExchange(CDataExchange*pDX){CDialog::DoDataExchange(pDX);DDX_Text(pDX,IDC_EDIT1,m_edit);}BEGIN_MESSAGE_MAP(CmysqlitesDlg,CDialog)#ifdefined(_DEVICE_RESOLUTION_AWARE)&&!defined(WIN32_PLATFORM_WFSP)ON_WM_SIZE()#endif//}}AFX_MSG_MAPON_BN_CLICKED(IDC_BUTTON1,&CmysqlitesDlg::OnBnClickedButton1)ON_BN_CLICKED(IDC_BUTTON2,&CmysqlitesDlg::OnBnClickedButton2)ON_BN_CLICKED(IDC_BUTTON3,&CmysqlitesDlg::OnBnClickedButton3)ON_EN_CHANGE(IDC_EDIT2,&CmysqlitesDlg::OnEnChangeEdit2)ON_BN_CLICKED(IDC_BUTTON4,&CmysqlitesDlg::OnBnClickedButton4)ON_EN_CHANGE(IDC_EDIT3,&CmysqlitesDlg::OnEnChangeEdit3)ON_EN_CHANGE(IDC_EDIT4,&CmysqlitesDlg::OnEnChangeEdit4)ON_BN_CLICKED(IDC_BUTTON5,&CmysqlitesDlg::OnBnClickedButton5)ON_BN_CLICKED(IDC_BUTTON7,&CmysqlitesDlg::OnBnClickedButton7)ON_EN_CHANGE(IDC_EDIT5,&CmysqlitesDlg::OnEnChangeEdit5)ON_EN_CHANGE(IDC_EDIT6,&CmysqlitesDlg::OnEnChangeEdit6)END_MESSAGE_MAP()//CmysqlitesDlg消息處理程序BOOLCmysqlitesDlg::OnInitDialog(){CDialog::OnInitDialog();//設(shè)置此對(duì)話框的圖標(biāo)。當(dāng)應(yīng)用程序主窗口不是對(duì)話框時(shí)，框架將自動(dòng)// 執(zhí)行此操作SetIcon(m_hIcon,TRUE);SetIcon(m_hIcon,FALSE);

//設(shè)置大圖標(biāo)//設(shè)置小圖標(biāo)//TODO:在此添加額外的初始化代碼returnTRUE;//除非將焦點(diǎn)設(shè)置到控件，否則返回TRUE}#ifdefined(_DEVICE_RESOLUTION_AWARE)&&!defined(WIN32_PLATFORM_WFSP)voidCmysqlitesDlg::OnSize(UINT/*nType*/,int/*cx*/,int/*cy*/){if(AfxIsDRAEnabled()){DRA::RelayoutDialog(AfxGetResourceHandle(),this->m_hWnd,DRA::GetDisplayMode()!=DRA::Portrait?MAKEINTRESOURCE(IDD_MYSQLITES_DIALOG_WIDE):MAKEINTRESOURCE(IDD_MYSQLITES_DIALOG));}}#endifvoidCmysqlitesDlg::OnBnClickedButton1(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");//打開或新建數(shù)據(jù)庫(kù)，文件名為test.dbMessageBox(_T("SUCCESS"),_T("INFORMATION"),MB_OK);//創(chuàng)建成功顯示db.close();//關(guān)閉}voidCmysqlitesDlg::OnBnClickedButton2(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");//打開數(shù)據(jù)庫(kù)//新建表CppSQLite3Queryq=db.execQuery(L"createtablePSRB(nndhvarchar(8),khidvarchar(8),npmcvarchar(8),npdjvarchar(8),npslvarchar(8)");//使用execQuery方法執(zhí)行SQL語(yǔ)句創(chuàng)建表。//插入數(shù)據(jù)q=db.execQuery(L"insertintoPSRBvalues('01','0321','完達(dá)ft','20','3')");//執(zhí)行SQL語(yǔ)句插入一條數(shù)據(jù)MessageBox(_T("SUCCESS"),_T("INFORMATION"),MB_OK);//成功則顯示SUCCESSdb.close();//關(guān)閉}voidCmysqlitesDlg::OnBnClickedButton3(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CppSQLite3Queryq=db.execQuery(L"select*fromPSRB");//查詢CStringstrTemp;while(!q.eof())//返回值按行循環(huán){strTemp.Format(_T("%s%s%s%s%s"),q.fieldValue(0),q.fieldValue(1),q.fieldValue(2),q.fieldValue(3),q.fieldValue(4));//返回的每一行的數(shù)據(jù)中，依次保存在q.fieldValue(0),q.fieldValue(1),q.fieldValue(2s空格%s空格的形式賦給strTemp。m_edit+=strTemp;//將strTemp賦給EDIT框成員變量m_edit。m_edit+="\r\n";UpdateData(FALSE);//更新，使EDIT顯示數(shù)據(jù)q.nextRow();//下一行，循環(huán)}q.finalize();//SQL返回結(jié)束db.close();//關(guān)閉}voidCmysqlitesDlg::OnEnChangeEdit2(){//TODO: IfthisisaRICHEDITcontrol,thecontrolwillnot//sendthisnotificationunlessyouoverridetheCDialog::OnInitDialog()//functionandcallCRichEditCtrl().SetEventMask()//withtheENM_CHANGEflagORedintothemask.//TODO: Addyourcontrolnotificationhandlercodehere}voidCmysqlitesDlg::OnBnClickedButton4(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CStringnndh,khid,npmc,npdj,npsl;GetDlgItem(IDC_EDIT2)->GetWindowText(nndh);GetDlgItem(IDC_EDIT3)->GetWindowText(khid);GetDlgItem(IDC_EDIT4)->GetWindowText(npmc);GetDlgItem(IDC_EDIT5)->GetWindowText(npdj);GetDlgItem(IDC_EDIT6)->GetWindowText(npsl);CStringstrTemp;strTemp.Format(_T("insertintoPSRBvalues('%s','%s','%s','%s','%s')"),nndh,khid,npmc,npdj,npsl);CppSQLite3Queryq=db.execQuery(strTemp);MessageBox(L"添加成功");db.close();}voidCmysqlitesDlg::OnEnChangeEdit3(){//TODO: IfthisisaRICHEDITcontrol,thecontrolwillnot//sendthisnotificationunlessyouoverridetheCDialog::OnInitDialog()//functionandcallCRichEditCtrl().SetEventMask()//withtheENM_CHANGEflagORedintothemask.//TODO: Addyourcontrolnotificationhandlercodehere}voidCmysqlitesDlg::OnEnChangeEdit4(){//TODO: IfthisisaRICHEDITcontrol,thecontrolwillnot//sendthisnotificationunlessyouoverridetheCDialog::OnInitDialog()//functionandcallCRichEditCtrl().SetEventMask()//withtheENM_CHANGEflagORedintothemask.//TODO: Addyourcontrolnotificationhandlercodehere}voidCmysqlitesDlg::OnBnClickedButton5(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CStringnndh;GetDlgItem(IDC_EDIT2)->GetWindowText(nndh);CStringstrTemp;strTemp.Format(_T("deletefromPSRBwherenndh=%s"),nndh);CppSQLite3Queryq=db.execQuery(strTemp);MessageBox(L"刪除成功");db.close();}voidCmysqlitesDlg::OnBnClickedButton7(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CStringnndh,khid,npmc,npdj,npsl;GetDlgItem(IDC_EDIT2)->GetWindowText(nndh);GetDlgItem(IDC_EDIT3)->GetWindowText(khid);GetDlgItem(IDC_EDIT4)->GetWindowText(npmc);GetDlgItem(IDC_EDIT5)->GetWindowText(npdj);GetDlgItem(IDC_EDIT6)->GetWindowText(npsl);CStringstrTemp;strTemp.Format(_T("UPDATEPSRBSETkhid='%s'WHEREnndh=%s"),khid,nndh);CppSQLite3Queryq=db.execQuery(strTemp);strTemp.Format(_T("UPDATEPSRBSETnpmc='%s'WHEREnndh=%s"),npmc,nndh);q=db.execQuery(strTemp);MessageBox(L"修改成功");db.close();}}1、創(chuàng)建牛奶配送代碼voidCmysqlitesDlg::OnBnClickedButton1(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");//打開或新建數(shù)據(jù)庫(kù)，文件名為test.dbMessageBox(_T("SUCCESS"),_T("INFORMATION"),MB_OK);//創(chuàng)建成功顯示db.close();//關(guān)閉}2、建立牛奶配送voidCmysqlitesDlg::OnBnClickedButton2(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");//打開數(shù)據(jù)庫(kù)//新建表CppSQLite3Queryq=db.execQuery(L"createtablePSRB(nndhvarchar(8),khidvarchar(8),npmcvarchar(8),npdjvarchar(8),npslvarchar(8))");//使用execQuery方法執(zhí)行SQL語(yǔ)句創(chuàng)建表。//插入數(shù)據(jù)\q=db.execQuery(L"insertintoPSRBvalues('01','0321','完達(dá)ft','20','3')");//執(zhí)行SQL語(yǔ)句插入一條數(shù)據(jù)MessageBox(_T("SUCCESS"),_T("INFORMATION"),MB_OK);//成功則顯示SUCCESSdb.close();//關(guān)閉}}3、查詢客戶voidCmysqlitesDlg::OnBnClickedButton3(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CppSQLite3Queryq=db.execQuery(L"select*fromPSRB");//查詢CStringstrTemp;while(!q.eof())//返回值按行循環(huán){strTemp.Format(_T("%s%s%s%s%s"),q.fieldValue(0),q.fieldValue(1),q.fieldValue(2),q.fieldValue(3),q.fieldValue(4));//返回的每一行的數(shù)據(jù)中，依次保存在q.fieldValue(0),q.fieldValue(1),q.fieldValue(2s空格%s空格的形式賦給strTemp。m_edit+=strTemp;//將strTemp賦給EDIT框成員變量m_edit。m_edit+="\r\n";UpdateData(FALSE);//更新，使EDIT顯示數(shù)據(jù)q.nextRow();//下一行，循環(huán)}q.finalize();//SQL返回結(jié)束db.close();//關(guān)閉}4、建立客戶voidCmysqlitesDlg::OnBnClickedButton4(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CStringnndh,khid,npmc,npdj,npsl;GetDlgItem(IDC_EDIT2)->GetWindowText(nndh);GetDlgItem(IDC_EDIT3)->GetWindowText(khid);GetDlgItem(IDC_EDIT4)->GetWindowText(npmc);GetDlgItem(IDC_EDIT5)->GetWindowText(npdj);GetDlgItem(IDC_EDIT6)->GetWindowText(npsl);CStringstrTemp;strTemp.Format(_T("insertintoPSRBvalues('%s','%s','%s','%s','%s')"),nndh,khid,npmc,npdj,npsl);CppSQLite3Queryq=db.execQuery(strTemp);MessageBox(L"添加成功");db.close();}6、刪除客戶voidCmysqlitesDlg::OnBnClickedButton5(){CppSQLite3DBdb;db.open(L"\\MyDocuments\\test.db");CStringnndh;GetDlgItem(IDC_EDIT2)->GetWindowText(nndh);CStringstrTemp;strTemp.Format(_T("deletefromPSRBwherenndh=%s"),nndh);CppSQLite3Queryq=db.execQuery(strTemp);MessageBox(L"刪除成功");db.close();