#include <iostream>

#include "MySQL_Dao.h"

using namespace std;

int main()

{

MySQL_Dao mysql;

string sql;

//test add

/*

sql = "insert into te11st(content) values('test1'),('test2')";

long iRows = mysql.add(sql);

cout << "totally insert: " << iRows << " rows" << endl;*/

//test query list

/*

sql = "select * from test";

vector<MYSQL_ROW> vList = mysql.queryList(sql);

for(unsigned int i = 0; i < vList.size(); ++i){

MYSQL_ROW row = vList[i];

cout << "{ " << row[0] << ", " << row[1] << " }" << endl;

} */

//test query_row

//*

try{

sql = "select * from test where id=1";

MYSQL_ROW qRow = mysql.queryRow(sql);

cout << "{ " << qRow[0] << ", " << qRow[1] << " }" << endl;

} catch(string & e){

cout << "query_row fail, detail reason is: \n" << e << endl;

}

//*/

//test query_one

//*

try{

sql = "select content from test where id=1";

string content = mysql.queryOne(sql);

cout << content << endl;

} catch(string & e){

cout << "query_one fail, detail reason is: \n" << e << endl;

}

//*/

//test deleteItem

/*sql = "delete from test where id = 2";

long iRows = mysql.deleteItem(sql);

cout << "totally delete: " << iRows << " rows" << endl;*/

//test updateData

/*

sql = "update test set `content`='修改后...' where id=3";

long iRows = mysql.updateData(sql);

cout << "totally update: " << iRows << " rows" << endl;

*/

return 0;

}