C++ (Cpp) ExcuteSql示例

示例#1

文件： MysqlCon.cpp 项目： czfsvn/LinuxC

bool MysqlCon::Connection()
{
	if (NULL == m_mysql)
	{
		m_mysql = mysql_init(NULL);
	}

	if (NULL == m_mysql)
	{
		return false;
	}

	if (mysql_real_connect(m_mysql, m_host.c_str(), m_usr.c_str(), m_pwd.c_str(), m_dbName.c_str(), m_port, m_socket, m_clientFlag))
	{
		m_isConnect = true;
		ExcuteSql(m_CodeQuery.c_str());
	}
	else
	{
		m_isConnect = false;
		uint32 err = mysql_errno(m_mysql);
		if (err)
		{
			std::cout<<"DB connection Err = "<<err<<std::endl;
		}
		Close();
		return false;
	}

	return true;
}

示例#2

文件： SqlServerDB.cpp 项目： siredblood/tree-bumpkin-project

BOOL CSqlServerDB::ModifyField(_bstr_t strTableName, _bstr_t strFieldsFormat)
{
	_bstr_t strSql;
	strSql = "ALTER TABLE " + strTableName + " ALTER COLUMN " + strFieldsFormat + "";

	BOOL bRes;
	bRes = ExcuteSql(strSql, adCmdText);
	return bRes;
}

示例#3

文件： SqlServerDB.cpp 项目： siredblood/tree-bumpkin-project

BOOL CSqlServerDB::RenameTable(_bstr_t strOldTableName, _bstr_t strNewTableName)
{
	_bstr_t strSql;
	strSql = "SP_RENAME '" + strOldTableName + "','" + strNewTableName + "'";

	BOOL bRes;
	bRes = ExcuteSql(strSql, adCmdText);
	return bRes;
}

示例#4

文件： MysqlCon.cpp 项目： czfsvn/LinuxC

int32 MysqlCon::ExcuteSql(std::string& sql)
{
	return ExcuteSql(sql.c_str());
}