人脸:
//源文件
#include "widget.h"
#include "ui_widget.h"
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
Mat src;//创建一个图像容器
Mat srb;
Mat gray;
Mat dst;
src = imread("D:/opencv/resourse/age.jpg");//将本地的图像放入容器中
namedWindow("src");//设置一个窗体用来展示图像
imshow("src",src);//窗口展示图像
VideoCapture video; //实例化视频容器的对象
if(!video.open(0))
{
QMessageBox::information(this,"提示","视频打开失败");
return;
}
namedWindow("srb");
while(video.read(srb))
{
flip(srb, srb, 1);
cvtColor(srb,gray,CV_BGR2GRAY);
equalizeHist(gray,dst);
CascadeClassifier a;
vector<Rect> faces;
a.load("D:/opencv/resourse/haarcascade_frontalface_alt.xml");
a.detectMultiScale(dst,faces);
imshow("srb",dst);
if(waitKey(20) == 27)
{
break;
}
}
}
Widget::~Widget()
{
delete ui;
}
数据库:
//源文件
#include "widget.h"
#include "ui_widget.h"
Widget::Widget(QWidget *parent)
: QWidget(parent)
, ui(new Ui::Widget)
{
ui->setupUi(this);
ui->table->setHorizontalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
ui->table->setVerticalScrollBarPolicy(Qt::ScrollBarAlwaysOff);
if(!db.contains("stu.db"))
{
db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("stu.db");
}
if(!db.open())
{
QMessageBox::information(this,"提示","数据库打开失败");
return;
}
QSqlQuery querry;
QString sql = "create table if not exists STU(id int,name char,sex char,score double)";
if(!querry.exec(sql))
{
QMessageBox::information(this,"提示","数据表创建失败");
return;
}
}
Widget::~Widget()
{
delete ui;
}
void Widget::on_btn1_clicked() //添加函数
{
int ui_numb = ui->edit1->text().toUInt();
QString ui_name = ui->edit2->text();
QString ui_sex = ui->edit3->text();
double ui_score = ui->edit4->text().toDouble();
if(ui_numb ==0 || ui_name.isEmpty() || ui_sex.isEmpty() || ui_score == 0)
{
QMessageBox::information(this,"提示","请将信息填写完整");
return;
}
QString sql = QString("insert into STU(id,name,sex,score) values(%1,'%2','%3',%4);").arg(ui_numb).arg(ui_name).arg(ui_sex).arg(ui_score);
QSqlQuery querry;
if(!querry.exec(sql))
{
QMessageBox::information(this,"提示","添加信息失败");
return;
}
else
{
QMessageBox::information(this,"提示","添加信息成功");
}
}
void Widget::on_btn2_clicked() //展示函数
{
ui->table->clearContents();
QSqlQuery querry;
QString sql = "select * from STU;";
if(!querry.exec(sql))
{
QMessageBox::information(this,"提示","展示失败");
return;
}
int i = 0;
while (querry.next())
{
QSqlRecord record = querry.record();
for(int j=0;j<record.count();j++)
{
QTableWidgetItem *item = new QTableWidgetItem(record.value(j).toString());
ui->table->setItem(i,j,item);
}
i++;
}
}
void Widget::on_btn3_clicked() //删除函数
{
int ui_numb = ui->edit1->text().toUInt();
if(ui_numb == 0)
{
QMessageBox::information(this,"提示","学号不能为空");
return;
}
QString sq1 = QString("DELETE FROM STU WHERE id = %1").arg(ui_numb);
QSqlQuery query;
if(!query.exec(sq1))
{
QMessageBox::information(this,"提示","删除失败");
}
else
{
QMessageBox::information(this,"提示","删除成功");
}
}
void Widget::on_btn4_clicked() //排序函数
{
QString sq1 = "SELECT * FROM STU ORDER BY score ASC";
QSqlQuery query;
if(!query.exec(sq1))
{
QMessageBox::information(this,"提示","排序失败");
}
else
{
int i = 0;
while (query.next())
{
QSqlRecord record = query.record();
for(int j=0;j<record.count();j++)
{
QTableWidgetItem *item = new QTableWidgetItem(record.value(j).toString());
ui->table->setItem(i,j,item);
}
i++;
}
}
}