C++ (Cpp) ExcuteSQL Examples

Example #1

File: RegisterDialog.cpp Project: xu-ben/JobSeek

//插入一条求职者数据到数据库里
void CRegisterDialog::insertJobSeekers(CString name, CString sex, CString age, CString EID, CString prof, CString workexp, CString areacode, 
	CString industryid, CString salary, CString email, CString pwd,CString smtpserver,
	int smptport,CString eusername,CString epassword,CString contentfilename,CString attachmentfilen)
{
	CString strSQL;
	strSQL.Format(_T("insert into JobSeekers(Name,Sex,Age,EID,Professional,WorkExperience,AreaCode,IndustryID,Salary,Email,PWD,SmtpServer,SmtpPort,EUserName,EPassWord,ContentFileName,AttachmentFileName) values (\'%s\',\'%s\',%s,%s,\'%s\',%s,\'%s\',%s,%s,\'%s\',\'%s\',\'%s\',%d,\'%s\',\'%s\',\'%s\',\'%s\')"), name, sex, age, EID, prof, workexp,areacode,industryid,salary,email,pwd,smtpserver,smptport,eusername,epassword,contentfilename,attachmentfilen);
//	AfxMessageBox(strSQL);
	ExcuteSQL(strSQL);
}

Example #2

File: dbwritethread.cpp Project: Anne081031/ParkCode

void CDbWriteThread::WriteData( CDbEvent::WriteParameter &paramter, bool bSQL )
{
    //qDebug( ) << Q_FUNC_INFO << paramter.strSql << endl;
    if ( !paramter.bDbHistory || paramter.bTimeCard ) {
        ExcuteSQL( interfaceNormal, bSQL, paramter );
    }

    if ( paramter.bDbHistory ) {
        if ( NULL == pHistoryThread ) {
            pHistoryThread = new CDbHistoryThread( );
        }

        paramter.bDbHistory = bSQL;
        if ( pHistoryThread->AddParameters( paramter ) ) {
            pHistoryThread->start( );
            pHistoryThread= NULL;
        }
    }
}

Example #3

File: RegisterDialog.cpp Project: xu-ben/JobSeek

//插入一条新数据至行业表
void CRegisterDialog::InsertANewIndustry(CString indName)
{
	CString strSQL;
	strSQL.Format(_T("insert into Industry values ('%s')"), indName);	
	ExcuteSQL(strSQL);
}