body.cpp

数据库课程设计

// BODY.cpp : implementation file
//

#include "stdafx.h"
#include "phonebook.h"
#include "BODY.h"
#include "ADD.h"
#include "AMEND.h"
#include "SQL.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CBODY dialog

CString name;

CBODY::CBODY(CWnd* pParent /*=NULL*/)
	: CDialog(CBODY::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBODY)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CBODY::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBODY)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_RADIO1, m_radio);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBODY, CDialog)
	//{{AFX_MSG_MAP(CBODY)
	ON_BN_CLICKED(IDC_BUTTON5, OnButton5)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBODY message handlers

void CBODY::OnButton5() 
{
	CDialog::OnCancel();
	
}

void CBODY::OnButton1() 
{
CADD obj;
obj.DoModal();
	
}

void CBODY::OnButton2() 
{   
	CAMEND obj;
    SQL sql;

CString str="driver={sql server};server=(local);database=phonebook;uid=sa;pwd=";
sql.m_db.OpenEx(str);
	int nItem = m_list.GetNextItem(-1, LVNI_SELECTED);
	if(nItem == -1)
	{
		MessageBox("没有选择要修改的成员");
	   return;
	}
	int id2=atoi(m_list.GetItemText(nItem,0));
	CString name=m_list.GetItemText(nItem,1);
	CString sex=m_list.GetItemText(nItem,2);
	CString phone=m_list.GetItemText(nItem,3);
	CString address=m_list.GetItemText(nItem,4);
	obj.m_account=name;
	obj.m_sex=sex;
	obj.m_number=phone;
	obj.m_place=address;
    if( obj.DoModal()==IDOK)
	{
	CString name=obj.m_account;
	CString sex=obj.m_sex;
	CString phone=obj.m_number;
	CString address=obj.m_place;
	 CString str1;
     if(m_radio.GetCheck()==1)
	 {
	
	 str1.Format("update person set name='%s',gender='%s',phone='%s',address='%s' where id=%d",name,sex,phone,address,id2);
	 //TRACE(str1);
	 sql.m_db.ExecuteSQL(str1);
	 }
	 else
	 {
	 str1.Format("update customer set name='%s',gender='%s',phone='%s',address='%s' where id=%d",name,sex,phone,address,id2);
	 sql.m_db.ExecuteSQL(str1);
	 }
	
	}
    
   
	
}

BOOL CBODY::OnInitDialog() 
{SQL sql;
int i=0;

	CDialog::OnInitDialog();
	SetDlgItemText(IDC_name,name);
	
	// TODO: Add extra initialization here
    DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |
		LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
	m_list.SetExtendedStyle(dwExStyle);

	LV_COLUMN lvColumn;
	lvColumn.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;
	lvColumn.fmt = LVCFMT_CENTER;
	lvColumn.cx = 30;
	lvColumn.iSubItem = 0;     
	lvColumn.pszText = "ID";
	m_list.InsertColumn(0, &lvColumn);
	//添加数目列
	lvColumn.cx = 80;  
	lvColumn.iSubItem = 1; 
	lvColumn.pszText = "姓名";
	m_list.InsertColumn(1, &lvColumn);
	lvColumn.cx = 50;  
	lvColumn.iSubItem = 2; 
	lvColumn.pszText = "性别";
	m_list.InsertColumn(2, &lvColumn);
	
	lvColumn.cx = 150;  
	lvColumn.iSubItem = 3; 
	lvColumn.pszText = "电话号码";
	m_list.InsertColumn(3, &lvColumn);

	lvColumn.cx =228;  
	lvColumn.iSubItem = 4; 
	lvColumn.pszText = "地址";
	m_list.InsertColumn(4, &lvColumn);
	CString str="driver={sql server};server=(local);database=phonebook;uid=sa;pwd=";
sql.m_db.OpenEx(str);
sql.conn.m_pDatabase=&sql.m_db;
	 str="select * from person";
sql.conn.Open(CRecordset::snapshot,str,CRecordset::readOnly);
	
	
  while(!sql.conn.IsEOF())
  {
  sql.conn.GetFieldValue("id",str);
  m_list.InsertItem(i,str);
  sql.conn.GetFieldValue("name",str);
  m_list.SetItemText(i,1,str);
  sql.conn.GetFieldValue("gender",str);
  m_list.SetItemText(i,2,str);
  sql.conn.GetFieldValue("phone",str);
  m_list.SetItemText(i,3,str);
  sql.conn.GetFieldValue("address",str);
  m_list.SetItemText(i,4,str);

  sql.conn.MoveNext();
  i++;
  }
  sql.conn.Close();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBODY::OnButton4() 
{
SQL sql;
int i=0;
CString str="driver={sql server};server=(local);database=phonebook;uid=sa;pwd=";
sql.m_db.OpenEx(str);
  


 m_list.DeleteAllItems();
  //while(m_list.DeleteColumn(0)){};
  /* m_list.InsertColumn(0,"id");
  m_list.InsertColumn(1,"姓名");
  m_list.InsertColumn(2,"性别");
  m_list.InsertColumn(3,"电话");
  m_list.InsertColumn(4,"地址");
  

  m_list.SetColumnWidth(0,50);
  m_list.SetColumnWidth(1,80);
  m_list.SetColumnWidth(2,45);
  m_list.SetColumnWidth(3,160);
  m_list.SetColumnWidth(4,200);*/

  sql.conn.m_pDatabase=&sql.m_db;
  	
if(m_radio.GetCheck()==1)
{

 str="select * from person";
sql.conn.Open(CRecordset::snapshot,str,CRecordset::readOnly);
	

  while(!sql.conn.IsEOF())
  {
  sql.conn.GetFieldValue("id",str);
  m_list.InsertItem(i,str);
  sql.conn.GetFieldValue("name",str);
  m_list.SetItemText(i,1,str);
  sql.conn.GetFieldValue("gender",str);
  m_list.SetItemText(i,2,str);
  sql.conn.GetFieldValue("phone",str);
  m_list.SetItemText(i,3,str);
  sql.conn.GetFieldValue("address",str);
  m_list.SetItemText(i,4,str);

  sql.conn.MoveNext();
  i++;
  }
  sql.conn.Close();



}
else 
{
str="select * from customer";
sql.conn.Open(CRecordset::snapshot,str,CRecordset::readOnly);
	

  while(!sql.conn.IsEOF())
  {
  sql.conn.GetFieldValue("id",str);
  m_list.InsertItem(i,str);
  sql.conn.GetFieldValue("name",str);
  m_list.SetItemText(i,1,str);
  sql.conn.GetFieldValue("gender",str);
  m_list.SetItemText(i,2,str);
  sql.conn.GetFieldValue("phone",str);
  m_list.SetItemText(i,3,str);
  sql.conn.GetFieldValue("address",str);
  m_list.SetItemText(i,4,str);

  sql.conn.MoveNext();
  i++;
  }
  sql.conn.Close();


}
	
}

void CBODY::OnButton3() 
{   
SQL sql;

CString str="driver={sql server};server=(local);database=phonebook;uid=sa;pwd=";
sql.m_db.OpenEx(str);
	int nItem = m_list.GetNextItem(-1, LVNI_SELECTED);
	if(nItem == -1)
	{
		MessageBox("没有选择要删除的成员");
	   return;
	}
	int number=atoi(m_list.GetItemText(nItem,0));
	
	CString str1;
	if(m_radio.GetCheck()==1)
	{
	str1.Format("delete from person where id=%d",number);
	sql.m_db.ExecuteSQL(str1);
	if(sql.m_db.CanUpdate()) MessageBox("successful");
	}
    else
    {
	str1.Format("delete from customer where id=%d",number);
	sql.m_db.ExecuteSQL(str1);
	if(sql.m_db.CanUpdate()) MessageBox("successful");
	
	}
	
	
}