PlayerInfo * db_findPlayerInfo(Connection *conn, const std::string &sql)
{
PlayerInfo *info = NULL;
Statement *stmt = conn->createStatement();
ResultSet *res = stmt->executeQuery(sql.c_str());
if (res->next())
{
info = new PlayerInfo;
info->user_id = res->getUInt("user_id");
std::string user_name = res->getString("user_name");
size_t size = user_name.size() < MAX_NAME ? user_name.size() : MAX_NAME;
memcpy(info->user_name, user_name.c_str(), size);
info->level = res->getInt("level");
info->gender = res->getInt("gender");
info->role_id = res->getInt("role_id");
info->scene_id = res->getInt("scene_id");
info->x = res->getInt("x");
info->y = res->getInt("y");
std::string user_pwd = res->getString("user_pwd");
size = user_pwd.size() < MAX_PWD ? user_pwd.size() : MAX_PWD;
memcpy(info->user_pwd, user_pwd.c_str(), size);
}
delete stmt;
delete res;
return info;
}
void HMMDataSet::read(int idAction){
openMysqlSession();
cout<<"Reading HMMData for action:"<<idAction<<endl;
this->idAction=idAction;
ResultSet *resSet;
PreparedStatement *prep_stmt;
/* create a statement object */
prep_stmt = con -> prepareStatement("SELECT * FROM `HMMDataSet` WHERE `compression_rate`=? AND `num_clusters`=? AND `id_action`=?");
prep_stmt->setInt(1, compressionRate);
prep_stmt->setInt(2, numClusters);
prep_stmt->setInt(3, idAction);
resSet = prep_stmt->executeQuery();
while (resSet->next()) {
std::stringstream state_trans(resSet->getString("state_trans"));
std::stringstream initial_state_dist(resSet->getString("initial_state_dist"));
std::stringstream obs_prob_dist(resSet->getString("obs_prob_dist"));
std::stringstream cluster_distribution(resSet->getString("cluster_distribution"));
stateTrans.resize(numStates, vector<double>(numStates, 0));
initialStateDist.resize(numStates, 0);
obsProbDist.resize(numStates, vector<double>(numStates,0));
clustDist.resize(numStates);
for (int i = 0; i < numClusters; i++) {
for (int j = 0; j < numClusters; j++) {
state_trans >> stateTrans[i][j];
}
}
for (int j = 0; j < numClusters; j++) {
initial_state_dist >> initialStateDist[j];
}
for (int i = 0; i < numClusters; i++) {
for (int j = 0; j < numClusters; j++) {
obs_prob_dist>> obsProbDist[i][j];
}
}
for (int j = 0; j < numClusters; j++) {
ClusterDistribution cluster;
cluster_distribution >> cluster.mean.idCluster;
cluster.mean.center.resize(Vector_Size);
for (int k = 0; k < Vector_Size; k++) {
cluster_distribution >> cluster.mean.center[k];
}
cluster_distribution >> cluster.standardDeviation;
clustDist.push_back(cluster);
}
}
delete resSet;
delete prep_stmt;
closeMysqlSession();
}
int ChargeBusiness::QueryOrder(TopupInfo *topupInfo){
int ret = 0;
Statement *stmt = NULL;
try{
stmt = conn->createStatement(SQL_CREATE_ORDER);
string tbOrderNo = topupInfo->qs_info.tbOrderNo;
fprintf(stderr, "ChargeBusiness::QueryOrder %s\n", tbOrderNo.c_str());
stmt->setString(1, tbOrderNo);
ResultSet *rs = stmt->executeQuery();
while(rs->next())
{
topupInfo->qs_info.tbOrderNo = rs->getString(1);
topupInfo->qs_info.coopOrderNo = rs->getString(2);
topupInfo->status = (OrderStatus)rs->getInt(3);
string ts = rs->getString(4);
trans_time(ts, topupInfo->update_time);
ret++;
}
conn->terminateStatement(stmt);
}catch(SQLException &sqlExcp){
HandleException(sqlExcp);
ret = -1;
}catch(std::exception &e){
HandleException(e);
ret = -1;
}
Finish();
if(stmt)
conn->terminateStatement(stmt);
return ret;
}
//through the product info get the best channel to create order
//@return the channel num
int ChargeBusiness::SelectBestChannel(int value, int province, int op, vector<ChannelInfo>& channels){
int ret = 0;
Statement *stmt = NULL;
try{
stmt = conn->createStatement(SQL_SELECT_CHANNEL);
stmt->setInt(1, value); //product value
stmt->setInt(2, province); //provice of product
stmt->setInt(3, op); //operator of product
ResultSet *rs = stmt->executeQuery();
while(rs->next())
{
ChannelInfo channel;
channel.channelId = rs->getInt(1); //channel id
//channel.channelName = rs->getString(2); //channel name
channel.sname = rs->getString(2); //short name
channel.priority = rs->getInt(3); //priority
channel.repeat = rs->getInt(4); //repeat times
channel.discount = rs->getFloat(5); //discount of product
channel.interfaceName = rs->getString(6); //the interface of channel,through it to find the class to handle order
channel.pid = rs->getString(7); //the product id given by channel
channel.private_key = rs->getString(8); //the private key given by channel
channel.query_interval = rs->getInt(9); //query order interval
channels.push_back(channel);
ret++;
}
stmt->closeResultSet(rs);
}catch(std::exception &e){
HandleException(e);
ret = -1;
}
Finish();
if(stmt)
conn->terminateStatement(stmt);
return ret;
}
int main(int argc, char* argv[])
{
//初始化连接，创建参数中maxSize一半的连接
connpool.initPool("tcp://127.0.0.1:3306", "root", "123456", 100);
Connection *con;
Statement *state;
ResultSet *result;
con = connpool.GetConnection();
for(int i = 0; i<2; i++)
{
state = con->createStatement();
state->execute("use mysql");
// 查询
result = state->executeQuery("select host,user from user");
// 输出查询
while (result->next())
{
try{
string user = result->getString("user");
string name = result->getString("host");
cout << user << " : " << name << endl;
}catch(sql::SQLException& e){
std::cout<< e.what() <<std::endl;
}
}
result = state->executeQuery("select cust_id,cust_name from customers");
while (result->next())
{
try{
string user = result->getString("cust_id");
string name = result->getString("cust_name");
cout << user << " : " << name << endl;
}catch(sql::SQLException& e){
std::cout<< e.what() <<std::endl;
}
}
std::cout << i << std::endl;
}
delete result;
delete state;
connpool.ReleaseConnection(con);
return 0;
}
void AdminServlet::handleGet(HttpRequest* request, HttpResponse* response) {
ResultSet* result;
try {
result = ServerDatabase::instance()->executeQuery("SELECT DISTINCT account_id, ip, COUNT(*) FROM account_ips WHERE timestamp >= DATE_SUB(timestamp, INTERVAL 1 DAY) GROUP BY ip HAVING COUNT(*) > 2 ORDER BY COUNT(*) DESC");
} catch (DatabaseException& e) {
response->println(e.getMessage());
return;
}
response->println("HTTP/1.1 200 OK");
response->println("Content-Type: text/html");
response->println("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">");
response->println("<html xmlns=\"http://www.w3.org/1999/xhtml\">");
response->println(" <head>");
response->println(" <title>SWGEmu Multiple Account Administration</title>");
response->println(" <meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\" />");
response->println(" <link rel=\"stylesheet\" type=\"text/css\" href=\"css/style.css\" />");
response->println(" </head>");
response->println(" <body>");
response->println(" <table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">");
response->println(" <caption>Suspect List</caption>");
response->println(" <tr>");
response->println(" <th>IP Address</th>");
response->println(" <th>Count</th>");
response->println(" </tr>");
if (result->size() > 0) {
while (result->next()) {
String ip = "<a href=\"http://ip-lookup.net/?ip=";
ip += String::valueOf(result->getString(1));
ip += "\">";
ip += String::valueOf(result->getString(1));
ip += "</a>";
response->println(" <tr>");
response->println(" <td>" + ip + "</td>");
response->println(" <td>" + String::valueOf(result->getInt(2)) + "</td>");
response->println(" <tr>");
}
} else {
response->println(" <tr>");
response->println(" <td>No suspects found.</td>");
response->println(" <tr>");
}
delete result;
result = NULL;
response->println(" </body>");
response->println("</html>");
}
//验证用户微信号
int ChargeBusiness::VerifyWeixin(string userId, string openId){
Statement *stmt = NULL;
int ret = 0;
try{
stmt = conn->createStatement(QUERY_USER_SQL);
stmt->setString(1, userId);
ResultSet *rs = stmt->executeQuery();
string user_open_id;
int id = -1;
while(rs->next())
{
id = rs->getInt(1);
user_open_id = rs->getString(2);
}
if(id == -1){
ret = 1;
}else if(user_open_id.empty()){
conn->terminateStatement(stmt);
stmt = conn->createStatement(VERIFY_SQL);
stmt->setString(1, openId);
stmt->setString(2, userId);
stmt->executeUpdate();
}else{
ret = 2;
}
}catch(SQLException &sqlExcp){
HandleException(sqlExcp);
}catch(std::exception &e){
HandleException(e);
}
if(stmt)
conn->terminateStatement(stmt);
return ret;
}
int main(int argc, char** argv)
{
USE_NETWORK;
using namespace sql;
Statement *state;
ResultSet *result;
Connection *con = DbLib::instance().connect("tcp://127.0.0.1:3306", "root", "");
state = con->createStatement();
state->execute("use net_db");
result = state->executeQuery("select * from g_user");
//printf(" id user_id user_name level profession\n");
printf("%7s%10s%20s%7s%10s\n", "id", "user_id", "user_name", "level", "role_id");
while(result->next())
{
int64_t id = result->getInt64("id");
int user_id = result->getInt("user_id");
string user_name = result->getString("user_name");
int level = result->getInt("level");
int profession = result->getInt("role_id");
printf(" %7d ", id);
printf(" %10d ", user_id);
printf(" %20s ", user_name.c_str());
printf(" %7d ", level);
printf(" %10d \n", profession);
}
delete state;
delete con;
system("pause");
return 0;
}
///ret = 2 no such product
///ret = 1 exception not find product
int ChargeBusiness::GetTmallProduct(string productId, Product &product){
int ret = 0;
Statement *stmt = NULL;
try{
//初始化数据库连接
stmt = conn->createStatement(SQL_QUERY_PRODUCT);
stmt->setString(1, productId);
ResultSet *rs = stmt->executeQuery();
while (rs->next())
{
product.productId = rs->getString(1);
product.provinceId = rs->getInt(2);
product.price = rs->getInt(3);
product.op = rs->getInt(4);
}
stmt->closeResultSet(rs);
if(product.productId.empty() || product.provinceId == 0){
ret = 2;
}
}
catch(std::exception &e)
{
HandleException(e);
ret = 1;
}
Finish();
if(stmt)
conn->terminateStatement(stmt);
return ret;
}
bool TEST_CONNECTION(){
GlobalConfig *gconf = GlobalConfig::Instance();
if(gconf == NULL || !gconf->Init("../conf/topup.ini")){
exit(EXIT_FAILURE);
}
ConnectionManager* conn_manager = ConnectionManager::Instance();
printf("user:%s\tpasswd:%s\n", gconf->s_db_userName.c_str(), gconf->s_db_passWord.c_str());
if(conn_manager == NULL || !conn_manager->Init(gconf->s_db_userName,
gconf->s_db_passWord, gconf->s_db_connString,
gconf->n_max_connection, gconf->n_min_connection,
gconf->n_inc_connection)){
exit(EXIT_FAILURE);
}
Connection *conn = conn_manager->CreateConnection();
Statement *stmt = conn->createStatement("SELECT ID,ZONE,VALUE,OPERATOR FROM PRODUCT_TBL WHERE ID = :1 AND STATUS != 3");
stmt->setString(1, "10001");
ResultSet *rs = stmt->executeQuery();
while (rs->next())
{
string id = rs->getString(1);
cout << id << endl;
}
stmt->closeResultSet(rs);
conn->terminateStatement(stmt);
return true;
}
void Student::List()
{
Statement *stmt = NULL;
ResultSet *rs = NULL;
string sql = "select * from sql_test_table";
try
{
stmt = conn->createStatement(sql);
}
catch (SQLException &e)
{
cout << e.getMessage();
}
if (stmt)
{
try
{
rs = stmt->executeQuery();
}
catch (SQLException &e)
{
cout << e.getMessage();
}
if (rs)
{
cout << endl << setw(3) << left <<"ID"
<< setw(6) << left << "NAME"
<< setw(8) << left << "DEFINITION"
<< endl;
cout << "===================" << endl;
while (rs->next())
{
cout << setw(3) << left << rs->getInt(1)
<< setw(6) << left << rs->getString(2)
<< setw(8) << left << rs->getString(3)
<< endl;
}
cout << "===================" << endl;
cout << endl;
stmt->closeResultSet(rs);
}
conn->terminateStatement(stmt);
}
}
vector<Profile> HumanHits::getAllProfilesInSecond(string absoluteTime, string cameraNode)
{
vector<Profile> profiles;
driver = sql::mysql::get_mysql_driver_instance();
con = driver->connect("tcp://127.0.0.1:3306", "root", "root");
stmt = con->createStatement();
stmt->execute("USE camera");
if (cameraNode == "PRG1.avi")
cameraNode = "camera_node_1";
else if (cameraNode == "PRG6.avi")
cameraNode = "camera_node_6";
else if (cameraNode == "PRG7.avi")
cameraNode = "camera_node_7";
else if (cameraNode == "PRG14.avi")
cameraNode = "camera_node_14";
else if (cameraNode == "PRG22.avi")
cameraNode = "camera_node_22";
else if (cameraNode == "PRG23.avi")
cameraNode = "camera_node_23";
else if (cameraNode == "PRG28.avi")
cameraNode = "camera_node_28";
else if (cameraNode == "PRG29.avi")
cameraNode = "camera_node_29";
string query = "select profile_id, Blob_Center_Point from " + cameraNode +" where TimeStamp = "+ absoluteTime;
// select profile_id, timestamp from camera_node_22 where TimeStamp = 1.54;
ResultSet *profileResult = stmt->executeQuery(query);
while (profileResult->next())
{
Profile prf;
prf.profileId = profileResult->getString("profile_id");
string centrePoint = profileResult->getString("Blob_Center_Point");
vector<string> coord = stringSplit(centrePoint, ",");
prf.centreX = stoi(coord[0]);
prf.centreY = stoi(coord[1]);
profiles.push_back(prf);
}
delete con;
delete stmt;
return profiles;
}
void run() {
Connection *con;
Statement *state;
ResultSet *result;
for(int i = 0; i<10000; i++){
con = connpool->GetConnection();
// for(int i = 0; i<1000; i++)
// {
state = con->createStatement();
state->execute("use mysql");
// 查询
result = state->executeQuery("select host,user from user");
// 输出查询
while (result->next())
{
try{
string user = result->getString("user");
string name = result->getString("host");
cout << user << " : " << name << endl;
}catch(sql::SQLException& e){
std::cout<< e.what() <<std::endl;
}
}
result = state->executeQuery("select cust_id,cust_name from customers");
while (result->next())
{
try{
string user = result->getString("cust_id");
string name = result->getString("cust_name");
cout << user << " : " << name << endl;
}catch(sql::SQLException& e){
std::cout<< e.what() <<std::endl;
}
}
std::cout << i << std::endl;
// }
delete result;
delete state;
connpool->ReleaseConnection(con);
}}
vector<MaintenanceContainer> SqlInterface::getMaintenanceData(){
ResultSet *rset;
MaintenanceContainer mContainer;
int temp2 = 0;
string query = "select * from maintenance";
vector<MaintenanceContainer> vContainer;
if(this == 0 || this == NULL)
return vContainer;
stmt = conn->createStatement(query);
try{
rset = stmt->executeQuery();
}
catch(SQLException ex){
cout<<"Exception thrown for select"<<endl;
cout<<"Error number: "<< ex.getErrorCode() << endl;
cout<<ex.getMessage() << endl;
}
vector<MetaData> data = rset->getColumnListMetaData();
try{
while(rset->next()){
for(unsigned int i = 0; i < data.size(); i++){
temp = rset->getString(i+1);
switch(i)
{
case 0: temp2 = atoi(temp.c_str());
mContainer.setCarId(temp2);
break;
case 1: mContainer.setDamages(temp);
break;
case 2: temp2 = atoi(temp.c_str());
mContainer.setCosts(temp2);
break;
case 3: mContainer.setStartDate(temp);
break;
case 4: mContainer.setFinishDate(temp);
break;
}
}
vContainer.push_back(mContainer);
}
}
catch(SQLException ex){
cout<<"Exception thrown for select"<<endl;
cout<<"Error number: "<< ex.getErrorCode() << endl;
cout<<ex.getMessage() << endl;
}
stmt->closeResultSet (rset);
conn->terminateStatement (stmt);
return vContainer;
}
/**
* The testing logic of the test case.
*/
dvoid select ()
{
cout << "occipool - Selecting records using ConnectionPool interface" <<
endl;
const string poolUserName = "******";
const string poolPassword = "******";
const string connectString = "";
const string username = "******";
const string passWord = "******";
unsigned int maxConn = 5;
unsigned int minConn = 3;
unsigned int incrConn = 2;
ConnectionPool *connPool;
try{
connPool = env->createConnectionPool
(poolUserName, poolPassword, connectString, minConn, maxConn, incrConn);
if (connPool)
cout << "SUCCESS - createConnectionPool" << endl;
else
cout << "FAILURE - createConnectionPool" << endl;
con = connPool->createConnection (username, passWord);
if (con)
cout << "SUCCESS - createConnection" << endl;
else
cout << "FAILURE - createConnection" << endl;
}catch(SQLException ex)
{
cout<<"Exception thrown for createConnectionPool"<<endl;
cout<<"Error number: "<< ex.getErrorCode() << endl;
cout<<ex.getMessage() << endl;
return;
}
cout << "retrieving the data" << endl;
try{
stmt = con->createStatement
("SELECT author_id, author_name FROM author_tab");
ResultSet *rset = stmt->executeQuery();
while (rset->next())
{
cout << "author_id:" << rset->getInt (1) << endl;
cout << "author_name:" << rset->getString (2) << endl;
}
stmt->closeResultSet (rset);
con->terminateStatement (stmt);
connPool->terminateConnection (con);
env->terminateConnectionPool (connPool);
}catch(SQLException ex)
{
cout<<"Exception thrown for retrieving data"<<endl;
cout<<"Error number: "<< ex.getErrorCode() << endl;
cout<<ex.getMessage() << endl;
}
cout << "occipool - done" << endl;
} // end of test (Connection *)
int Call::DBread(Connection *sqlCon)
{
if (!sqlCon || !id)
return -1;
PreparedStatement *pstmt = sqlCon->prepareStatement(
"SELECT phone, client, translator, client_country, translator_country, lang, price, start_time, accounted, cost, error FROM calls WHERE id=(?)");
pstmt->setInt(1, id);
ResultSet *res;
try {
res = pstmt->executeQuery();
} catch (SQLException &ex) {
log(LOG_ERROR, "[%s] MySQL error(%d): %s", __func__, ex.getErrorCode(), ex.what());
delete pstmt;
return 0;
}
delete pstmt;
if (res->rowsCount() != 1)
return -1;
res->first();
bool isPhone = dynamic_cast<PhoneCall *>(this) != 0;
if (res->getInt("phone") != isPhone) {
delete res;
return -1;
}
client = res->getInt("client");
translator = res->getInt("translator");
translateLang = res->getString("lang").c_str();
price = res->getInt("price");
const char *time = res->getString("start_time").c_str();
if (strlen(time) > 0)
start_time = mktime(getdate(time));
time = res->getString("end_time").c_str();
if (strlen(time) > 0)
end_time = mktime(getdate(time));
accounted = res->getInt("accounted");
cost = res->getInt("cost");
if (res->getInt("error"))
state = ERROR;
// setClientCountry(res->getString("client_country").c_str());
// setTranslatorCountry(res->getString("translator_country").c_str());
delete res;
return 0;
}
bool XMLProcessor::getExistingHashtoDBNameInfo()
{
vector<pair<string, string>> vec;
try
{
ResultSet* resultset = dbConnect.querybyExistingColumnName(HASHNAMETOTRUETABLENAME, vec);
countSameNode.clear();
while (resultset->next())
{
nodeToDBName[resultset->getString(HASHNAME)] = resultset->getString(TRUETABLENAME) + "_" + resultset->getString(NAMEINDEX);
countSameNode[resultset->getString(TRUETABLENAME)]++;
}
}
catch (exception e)
{
return false;
}
return true;
}
std::list<Classroom> find(std::string condition)
{
ResultSet *res;
std::list<Classroom> classroom_list;
std::string sql = "SELECT * FROM classroom WHERE "
+ condition;
DButil *myDB;
res = myDB->execQuery(sql);
while(res->next())
{
Classroom *classroom = new Classroom();
classroom->set_classroom_id(res->getInt("classroom_id"));
classroom->set_classroom_name(res->getString("classroom_name"));
classroom->set_classroom_way(res->getString("classroom_way"));
classroom_list.push_back(*classroom);
}
return classroom_list;
}
vector<Profile> HumanHits::getAllProfilesInSecond(string absoluteTime, string cameraNode)
{
vector<Profile> profiles;
stmt->execute("USE camera");
if (cameraNode == "PRG1.avi")
cameraNode = "camera_node_1";
else if (cameraNode == "PRG6.avi")
cameraNode = "camera_node_6";
else if (cameraNode == "PRG7.avi")
cameraNode = "camera_node_7";
else if (cameraNode == "PRG14.avi")
cameraNode = "camera_node_14";
else if (cameraNode == "PRG22.avi")
cameraNode = "camera_node_22";
else if (cameraNode == "PRG23.avi")
cameraNode = "camera_node_23";
else if (cameraNode == "PRG28.avi")
cameraNode = "camera_node_28";
else if (cameraNode == "PRG29.avi")
cameraNode = "camera_node_29";
string query = "select profile_id, Blob_Center_Point from " + cameraNode +" where TimeStamp = "+ absoluteTime +" AND Blob_Center_Point NOT LIKE 'MISSING'";
// select profile_id, timestamp from camera_node_22 where TimeStamp = 1.54;
ResultSet *profileResult = stmt->executeQuery(query);
while (profileResult->next())
{
Profile prf;
prf.profileId = profileResult->getString("profile_id");
string centrePoint = profileResult->getString("Blob_Center_Point");
vector<string> coord = stringSplit(centrePoint, ",");
prf.centreX = stoi(coord[0]);
prf.centreY = stoi(coord[1]);
profiles.push_back(prf);
}
return profiles;
}
vector<map<string, string>> retrievePendingMessages(Document & request)
{
int recvid= validateToken(request["usertoken"].GetString());
try
{
PreparedStatement * prepstmt;
prepstmt = conn->prepareStatement("select senderuid, receiveruid, msg, datesent from msgs where (receiveruid=? and status=0);");
prepstmt->setInt(1, recvid);
ResultSet * rs;
rs = prepstmt->executeQuery();
prepstmt = conn->prepareStatement("update msgs set status=1 where receiveruid=?;"); //ATTENTION! Threading error can occur!
prepstmt->setInt(1, recvid);
prepstmt->executeUpdate();
conn->commit();
ResultSet * namers;
prepstmt = conn->prepareStatement("select login from users where id=?;");
prepstmt->setInt(1, recvid);
namers = prepstmt->executeQuery();
namers->next();
string receiver = namers->getString("login");
vector<map<string, string>> msgs;
while(rs->next()){
map<string, string> onemsg;
prepstmt = conn->prepareStatement("select login from users where id=?;");
prepstmt->setInt(1, rs->getInt("senderuid"));
namers = prepstmt->executeQuery();
namers->next();
onemsg.insert(make_pair("sender", namers->getString("login")));
onemsg.insert(make_pair("receiver", receiver));
onemsg.insert(make_pair("message", rs->getString("msg")));
onemsg.insert(make_pair("datesent", rs->getString("datesent")));
//cout << namers->getString("login") << " " << rs->getString("msg") << endl;
msgs.push_back(onemsg);
}
return msgs;
}
catch(exception e)
{
throw 2;
}
}
void Database::establishServer()
{
if (!isConnected())
init();
if (!m_isConnected)
return;
if(m_isConnected)
{
PreparedStatement *prep_stmt = 0;
Statement *stmt= 0;
ResultSet *res = 0;
QString IP;
stmt = m_database->createStatement();
try
{
QString qry = QString("SELECT USER( ) AS a");
res = stmt->executeQuery(qry.toStdString());
if (res -> rowsCount() != 0)
{
while (res->next())
{
IP = QString(res->getString("a").c_str());
}
}
m_serverID = Crypto::sessionId(IP).toHex();
prep_stmt = m_database->prepareStatement("INSERT INTO servers(id, serverName, maxPlayers, connectedPlayers, ipAddr) VALUES (?, ?, ?, ?, ?)");
prep_stmt->setString(1, m_serverID.toStdString());
prep_stmt->setString(2, m_settings.value("serverName", DefaultSettings::serverName()).toString().toStdString());
prep_stmt->setInt(3, m_settings.value("maxPlayers", DefaultSettings::maxPlayers()).toInt());
prep_stmt->setInt(4, 0);
prep_stmt->setString(5, m_settings.value("serverIP", "127.0.0.1").toString().toStdString());
prep_stmt->executeUpdate();
}
catch (SQLException &e)
{
emit writeToConsole("Query failed(establishServer): " + QLatin1String(e.getSQLStateCStr()));
}
delete prep_stmt;
delete stmt;
delete res;
}
}
std::auto_ptr<std::map<std::string , model::ConfigItem>> ConfigConnector::getConfigInfo()
{
Connection conn = _pool->getConnection();
PreparedStatement stmt = conn->prepareStatement("select * from config_resource");
ResultSet result = stmt->executeQuery();
std::auto_ptr<std::map<std::string ,model::ConfigItem >> mapConfig(new std::map<std::string , model::ConfigItem>);
model::ConfigItem item;
while (result->next()) {
item.setCid(result->getInt(1));
item.setName(result->getString(2));
item.setValue(result->getString(3));
item.setDetail(result->getString(4));
(*mapConfig)[item.getName()] = item;
}
_pool->returnConnection(conn);
return mapConfig;
}
void display::DisplayLocations()
{
string query = "select * from LocationInfo";
ResultSet* res = BaseDBTable::ExecuteQuery(query);
int index = 1;
if(res != NULL)
{
int rowCount = res->rowsCount();
if(rowCount != 0 && res->next())
{
cout<< index <<": "<< res->getString("Location")<<endl;
index++;
}
}
}
void display::DisplayShelves(int locationID)
{
string query = "select * from ShelfInfo where ShelfLocationID = ";
query.append(to_string(locationID));
ResultSet* res = BaseDBTable::ExecuteQuery(query);
int index = 1;
if(res != NULL)
{
int rowCount = res->rowsCount();
if(rowCount != 0 && res->next())
{
cout<< index <<": "<< res->getString("ShelfCode")<<endl;
index++;
}
}
}
void LoginCheck::check(Buf* pbuf) {
struct sLogin login;
memcpy(&login, ((MSG_HEAD*)pbuf->ptr())->cData(), sizeof(login));
PreparedStatement* pstmt = DATABASE->preStatement(SQL_SELECT_STU);
pstmt->setString(1, login.username);
ResultSet* prst = pstmt->executeQuery();
string strpwd;
while(prst->next()) {
strpwd = prst->getString(1);
}
if (0 == strcmp(login.password, strpwd.c_str())) {
printf("login success!\n");
}
}
void CHandleMessage::handleGetStoreBooksList (Buf *p) {
#ifdef __DEBUG_HANDLE_HEAD_
cout << "CT_GetStoreBooksList" << endl;
#endif
const epUser* pUser = EPMANAGER->getUserByFd(p->getfd());
CHECK_P(pUser);
cGetPublicBooksList cgbl;
UNPACKET(p, cgbl);
bookList book_list;
bookNode* book_node;
try {
MutexLockGuard guard(DATABASE->m_mutex);
PreparedStatement* pstmt = DATABASE->preStatement(SQL_GET_COURSE_LIST_IN_STORE);
ResultSet* prst = pstmt->executeQuery ();
while (prst->next ()) {
book_node = book_list.add_book_list();
book_node->set_book_id (prst->getInt ("book_id"));
book_node->set_book_name(prst->getString("book_name"));
book_node->set_book_type(prst->getInt ("book_type"));
book_node->set_auth_id (prst->getInt ("auth_id"));
book_node->set_auth_type((enum LoginType)prst->getInt ("auth_type"));
#ifdef __DEBUG__
std::cout << "book_node->book_id () = " << book_node->book_id () << std::endl;
std::cout << "book_node->book_name() = " << book_node->book_name() << std::endl;
std::cout << "book_node->book_type() = " << book_node->book_type() << std::endl;
std::cout << "book_node->auth_id () = " << book_node->auth_id () << std::endl;
std::cout << "book_node->auth_type() = " << book_node->auth_type() << std::endl;
#endif
}
delete prst;
delete pstmt;
}catch (SQLException e) {
PRINT_CATCH(e);
RETURN(p);
}
Buf* pBuf = packet_list(ST_GetStoreBooksList, book_list, p->getfd());
CHECK_P(pBuf);
SINGLE->sendqueue.enqueue(pBuf);
RETURN(p);
}
Player *Database::authenticateUser(const QString &user, const QString &password)
{
if (!isConnected())
init();
if (!m_isConnected)
return 0;
Player *player = 0;
Statement *stmt = 0;
ResultSet *res = 0;
stmt = m_database->createStatement();
try {
QString qry = QString("SELECT id, username, kills, deaths FROM accounts where username='******' and secret='%2'").arg(user, password);
res = stmt->executeQuery(qry.toStdString());
if (res -> rowsCount() != 0)
{
player = new Player();
while (res->next())
{
player->setUserId(res->getInt("id"));
player->setUserName(QString::fromStdString(res->getString("username")));
player->setKills(res->getInt("kills"));
player->setDeaths(res->getInt("deaths"));
}
}
} catch (SQLException &e)
{
emit writeToConsole("Query failed: " + QLatin1String(e.getSQLStateCStr()));
return false;
}
delete stmt;
delete res;
return player;
}
vector<string> getUserMatches(Document & request){
validateToken(request["usertoken"].GetString());
try{
PreparedStatement * prepstmt;
prepstmt = conn -> prepareStatement("select login from users where login like ?;");
string tomatch = request["data"][0].GetString();
tomatch += "%"; //Search not only for the matchreq, but for all the str beginning with it
prepstmt -> setString(1, tomatch);
ResultSet * rs;
rs = prepstmt -> executeQuery();
vector<string> strmatch;
while(rs->next()){
strmatch.push_back(rs->getString("login"));
}
return strmatch;
}
catch(exception e){
throw 2;
}
}
/**
* displaying all the rows in the table
*/
void displayAllRows ()
{
string sqlStmt = "SELECT author_id, author_name FROM author_tab \
order by author_id";
stmt = conn->createStatement (sqlStmt);
ResultSet *rset = stmt->executeQuery ();
try{
while (rset->next ())
{
cout << "author_id: " << rset->getInt (1) << " author_name: "
<< rset->getString (2) << endl;
}
}catch(SQLException ex)
{
cout<<"Exception thrown for displayAllRows"<<endl;
cout<<"Error number: "<< ex.getErrorCode() << endl;
cout<<ex.getMessage() << endl;
}
stmt->closeResultSet (rset);
conn->terminateStatement (stmt);
}
void SimpleDataSet::read(int type){
openMysqlSession();
this->dataSet.clear();
ResultSet *resSet;
PreparedStatement *prep_stmt;
/* create a statement object */
prep_stmt = con -> prepareStatement("SELECT * FROM `SimpleDataSet` WHERE `compression_rate`=? AND `num_clusters`=? AND `type`=?");
prep_stmt->setInt(1, compressionRate);
prep_stmt->setInt(2, numClusters);
prep_stmt->setInt(3, type);
resSet = prep_stmt->executeQuery();
while (resSet->next()) {
std::stringstream datastream(resSet->getString("sequence"));
//for each loop we save one sequence
vector<int> sequence;
while (!datastream.eof()) {
int state;
datastream >> state;
sequence.push_back(state);
}
SimpleData newSD;
newSD.sequence=sequence;
newSD.idAction=resSet->getInt("id_action");
this->dataSet.push_back(newSD);
}
delete resSet;
delete prep_stmt;
closeMysqlSession();
cout<<"SimpleData readad: "<<this->dataSet.size()<<" data, each sequence length:"<<this->dataSet[0].sequence.size()<<endl;
}
