使用MySQLConnector/C++连接MySQL数据库

最新推荐文章于 2024-08-26 10:03:39 发布

whisperapart

最新推荐文章于 2024-08-26 10:03:39 发布

阅读量628

点赞数

分类专栏： C++ 文章标签： mysql sql server table delete 数据库

本文链接：https://blog.csdn.net/whisperapart/article/details/6931512

版权

C++ 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

sql::ResultSet * CMyTools::ListAll(void)
{
	using namespace sql;  	
	mysql::MySQL_Driver::Driver *  driver;
	Connection * con;
	Statement * state;
	ResultSet * result;
	
	try
	{
		driver	=	sql::mysql::get_mysql_driver_instance();
		if(theApp.s_server=="")
		{
			con		=	driver->connect(SERVER,ACC,PSW);
		}
		else
		{
			con		=	driver->connect((sql::SQLString)theApp.s_server,(sql::SQLString)theApp.s_account,(sql::SQLString)theApp.s_password);
		}
		state	=	con->createStatement();
		state->execute("use nfm");
		result	=	state->executeQuery("select id,name,gender,birth,bed,hos,table1,table2 from patient where mask=0;");
	}
	catch(sql::SQLException &e)
	{		
		return NULL;
	}
	delete state;
	delete con;
	return result;
}