QVector<CarInfo_tb> DBService::getAllCarInfo_tb() { QVector<CarInfo_tb> carInfos; if(!database.open()) { qDebug()<<database.lastError(); return QVector<CarInfo_tb>(); } else { QString select_sql("select slm1,slm2,car_name from tb_car_info;"); QSqlQuery sql_query(database); sql_query.prepare(select_sql); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { while(sql_query.next()) { CarInfo_tb carInfo; carInfo.slm1 = sql_query.value(0).toString(); carInfo.slm2 = sql_query.value(1).toString(); carInfo.carName = sql_query.value(2).toString(); carInfo.isValid = true; carInfos.append(carInfo); } } } database.close(); return carInfos; }
CarInfo_tb DBService::getCarInfo_tb(const QString& carName) { CarInfo_tb carInfo; if(!database.open()) { qDebug()<<database.lastError(); carInfo.isValid = false; return carInfo; } else { QString select_sql("select slm1,slm2 from tb_car_info where car_name=?"); QSqlQuery sql_query(database); sql_query.prepare(select_sql); sql_query.addBindValue(carName); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { while(sql_query.next()) { carInfo.carName = carName; carInfo.slm1 = sql_query.value(0).toString(); carInfo.slm2 = sql_query.value(1).toString(); carInfo.isValid = true; break; } } } database.close(); return carInfo; }
int SqliteDao::init(const char* data_file) { int ret = 0; bool flag = false; if (!is_init_) { ret = sqlite3_open(data_file, &sqlite_); data_base_ = sqlite_; if (SQLITE_OK != ret) { COM_WRITELOG(COMLOG_WARNING, "sqlite open failed error [%s]", sqlite3_errmsg(sqlite_)); } else { int row_num = 0; db_mm::SchemaManager* schema_manager = table_manager_->get_schema_manager(); int table_num = schema_manager->get_table_num(); for (int i = 0; i < table_num; i++) { db_mm::TableIndex* table_index = table_manager_->get_table_index(i); db_mm::TableSchema* table_schema = schema_manager->get_table_schema(i); if (0 != (ret = select_sql(table_schema))) { COM_WRITELOG(COMLOG_WARNING, "in sqlite_dao, sql err,sql[%s], ret[%d]", sql_, ret); break; } else if (0 != (ret = get_data(table_schema, row_num))) { COM_WRITELOG(COMLOG_WARNING, "in sqlite_dao get_data error, ret[%d]", ret); //如果表不存在,继续 ret = 0; continue; } else { flag = true; table_index->set_row_num(row_num); } } } is_init_ = true; } if (!flag) { ret = -1; } return ret; }
int main(int argc, char* argv[]) { if(argc <2) { printf("select [select/insert]\n"); exit(1); } if(0 == strcmp(argv[1], "select")){ printf("execute select sql\n"); select_sql(); } else if(0 == strcmp(argv[1], "stores")){ printf("execute stores\n"); stores_sql(); } else if(0 == strcmp(argv[1], "insert")){ printf("execute insert the number is %d\n", atoi(argv[2])); insert_sql(atoi(argv[2])); } return 0; }
QVector<CarNuMap_tb> DBService::getAllCarNuMap_tb() { QVector<CarNuMap_tb> carNuMaps; if(!database.open()) { qDebug()<<database.lastError(); return QVector<CarNuMap_tb>(); } else { QString select_sql("select car_nu_l,car_nu_g,car_name from tb_car_nu_map;"); QSqlQuery sql_query(database); sql_query.prepare(select_sql); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { while(sql_query.next()) { CarNuMap_tb carNuMap; carNuMap.car_nu_l = sql_query.value(0).toInt(); carNuMap.car_nu_g = sql_query.value(1).toInt(); carNuMap.carName = sql_query.value(2).toString(); carNuMap.isValid = true; carNuMaps.append(carNuMap); } } } database.close(); return carNuMaps; }
CarNuMap_tb DBService::getCarNuMap_tb(const QString& carName) { CarNuMap_tb carNuMap; if(!database.open()) { qDebug()<<database.lastError(); carNuMap.isValid = false; return carNuMap; } else { QString select_sql("select car_nu_l,car_nu_g from tb_car_nu_map where car_name=?"); QSqlQuery sql_query(database); sql_query.prepare(select_sql); sql_query.addBindValue(carName); if(!sql_query.exec()) { qDebug()<<sql_query.lastError(); } else { while(sql_query.next()) { carNuMap.carName = carName; carNuMap.car_nu_l = sql_query.value(0).toInt(); carNuMap.car_nu_g = sql_query.value(1).toInt(); carNuMap.isValid = true; break; } } } database.close(); return carNuMap; }