做的一个成绩查询系统,想实现先登录,再查询
我在第一个对话框中输入学号,密码,登陆成功
UpdateData(true);
variant_t var;
CString strName = "";
_ConnectionPtr m_pConnection;
_CommandPtr m_pCommand;
_RecordsetPtr m_pRecordset;
CString SQL;
char*STRSQL;
SQL="SELECT * FROM studentinfo WHERE num='"+m_num+"' and pwd='"+m_pwd+"'";
STRSQL=SQL.GetBuffer(SQL.GetLength());
::CoInitialize(NULL);
m_pConnection.CreateInstance(_uuidof(Connection));
try
{
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=student.mdb","","",adModeUnknown);
m_pRecordset.CreateInstance(__uuidof(Recordset));
m_pRecordset->Open(STRSQL,
m_pConnection.GetInterfacePtr(), // 获取库接库的IDispatch指针
adOpenDynamic,
adLockOptimistic,
adCmdText);
连上了数据库,怎样在第三个对话框里来显示刚刚登陆的时候连上的数据库里的信息?
m_List.DeleteAllItems();
UpdateData(TRUE);
_variant_t var;
CString strName = "";
_ConnectionPtr m_pConnection;
_CommandPtr m_pCommand;
_RecordsetPtr m_pRecordset;
CString SQL;
char*STRSQL;
** */*CYyyDlg rt;
m_NUM=rt.m_num;
UpdateData(false);*/* ** 我本来想这样来实现,把m_num的值赋给m_NUM,但是没用
SQL="SELECT * FROM studentinfo WHERE num='"+m_NUM+"'";
STRSQL=SQL.GetBuffer(SQL.GetLength());
::CoInitialize(NULL);
m_pConnection.CreateInstance(__uuidof(Connection));
try
{
m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=student.mdb","","",adModeUnknown);
C052012099