开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
StudentDlg.cpp
资源名称：school.rar　[点击查看]
上传用户：rs600066
上传日期：2017-10-16
资源大小：4788k
文件大小：17k
源码类别：

数据库系统

开发平台：

Visual C++

StudentDlg.cpp：源码内容
  1. // StudentDlg.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "school.h"
  6. #include "StudentDlg.h"
  7. #include "departmentset.h"
  8. #include "majorset.h"
  9. #include "classset.h"
  10. #include "studentInfodlg.h"
  12. #ifdef _DEBUG
  13. #define new DEBUG_NEW
  14. #undef THIS_FILE
  15. static char THIS_FILE[] = __FILE__;
  16. #endif
  18. /////////////////////////////////////////////////////////////////////////////
  19. // CStudentDlg dialog
  22. CStudentDlg::CStudentDlg(CWnd* pParent /*=NULL*/)
  23. : CDialog(CStudentDlg::IDD, pParent)
  24. {
  25. //{{AFX_DATA_INIT(CStudentDlg)
  26. m_strClass = _T("");
  27. m_strDepartment = _T("");
  28. m_strMajor = _T("");
  29. //}}AFX_DATA_INIT
  30. }
  33. void CStudentDlg::DoDataExchange(CDataExchange* pDX)
  34. {
  35. CDialog::DoDataExchange(pDX);
  36. //{{AFX_DATA_MAP(CStudentDlg)
  37. DDX_Control(pDX, IDC_LIST1, m_ctrList);
  38. DDX_Control(pDX, IDC_COMBO_MAJOR, m_ctrMajor);
  39. DDX_Control(pDX, IDC_COMBO_DEPARTMENT, m_ctrDepartment);
  40. DDX_Control(pDX, IDC_COMBO_CLASS, m_ctrClass);
  41. DDX_CBString(pDX, IDC_COMBO_CLASS, m_strClass);
  42. DDX_CBString(pDX, IDC_COMBO_DEPARTMENT, m_strDepartment);
  43. DDX_CBString(pDX, IDC_COMBO_MAJOR, m_strMajor);
  44. //}}AFX_DATA_MAP
  45. }
  48. BEGIN_MESSAGE_MAP(CStudentDlg, CDialog)
  49. //{{AFX_MSG_MAP(CStudentDlg)
  50. ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
  51. ON_BN_CLICKED(IDC_BUTTON_NEW, OnButtonNew)
  52. ON_BN_CLICKED(IDC_BUTTON_MODIFY, OnButtonModify)
  53. ON_BN_CLICKED(IDC_BUTTON_DELETE, OnButtonDelete)
  54. ON_BN_CLICKED(IDC_BUTTON_BROWSE, OnButtonBrowse)
  55. ON_CBN_SETFOCUS(IDC_COMBO_MAJOR, OnSetfocusComboMajor)
  56. ON_CBN_SETFOCUS(IDC_COMBO_CLASS, OnSetfocusComboClass)
  57. ON_CBN_SELCHANGE(IDC_COMBO_DEPARTMENT, OnSelchangeComboDepartment)
  58. ON_CBN_SELCHANGE(IDC_COMBO_MAJOR, OnSelchangeComboMajor)
  59. ON_BN_CLICKED(IDC_BUTTON_SEARCH, OnButtonSearch)
  60. //}}AFX_MSG_MAP
  61. END_MESSAGE_MAP()
  63. /////////////////////////////////////////////////////////////////////////////
  64. // CStudentDlg message handlers
  66. BOOL CStudentDlg::OnInitDialog() 
  67. {
  68. CDialog::OnInitDialog();
  70. CDepartmentSet DeptSet ;
  71. CString strSQL;
  72. strSQL="select * from department";
  73. if(!DeptSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  74. {
  75. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  77. }
  78. while(!DeptSet.IsEOF())
  79. {
  80. m_ctrDepartment.AddString(DeptSet.m_name);
  81. DeptSet.MoveNext();
  82. }
  83. DeptSet.Close();
  85. m_ctrList.InsertColumn(0,"学号");
  86. m_ctrList.InsertColumn(1,"姓名");
  87. m_ctrList.InsertColumn(2,"曾用名");
  88. m_ctrList.InsertColumn(3,"性别");
  89. m_ctrList.InsertColumn(4,"出生年月");
  90. m_ctrList.InsertColumn(5,"民族");
  91. m_ctrList.InsertColumn(6,"政治面貌");
  92. m_ctrList.InsertColumn(7,"籍贯");
  93. m_ctrList.InsertColumn(8,"家庭出身");
  94. m_ctrList.InsertColumn(9,"联系电话");
  95. m_ctrList.InsertColumn(10,"邮政编码");
  96. m_ctrList.InsertColumn(11,"家庭地址");
  97. m_ctrList.InsertColumn(12,"身份证号");
  98. m_ctrList.InsertColumn(13,"入学时间");
  99. m_ctrList.InsertColumn(14,"毕业时间");
  100. m_ctrList.InsertColumn(15,"班级");
  101. m_ctrList.InsertColumn(16,"所在院系");
  102. m_ctrList.InsertColumn(17,"专业");
  105. m_ctrList.SetColumnWidth(0,60);
  106. m_ctrList.SetColumnWidth(1,80);
  107. m_ctrList.SetColumnWidth(2,80);
  108. m_ctrList.SetColumnWidth(3,60);
  109. m_ctrList.SetColumnWidth(4,60);
  110. m_ctrList.SetColumnWidth(5,60);
  111. m_ctrList.SetColumnWidth(6,100);
  112. m_ctrList.SetColumnWidth(7,60);
  113. m_ctrList.SetColumnWidth(8,100);
  114. m_ctrList.SetColumnWidth(9,100);
  115. m_ctrList.SetColumnWidth(10,100);
  116. m_ctrList.SetColumnWidth(11,100);
  117. m_ctrList.SetColumnWidth(12,100);
  118. m_ctrList.SetColumnWidth(13,100);
  119. m_ctrList.SetColumnWidth(14,100);
  120. m_ctrList.SetColumnWidth(15,100);
  121. m_ctrList.SetColumnWidth(16,100);
  122. m_ctrList.SetColumnWidth(17,100);
  124. m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
  127. return TRUE;  // return TRUE unless you set the focus to a control
  128.               // EXCEPTION: OCX Property Pages should return FALSE
  129. }
  131. void CStudentDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
  132. {
  133. // TODO: Add your control notification handler code here
  135. *pResult = 0;
  136. }
  138. void CStudentDlg::OnButtonNew() 
  139. {
  140. // TODO: Add your control notification handler code here
  141. CStudentInfoDlg Dlg;
  142. if(IDOK==Dlg.DoModal())
  143. {//添加新记录
  144. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE))
  145. {
  146. AfxMessageBox("打开数据库失败!");
  147. return ;
  148. }
  149. m_recordset.AddNew();
  150. m_recordset.m_class =Dlg.m_strClass ;
  151. m_recordset.m_department =Dlg.m_strDept ;
  152. m_recordset.m_sex =Dlg.m_strSex ;
  153. m_recordset.m_major =Dlg.m_strMajor ;
  154. m_recordset.m_birthday =Dlg.m_tmBirth ;
  155. m_recordset.m_enroll_date =Dlg.m_tmEnroll ;
  156. m_recordset.m_graduate_date =Dlg.m_tmGraduate ;
  157. m_recordset.m_address =Dlg.m_strAddress ;
  158. m_recordset.m_family_dept1 =Dlg.m_strDept1 ;
  159. m_recordset.m_family_dept2 =Dlg.m_strDept2 ;
  160. m_recordset.m_family_dept3 =Dlg.m_strDept3 ;
  161. m_recordset.m_family_duty1 =Dlg.m_strDuty1 ;
  162. m_recordset.m_family_duty2 =Dlg.m_strDuty2 ;
  163. m_recordset.m_family_dept3 =Dlg.m_strDuty3 ;
  164. m_recordset.m_edu_sys =Dlg.m_strEdusys ;
  165. m_recordset.m_family =Dlg.m_strFamily ;
  166. m_recordset.m_folk =Dlg.m_strFolk ;
  167. m_recordset.m_IDCard =Dlg.m_strIDCard ;
  168. m_recordset.m_family_name1 =Dlg.m_strName1 ;
  169. m_recordset.m_family_name2 =Dlg.m_strName2 ;
  170. m_recordset.m_family_name3 =Dlg.m_strName3 ;
  171. m_recordset.m_native =Dlg.m_strNative ;
  172. m_recordset.m_oldname =Dlg.m_strOldName ;
  173. m_recordset.m_phone =Dlg.m_strPhone ;
  174. m_recordset.m_honor_digiest1 =Dlg.m_strDegist1 ;
  175. m_recordset.m_honor_digiest2 =Dlg.m_strDegist2 ;
  176. m_recordset.m_honor_digiest3 =Dlg.m_strDegist3 ;
  177. m_recordset.m_honor_digiest4 =Dlg.m_strDegist4 ;
  178. m_recordset.m_honor_digiest5 =Dlg.m_strDegist5 ;
  179. m_recordset.m_honor_digiest6 =Dlg.m_strDegist6 ;
  180. m_recordset.m_honor_date1 =Dlg.m_strHonorDate1 ;
  181. m_recordset.m_honor_date2 =Dlg.m_strHonorDate2 ;
  182. m_recordset.m_honor_date3 =Dlg.m_strHonorDate3 ;
  183. m_recordset.m_honor_date4 =Dlg.m_strHonorDate4 ;
  184. m_recordset.m_honor_date5 =Dlg.m_strHonorDate5 ;
  185. m_recordset.m_honor_date6 =Dlg.m_strHonorDate6 ;
  186. m_recordset.m_family_phone1 =Dlg.m_strPhone1 ;
  187. m_recordset.m_family_phone2 =Dlg.m_strPhone2 ;
  188. m_recordset.m_family_phone3 =Dlg.m_strPhone3 ;
  189. m_recordset.m_political =Dlg.m_strPolitical ;
  190. m_recordset.m_family_political1 =Dlg.m_strPolitical1 ;
  191. m_recordset.m_family_political2 =Dlg.m_strPolitical3 ;
  192. m_recordset.m_family_political3 =Dlg.m_strPolitical2 ;
  193. m_recordset.m_postcode =Dlg.m_strPostCode ;
  194. m_recordset.m_family_relation1 =Dlg.m_strRelation1 ;
  195. m_recordset.m_family_relation2 =Dlg.m_strRelation2 ;
  196. m_recordset.m_family_relation3 =Dlg.m_strRelation3 ;
  197. m_recordset.m_honor_remark1 =Dlg.m_strRemark1 ;
  198. m_recordset.m_honor_remark2 =Dlg.m_strRemark2 ;
  199. m_recordset.m_honor_remark3 =Dlg.m_strRemark3 ;
  200. m_recordset.m_honor_remark4 =Dlg.m_strRemark4 ;
  201. m_recordset.m_honor_remark5 =Dlg.m_strRemark5 ;
  202. m_recordset.m_honor_remark6 =Dlg.m_strRemark6 ;
  203. m_recordset.m_term1 =Dlg.m_strScore1 ;
  204. m_recordset.m_term10 =Dlg.m_strScore10 ;
  205. m_recordset.m_term2 =Dlg.m_strScore2 ;
  206. m_recordset.m_term3 =Dlg.m_strScore3 ;
  207. m_recordset.m_term4 =Dlg.m_strScore4 ;
  208. m_recordset.m_term5 =Dlg.m_strScore5 ;
  209. m_recordset.m_term6 =Dlg.m_strScore6 ;
  210. m_recordset.m_term7 =Dlg.m_strScore7 ;
  211. m_recordset.m_term8 =Dlg.m_strScore8 ;
  212. m_recordset.m_term9 =Dlg.m_strScore9 ;
  213. m_recordset.m_code =Dlg.m_strCode ;
  214. m_recordset.m_name =Dlg.m_strName ;
  216. m_recordset.Update();
  217. m_recordset.Close();
  218. CString strSQL = "select * from student ";
  219. RefreshData(strSQL);
  220. }
  221. }
  223. void CStudentDlg::OnButtonModify() 
  224. {
  225. // TODO: Add your control notification handler code here
  226. CStudentInfoDlg Dlg;
  227. UpdateData();
  228. int i = m_ctrList.GetSelectionMark();
  229. if(0>i)
  230. {
  231. AfxMessageBox("请选择一条记录进行修改！");
  232. return;
  233. }
  234. Dlg.m_strCode=m_ctrList.GetItemText(i,0);
  235. if(IDOK==Dlg.DoModal())
  236. {//修改记录
  237. CString strSQL;
  238. strSQL.Format("select * from student where code = '%s'",Dlg.m_strCode);
  239. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  240. {
  241. AfxMessageBox("打开数据库失败!");
  242. return ;
  243. }
  244. m_recordset.Edit();
  245. m_recordset.m_class =Dlg.m_strClass ;
  246. m_recordset.m_department =Dlg.m_strDept ;
  247. m_recordset.m_sex =Dlg.m_strSex ;
  248. m_recordset.m_major =Dlg.m_strMajor ;
  249. m_recordset.m_birthday =Dlg.m_tmBirth ;
  250. m_recordset.m_enroll_date =Dlg.m_tmEnroll ;
  251. m_recordset.m_graduate_date =Dlg.m_tmGraduate ;
  252. m_recordset.m_address =Dlg.m_strAddress ;
  253. m_recordset.m_family_dept1 =Dlg.m_strDept1 ;
  254. m_recordset.m_family_dept2 =Dlg.m_strDept2 ;
  255. m_recordset.m_family_dept3 =Dlg.m_strDept3 ;
  256. m_recordset.m_family_duty1 =Dlg.m_strDuty1 ;
  257. m_recordset.m_family_duty2 =Dlg.m_strDuty2 ;
  258. m_recordset.m_family_dept3 =Dlg.m_strDuty3 ;
  259. m_recordset.m_edu_sys =Dlg.m_strEdusys ;
  260. m_recordset.m_family =Dlg.m_strFamily ;
  261. m_recordset.m_folk =Dlg.m_strFolk ;
  262. m_recordset.m_IDCard =Dlg.m_strIDCard ;
  263. m_recordset.m_family_name1 =Dlg.m_strName1 ;
  264. m_recordset.m_family_name2 =Dlg.m_strName2 ;
  265. m_recordset.m_family_name3 =Dlg.m_strName3 ;
  266. m_recordset.m_native =Dlg.m_strNative ;
  267. m_recordset.m_oldname =Dlg.m_strOldName ;
  268. m_recordset.m_phone =Dlg.m_strPhone ;
  269. m_recordset.m_honor_digiest1 =Dlg.m_strDegist1 ;
  270. m_recordset.m_honor_digiest2 =Dlg.m_strDegist2 ;
  271. m_recordset.m_honor_digiest3 =Dlg.m_strDegist3 ;
  272. m_recordset.m_honor_digiest4 =Dlg.m_strDegist4 ;
  273. m_recordset.m_honor_digiest5 =Dlg.m_strDegist5 ;
  274. m_recordset.m_honor_digiest6 =Dlg.m_strDegist6 ;
  275. m_recordset.m_honor_date1 =Dlg.m_strHonorDate1 ;
  276. m_recordset.m_honor_date2 =Dlg.m_strHonorDate2 ;
  277. m_recordset.m_honor_date3 =Dlg.m_strHonorDate3 ;
  278. m_recordset.m_honor_date4 =Dlg.m_strHonorDate4 ;
  279. m_recordset.m_honor_date5 =Dlg.m_strHonorDate5 ;
  280. m_recordset.m_honor_date6 =Dlg.m_strHonorDate6 ;
  281. m_recordset.m_family_phone1 =Dlg.m_strPhone1  ;
  282. m_recordset.m_family_phone2 =Dlg.m_strPhone2  ;
  283. m_recordset.m_family_phone3 =Dlg.m_strPhone3  ;
  284. m_recordset.m_political =Dlg.m_strPolitical  ;
  285. m_recordset.m_family_political1 =Dlg.m_strPolitical1 ;
  286. m_recordset.m_family_political2 =Dlg.m_strPolitical3 ;
  287. m_recordset.m_family_political3 =Dlg.m_strPolitical2 ;
  288. m_recordset.m_postcode =Dlg.m_strPostCode  ;
  289. m_recordset.m_family_relation1 =Dlg.m_strRelation1  ;
  290. m_recordset.m_family_relation2 =Dlg.m_strRelation2  ;
  291. m_recordset.m_family_relation3 =Dlg.m_strRelation3  ;
  292. m_recordset.m_honor_remark1 =Dlg.m_strRemark1  ;
  293. m_recordset.m_honor_remark2 =Dlg.m_strRemark2  ;
  294. m_recordset.m_honor_remark3 =Dlg.m_strRemark3  ;
  295. m_recordset.m_honor_remark4 =Dlg.m_strRemark4  ;
  296. m_recordset.m_honor_remark5 =Dlg.m_strRemark5  ;
  297. m_recordset.m_honor_remark6 =Dlg.m_strRemark6  ;
  298. m_recordset.m_term1 =Dlg.m_strScore1  ;
  299. m_recordset.m_term10 =Dlg.m_strScore10  ;
  300. m_recordset.m_term2 =Dlg.m_strScore2 ;
  301. m_recordset.m_term3 =Dlg.m_strScore3 ;
  302. m_recordset.m_term4 =Dlg.m_strScore4 ;
  303. m_recordset.m_term5 =Dlg.m_strScore5 ;
  304. m_recordset.m_term6 =Dlg.m_strScore6 ;
  305. m_recordset.m_term7 =Dlg.m_strScore7 ;
  306. m_recordset.m_term8 =Dlg.m_strScore8 ;
  307. m_recordset.m_term9 =Dlg.m_strScore9 ;
  308. m_recordset.m_code =Dlg.m_strCode ;
  309. m_recordset.m_name =Dlg.m_strName ;
  311. m_recordset.Update();
  312. m_recordset.Close();
  313. strSQL = "select * from student ";
  314. RefreshData(strSQL);
  315. }
  316. }
  318. void CStudentDlg::OnButtonDelete() 
  319. {
  320. // TODO: Add your control notification handler code here
  321. int i = m_ctrList.GetSelectionMark();
  322. if(0>i)
  323. {
  324. AfxMessageBox("请选择一条记录进行查看！");
  325. return;
  326. }
  327. CString strSQL;
  328. strSQL.Format("select * from student where code = '%s'",m_ctrList.GetItemText(i,0));
  329. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  330. {
  331. AfxMessageBox("打开数据库失败!");
  332. return ;
  333. }
  334. m_recordset.Delete();
  335. m_recordset.Close();
  336. strSQL = "select * from student";
  337. RefreshData(strSQL);
  338. }
  340. void CStudentDlg::OnButtonBrowse() 
  341. {
  342. // TODO: Add your control notification handler code here
  343. CStudentInfoDlg Dlg;
  344. UpdateData();
  345. int i = m_ctrList.GetSelectionMark();
  346. if(0>i)
  347. {
  348. AfxMessageBox("请选择一条记录进行查看！");
  349. return;
  350. }
  351. Dlg.m_strCode=m_ctrList.GetItemText(i,0);
  352. Dlg.DoModal();
  353. }
  356. void CStudentDlg::OnSetfocusComboMajor() 
  357. {
  358. // TODO: Add your control notification handler code here
  359. UpdateData();
  360. CString strSQL;
  361. //清空ComboBox查询内容//////////////////////
  362. int nCount=m_ctrMajor.GetCount();
  363. for(int i=0;i<nCount;i++)
  364. {
  365. m_ctrMajor.DeleteString(0);
  366. }
  367. nCount=m_ctrClass.GetCount();
  368. for(i=0;i<nCount;i++)
  369. {
  370. m_ctrClass.DeleteString(0);
  371. }
  373. ///////////////////////////////////////////
  374. CMajorSet recordset ;
  375. strSQL.Format( "select * from major where department = '%s'",m_strDepartment);
  376. if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  377. {
  378. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  379. return ;
  380. }
  381. while(!recordset.IsEOF())
  382. {
  383. m_ctrMajor.AddString(recordset.m_name);
  384. recordset.MoveNext();
  385. }
  386. recordset.Close();
  387. }
  389. void CStudentDlg::OnSetfocusComboClass() 
  390. {
  391. // TODO: Add your control notification handler code here
  392. UpdateData();
  393. CString strSQL;
  394. //清空ComboBox查询内容//////////////////////
  395. int nCount=m_ctrClass.GetCount();
  396. for(int i=0;i<nCount;i++)
  397. {
  398. m_ctrClass.DeleteString(0);
  399. }
  401. ///////////////////////////////////////////
  402. CClassSet recordset ;
  403. strSQL.Format( "select * from class where department = '%s' and major = '%s'",m_strDepartment,m_strMajor);
  404. if(!recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  405. {
  406. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  407. return ;
  408. }
  409. while(!recordset.IsEOF())
  410. {
  411. m_ctrClass.AddString(recordset.m_name);
  412. recordset.MoveNext();
  413. }
  414. recordset.Close();
  415. }
  417. void CStudentDlg::OnSelchangeComboDepartment() 
  418. {
  419. // TODO: Add your control notification handler code here
  420. UpdateData();
  421. //清空ComboBox查询内容//////////////////////
  422. int nCount=m_ctrMajor.GetCount();
  423. for(int i=0;i<nCount;i++)
  424. {
  425. m_ctrMajor.DeleteString(0);
  426. }
  427. nCount=m_ctrClass.GetCount();
  428. for(i=0;i<nCount;i++)
  429. {
  430. m_ctrClass.DeleteString(0);
  431. }
  433. ///////////////////////////////////////////
  434. }
  436. void CStudentDlg::OnSelchangeComboMajor() 
  437. {
  438. // TODO: Add your control notification handler code here
  439. UpdateData();
  441. //清空ComboBox查询内容//////////////////////
  442. int nCount=m_ctrClass.GetCount();
  443. for(int i=0;i<nCount;i++)
  444. {
  445. m_ctrClass.DeleteString(0);
  446. }
  448. ///////////////////////////////////////////
  449. }
  451. void CStudentDlg::OnButtonSearch() 
  452. {
  453. // TODO: Add your control notification handler code here
  454. UpdateData();
  456. CString  strSQL,strTemp;
  457. strTemp="";
  458. BOOL bHaveCon = FALSE;
  459. if(m_strDepartment!="")
  460. {
  461. strSQL.Format("select * from student where department = '%s' ",m_strDepartment);
  462. bHaveCon = TRUE;
  463. }
  464. if(m_strMajor!="")
  465. {
  467. if(bHaveCon)
  468. {
  469. strTemp.Format(" major = '%s' ",m_strMajor);
  470. strSQL=strSQL + " and " + strTemp;
  471. }
  472. else
  473. {
  474. strSQL.Format("select * from student where major = '%s' ",m_strMajor);
  475. }
  476. bHaveCon=TRUE;
  477. }
  478. if(m_strClass!="")
  479. {
  481. if(bHaveCon)
  482. {
  483. strTemp.Format(" class = '%s' ",m_strClass);
  484. strSQL=strSQL + " and " + strTemp;
  485. }
  486. else
  487. {
  488. strSQL.Format("select * from student where class = '%s' ",m_strClass);
  489. }
  490. bHaveCon=TRUE;
  491. }
  492. if(!bHaveCon)
  493. {
  494. strSQL="select * from student";
  495. }
  496. RefreshData(strSQL);
  498. }
  499. void CStudentDlg::RefreshData(CString strSQL)
  500. {
  502. m_ctrList.DeleteAllItems();
  503. m_ctrList.SetRedraw(FALSE);
  506. UpdateData(TRUE);
  508. // strSQL="select * from dept";
  509. if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
  510. {
  511. MessageBox("打开数据库失败!","数据库错误",MB_OK);
  512. return ;
  513. }
  516. int i=0;
  517. CString strTime;
  518. while(!m_recordset.IsEOF())
  519. {
  520. m_ctrList.InsertItem(i,m_recordset.m_code);
  521. m_ctrList.SetItemText(i,1,m_recordset.m_name);
  522. m_ctrList.SetItemText(i,2,m_recordset.m_oldname);
  523. m_ctrList.SetItemText(i,3,m_recordset.m_sex);
  524. strTime.Format("%d-%d-%d",m_recordset.m_birthday.GetYear(),m_recordset.m_birthday.GetMonth(),m_recordset.m_birthday.GetDay());
  525. m_ctrList.SetItemText(i,4,strTime);
  526. m_ctrList.SetItemText(i,5,m_recordset.m_folk);
  527. m_ctrList.SetItemText(i,6,m_recordset.m_political);
  528. m_ctrList.SetItemText(i,7,m_recordset.m_native);
  529. m_ctrList.SetItemText(i,8,m_recordset.m_family);
  530. m_ctrList.SetItemText(i,9,m_recordset.m_phone);
  531. m_ctrList.SetItemText(i,10,m_recordset.m_postcode);
  532. m_ctrList.SetItemText(i,11,m_recordset.m_address);
  533. m_ctrList.SetItemText(i,12,m_recordset.m_IDCard);
  534. strTime.Format("%d-%d-%d",m_recordset.m_enroll_date.GetYear(),m_recordset.m_enroll_date.GetMonth(),m_recordset.m_enroll_date.GetDay());
  535. m_ctrList.SetItemText(i,13,strTime);
  536. strTime.Format("%d-%d-%d",m_recordset.m_graduate_date.GetYear(),m_recordset.m_graduate_date.GetMonth(),m_recordset.m_graduate_date.GetDay());
  537. m_ctrList.SetItemText(i,14,strTime);
  538. m_ctrList.SetItemText(i,15,m_recordset.m_class);
  539. m_ctrList.SetItemText(i,16,m_recordset.m_department);
  540. m_ctrList.SetItemText(i,17,m_recordset.m_major);
  542. i++;
  543. m_recordset.MoveNext();
  544. }
  545. m_recordset.Close();
  546. m_ctrList.SetRedraw(TRUE);
  548. }