javascript 封装Qt sql API
/**
* Provides a connection to a SQLite database.
*
* \param connectionName The connection name to use.
*/
function DbConnection(connectionName) {
if (isNull(connectionName)) {
return;
}
this.db = QSqlDatabase.database(connectionName, false);
}
DbConnection.prototype.dump = function() {
var query = this.createQuery();
query.execQuery(".dump");
};
DbConnection.prototype.transaction = function() {
this.db.transaction();
};
DbConnection.prototype.commit = function() {
this.db.commit();
};
DbConnection.prototype.rollback = function() {
this.db.rollback();
};
/**
* Executes the given QSqlQuery or SQL string and handles errors if appropriate.
*/
DbConnection.prototype.execQuery = function(query) {
try {
var ret = false;
if (isString(query)) {
var sql = query;
query = new QSqlQuery(this.db);
ret = query.exec(sql);
}
else {
ret = query.exec();
}
if (!ret) {
qCritical("DbConnection.js:", "execQuery(): error:", query
.lastError().text());
qCritical("DbConnection.js:", "execQuery(): query failed:\n", query
.executedQuery());
debugger;
}
} catch (e) {
qCritical("DbConnection.js:", "execQuery(): exception:", e);
debugger;
}
return query;
};
/**
* \return New QSqlQuery object.
*/
DbConnection.prototype.createQuery = function() {
return new QSqlQuery(this.db);
};
DbConnection.prototype.prepareQuery = function(sql) {
var query = new QSqlQuery(this.db);
var ret = query.prepare(sql);
if (!ret) {
qCritical("DbConnection.js:", "prepareQuery(): SQL prepare failed:\n",
sql, "\n", query.lastError().text());
debugger;
}
return query;
};
DbConnection.prototype.vacuum = function(sql) {
var query = this.createQuery();
query.exec("VACUUM");
};
/**
* Converts the given QPixmap into a QByteArray for storage in a BLOB.
*/
DbConnection.pixmapToByteArray = function(pixmap) {
if (pixmap == undefined || pixmap == null) {
return null;
}
var ba = new QByteArray();
var buffer = new QBuffer(ba);
buffer.open(QIODevice.WriteOnly);
pixmap.save(buffer, "PNG"); // writes pixmap into ba in PNG format
return ba;
};