随机生成商品编号(qt+mysql)

随机生成商品编号(qt+mysql)

//2.自动生成编号按钮
void AddCommodity::on_toolButton_auto_clicked()
{
    //商品编号   "SP"+"当前年份"+"1-10000以内的五位数字(不足前面补0)"
    qsrand(QTime(0,0,0).secsTo(QTime::currentTime()));//设置随机数种子
    QDate date(QDate::currentDate());
    int year = date.year(); //获取当前年份
    QString id1 = QString("%1").arg(year); //将int型转化为string
    int n = qrand() % 10000;  //产生1000以内的随机数
    QString id2 = QString("%1").arg(n,5,10,QLatin1Char('0'));

    QString id = "SP" + id1 + id2;
    //查重
    QSqlDatabase db;
    QSqlQuery query(db);

    QString sqlCode,_id,_id2; //_id用于查重
    int _n;
    int flag = 1; //设置一个查询标志
    sqlCode = "SELECT commodity_id FROM commodity";
    query.exec(sqlCode);
    while(flag == 1)
    {
        while(query.next())
        {
            if(query.value("commodity_id").toString() == id)//若找到则flag = 1 ，跳出循环，再次查重
            {
                _n = qrand() % 10000;
                _id2 = QString("%1").arg(_n,5,10,QLatin1Char('0'));
                _id = "SP" + id1 + _id2;
                id = _id;  //更新id
                flag = 1;
                break;
            }
            else//若不一样，则flag=0，直到查询完整个表，若flag还是0，则跳出外循环
            {
                flag = 0;
            }
        }
    }
    qDebug() << id;
    ui->lineEdit_id->setText(id);

}