bool DBService::updateCarInfo_tb(const CarInfo_tb& carInfo) { bool res = false; if(!database.open()) { qDebug()<<database.lastError(); return res; } else { QSqlQuery sql_query(database); QString update_sql("update tb_car_info set slm1=?,slm2=? where car_name=?"); sql_query.prepare(update_sql); sql_query.addBindValue(carInfo.slm1); sql_query.addBindValue(carInfo.slm2); sql_query.addBindValue(carInfo.carName); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { qDebug()<<"updated!"; res = true; } } database.close(); return res; }
bool DBService::updateCarNuMap_tb(const CarNuMap_tb& carNuMap) { bool res = false; if(!database.open()) { qDebug()<<database.lastError(); return res; } else { QSqlQuery sql_query(database); QString update_sql("update tb_car_nu_map set car_nu_l=?,car_nu_g=? where car_name=?"); sql_query.prepare(update_sql); sql_query.addBindValue(carNuMap.car_nu_l); sql_query.addBindValue(carNuMap.car_nu_g); sql_query.addBindValue(carNuMap.carName); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { qDebug()<<"updated!"; res = true; } } database.close(); return res; }
bool DBService::insertCarInfo_tb(const CarInfo_tb& carInfo) { bool res = false; if(!database.open()) { qDebug()<<database.lastError(); return res; } else { QSqlQuery sql_query(database); QString update_sql("insert into tb_car_info (slm1,slm2,car_name) values(?,?,?);"); sql_query.prepare(update_sql); sql_query.addBindValue(carInfo.slm1); sql_query.addBindValue(carInfo.slm2); sql_query.addBindValue(carInfo.carName); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { qDebug()<<"inserted!"; res = true; } } database.close(); return res; }
bool DBService::insertCarNuMap_tb(const CarNuMap_tb& carNuMap) { bool res = false; if(!database.open()) { qDebug()<<database.lastError(); return res; } else { QSqlQuery sql_query(database); QString update_sql("insert into tb_car_nu_map (car_nu_l,car_nu_g,car_name) values(?,?,?);"); sql_query.prepare(update_sql); sql_query.addBindValue(QString::number(carNuMap.car_nu_l)); sql_query.addBindValue(QString::number(carNuMap.car_nu_g)); sql_query.addBindValue(carNuMap.carName); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { qDebug()<<"inserted!"; res = true; } } database.close(); return res; }
int do_change_passwd_cmd(char* buf,struct tcp_param *p)//login data order : 用户名长度用户名,密码长度 密码 { int username_size = buf[1]; int passwd_size = buf[2]; int new_passwd_size = buf[3]; char cmd[100]; char user_name[20]; char user_passwd[20]; char service_passwd[20]; char datalength[2]; int cnt; //if(buf[0] !=2 )return -1; // printf("do change passwd\n"); memcpy(user_name,&buf[4],username_size); user_name[username_size] = '\0'; memcpy(user_passwd,&buf[4+username_size],passwd_size); user_passwd[passwd_size] = '\0'; snprintf(cmd,100,"select pass_wd from user where user_name=\"%s\";",user_name); printf("cmd=%s\n",cmd); if((cnt = query_sql(cmd,service_passwd,datalength)) == 1) { printf("username %s\n",user_passwd); printf("service_pass %s\n",service_passwd); if(!strcmp(user_passwd,service_passwd)) { printf("here we can change passwd\n"); memcpy(user_passwd,&buf[4+username_size+passwd_size],new_passwd_size);//put new passwd to there. snprintf(cmd,100,"update user set pass_wd=\"%s\" where user_name=\"%s\";",user_passwd,user_name); printf("new pass cmd = %s\n",cmd); cnt = update_sql(cmd); if(cnt == 0)cnt = send_ok_toclient(p->fd,NULL,0); if(cnt)printf("send ok error\n"); } } return cnt; }