基于sqlite的Qt 数据库封装 - 开源中国社区
}
sql = sql + QString(" where ") + expression; if (query.exec(sql)) {
return true; } else {
return false; } }
/* 删除函数. 构造SQL删除语句.
int i;
基于sqlite的Qt 数据库封装 - 开源中国社区
for (i=0; i < names.size(); i++) {
sql = sql + names.value(i); if (i != names.size() - 1) {
sql+=QString(","); } else {
sql = sql + QString(")"); } }
代码片段(2)
顶0 踩
[全屏查看所有代码]
1. [代码]mydata.h
1 /************************************************************************?****
2 **
3 ** Copyright (C) 2013 C,g
4 ** All rights reserved.
if (names.size() != values.size()) {
return false; }
//UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值 QSqlQuery query(QSqlDatabase::database()); QString sql = QString("update ")+table+QString(" set "); for (int i = 0; i < names.size(); i++) {
17 #include <QtSql/QSqlDatabase>
18
19 class mydata : public QObject
20 {
21
Q_OBJECT
22 public:
23
explicit mydata(QObject *parent = 0);
24
~mydata();
25
void SetTableName(QString table);
*/ bool mydata::del(QString &table, QString &expression) {
//DELETE FROM 表名称 WHERE 列名称 = 值 QSqlQuery query(QSqlDatabase::database()); QString sql = QString("delete from ") + table + QString(" where ") + expre
sql = sql + QString(","); } }
sql = sql + QString(")");
if (query.exec(sql)) {
return true; } else {
return false; } }
/* 修改函数. 构造SQL修改语句.
*/ bool mydata::Updata(QString &table, QStringList &names, QStringList &values, Q {
if (query.exec(sql)) {
return true; } else {
return false; } }
void mydata::GetValues(QString &table, QStringList &values) {
QSqlQuery query(QSqlDatabase::database()); QString sql = QString("select * from ") + table; query.exec(sql); while (query.next()) {
26
bool opendatabase();
27
28
bool insert(QString &table, QStringList &names,QStringList &values);
29
30
bool Updata(QString &table, QStringList &names,QStringList &values, QString
8 **
9 ****************************************************************************/
10 #include <QtSql/QSqlQuery>
11 #include <QObject>
12 #include "mydata.h"
10 #ifndef MYDATA_H
11 #define MYDATA_H
12 #include <QObject>
13 #include <QString>
14 #include <QtSql/QSqlTableModel>
15 #include <QtSql/QSqlQuery>
16 #include <QStringList>
3/7
15-6-1
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
sql = sql + QString("values (");
for (i = 0; i < values.size(); i++) {
sql = sql + QString("'") + values.value(i) + QString("'"); if (i != values.size()-1) {
5 ** Contact: 1213125967@
6 ** Please keep the author contact information.
7 ** 2013-10-31
8 **
9 ****************************************************************************/
2 **
3 ** Copyright (C) 2013 C,g
4 ** All rights reserved.
5 ** Contact: 1213125967@
6 ** Please keep the author contact information.
7 ** 2013-10-31
sql = sql + names.value(i); sql = sql + QString(" = '"); sql = sql + values.value(i); sql = sql + QString("'"); if (i != names.size()-1) {
sql = sql + QString(" ,"); }
26 {
27
_tableName = table + ".db";
28 }
29
30 /*
31
打开数据库.
32 */
33 bool mydata::opendatabase()
34 {
35
_db = QSqlDatabase::addDatabase("QSQLITE");
36
_db.setDatabaseName(_tableName);
47
{
48
return false;
49
}ery query(QSqlDatabase::database());
52
53
QString sql = QString("insert into ") + table + QString("(");
54
/code/snippet_237375_26033
/code/snippet_237375_26033
4/7
15-6-1
118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
13
14 mydata::mydata(QObject *parent) :