QStringList strings;
if(db.isOpen())
{
QSqlQuery query("SELECT goodsno,caw FROM ct_goods");
while (query.next()) {
QString goodsno = query.value(0).toString();
strings.append(goodsno);
}
completer = new QCompleter(strings, this);
ui->comboBox->clear();
ui->comboBox->addItems(strings);
ui->comboBox->setCompleter(completer);
}