LNDBkRtW

1Conndb conn;
2conn.open();
3
4QSqlQuery sql;
5sql.prepare("insert into [ECUP_DSS_DB].[dbo].[ContHistory] (HistID, NodeID)"
6            "values (?, ?)");
7
8QVariantList Hidval;
9Hidval << 2 << 2 << 1 << 8;
10sql.addBindValue(Hidval);
11
12QVariantList Nodeval;
13Nodeval << 2 << 2 << 1 << 8;
14sql.addBindValue(Nodeval);
15
16// QSqlTableModel * modal = new QSqlTableModel();
17
18if (!sql.execBatch()) {
19    qDebug() << sql.lastError();
20} else {
21    qDebug() << sql.executedQuery();
22}
23QSqlQueryModel * modal = new QSqlQueryModel();
24sql.exec();
25modal->setQuery(sql);
26ui->tableView->setModel(modal);
27conn.close();
28	
29QVariantList values;
30values << 1 << 2 << 3;
31
32QSqlQuery query;
33query.prepare("INSERT INTO numbers (number) VALUES(?)");
34query.addBindValue(values);
35
36if (!query.execBatch()) {
37    qDebug() << query.lastError();
38} else {
39    qDebug() << query.executedQuery();
40}
41	
42QSqlQueryModel* model = new QSqlQueryModel();
43model->setQuery("SELECT id, number FROM numbers");
44ui->tableView->setModel(model);
45	
46CREATE TABLE IF NOT EXISTS numbers (id INTEGER PRIMARY KEY AUTOINCREMENT, number INTEGER);