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> |
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); |
26 |
bool opendatabase(); |
27 |
28 |
bool insert(QString &table, QStringList &names,QStringList &values); |
29 |
30 |
bool Updata(QString &table, QStringList &names,QStringList &values, QString &expression); |
31 |
32 |
bool del(QString &table, QString &expression); |
33 |
34 |
void GetValues(QString &table, QStringList &values); |
35 |
private: |
36 |
QSqlTableModel *model; |
37 |
QSqlDatabase _db; |
38 |
QString _tableName; |
39 |
40 |
}; |
41 |
42 |
#endif // MYDATA_H |
001 |
/**************************************************************************** |
002 |
** |
003 |
** Copyright (C) 2013 C,g |
004 |
** All rights reserved. |
005 |
** Contact: 1213125967@qq.com |
006 |
** Please keep the author contact information. |
007 |
** 2013-10-31 |
008 |
** |
009 |
****************************************************************************/ |
010 |
#include <QtSql/QSqlQuery> |
011 |
#include <QObject> |
012 |
#include "mydata.h" |
013 |
014 |
mydata::mydata(QObject *parent) : |
015 |
QObject(parent) |
016 |
{ |
017 |
018 |
} |
019 |
020 |
mydata::~mydata() |
021 |
{ |
022 |
_db.close(); |
023 |
} |
024 |
025 |
void mydata::SetTableName(QString table) |
026 |
{ |
027 |
_tableName = table + ".db"; |
028 |
} |
029 |
030 |
/* |
031 |
打开数据库. |
032 |
*/ |
033 |
bool mydata::opendatabase() |
034 |
{ |
035 |
_db = QSqlDatabase::addDatabase("QSQLITE"); |
036 |
_db.setDatabaseName(_tableName); |
037 |
return _db.open(); |
038 |
} |
039 |
040 |
/* |
041 |
插入函数. |
042 |
构造SQL插入语句. |
043 |
*/ |
044 |
bool mydata::insert(QString &table, QStringList &names, QStringList &values) |
045 |
{ |
046 |
if (names.size() != values.size()) |
047 |
{ |
048 |
return false; |
049 |
} |
050 |
051 |
QSqlQuery query(QSqlDatabase::database()); |
052 |
053 |
QString sql = QString("insert into ") + table + QString("("); |
054 |
055 |
int i; |
056 |
057 |
for (i=0; i < names.size(); i++) |
058 |
{ |
059 |
sql = sql + names.value(i); |
060 |
if (i != names.size() - 1) |
061 |
{ |
062 |
sql+=QString(","); |
063 |
} |
064 |
else |
065 |
{ |
066 |
067 |
sql = sql + QString(")"); |
068 |
} |
069 |
} |
070 |
071 |
sql = sql + QString("values ("); |
072 |
073 |
for (i = 0; i < values.size(); i++) |
074 |
{ |
075 |
sql = sql + QString("‘") + values.value(i) + QString("‘"); |
076 |
if (i != values.size()-1) |
077 |
{ |
078 |
sql = sql + QString(","); |
079 |
} |
080 |
} |
081 |
082 |
sql = sql + QString(")"); |
083 |
084 |
if (query.exec(sql)) |
085 |
{ |
086 |
return true; |
087 |
} |
088 |
else |
089 |
{ |
090 |
return false; |
091 |
} |
092 |
} |
093 |
094 |
/* |
095 |
修改函数. |
096 |
构造SQL修改语句. |
097 |
*/ |
098 |
bool mydata::Updata(QString &table, QStringList &names, QStringList &values, QString &expression) |
099 |
{ |
100 |
if (names.size() != values.size()) |
101 |
{ |
102 |
return false; |
103 |
} |
104 |
105 |
//UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值 |
106 |
QSqlQuery query(QSqlDatabase::database()); |
107 |
QString sql = QString("update ")+table+QString(" set "); |
108 |
for (int i = 0; i < names.size(); i++) |
109 |
{ |
110 |
sql = sql + names.value(i); |
111 |
sql = sql + QString(" = ‘"); |
112 |
sql = sql + values.value(i); |
113 |
sql = sql + QString("‘"); |
114 |
if (i != names.size()-1) |
115 |
{ |
116 |
sql = sql + QString(" ,"); |
117 |
} |
118 |
} |
119 |
120 |
sql = sql + QString(" where ") + expression; |
121 |
if (query.exec(sql)) |
122 |
{ |
123 |
return true; |
124 |
} |
125 |
else |
126 |
{ |
127 |
return false; |
128 |
} |
129 |
} |
130 |
131 |
/* |
132 |
删除函数. |
133 |
构造SQL删除语句. |
134 |
*/ |
135 |
bool mydata::del(QString &table, QString &expression) |
136 |
{ |
137 |
//DELETE FROM 表名称 WHERE 列名称 = 值 |
138 |
QSqlQuery query(QSqlDatabase::database()); |
139 |
QString sql = QString("delete from ") + table + QString(" where ") + expression; |
140 |
141 |
if (query.exec(sql)) |
142 |
{ |
143 |
return true; |
144 |
} |
145 |
else |
146 |
{ |
147 |
return false; |
148 |
} |
149 |
} |
150 |
151 |
void mydata::GetValues(QString &table, QStringList &values) |
152 |
{ |
153 |
QSqlQuery query(QSqlDatabase::database()); |
154 |
QString sql = QString("select * from ") + table; |
155 |
query.exec(sql); |
156 |
while (query.next()) |
157 |
{ |
158 |
values << query.value(0).toString(); |
159 |
} |
160 |
} |
基于sqlite的Qt 数据库封装,布布扣,bubuko.com
原文：http://www.cnblogs.com/lvdongjie/p/3758575.html