Currently when I run the code, I end up with this as the output.
Expand|Select|Wrap|Line Numbers
- test
- �y�������
- DB connection failed: Bad character '�' in TCP/IP address
Any help with this is greatly appreciated.
Here is my code so far
DbConnect.h
Expand|Select|Wrap|Line Numbers
- #ifndef DBCONNECT_H_
- #define DBCONNECT_H_
- #include <string>
- #include <mysql++.h>
- class DbConnect
- {
- public:
- std::string keep_value; // private data value
- const char* datasource;
- const char* hostname;
- const char* username;
- const char* password;
- void db_set(std::string db_value); // public method to set value
- std::string db_get(void); // public method to get value
- mysqlpp::StoreQueryResult db_query(std::string sqlQuery); // query connection
- };
- #endif /*DBCONNECT_H_*/
Expand|Select|Wrap|Line Numbers
- #include "test2.h"
- #include "DbConnect.h"
- #include <mysql++.h>
- #include <string>
- #include <iomanip>
- // Main application method
- int DataParse::mainParse(void){
- DbConnect qryAction, sqlQuery, db;
- db.datasource = "test";
- std::cout << db.datasource << std::endl;
- sqlQuery.db_set("SELECT * from test");
- mysqlpp::StoreQueryResult qryResult = qryAction.db_query(sqlQuery.db_get());
- mysqlpp::StoreQueryResult::const_iterator it;
- for (it = qryResult.begin(); it != qryResult.end(); ++it) {
- mysqlpp::Row row = *it;
- std::cout << '\t' << row[0] << std::endl;
- std::cout << '\t' << row[1] << std::endl;
- }
- }
Expand|Select|Wrap|Line Numbers
- #include "DbConnect.h"
- #include <mysql++.h>
- #include <string>
- #include <iomanip>
- #include <iostream>
- // Setter for db connection variables
- void DbConnect::db_set(std::string db_value){
- keep_value = db_value;
- }
- // Getter for db connection variables
- std::string DbConnect::db_get(void){
- return (keep_value);
- }
- // Query server for data, returns query object
- mysqlpp::StoreQueryResult DbConnect::db_query(std::string sqlQuery){
- // connect to database server
- mysqlpp::Connection conn(false);
- std::cout << DbConnect::datasource << std::endl;
- if (conn.connect(datasource, hostname, username, password)) {
- // Retrieve a subset of the sample stock table set up by resetdb
- // and display it.
- mysqlpp::Query query = conn.query(sqlQuery);
- if (mysqlpp::StoreQueryResult result = query.store()) {
- mysqlpp::StoreQueryResult::const_iterator it;
- return result;
- }
- else {
- std::cerr << "Failed to get item list: " << query.error() << std::endl;
- }
- }
- else {
- std::cerr << "DB connection failed: " << conn.error() << std::endl;
- }
- }