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

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;}