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