mysql connect c++

先前在测试mysql connect c++接口的时候运行其官方提供的例子

21.5.5.6. MySQL Connector/C++ Complete Example 2The following code shows a complete example of how to use MySQL Connector/C++: /* Copyright 2008 Sun Microsystems, Inc.This program is free software; you can redistribute it and/or modifyit under the terms of the GNU General Public License as published bythe Free Software Foundation; version 2 of the License.There are special exceptions to the terms and conditions of the GPLas it is applied to this software. View the full text of theexception in file EXCEPTIONS-CONNECTOR-C++ in the directory of thissoftware distribution.This program is distributed in the hope that it will be useful,but WITHOUT ANY WARRANTY; without even the implied warranty ofMERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See theGNU General Public License for more details.You should have received a copy of the GNU General Public Licensealong with this program; if not, write to the Free SoftwareFoundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA*//* Standard C++ includes */#include <stdlib.h>#include <iostream>/* Include directly the different headers from cppconn/ and mysql_driver.h + mysql_util.h (and mysql_connection.h). This will reduce your build time!*/#include "mysql_connection.h"#include <cppconn/driver.h>#include <cppconn/exception.h>#include <cppconn/resultset.h>#include <cppconn/statement.h>#include <cppconn/prepared_statement.h>using namespace std;int main(void){cout << endl;cout << "Let's have MySQL count from 10 to 1..." << endl;try { sql::Driver *driver; sql::Connection *con; sql::Statement *stmt; sql::ResultSet *res; sql::PreparedStatement *pstmt; /* Create a connection */ driver = get_driver_instance(); con = driver->connect("tcp://127.0.0.1:3306", "root", "root"); /* Connect to the MySQL test database */ con->setSchema("test"); stmt = con->createStatement(); stmt->execute("DROP TABLE IF EXISTS test"); stmt->execute("CREATE TABLE test(id INT)"); delete stmt; /* '?' is the supported placeholder syntax */ pstmt = con->prepareStatement("INSERT INTO test(id) VALUES (?)"); for (int i = 1; i <= 10; i++) { pstmt->setInt(1, i); pstmt->executeUpdate(); } delete pstmt; /* Select in ascending order */ pstmt = con->prepareStatement("SELECT id FROM test ORDER BY id ASC"); res = pstmt->executeQuery(); /* Fetch in reverse = descending order! */ res->afterLast(); while (res->previous()) cout << "/t... MySQL counts: " << res->getInt("id") << endl; delete res; delete pstmt; delete con;} catch (sql::SQLException &e) { cout << "# ERR: SQLException in " << __FILE__; cout << "(" << __FUNCTION__ << ") on line " » << __LINE__ << endl; cout << "# ERR: " << e.what(); cout << " (MySQL error code: " << e.getErrorCode(); cout << ", SQLState: " << e.getSQLState() << » " )" << endl;}cout << endl;return EXIT_SUCCESS;}

后在debug模式下，程序调用到此处

con = driver->connect("tcp://127.0.0.1:3306", "root", "root");

后崩溃，查找原因根据官方的MIALLIST里的信息是MYSQL CONNECT C++的本身BUG，在 RELEASE模式下运行正常，在RELEASE模式下，做测试，OK，其配置如下：

 

 

 

 

 

 

软件环境：

下载mysqlserver 5.1安装包地址：http://dev.mysql.com/downloads/mysql/

 

默认用户名：root 密码：自己安装时设置，默认端口：3306 默认安装目录 C:/Program Files/MySQL

 

下载mysql connect c++ 安装包地址：http://dev.mysql.com/downloads/connector/cpp/

默认安装目录 C:/Program Files/MySQL/MySQL Connector C++ 1.0.5

 

拷贝上面提供的例子在REALEASE模式下可以运行。