SIGNAL(delete_sucess())。

QIcon("1.ico"));_Item2=new QTreeWidgetItem(_treeWidget);_Item2-setText(0，this-height());}void Administrater::slotAction2(){Delete *w2=new Delete;w2-show();connect(w2，messageBox，"你输入的资料不完整"。

255，600。

"温馨提示"，"该分组下无该用户"。

"温馨提示"。

SLOT(close()));emit delete_sucess();}else{QMessageBox *messageBox=new QMessageBox(QMessageBox::Information。

下面贴代码： Administrater::Administrater(QWidget *parent): QMainWindow(parent){QSqlDatabase Administrater=QSqlDatabase::addDatabase("QSQLITE");Administrater.setDatabaseName("Administrater.db");Administrater.open();_query=QSqlQuery(Administrater);_query.prepare("create table goldVip(name varchar(20)，"黄金vip");// _Item-setCheckState(0。

QIcon("2.ico"));_Item3=new QTreeWidgetItem(_treeWidget);_Item3-setText(0，写了一个基于sqlite的数据库打点小软件，ui(new Ui::Delete){ui-setupUi(this);}Delete::~Delete(){delete ui;}void Delete::on_pushButton_clicked(){QString str=ui-lineEdit-text();QString str2="delete from ";QString str3=" where\'")+str+QString("\'");QSqlQuery query;query.prepare(str4);if(query.exec()){QMessageBox *messageBox=new QMessageBox(QMessageBox::Information，QIcon("1.ico"));int i=0;_query.prepare("select * from goldVip");_query.exec();while(i_a){_query.next();QTreeWidgetItem *Item=new QTreeWidgetItem;Item-setText(0，sex varchar(10)，"普通vip");_Item2-setIcon(0，SLOT(close()));emit add_sucess();}else{qDebug()"falied";}}void Deal::on_comboBox_activated(int s){if(ui-lineEdit-text().isEmpty()|ui-lineEdit_2-text().isEmpty()|ui-lineEdit_3-text().isEmpty()){QMessageBox::information(this，this， 207);");ui-lineEdit_2-setStyleSheet("background-color: rgb(188，"温馨提示"，this，SIGNAL(activated(int))，SLOT(slotAction2()));connect(Action3，int index)));_Item2=new QTreeWidgetItem(_treeWidget);_Item2-setText(0，messageBox，SIGNAL(triggered(bool))，QIcon("3.ico"));i=0;_query.prepare("select * from Coustomer");_query.exec();while(i_c){_query.next();QTreeWidgetItem *Item=new QTreeWidgetItem;Item-setText(0，QMessageBox::Ok);}QString str=ui-lineEdit-text();QString str2="select * from "+_Str+QString(" where\'")+str+QString("\'");QSqlQuery query;query.prepare(str2);if(query.exec()){query.next();if(query.value(0).toString().isEmpty()){QMessageBox::warning(this。

"温馨提示"。

Qt::green);this-setPalette(pal);}Find::~Find(){delete ui;}void Find::on_pushButton_clicked(){if(_Str.isEmpty()){QMessageBox::information(this，QIcon("2.ico"));i=0;_query.prepare("select * from Vip");_query.exec();while(i_b){_query.next();QTreeWidgetItem *Item=new QTreeWidgetItem;Item-setText(0，this-width()，_query.value(0).toString());_Item3-addChild(Item);++i;}}#include "Deal.h"#include "ui_Deal.h"#includeQtSql/QSqlDatabase#includeQSqlQuery#includeQDebug#includeQComboBox#includeQMessageBoxDeal::Deal(QWidget *parent) :QWidget(parent)，"添加乐成"，0，SIGNAL(itemClicked(QTreeWidgetItem *Item。

"删除乐成"， 207);");ui-lineEdit_3-setStyleSheet("background-color: rgb(188，SLOT(slotAction3()));}Administrater::~Administrater(){}void Administrater::resizeEvent(QResizeEvent *){_treeWidget-setGeometry(0，this，"温馨提示："， 162);");connect(w，QMessageBox::Ok);}}void Delete::on_comboBox_activated(int index){if(index==0){_Str="goldVip";}else if(index==1){_Str="Vip";}else if(index==2){_Str="Coustomer";}} #include "Find.h"#include "ui_Find.h"#includeQSqlQuery#includeQMessageBox#includeQPaletteFind::Find(QWidget *parent) :QWidget(parent)。

添加删除实质上是对数据库在操纵，不想写太多成果，this，_query.value(0).toString());_Item-addChild(Item);++i;}// connect(_Item，_query.value(0).toString());_Item2-addChild(Item);++i;}i=0;_query.prepare("select * from Coustomer");_query.exec();while(i_c){_query.next();QTreeWidgetItem *Item=new QTreeWidgetItem;Item-setText(0，将名字以treewidgetItem显示出来， 闲来无事，"普通vip");_Item2-setIcon(0，ui(new Ui::Find){ui-setupUi(this);_lists"姓名：""性别：""ID:";QPalette pal=this-palette();pal.setBrush(QPalette::Background， 207);");}Deal::~Deal(){delete ui;}void Deal::on_pushButton_clicked(){QSqlQuery query;QString str=ui-lineEdit-text();QString str2=ui-lineEdit_2-text();QString str3=ui-lineEdit_3-text();if(_Kind.isEmpty()){QMessageBox::information(this， ，this);QAction *Action3=new QAction("查询"，int index))，QMessageBox::Ok);messageBox-show();_timer=new QTimer(this);_timer-start(1200);connect(_timer，int index))，"你未选择客户范例"，")+QString("\'")+str2+QString("\'")+QString("，400);_treeWidget = new QTreeWidget(this);_treeWidget-setColumnCount(1);_treeWidget-setHeaderLabel("接洽人");_treeWidget-setStyleSheet("color: blue;""background-color: yellow;""selection-color: yellow;""selection-background-color: blue;");_Item=new QTreeWidgetItem(_treeWidget);_Item-setText(0，QMessageBox::Ok);}if(s==0){_Kind="goldVip";}else if(s==1){_Kind="Vip";}else if(s==2){_Kind="Coustomer";}} #include "Delete.h"#include "ui_Delete.h"#includeQSqlQuery#includeQDebug#includeQMessageBox#includeQTimer#includeQPaletteDelete::Delete(QWidget *parent) :QWidget(parent)。

252，ID char(20))");_query.exec();_query.prepare("select count(*) from goldVip");_query.exec();_query.next();_a=_query.value(0).toInt();_query.prepare("select count(*) from Vip");_query.exec();_query.next();_b=_query.value(0).toInt();_query.prepare("select count(*) from Coustomer");_query.exec();_query.next();_c=_query.value(0).toInt();this-setGeometry(400，SIGNAL(timeout())，this，"温馨提示"，"该数据库查无此人"。

SLOT(update_show()));}void Administrater::slotAction3(){Find *w3=new Find;w3-show();}void Administrater::update_show(){delete _Item;delete _Item2;delete _Item3;_Item=new QTreeWidgetItem(_treeWidget);_Item-setText(0，SIGNAL(triggered(bool))。

SIGNAL(timeout())，this);QListQAction *_list;_listActionAction2Action3;menuBar-addActions(_list);connect(Action，SLOT(on_comboBox_activated(int d)));this-setStyleSheet("QLineEdit{background-color: red}");ui-lineEdit-setStyleSheet("background-color: rgb(188。

sex varchar(10)，"黄金vip");// _Item-setCheckState(0，SLOT(update_show()));}void Administrater::slotAction(){Deal *w=new Deal;w-show();w-setStyleSheet("background-color: rgb(255，"你还没有选者客户分类"，QMessageBox::Ok);return;}while(!query.value(0).toString().isEmpty()){for(int i=0;i3;++i){ui-textBrowser-append(_lists.at(i)+query.value(i).toString());}query.next();}}else{QMessageBox *messageBox=new QMessageBox(QMessageBox::Information，"告诫"，ID char(20))");_query.exec();_query.prepare("create table Vip(name varchar(50)。

ID char(20))");_query.exec();_query.prepare("create table Coustomer(name varchar(20)， 255，"告诫"，SIGNAL(add_sucess())，int index)));i=0;_query.prepare("select * from Vip");_query.exec();while(i_b){_query.next();QTreeWidgetItem *Item=new QTreeWidgetItem;Item-setText(0， Qt::Checked);//复选框_Item-setIcon(0，SIGNAL(itemClicked(QTreeWidgetItem *Item，//SLOT(slotItem(QTreeWidgetItem *Item，sex varchar(10)，QIcon("3.ico"));_query.prepare("select count(*) from goldVip");_query.exec();_query.next();_a=_query.value(0).toInt();_query.prepare("select count(*) from Vip");_query.exec();_query.next();_b=_query.value(0).toInt();_query.prepare("select count(*) from Coustomer");_query.exec();_query.next();_c=_query.value(0).toInt();// _Item-removeChild();int i=0;_query.prepare("select * from goldVip");_query.exec();while(i_a){_query.next();QTreeWidgetItem *Item=new QTreeWidgetItem;Item-setText(0，this，"该分组下无该用户"， Qt::Checked);//复选框_Item-setIcon(0，QMessageBox::Ok);messageBox-show();QTimer *timer=new QTimer(this);timer-start(1200);connect(timer，//SLOT(slotItem(QTreeWidgetItem *Item，SLOT(slotAction()));connect(Action2。

先上图 中心思想就是： 建设一个数据库 然后每一个分组对应一个数据表 然后遍历该数据表，this，写多了就成了数据库的桌面打点版了（嘻嘻恶作剧的题外话），"普通客户");_Item3-setIcon(0，"普通客户");_Item3-setIcon(0， 255，QMessageBox::Ok);return;}QString str4=QString("insert into ")+_Kind+QString(" values(")+QString("\'")+str+QString("\'")+QString("，SIGNAL(triggered(bool))，QMessageBox::Ok);}}void Find::on_comboBox_activated(int index){if(index==0){_Str="goldVip";}else if(index==1){_Str="Vip";}else if(index==2){_Str="Coustomer";}} 顺便提一句 sqlite是没有表头的 所以用query去提取数据时 先next下才有数据的哈，this);QAction *Action2=new QAction("删除"，ui(new Ui::Deal){ui-setupUi(this);connect(ui-comboBox，_query.value(0).toString());_Item3-addChild(Item);++i;}//Administrater.close();QMenuBar *menuBar=QMainWindow::menuBar();this-setMenuBar(menuBar);QAction *Action=new QAction("添加"。

_query.value(0).toString());_Item2-addChild(Item);++i;}_Item3=new QTreeWidgetItem(_treeWidget);_Item3-setText(0，200。

")+QString("\'")+str3+QString("\'")+QString(")");query.prepare(str4);if(query.exec()){QMessageBox *messageBox=new QMessageBox(QMessageBox::Information，_query.value(0).toString());_Item-addChild(Item);++i;}// connect(_Item，。