要做的还有很多

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

void CBookMangageSystemDlg::OnBtnAddbook() {// TODO: Add your control notification handler code hereUpdateData();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 herewhile(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 hereUpdateData();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 hereUpdateData();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 hereif(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("借阅手续办理完毕!");}

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