#include?“db.h“
#include
#include

#include
#include?“stdio.h“
#include?“string.h“
#include?
using?namespace?std;
sqlite3*?DB::db=NULL;
DB::DB（）
{
????stmt?=?NULL;
????result?=?NULL;
}


//打開數(shù)據(jù)庫(kù)
int?DB::db_open（char?*sql_adr）
{
????int?ret;
????ret?=?sqlite3_open（sql_adr?&db）;
????if（ret?!=?0）
????{
????????perror（“sqlite3_open“）;
????????cout<????????return?ret;
????}
????cout<<“open=“<????return?0;

}

//關(guān)閉數(shù)據(jù)庫(kù)
int?DB::db_close（）
{
????int?ret;
????if（stmt?!=?NULL）
????????sqlite3_finalize（stmt）;
????if（result?!=?NULL）
????????sqlite3_free_table（result）;
????ret?=?sqlite3_close（db）;
????if（ret?!=?0）
????????return?-1;
????return?0;
}
//prepare（）數(shù)據(jù)庫(kù)
int?DB::db_prepare（char?*sql）
{
????int?ret;
????ret?=?sqlite3_prepare（db?sql?-1?&stmt?NULL）;
????if（ret?!=?0）
????{
????????return?ret;
????}
????return?0;
}



//step（）數(shù)據(jù)庫(kù)
int?DB::db_step（）
{
????int?ret;
????ret=sqlite3_step（stmt）;
????return?ret;
}
//finalize（）數(shù)據(jù)庫(kù)
int?DB::db_finalize（）
{
????int?ret;
????ret=sqlite3_finalize（stmt）;
????return?ret;
}
//get（）數(shù)據(jù)庫(kù)
int?DB::db_gettable?（char?*sql）
{
????int?ret;
????ret=sqlite3_get_table（dbsql&result&row&column0）;
????if（ret?!=?0）
????????return?ret;
}


//exec（）數(shù)據(jù)庫(kù)
int?DB::db_exec（char?*sql）
{
????int?ret;
????ret?=?sqlite3_exec（db?sql?NULL?NULL?NULL）;
????if（ret?!=?0）
????{
????????printf（“illegality?SQL?statemen“）;
????????return?ret;
????}
????cout<????return?0;

}



//填充table數(shù)據(jù)表
int?DB::db_tablefill（QTableWidget*?table）
?{
?????int?i;
?????int?rowtmp=0;

?????table->setRowCount（0）;
?????table->insertRow（rowtmp）;???//插入第一行

?????for（i=column;i<（row+1）*（column）;i++）
?????{
?????????table->setItem?（rowtmpi%columnnew?QTableWidgetItem（result[i]））;//寫入第一行數(shù)據(jù)
?????????if（（i+1）%column==0&&rowtmp?????????{
?????????????table->insertRow（++rowtmp）;//第一行滿后，插入第二行
?????????}
?????}
?}

void?DB::db_freetable（）
{
???sqlite3_free_table?（result）;
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????465??2014-07-15?20:00??xiangmu\banksystem\banksystem.pro

?????文件??????18230??2014-07-21?11:47??xiangmu\banksystem\banksystem.pro.user

?????文件??????17948??2014-07-20?19:00??xiangmu\banksystem\banksystem.pro.user.16a7e05

?????文件???????9637??2014-07-18?10:45??xiangmu\banksystem\jiaohao.cpp

?????文件???????1717??2014-07-18?10:12??xiangmu\banksystem\jiaohao.h

?????文件???????4003??2014-07-08?15:39??xiangmu\banksystem\jiaohao.ui

?????文件????????611??2014-07-15?22:08??xiangmu\banksystem\main.cpp

?????文件????????233??2014-07-08?10:04??xiangmu\banksystem\mainwindow.cpp

?????文件????????313??2014-07-08?10:04??xiangmu\banksystem\mainwindow.h

?????文件????????989??2014-07-15?21:01??xiangmu\banksystem\mainwindow.ui

?????文件?????117337??2013-06-28?08:26??xiangmu\banksystem\qt_zh_CN.qm

?????文件??????????0??2014-07-09?08:58??xiangmu\banksystem\qt_zh_CN.qrc

?????文件??????????0??2014-07-09?08:49??xiangmu\banksystem\qt_zh_CN.txt

?????文件???????3613??2014-07-15?23:23??xiangmu\banksystem\uuu.h

?????文件??????17955??2014-07-11?14:00??xiangmu\banksystem?111111\banksystem.pro.user

?????文件????????472??2014-07-11?14:00??xiangmu\banksystem?111111\banksystem1.pro

?????文件??????17948??2014-07-20?19:00??xiangmu\banksystem?111111\banksystem1.pro.user

?????文件???????9197??2014-07-18?10:21??xiangmu\banksystem?111111\jiaohao.cpp

?????文件???????1694??2014-07-18?10:12??xiangmu\banksystem?111111\jiaohao.h

?????文件???????4003??2014-07-08?15:39??xiangmu\banksystem?111111\jiaohao.ui

?????文件????????721??2014-07-11?12:30??xiangmu\banksystem?111111\main.cpp

?????文件????????233??2014-07-08?10:04??xiangmu\banksystem?111111\mainwindow.cpp

?????文件????????313??2014-07-08?10:04??xiangmu\banksystem?111111\mainwindow.h

?????文件????????654??2014-07-08?10:04??xiangmu\banksystem?111111\mainwindow.ui

?????文件?????117337??2013-06-28?08:26??xiangmu\banksystem?111111\qt_zh_CN.qm

?????文件??????????0??2014-07-09?08:58??xiangmu\banksystem?111111\qt_zh_CN.qrc

?????文件??????????0??2014-07-09?08:49??xiangmu\banksystem?111111\qt_zh_CN.txt

?????文件???????3613??2014-07-15?23:28??xiangmu\banksystem?111111\uuu.h

?????文件??????17955??2014-07-11?14:00??xiangmu\banksystem?2222222\banksystem.pro.user

?????文件??????17949??2014-07-18?10:41??xiangmu\banksystem?2222222\banksystem1.pro.user

............此處省略106個(gè)文件信息