对数据库添加、修改、删除数据

View Code

CString sql;
Ctb_number* m_number;
CDatabase m_DB;
sql.Format("select * from tb_number");
m_number = new Ctb_number(&((CMainApp*)AfxGetApp())->m_DB);
if(!m_number->open(AFX_DB_USE_DEFAULT_TYPE,sql))
{
    MessageBox("tb_number 打开失败!");
}
//添加数据
UpdateData(TRUE);
if(m_name.IsEmpty() || m_phonenumber.IsEmpty())
{
    MessageBox("姓名和号码不能为空!");
}
m_number->AddNew();
m_number->m_name = m_name;
m_number->m_phonenumber = m_phonenumber;
m_number->Update();
m_number->Requery();
m_number->colse();

//修改数据
UpdateData(TRUE);
if(m_name.IsEmpty() || m_phonenumber.IsEmpty())
{
    MessageBox("姓名和号码不能为空!");
}
m_number->MoveFirst();
while(!m_number->IsEmpty())
{
    if(m_phoenumber == m_number->phonenumber)
    {
        m_number->Edit();
        m_number->name = m_name;
        m_number->phonenumber = m_phonenumber;
        m_number->Update();
        m_number->Requery();
        break;
    }
    else
        m_number->MoveNext();
}
m_number->close();

//删除数据
UpdateData(TRUE);
m_number->MoveFirst();
while(!m_number->IsEOF())
{
    if(m_phonenumber == m_number->m_phonenumber)
    {
        m_number->Delete();
        m_number->Requery();
        break;
    }
    else
        m_number->MoveNext();
}
m_number->close();

 

 

转载于:https://www.cnblogs.com/world-ding/archive/2012/08/01/2617990.html