1.先设计对话框
5个按钮控件 二个列表控件 二个组框控件 三个文本控件 3个编辑控件
每个控件对应的变量名
enum { IDD = IDD_DIALOG_USER };
CButton m_bntOK;
CButton m_bntNew;
CButton m_bntDelete;
CButton m_bntCancel;
CEdit m_ctrPass;
CEdit m_ctrUser;
CListCtrl m_ctrList;
BOOL m_bIsAdmin;
CString m_strUser;
CString m_strPass;
CString m_strRePass;
//}}AFX_DATA
CButton m_bntOK;
CButton m_bntNew;
CButton m_bntDelete;
CButton m_bntCancel;
CEdit m_ctrPass;
CEdit m_ctrUser;
CListCtrl m_ctrList;
BOOL m_bIsAdmin;
CString m_strUser;
CString m_strPass;
CString m_strRePass;
//}}AFX_DATA
2.对对话框进行初始化
BOOL CUserDlg::OnInitDialog()
{
CDialog::OnInitDialog();
//创建用户列表
m_ctrList.InsertColumn(0,"用户名");
m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
m_ctrList.SetColumnWidth(0,120);
//在添加用户列表中添加用户名
RefreshData();
{
CDialog::OnInitDialog();
//创建用户列表
m_ctrList.InsertColumn(0,"用户名");
m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
m_ctrList.SetColumnWidth(0,120);
//在添加用户列表中添加用户名
RefreshData();
return TRUE;
}
}
3list控件的函数
void CUserDlg::OnClickListUsername(NMHDR* pNMHDR, LRESULT* pResult)
{
CString strSQL;
UpdateData(TRUE);
//从数据库中获取选择用户名的资料
int i = m_ctrList.GetSelectionMark();
m_strUser = m_ctrList.GetItemText(i,0);
strSQL.Format("select * from user where user='%s'",m_strUser);
if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
{
MessageBox("打开数据库失败!","数据库错误",MB_OK);
return ;
}
//显示用户资料
m_strPass = m_recordset.m_passwd;
m_strRePass = m_strPass;
m_bIsAdmin = m_recordset.m_isadmin;
m_recordset.Close();
UpdateData(FALSE);
*pResult = 0;
}
{
CString strSQL;
UpdateData(TRUE);
//从数据库中获取选择用户名的资料
int i = m_ctrList.GetSelectionMark();
m_strUser = m_ctrList.GetItemText(i,0);
strSQL.Format("select * from user where user='%s'",m_strUser);
if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
{
MessageBox("打开数据库失败!","数据库错误",MB_OK);
return ;
}
//显示用户资料
m_strPass = m_recordset.m_passwd;
m_strRePass = m_strPass;
m_bIsAdmin = m_recordset.m_isadmin;
m_recordset.Close();
UpdateData(FALSE);
*pResult = 0;
}
4.ok按钮代码
void CUserDlg::OnOK()
{
UpdateData();
if(m_ctrUser.IsWindowEnabled())
{//增加新用户的输入检查
if(m_strUser=="")
{
MessageBox("请填写用户名!");
m_ctrUser.SetFocus();
return;
}
}
else
{//修改用户信息的输入检查
if(m_strUser=="")
{
MessageBox("请选择一个用户!");
return;
}
}
//限制密码不能为空
if(m_strPass=="")
{
MessageBox("密码不能为空,请输入密码!");
m_ctrPass.SetFocus();
return;
}
//验证密码与确认密码是否一致
if(m_strPass!=m_strRePass)
{
MessageBox("两次输入地密码不一致,请重新输入密码!");
m_ctrPass.SetFocus();
m_strPass = "";
m_strRePass = "";
UpdateData(FALSE);
return;
}
//打开记录集
CString strSQL;
strSQL.Format("select * from user where user='%s'",m_strUser);
if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
{
MessageBox("打开数据库失败!","数据库错误",MB_OK);
return ;
}
if(m_ctrUser.IsWindowEnabled())
{//增加新用户
//判断用户是否已经存在
if(m_recordset.GetRecordCount()!=0)
{
m_recordset.Close();
MessageBox("该用户已经存在!");
return;
}
m_recordset.AddNew();
m_recordset.m_user = m_strUser;
m_recordset.m_passwd = m_strPass;
m_recordset.m_isadmin = m_bIsAdmin;
m_recordset.Update();
MessageBox("用户添加成功!请记住用户名和密码!");
m_recordset.Close();
}
else
{//修改用户信息
//判断用户是否不存在
if(m_recordset.GetRecordCount()==0)
{
m_recordset.Close();
MessageBox("该用户不存在!请更新数据库");
return;
}
m_recordset.Edit();
m_recordset.m_user = m_strUser;
m_recordset.m_passwd = m_strPass;
m_recordset.m_isadmin = m_bIsAdmin;
m_recordset.Update();
MessageBox("用户修改成功!请记住用户名和密码!");
m_recordset.Close();
}
m_ctrUser.EnableWindow(FALSE);
//更新用户列表
RefreshData();
}
{
UpdateData();
if(m_ctrUser.IsWindowEnabled())
{//增加新用户的输入检查
if(m_strUser=="")
{
MessageBox("请填写用户名!");
m_ctrUser.SetFocus();
return;
}
}
else
{//修改用户信息的输入检查
if(m_strUser=="")
{
MessageBox("请选择一个用户!");
return;
}
}
//限制密码不能为空
if(m_strPass=="")
{
MessageBox("密码不能为空,请输入密码!");
m_ctrPass.SetFocus();
return;
}
//验证密码与确认密码是否一致
if(m_strPass!=m_strRePass)
{
MessageBox("两次输入地密码不一致,请重新输入密码!");
m_ctrPass.SetFocus();
m_strPass = "";
m_strRePass = "";
UpdateData(FALSE);
return;
}
//打开记录集
CString strSQL;
strSQL.Format("select * from user where user='%s'",m_strUser);
if(!m_recordset.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
{
MessageBox("打开数据库失败!","数据库错误",MB_OK);
return ;
}
if(m_ctrUser.IsWindowEnabled())
{//增加新用户
//判断用户是否已经存在
if(m_recordset.GetRecordCount()!=0)
{
m_recordset.Close();
MessageBox("该用户已经存在!");
return;
}
m_recordset.AddNew();
m_recordset.m_user = m_strUser;
m_recordset.m_passwd = m_strPass;
m_recordset.m_isadmin = m_bIsAdmin;
m_recordset.Update();
MessageBox("用户添加成功!请记住用户名和密码!");
m_recordset.Close();
}
else
{//修改用户信息
//判断用户是否不存在
if(m_recordset.GetRecordCount()==0)
{
m_recordset.Close();
MessageBox("该用户不存在!请更新数据库");
return;
}
m_recordset.Edit();
m_recordset.m_user = m_strUser;
m_recordset.m_passwd = m_strPass;
m_recordset.m_isadmin = m_bIsAdmin;
m_recordset.Update();
MessageBox("用户修改成功!请记住用户名和密码!");
m_recordset.Close();
}
m_ctrUser.EnableWindow(FALSE);
//更新用户列表
RefreshData();
}
转载于:https://blog.51cto.com/suxiangjuner/144605