Vc++2005+sql2000数据库编程第六篇(一个小程序搞定).doc

Vc+2005+sql2000数据库编程第六篇增加删除功能1.使用的方法与 添加记录 按钮的功能原理差不多。2.都是使用sql语句。我觉得没必要使用教科书中将的那么复杂的各种控件的方法，读都读不明白。我还是按我的原则，能达到目的就可以了额。3.虽然代码多了点，好理解才是王道，自己的才是王道。各种控件的方法，各种函数，等以后写多了，觉得麻烦了，就可以学习了，哈哈4.对了，有一点没说的是，我还限制了字符的输入代码为if(ch_sno.GetLength()0&ch_sname.GetLength()0&ch_ssex.GetLength()0&ch_sage.GetLength()0&ch_scollege.GetLength()0&ch_sno.GetLength()11&ch_sname.GetLength()11&ch_ssex.GetLength()11&ch_sage.GetLength()11&ch_scollege.GetLength()ConnectionString=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=student;Data Source=DJ-E2F554D95B00;pConn-Open(,-1);pRst=pConn-Execute(select * from student,NULL,adCmdText);UpdateData();CString ch_sno,ch_sname,ch_ssex,ch_sage,ch_scollege;/得到cedit中的数据GetDlgItem(IDC_EDIT1)- GetWindowText(ch_sno); GetDlgItem(IDC_EDIT2)- GetWindowText(ch_sname);GetDlgItem(IDC_EDIT3)- GetWindowText(ch_ssex); GetDlgItem(IDC_EDIT4)- GetWindowText(ch_sage);GetDlgItem(IDC_EDIT5)- GetWindowText(ch_scollege); /除去字符串两边的空格ch_sno.Trim();ch_sname.Trim();ch_ssex.Trim();ch_sage.Trim();ch_scollege.Trim();/*m_sno.SendMessage(WM_GETTEXT,10,(LPARAM)ch_sno); /m_nCurrentSel当前记录号m_sname.SendMessage(WM_GETTEXT,10,(LPARAM)ch_sname); /因为m_sno等是控件变量，所以使用方法sendmessagem_ssex.SendMessage(WM_GETTEXT,10,(LPARAM)ch_ssex); m_sage.SendMessage(WM_GETTEXT,10,(LPARAM)ch_sage); m_scollege.SendMessage(WM_GETTEXT,10,(LPARAM)ch_scollege); */if(ch_sno.GetLength()0&ch_sname.GetLength()0&ch_ssex.GetLength()0&ch_sage.GetLength()0&ch_scollege.GetLength()0&ch_sno.GetLength()11&ch_sname.GetLength()11&ch_ssex.GetLength()11&ch_sage.GetLength()11&ch_scollege.GetLength()AddNew();/m_nCurrentSel=m_List.InsertItem(0xffff,_T();/SaveData();/m_List.SetItemState(m_nCurrentSel,LVIS_SELECTED|LVIS_FOCUSED,LVIS_SELECTED|LVIS_FOCUSED);/m_List.SetHotItem(m_nCurrentSel);/m_List.SetFocus(); int sno_flag=0;CString data_sno,data_sname,data_ssex,data_sage,data_scollege;while(!pRst-rsEOF)/(CListBox*)GetDlgItem(IDC_LIST1)-AddString(_bstr_t)pRst-GetCollect(standvalue);/CListBox列表框的用法data_sno=(LPCTSTR)(_bstr_t)(pRst-GetCollect(sno);data_sname=(LPCTSTR)(_bstr_t)(pRst-GetCollect(sname);data_ssex=(LPCTSTR)(_bstr_t)(pRst-GetCollect(ssex);data_sage=(LPCTSTR)(_bstr_t)(pRst-GetCollect(sage);data_scollege=(LPCTSTR)(_bstr_t)(pRst-GetCollect(scollege);/除去字符串两边的空格data_sno.Trim();/去出字符串data_sname.Trim();/去出字符串data_ssex.Trim();/去出字符串data_sage.Trim();/去出字符串data_scollege.Trim();/去出字符串if(ch_sno=data_sno&ch_sname=data_sname&ch_ssex=data_ssex&ch_sage=data_sage&ch_scollege=data_scollege)sno_flag=1; / 比较ch_sno和数据库的sno值。看是否重值pRst-MoveNext();if(sno_flag)CString strSQL;strSQL.Format(_T(DELETE FROM student WHERE sno=%s),ch_sno); /,ch_sno,ch_sname,ch_ssex,ch_sage,ch_scollegepConn-Execute(_bstr_t)strSQL,NULL,adCmdText);else AfxMessageBox(_T(数据库中不存在要删除的);elseAfxMessageBox(_T(数据库中不存在要删除的);pRst-Close();pConn-Close(); /连接数据库先不