1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setHostName("localhost");
db.setUserName("root");
db.setPassword("");
db.setDatabaseName("GestionTicket");
if(db.open())
{
QMessageBox::information(this,"","Vous êtes maintenant connecté à "+db.hostName());
QSqlQuery query;
if( query.exec("create table artists (id int primary key, ""artist varchar(40)," "albumcount int)"))
{
QMessageBox::information(this,"","done");
}
else
QMessageBox::information(this,"","erreur");
if( query.exec("insert into mytable(data,data1,data2) values ('da','da','da');")){
QMessageBox::information(this,"","done");
}
else
QMessageBox::information(this,"","erreur");
db.close();
} |
Partager