VC + + Package ADO class and how to use

Operating system: Windows 7
Software Environment: Visual Studio 2008, Microsoft SQL 2005
Objective: To introduce an already encapsulated ADO class that simply explains how to import and use

First of all, this package of ADO class is downloaded in the "VC Knowledge Base", because recently in the database course design, so the VC under the use of ADO connection database is not very understanding, so if this article has the wrong place, please do not hesitate to point out. Specific ADO class Each package function, please go to "original address" view. Only a primer on using this ADO wrapper class is described here, such as connecting to a database, displaying records, and so on. A test example is as follows:

Steps to use:
1. First download the encapsulated ADO class from "Here", you can use Notepad and so on to open the inside of the file, for each function has commented pretty detailed;
2. Prepare the database, can be SQL 2000 or higher, here I am using SQL 2005, create a new vc_sqlexample database A student table, the format is as follows:

3. Specific table content can be casually written, and then create a new MFC based on the dialog box project (named Test 1), right-click the project name, add the encapsulated ADO class into the project;
4. Initialize the COM environment and add the following code:

[CPP]View PlainCopy

2. /* Test 1.h */
4. Class C Test 1App: public CWinApp
6. {
8. Public :
10. virtual int exitinstance ();
12. }
14. /* Test 1.cpp */
16. BOOL C Test 1app::initinstance ()
18. {
20. CoInitialize (NULL);
22. }
24. int c Test App::exitinstance ()
26. {
28. CoUninitialize ();
30. return CWinApp::ExitInstance ();
32. }

5. Add "Ado.h" in the dialog (Project based dialog) header file to add the object to the class declaration. and the OnInitDialog function inside the implementation file connects to the database.

[CPP]View PlainCopy

2. #include "ado.h"
4. Class C Test 1DLG: public CDialog
6. {
8. Protected
10. Cadoconnection m_adoconnection;
12. Cadorecordset M_adorecordset;
14. }
16. /* Test 1Dlg.cpp: Implement file */
18. BOOL C Test 1dlg::oninitdialog ()
20. {
22. if (M_adoconnection.connectsqlserver ("127.0.0.1","Vc_sqlexample","sa","wjs1314"))
24. {
26. M_adorecordset.setadoconnection (&m_adoconnection);
28. M_adorecordset.setcursorlocation ();
30. M_adorecordset.open ("student", adCmdTable);
32. M_adoconnection.begintrans ();
34. UpdateRecord (TRUE);
36. }
38. Else
40. {
42. MessageBox ("Database connection failed!");
44. }
46. }

6. Add a variable to the control (right-click the control to add a variable), a function to display the data, and a button function for the previous record and the next record

[CPP]View PlainCopy

2. Class C Test 1DLG: public CDialog
4. {
6. Public
8. COleDateTime M_strbirth;
10. CString M_strbrief;
12. CString M_strstuid;
14. CString M_strname;
16. CString M_strsex;
20. bool UpdateRecord (bool bload = TRUE);
22. }
24. BOOL C Test 1dlg::updaterecord (bool bload)
26. {
28. if (M_adorecordset.getrecordcount () < 1) return FALSE;
30. if (bload)
32. {
34. if (!m_adorecordset.getcollect ("Stuid", M_strstuid)
36. || !m_adorecordset.getcollect ("Stuname", M_strname)
38. || !m_adorecordset.getcollect ("Stusex", M_strsex)
40. || !m_adorecordset.getcollect ("Birth", M_strbirth)
42. || !m_adorecordset.getcollect ("brief", M_strbrief))
44. {}
46. UpdateData (FALSE);
48. return TRUE;
50. }
52. }
54. void C Test 1dlg::onbnclickedbutton1 ()
56. {
58. //TODO: Add control notification handler code here
60. UpdateData ();
62. if (m_adorecordset.moveprevious ())
64. UpdateRecord ();
66. }
68. void C Test 1dlg::onbnclickedbutton2 ()
70. {
72. //TODO: Add control notification handler code here
74. UpdateData ();
76. if (M_adorecordset.movenext ())
78. UpdateRecord ();
80. }

7. Start the database and run the compilation program.

http://blog.csdn.net/akof1314/article/details/4657780

VC + + Package ADO class and how to use