要做的还有很多

这两天因为要做这个简易的图书管理系统，搞得眼睛很痛。现在应该说有一个雏形了吧，接下去就是做终端了。这需要涉及到套接字的知识，这就要用到WSASendto和WSARecvfrom这两个函数了。WSABUF问题前两天解决了，这下可以做下一步工作了。下面贴出部分代码。

void CBookMangageSystemDlg::OnBtnAddbook() { // TODO: Add your control notification handler code here UpdateData(); if(m_Bkid.IsEmpty() | m_Bkname.IsEmpty()) { MessageBox("图书ID号与图书名均不允许为空"); return; } LVFINDINFO info; int nIndex; info.flags = LVFI_PARTIAL|LVFI_STRING; info.psz = m_Bkid; nIndex = m_nListCtrl.FindItem(&info); if(nIndex != -1) { MessageBox("这个图书ID号已经存在,不允许重复添加，请认真确认!"); return; } m_pRecordset->AddNew(); m_pRecordset->PutCollect("bookid",_variant_t(m_Bkid.GetBuffer(m_Bkid.GetLength()))); m_pRecordset->PutCollect("bookname",_variant_t(m_Bkname.GetBuffer(m_Bkname.GetLength()))); m_pRecordset->PutCollect("booknum",_variant_t((long)m_Bknum)); UpdateData(FALSE); MessageBox("添加成功！"); SetDlgItemText(IDC_EDIT_BKID,""); SetDlgItemText(IDC_EDIT_BKNAME,""); SetDlgItemText(IDC_EDIT_BKNUM,""); _variant_t vbookid,vbookname,vbooknum; while(!m_pRecordset->adoEOF) { vbookid = m_pRecordset->GetCollect("bookid"); vbookname = m_pRecordset->GetCollect("bookname"); vbooknum = m_pRecordset->GetCollect("booknum"); if(vbookid.vt != VT_NULL && vbookname.vt != VT_NULL && vbooknum.vt != VT_NULL) { int nRow = m_nListCtrl.InsertItem(0,(LPCTSTR)(_bstr_t)vbookid); m_nListCtrl.SetItemText(nRow,1,(LPCTSTR)(_bstr_t)vbookname); m_nListCtrl.SetItemText(nRow,2,(LPCTSTR)(_bstr_t)vbooknum); } m_pRecordset ->MoveNext(); } }

这是添加图书的代码。

void CBookMangageSystemDlg::OnBtnBrowse() { // TODO: Add your control notification handler code here while(m_nListCtrl.DeleteColumn(0)); m_nListCtrl.DeleteAllItems(); m_nListCtrl.InsertColumn(0,"图书ID",LVCFMT_LEFT,100); m_nListCtrl.InsertColumn(1,"图书名",LVCFMT_LEFT,200); m_nListCtrl.InsertColumn(2,"在馆图书数量",LVCFMT_LEFT,100); if(m_pRecordset->State) m_pRecordset->Close(); m_pRecordset.CreateInstance("ADODB.Recordset"); m_pRecordset->Open("select * from bookinfo", _variant_t((IDispatch *)m_pConnection,true), adOpenStatic,adLockOptimistic,adCmdText); // m_nListCtrl.DeleteAllItems(); m_pRecordset->MoveFirst(); _variant_t vbookid,vbookname,vbooknum; while(!m_pRecordset->adoEOF) { vbookid = m_pRecordset->GetCollect("bookid"); vbookname = m_pRecordset->GetCollect("bookname"); vbooknum = m_pRecordset->GetCollect("booknum"); if(vbookid.vt != VT_NULL && vbookname.vt != VT_NULL && vbooknum.vt != VT_NULL) { int nRow = m_nListCtrl.InsertItem(0,(LPCTSTR)(_bstr_t)vbookid); m_nListCtrl.SetItemText(nRow,1,(LPCTSTR)(_bstr_t)vbookname); m_nListCtrl.SetItemText(nRow,2,(LPCTSTR)(_bstr_t)vbooknum); } m_pRecordset ->MoveNext(); } }

这是查看图书情况的代码

void CBookMangageSystemDlg::OnBtnFind() { // TODO: Add your control notification handler code here UpdateData(); if(m_Bkid.IsEmpty()) { MessageBox("图书ID号不允许为空"); return; } LVFINDINFO info; int nIndex = -1; info.flags = LVFI_PARTIAL|LVFI_STRING; info.psz = m_Bkid; nIndex = m_nListCtrl.FindItem(&info); if(nIndex != -1) { m_nListCtrl.SetFocus(); m_nListCtrl.SetItemState(nIndex,LVIS_SELECTED, LVIS_SELECTED); m_nListCtrl.EnsureVisible(nIndex,FALSE); return; }else { MessageBox("这个图书ID号不存在,请认真确认!"); return; } UpdateData(FALSE); } void CBookMangageSystemDlg::OnBtnFindn() { // TODO: Add your control notification handler code here UpdateData(); if(m_Bkname.IsEmpty()) { MessageBox("图书名不允许为空"); return; } int num = m_nListCtrl.GetItemCount(); for(int i = 0 ; i < num ; i++) { CString str = m_nListCtrl.GetItemText(i,1); CString nstr = str.Left(m_Bkname.GetLength()); if(nstr.Compare(m_Bkname) == 0) { m_nListCtrl.SetFocus(); m_nListCtrl.SetItemState(i, LVIS_SELECTED, LVIS_SELECTED); m_nListCtrl.EnsureVisible(i,FALSE); return; } } MessageBox("不含该图书"); UpdateData(FALSE); }

以上两个是分别使用ListCtrl控件头两列数据进行查找的代码。

void CBookMangageSystemDlg::OnBtnBorrow() { // TODO: Add your control notification handler code here if(m_pRecordset->State) m_pRecordset->Close(); CString str; m_pRecordset.CreateInstance("ADODB.Recordset"); UpdateData(); if(m_userid.IsEmpty() | m_username.IsEmpty() | m_Bkid.IsEmpty()) { MessageBox("用户ID或用户名不允许为空!"); return; } str += "select * from bkreader where readerid = "; str += "'"; str += m_userid; str += "'"; str += "and readername = "; str += "'"; str += m_username; str += "'"; CString sstr = "select * from bwinfo where bookid = "; sstr += "'"; sstr += m_Bkid; sstr += "'"; sstr += "and readerid = "; sstr += "'"; sstr += m_userid; sstr += "'"; m_pRecordset->Open((_variant_t)sstr, _variant_t((IDispatch *)m_pConnection,true), adOpenStatic,adLockOptimistic,adCmdText); int nnum = m_pRecordset->GetRecordCount(); if(nnum != 0) { MessageBox("您不能重复借着本书!"); return; } m_pRecordset->Close(); CString ssstr = "select * from bookinfo where bookid = "; ssstr += "'"; ssstr += m_Bkid; ssstr += "'"; m_pRecordset.CreateInstance("ADODB.Recordset"); m_pRecordset->Open((_variant_t)ssstr, _variant_t((IDispatch *)m_pConnection,true), adOpenStatic,adLockOptimistic,adCmdText); int num = m_pRecordset->GetRecordCount(); if(num == 0) { MessageBox("没有这本书,请重新确认!"); return; } m_pRecordset->Close(); m_pRecordset.CreateInstance("ADODB.Recordset"); m_pRecordset->Open((_variant_t)str, _variant_t((IDispatch *)m_pConnection,true), adOpenStatic,adLockOptimistic,adCmdText); num = m_pRecordset->GetRecordCount(); if(num == 0) { MessageBox("用户名与用户ID验证不符！请重新输入！"); return; } _variant_t RecordsAffected; CString ustr = "update bkreader set borrownum = borrownum +1 where readerid = "; ustr += "'"; ustr += m_userid; ustr += "'"; m_pConnection->Execute((_bstr_t)ustr,&RecordsAffected,adCmdText); CString istr = "insert into bwinfo values("; istr += "'"; istr += m_Bkid; istr += "'"; istr += ","; istr += "'"; istr += m_userid; istr += "')"; m_pConnection->Execute((_bstr_t)istr,&RecordsAffected,adCmdText); CString gstr = "update bookinfo set booknum = booknum - 1 where bookid = "; gstr += "'"; gstr += m_Bkid; gstr += "'"; m_pConnection->Execute((_bstr_t)gstr,&RecordsAffected,adCmdText); MessageBox("借阅手续办理完毕!"); }

这是借书的代码，这个最长，其实也正常，要对好几张数据库的表进行操作。