学步园

第一步：安装qt开发环境

xhy@xhy-desktop:~$sudo apt-get install qt4-dev-tools qt4-doc qt4-qtconfig qt4-demos qt4-designer

第二步：安装mysql开发环境

xhy@xhy-desktop:~$sudo apt-get install mysql-server mysql-client

xhy@xhy-desktop:~$sudo apt-get install libmysqlclient15-dev

xhy@xhy-desktop:~$sudo apt-get install libqt4-sql-mysql

xhy@xhy-desktop:~$sudo /etc/init.d/mysql restart

第三步：给普通用户授权操作数据库
xhy@xhy-desktop:~$ mysql -u root -p      (root登录数据库)
mysql> create database mydb;                     (创建一个数据库)
mysql> grant all privileges on *.* to username@localhost identified by 'password';
mysql> quit;
给特定用户分配数据操作权限的格式是:
grant 权限1,权限2,...权限n on 数据库名称.表名称 to 用户名@用户ip地址 identified by '密码';

 第四步：测试环境

#include <QApplication><br /> #include <QtSql><br /> #include <QTableView><br /> #include <iostream></p> <p>using namespace std;</p> <p>int main(int argc, char *argv[])<br /> {<br /> QApplication app(argc, argv);</p> <p> QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");<br /> db.setHostName("localhost");<br /> db.setDatabaseName("mydb");<br /> db.setUserName("username");<br /> db.setPassword("password");<br /> db.open();</p> <p> QSqlQuery query;<br /> query.exec("create table hello(id bigint not null auto_increment,name varchar(255),age bigint,primary key (id))");<br /> query.exec("insert into hello(name, age) values('xiaoxi', 18)");<br /> query.exec("insert into hello(name, age) values('xiaonan', 19)");<br /> query.exec("insert into hello(name, age) values('xiaobei', 20)");<br /> query.exec("insert into hello(name, age) values('xiaodong', 21)");</p> <p> QSqlQueryModel *model = new QSqlQueryModel;<br /> model->setQuery("select * from hello");<br /> model->setHeaderData(0, Qt::Horizontal, "id");<br /> model->setHeaderData(1, Qt::Horizontal, "name");<br /> model->setHeaderData(2, Qt::Horizontal, "age");<br /> QTableView *view = new QTableView;<br /> view->setWindowTitle("QSqlQueryModel");<br /> view->setModel(model);<br /> view->show();</p> <p> db.close();<br /> return app.exec();<br /> }</p> <p>

编译：

xhy@xhy-desktop:~$ qmake -project

xhy@xhy-desktop:~$ qmake

一定别忘了在工程的.pro文件里加上下面一行:

QT += sql

xhy@xhy-desktop:~$make

xhy@xhy-desktop:~$./mysql