people.cpp

人事管理系统.SQL的数据库．所用密码和用户名均是５３１

// people.cpp: implementation of the Cpeople class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "people2.h"
#include "people.h"
#include "PEOPLEConn1.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

Cpeople::Cpeople()
{
	Number="";
	Name="";
	Sex="";
	Age="";
	Department="";
	Job="";
	Phone="";
	Email="";
	Edulevel="";
	Remark="";
	Departnum="";
	Passwd="";
}

Cpeople::~Cpeople()
{

}
void Cpeople::sql_insert()
{
	//连接数据库
	PEOPLEConn m_PeopleConn;
		m_PeopleConn.OnInitPEOPLEConn();
	//设置INSERT语句
	_bstr_t vSQL;
	vSQL="INSERT INTO 职工信息(PNumber,PPasswd,PName,PSex,PAge,PDepartment,PEdulevel,PJob,PPhone,PEmail,PRemark,PDepartnum) VALUES ('"+Number+"','111111','"+Name+"','"+Sex+"','"+Age+"','"+Department+"','"+Edulevel+"','"+Job+"','"+Phone+"','"+Email+"','"+Remark+"','"+Departnum+"')";
	//执行insert语句
	m_PeopleConn.ExecuteSQL(vSQL);
	//断开连接
	m_PeopleConn.ExitConnect();
}

void sql_update(CString vNumber)
{//连接数据库
	PEOPLEConn m_PeopleConn;
		m_PeopleConn.OnInitPEOPLEConn();
	//设置update语句
	_bstr_t vSQL;
	vSQL="UPDATE 职工信息 SET PNumber='"+vNumber+"'";
	//执行update语句
	m_PeopleConn.ExecuteSQL(vSQL);
	//断开连接
	m_PeopleConn.ExitConnect();
}

void Cpeople::sql_delete(CString vNumber)
{
	//连接数据库
	PEOPLEConn m_PeopleConn;
		m_PeopleConn.OnInitPEOPLEConn();
	//设置delete语句
	_bstr_t vSQL;
	vSQL="DELETE  FROM 职工信息 WHERE PNumber=" + vNumber ;
	//执行delete语句
	m_PeopleConn.ExecuteSQL(vSQL);
	//断开连接
	m_PeopleConn.ExitConnect();
}

void Cpeople::sql_updatePwd(CString cNumber)
{
	//连接数据库
	PEOPLEConn m_PEOPLEConn;
	m_PEOPLEConn.OnInitPEOPLEConn();
	//设置UPDATE语句

	_bstr_t vSQL;
	vSQL = "UPDATE 职工信息 SET PPasswd='" + Passwd + "' WHERE PNumber='" + cNumber + "'";
	//执行UPDATE语句
	m_PEOPLEConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_PEOPLEConn.ExitConnect();
}

void Cpeople::GetData(CString cNumber)
{
	// 连接数据库
	PEOPLEConn m_PeopleConn;
	m_PeopleConn.OnInitPEOPLEConn();
	//设置select语句
	_bstr_t vSQL;
	vSQL="SELECT *FROM 职工信息 WHERE PNumber='"+cNumber+"'";
	//执行语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_PeopleConn.GetRecordSet(vSQL);
	//返回各列的值
	 if(m_pRecordset->adoEOF==1)
		 Cpeople();
	 else 
	 {	
		 Number=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PNumber");
		 Name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PName");
		 Sex=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PSex");
		 Age=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PAge");
		 Department=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PDepartment");
		 Job=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PJob");
	     Phone=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PPhone");
		 Email=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PEmail");
		 Edulevel=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PEdulevel");
		 Passwd=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PPasswd");
		Departnum=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PDepartnum");
		Remark=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PRemark");	 
	 }
	 m_PeopleConn.ExitConnect();
}

void Cpeople::GetData1(CString cPasswd)
{
	// 连接数据库
	PEOPLEConn m_PeopleConn;
	m_PeopleConn.OnInitPEOPLEConn();
	//设置select语句
	_bstr_t vSQL;
	vSQL="SELECT *FROM 职工信息 WHERE PPasswd='"+cPasswd+"'";
	//执行语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_PeopleConn.GetRecordSet(vSQL);
	//返回各列的值
	 if(m_pRecordset->adoEOF==1)
		 Cpeople();
	 else 
	 {	
		 Number=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PNumber");
		 Name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PName");
		 Sex=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PSex");
		 Age=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PAge");
		 Department=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PDepartment");
		 Job=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PJob");
	     Phone=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PPhone");
		 Email=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PEmail");
		 Edulevel=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PEdulevel");
		 Passwd=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PPasswd");
	}
	 m_PeopleConn.ExitConnect();
}



int Cpeople::HaveNumber(CString vNumber)
{
	//连接数据库
	PEOPLEConn m_PeopleConn;
	m_PeopleConn.OnInitPEOPLEConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL="SELECT *FROM 职工信息 WHERE PNumber='"+vNumber+"'";
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_PeopleConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_PeopleConn.ExitConnect();
}
int Cpeople::HavePasswd(CString vPasswd)
{	//连接数据库
	PEOPLEConn m_PeopleConn;
	m_PeopleConn.OnInitPEOPLEConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL="SELECT *FROM 职工信息 WHERE Passwd='"+vPasswd+"'";
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_PeopleConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_PeopleConn.ExitConnect();
}