qt mysql药品订购系统_基于RFID,QT,MYSQL开发的医疗电子病历系统

迷南。 2023-01-11 08:28 112阅读 0赞

没事做，跟着模版随便做了一个电子病历系统，功能很简陋，界面也不太好看，各位大神看到别见怪啊~

功能包括有通过RFID读写器读取S50卡中的卡号把病人详细信息存入数据库、通过RFID读写器读取S50卡把病人的详细信息从数据库中进行读取并显示到QT程序界面上、在QT程序中进行病人信息的查询，包括修改与删除、计费功能(通过读取卡号，可进行对账户的充值与扣费)

随着物联网技术的成熟，物联网可以应用到各方各面，无论家居，农业，医疗等等都可以利用到物联网技术。而物联网技术的核心技术有：应用技术、网络技术和感知技术。我们所设计的系统正正利用了物联网的核心技术：感知技术中的RFID。在以前，病人去医院看病必须带上病历，而纸质不易保存，易潮，易脏。于是我们设计的电子病历既解决了纸质病历的问题，更加在此中增加了结算和电子钱包的功能。

电子病历是高质量，更快捷，更方便的医疗系统，电子病历不仅可以用于病人的随身携带，而且只需要带一张不到20克的卡，就可以不带钱去看医生。电子病历系统更加合理化，信息化，对医院也便于统计和整理病人数据。所以电子病历对医院和病人都有着莫大的好处，电子病历在当今社会是发展趋势。

1．  用户：

(1)       随身携带：轻便，简单。

(2)       电子钱包：预存费用，方便结算。

2．  医生：

(1)       过往病史：方便医生对症下药，对过往病史、过敏病史清楚了解。

(2)       记录病历：写入数据库，节约资源。

3．  管理员：

(1)       用户管理：用户的增加，删除，修改，查询。

(2)       余额管理：用户余额的增加与减少。

管理员登陆相关代码：

dialog.h：

\#ifndef DIALOG\_H

\#define DIALOG\_H

\#include

namespace Ui \{

class Dialog;

class Dialog : public QDialog

Q\_OBJECT

public:

explicit Dialog(QWidget \*parent = 0);

~Dialog();

private slots:

void on\_login\_clicked();

void on\_cancel\_clicked();

private:

Ui::Dialog \*ui;

\};

\#endif // DIALOG\_H

dialog.cpp

\#include "dialog.h"

\#include "ui\_dialog.h"

\#include"QMessageBox"

\#include"mainwindow.h"

Dialog::Dialog(QWidget \*parent) :

QDialog(parent),

ui(new Ui::Dialog)

ui->setupUi(this);

Dialog::~Dialog()

delete ui;

void Dialog::on\_login\_clicked()

if(ui->username->text().trimmed()=="admin" && ui->password->text().trimmed()=="admin")

MainWindow \*m=new MainWindow;

m->show();

this->hide();

else

QMessageBox::critical(this,"error",tr("用户名或密码出错！"));

void Dialog::on\_cancel\_clicked()

this->close();

RFID读卡界面相关代码：

reader.h

\#ifndef    READER\_H

\#define READER\_H

//\#include "function.h"

\#include

\#include "function.h"

class Reader

public:

Reader(QWidget \*parent);

~Reader();

bool LoadDll();

bool CloseDll();

MF\_Read\_Func MF\_Read;

MF\_Write\_Func MF\_Write;

MF\_InitValue\_Func MF\_InitValue;

MF\_Dec\_Func MF\_Dec;

MF\_Inc\_Func MF\_Inc;

MF\_Halt\_Func MF\_Halt;

MF\_Getsnr\_Func MF\_Getsnr;

ControlBuzzer\_Func ControlBuzzer;

ControlLED\_Func ControlLED;

GetVersionNum\_Func GetVersionNum;

SetSerNum\_Func SetSerNum;

GetSerNum\_Func GetSerNum;

TypeB\_Request\_Func TypeB\_Request;

TYPEB\_SFZSNR\_Func TYPEB\_SFZSNR;

TypeB\_TransCOS\_Func TypeB\_TransCOS;

UL\_Request\_Func UL\_Request;

UL\_HLRead\_Func UL\_HLRead;

UL\_HLWrite\_Func UL\_HLWrite;

ISO15693\_Inventory\_Func ISO15693\_Inventory;

ISO15693\_Read\_Func ISO15693\_Read;

ISO15693\_Write\_Func ISO15693\_Write;

ISO15693\_GetSysInfo\_Func ISO15693\_GetSysInfo;

ISO15693\_Lock\_Func ISO15693\_Lock;

ISO15693\_Select\_Func ISO15693\_Select;

ISO15693\_WriteAFI\_Func ISO15693\_WriteAFI;

ISO15693\_LockAFI\_Func ISO15693\_LockAFI;

ISO15693\_WriteDSFID\_Func ISO15693\_WriteDSFID;

ISO15693\_LockDSFID\_Func ISO15693\_LockDSFID;

ISO15693\_GetMulSecurity\_Func ISO15693\_GetMulSecurity;

private:

QLibrary \*functionLib;

int DeviceAddress;

\};

\#endif

reader.cpp

\#include "reader.h"

\#include

Reader::Reader(QWidget \*parent)

DeviceAddress = 0;

functionLib = new QLibrary("function.dll");

if (!LoadDll())

QMessageBox::critical(parent,"Error",QString::fromLocal8Bit("��ȡfunction.dllʧ��"));

Reader::~Reader()

CloseDll();

bool Reader::LoadDll()

if ( !functionLib->load() )

qDebug()<

return false;

qDebug()<

MF\_Read        = (MF\_Read\_Func)functionLib->resolve("MF\_Read");

MF\_Write       = (MF\_Write\_Func)functionLib->resolve("MF\_Write");

MF\_InitValue   = (MF\_InitValue\_Func)functionLib->resolve("MF\_InitValue");

MF\_Dec         = (MF\_Dec\_Func)functionLib->resolve("MF\_Dec");

MF\_Inc         = (MF\_Inc\_Func)functionLib->resolve("MF\_Inc");

MF\_Halt        = (MF\_Halt\_Func)functionLib->resolve("MF\_Halt");

MF\_Getsnr      = (MF\_Getsnr\_Func)functionLib->resolve("MF\_Getsnr");

ControlLED           = (ControlLED\_Func)functionLib->resolve("ControlLED");

ControlBuzzer        = (ControlBuzzer\_Func)functionLib->resolve("ControlBuzzer");

GetVersionNum        = (GetVersionNum\_Func)functionLib->resolve("GetVersionNum");

SetSerNum            = (SetSerNum\_Func)functionLib->resolve("SetSerNum");

GetSerNum            = (GetSerNum\_Func)functionLib->resolve("GetSerNum");

TypeB\_Request        = (TypeB\_Request\_Func)functionLib->resolve("TypeB\_Request");

TYPEB\_SFZSNR         = (TYPEB\_SFZSNR\_Func)functionLib->resolve("TYPEB\_SFZSNR");

TypeB\_TransCOS          = (TypeB\_TransCOS\_Func)functionLib->resolve("TypeB\_TransCOS");

ISO15693\_Inventory            = (ISO15693\_Inventory\_Func)functionLib->resolve("ISO15693\_Inventory");

ISO15693\_Read                   = (ISO15693\_Read\_Func)functionLib->resolve("ISO15693\_Read");

ISO15693\_Write                  = (ISO15693\_Write\_Func)functionLib->resolve("ISO15693\_Write");

ISO15693\_GetSysInfo   = (ISO15693\_GetSysInfo\_Func)functionLib->resolve("ISO15693\_GetSysInfo");

ISO15693\_Lock                   = (ISO15693\_Lock\_Func)functionLib->resolve("ISO15693\_Lock");

ISO15693\_Select                 = (ISO15693\_Select\_Func)functionLib->resolve("ISO15693\_Select");

ISO15693\_WriteAFI            = (ISO15693\_WriteAFI\_Func)functionLib->resolve("ISO15693\_WriteAFI");

ISO15693\_LockAFI             = (ISO15693\_LockAFI\_Func)functionLib->resolve("ISO15693\_LockAFI");

ISO15693\_WriteDSFID = (ISO15693\_WriteDSFID\_Func)functionLib->resolve("ISO15693\_WriteDSFID");

ISO15693\_LockDSFID  = (ISO15693\_LockDSFID\_Func)functionLib->resolve("ISO15693\_LockDSFID");

ISO15693\_GetMulSecurity=(ISO15693\_GetMulSecurity\_Func)functionLib->resolve("ISO15693\_GetMulSecurity");

UL\_Request           = (UL\_Request\_Func)functionLib->resolve("UL\_Request");

UL\_HLRead            = (UL\_HLRead\_Func)functionLib->resolve("UL\_HLRead");

UL\_HLWrite           = (UL\_HLWrite\_Func)functionLib->resolve("UL\_HLWrite");

if(//14443A

MF\_Read        == NULL       ||

MF\_Write            == NULL       ||

MF\_InitValue       == NULL       ||

MF\_Dec              == NULL       ||

MF\_Inc               == NULL       ||

MF\_Getsnr          == NULL       ||

MF\_Halt             == NULL       ||

SetSerNum            == NULL       ||

GetSerNum           == NULL       ||

ControlLED           == NULL       ||

ControlBuzzer        == NULL       ||

GetVersionNum      == NULL       ||

TypeB\_Request      == NULL       ||

TYPEB\_SFZSNR   == NULL       ||

TypeB\_TransCOS   == NULL       ||

ISO15693\_Inventory     == NULL ||

ISO15693\_Read            == NULL||

ISO15693\_Write           == NULL ||

ISO15693\_GetSysInfo == NULL ||

ISO15693\_Lock            == NULL ||

ISO15693\_Select          == NULL ||

ISO15693\_WriteAFI     == NULL ||

ISO15693\_LockAFI      == NULL ||

ISO15693\_WriteDSFID == NULL ||

ISO15693\_LockDSFID  == NULL ||

UL\_Request                 == NULL  ||

UL\_HLRead                 == NULL  ||

UL\_HLWrite                 == NULL)

qDebug()<

return false;

qDebug()<

return true;

bool Reader::CloseDll()

if(functionLib)

functionLib->unload();

return true;

return false;

showsick.h

\#ifndef SHOWALLSICK\_H

\#define SHOWALLSICK\_H

\#include

namespace Ui \{

class ShowAllSick;

class ShowAllSick : public QDialog

Q\_OBJECT

public:

explicit ShowAllSick(QWidget \*parent = 0);

~ShowAllSick();

void connectMySql();

private slots:

void on\_delete\_2\_clicked();

void on\_update\_clicked();

void on\_insert\_clicked();

void gettotalrecords();

void showdata();

void on\_select\_clicked();

void on\_first\_clicked();

void on\_next\_clicked();

void on\_pre\_clicked();

void on\_last\_clicked();

void on\_go\_clicked();

private:

Ui::ShowAllSick \*ui;

QSqlTableModel \*tablemodel;

int page;

int records;

int totalrecords;

int totalpages;\};

\#endif // SHOWALLSICK\_H

showsick.cpp

\#include "showsick.h"

\#include "ui\_showsick.h"

\#include

showsick::showsick(QWidget \*parent) :

QDialog(parent),

ui(new Ui::showsick)

ui->setupUi(this);

//timer read rfid

timer=new QTimer;

connect(timer,SIGNAL(timeout()),this,SLOT(readcardid()));

//rfid

cardReader = new Reader(this);

//mysql

connectMySql();

showsick::~ showsick ()

delete ui;

void showsick::on\_read\_clicked()

if(ui->id->text()=="")

timer->start(1000);

ui->read->setEnabled(false);

QSqlQuery query;

query.prepare("select no,sex,intro intro,image from tbl\_sick where id=?");

query.addBindValue(ui->id->text());

query.exec();

if(query.next())

ui->no->setText(query.value(0).toString());

ui->sex->setText(query.value(1).toString());

ui->intro->setText(query.value(2).toString());

QPixmap photo;

photo.loadFromData(query.value(3).toByteArray());

ui->img->setPixmap(photo.scaled(ui->img->size()));

\}\}

void showsick::on\_stop\_clicked()

timer->stop();

ui->read->setEnabled(true);

//读取卡号

void showsick::readcardid()

unsigned int cardid;

unsigned char snr\[7\];

unsigned char mode =00;

int result = cardReader->UL\_Request(mode, snr);

if(result==0)

cardid= (snr\[0\]<<24) |(snr\[1\]<<16) | (snr\[2\]<<8) | (snr\[3\]);

//根据读出的卡号查询数据

showdata(cardid);    \}\}

//rfid beer

void showsick::beer()

int freq =20;

int duration = 1;

unsigned char buffer;

int result = cardReader->ControlBuzzer(freq, duration, &buffer);\}

//mysql

void showsick::connectMySql()

QSqlDatabase db =QSqlDatabase::addDatabase("QMYSQL"); // becomes the new default connection

db.setUserName("root");//用户名

db.setPassword("root");//密码

db.setHostName("172.16.170.47");

db.setDatabaseName("book");//数据库名

db.setConnectOptions("CLIENT\_SSL=1;CLIENT\_IGNORE\_SPACE=1");//使用SSL

db.setPort(3306);//端口

if(db.open())

QMessageBox::information(this,"open","OK!");

else

QMessageBox::information(this,"open","False");

//mysql

void showsick::showdata(unsigned int cardid)

//根据读出的卡号查询数据

QSqlQuery query;

query.prepare("SELECT id,no,sex,intro,image FROM tbl\_sick WHERE rfidno = ?");

query.addBindValue(QString::number(cardid,16));

query.exec();

while (query.next())

if (query.isNull(0) == false)

//显示病人数据

ui->id->setText(query.value(0).toString());//身份证

ui->no->setText(query.value(1).toString());//姓名

ui->intro->setText(query.value(2).toString());//病症

ui->sex->setText(query.value(3).toString());//性别

//显示病人头像

QPixmap photo;

photo.loadFromData(query.value(3).toByteArray());

ui->img->setPixmap(photo.scaled(ui->img->size()));

qDebug()<

beer();         \}

else

qDebug()<

\}     \}\}

显示全部病人信息界面：

showallsick.h

\#ifndef SHOWALLSICK\_H

\#define SHOWALLSICK\_H

\#include

//mysql

\#include

namespace Ui \{

class ShowAllSick;\}

class ShowAllSick : public QDialog

Q\_OBJECT

public:

explicit ShowAllSick(QWidget \*parent = 0);

~ShowAllSick();

void connectMySql();

private slots:

void on\_delete\_2\_clicked();

void on\_update\_clicked();

void on\_insert\_clicked();

void gettotalrecords();

void showdata();

void on\_select\_clicked();

void on\_first\_clicked();

void on\_next\_clicked();

void on\_pre\_clicked();

void on\_last\_clicked();

void on\_go\_clicked();

private:

Ui::ShowAllSick \*ui;

QSqlTableModel \*tablemodel;

int page;

int records;

int totalrecords;

int totalpages;\};

\#endif // SHOWALLSICK\_H

showallsick.cpp

\#include "showallsick.h"

\#include "ui\_showallsick.h"

\#include"sickinfo.h"

\#include"updatesickinfo.h"

\#include

QString globaldata;

ShowAllSick::ShowAllSick(QWidget \*parent) :

QDialog(parent),

ui(new Ui::ShowAllSick)

ui->setupUi(this);

ui->tableView->horizontalHeader()->setResizeMode(QHeaderView::Stretch);

connectMySql();

tablemodel=new QSqlTableModel(this);

tablemodel->setTable("tbl\_sick");

tablemodel->setEditStrategy(QSqlTableModel::OnFieldChange);

tablemodel->select();

tablemodel->removeColumn(8);

tablemodel->setHeaderData(0,Qt::Horizontal,QObject::tr("卡号"));

tablemodel->setHeaderData(1,Qt::Horizontal,QObject::tr("姓名"));

tablemodel->setHeaderData(2,Qt::Horizontal,QObject::tr("身份证号"));

tablemodel->setHeaderData(3,Qt::Horizontal,QObject::tr("性别"));

tablemodel->setHeaderData(4,Qt::Horizontal,QObject::tr("出生日期"));

tablemodel->setHeaderData(5,Qt::Horizontal,QObject::tr("病症"));

tablemodel->setHeaderData(6,Qt::Horizontal,QObject::tr("照片"));

tablemodel->setHeaderData(7,Qt::Horizontal,QObject::tr("余额"));

ui->tableView->setModel(tablemodel);\}

ShowAllSick::~ShowAllSick()

delete ui;

//mysql

void ShowAllSick::connectMySql()

QSqlDatabase db =QSqlDatabase::addDatabase("QMYSQL"); // becomes the new default connection

db.setUserName("root");//用户名

db.setPassword("root");//密码

db.setHostName("172.16.170.47");

db.setDatabaseName("book");//数据库名

db.setConnectOptions("CLIENT\_SSL=1;CLIENT\_IGNORE\_SPACE=1");//使用SSL

db.setPort(3306);//端口

if(!db.open())

QMessageBox::information(this,"open","False");

\}\}

void ShowAllSick::on\_delete\_2\_clicked()

QItemSelectionModel \*selections = ui->tableView->selectionModel();

QModelIndexList selected = selections->selectedIndexes();

QSqlQuery query;

int ok = QMessageBox::warning(this,QObject::tr("删除当前行!"),QObject::tr("确定删除当前行?"),

QMessageBox::Yes,QMessageBox::No);

if(ok==QMessageBox::Yes)

foreach (QModelIndex index, selected)

QString no=index.sibling(index.row(),0).data().toString();

query.prepare("delete from tbl\_sick where rfidno =?");

query.addBindValue(no);

query.exec();        \}

tablemodel->select();

\}\}

void ShowAllSick::on\_update\_clicked()

int curRow = ui->tableView->currentIndex().row();

QModelIndex index = ui->tableView->currentIndex();

globaldata=index.sibling(curRow,2).data().toString();

UpdateSickInfo \*updatesickinfo=new UpdateSickInfo;

updatesickinfo->show();\}

void ShowAllSick::on\_insert\_clicked()

SickInfo \*sickinfo=new SickInfo;

sickinfo->show();

sickinfo->resize(600,450);

void ShowAllSick::on\_select\_clicked()\{

QString id=ui->id->text().trimmed();

if(id!="")    \{

tablemodel->setFilter(QString("id=%1").arg(id));

tablemodel->select();

\}else\{

tablemodel->setTable("tbl\_sick");

tablemodel->select();

\}\}

void ShowAllSick::gettotalrecords()

QSqlQuery query;

query.clear();

query.exec("select count(\*) from tbl\_sick");

query.next();

totalrecords=query.value(0).toInt();

records=ui->record->text().toInt();

totalpages=(totalrecords%records)?(totalrecords/records)+1:(totalrecords/records);

ui->totalpage->setText("totalpage:"+QString::number(totalpages));\}

void ShowAllSick::showdata()

QString strFilter = QString("1=1 LIMIT %1,%2;").arg(0).arg(records);

tablemodel->setFilter(strFilter);

tablemodel->select();

ui->tableView->setModel(tablemodel);

void ShowAllSick::on\_first\_clicked()

showdata();

ui->page->setText("1");\}

void ShowAllSick::on\_next\_clicked()

page=ui->page->text().trimmed().toInt();

records=ui->record->text().trimmed().toInt();

if(page

QString strFilter = QString("1=1 LIMIT %1,%2;").arg(page\*records).arg(records);

tablemodel->setFilter(strFilter);

tablemodel->select();

ui->tableView->setModel(tablemodel);

ui->page->setText(QString::number(page+1));

\}\}

void ShowAllSick::on\_pre\_clicked()

page=ui->page->text().trimmed().toInt();

records=ui->record->text().trimmed().toInt();

if(page>1)    \{

QString strFilter = QString("1=1 LIMIT %1,%2;").arg((page-2)\*records).arg(records);

tablemodel->setFilter(strFilter);

tablemodel->select();

ui->tableView->setModel(tablemodel);

ui->page->setText(QString::number(page-1));

\}\}

void ShowAllSick::on\_last\_clicked()\{

records=ui->record->text().trimmed().toInt();

int lastpages=(totalrecords%records)?(totalrecords/records):(totalrecords/records)-1;

QString strFilter=QString("1=1 LIMIT %1,%2").arg((lastpages)\*records).arg(records);

tablemodel->setFilter(strFilter);

tablemodel->select();

ui->tableView->setModel(tablemodel);

ui->page->setText(QString::number(lastpages+1));\}

void ShowAllSick::on\_go\_clicked()\{

page=ui->page->text().trimmed().toInt();

records=ui->record->text().trimmed().toInt();

totalpages=(totalrecords%records)?(totalrecords/records)+1:(totalrecords/records);

if(page<=totalpages)    \{

QString strFilter=QString("1=1 LIMIT %1,%2").arg((page-1)\*records).arg(records);

tablemodel->setFilter(strFilter);

tablemodel->select();

ui->tableView->setModel(tablemodel);

\}else\{

QString strFilter=QString("1=1 LIMIT %1,%2;").arg(0).arg(records);

tablemodel->setFilter(strFilter);

tablemodel->select();

ui->tableView->setModel(tablemodel);

ui->page->setText("1");    \}

ui->totalpage->setText(tr("totalpage:")+QString::number(totalpages));\}

增加用户数据：

sickinfo.c

\#ifndef SICKINFO\_H

\#define SICKINFO\_H

\#include

//rfid

\#include"reader.h"

//mysql

\#include

namespace Ui \{

class SickInfo;\}

class SickInfo : public QDialog\{

Q\_OBJECT

public:

explicit SickInfo(QWidget \*parent = 0);

~SickInfo();

//rfid

void beer();

//mysql

void connectMySql();

private slots:

void on\_ok\_clicked();

void on\_openimage\_clicked();

void on\_readcard\_clicked();

private:

Ui::SickInfo \*ui;

QString fileName;

//rfid

Reader \*cardReader;

//mysql

QSqlDatabase db;

\};

sickinfo.cpp

\#endif // SICKINFO\_H

\#include "sickinfo.h"

\#include "ui\_sickinfo.h"

\#include

SickInfo::SickInfo(QWidget \*parent) :

QDialog(parent),

ui(new Ui::SickInfo)\{

ui->setupUi(this);

//rfid

cardReader = new Reader(this);

//mysql

connectMySql();\}

SickInfo::~SickInfo()

delete ui;

//mysql的save

void SickInfo::on\_ok\_clicked()

QString s="";

s.append(ui->rfidno->text()+"\\n");

s.append(ui->no->text()+"\\n");

s.append(ui->id->text()+"\\n");

s.append(fileName+"\\n");

s.append(ui->sex->checkedButton()->text()+"\\n");

s.append(ui->birthday->text()+"\\n");

s.append(ui->textEdit->toPlainText());

QMessageBox::information(this,tr("infromation"),tr("%1").arg(s));    //读取数据

QString rfidno=ui->rfidno->text().trimmed();

QString no=ui->no->text().trimmed();

QString id=ui->id->text().trimmed();

QString sex=ui->sex->checkedButton()->text().trimmed();

QString birthday=ui->birthday->text();

QString intro=ui->textEdit->toPlainText();

//读取图片数据为二进制数据

QByteArray bytes;

QBuffer buffer(&bytes);

buffer.open(QIODevice::WriteOnly);

ui->img->pixmap()->save(&buffer, "PNG");

QByteArray data;

QFile\* file=new QFile(fileName);

file->open(QIODevice::ReadOnly);

data = file->readAll();

file->close();

QVariant var(data);

//mysql的insert操作

QSqlQuery query;

bool value;

query.prepare("insert into tbl\_sick(rfidno,no,id,sex,intro,birthday,image) values(?,?,?,?,?,?,?)");

query.addBindValue(rfidno);

query.addBindValue(no);

query.addBindValue(id);

query.addBindValue(sex);

query.addBindValue(intro);

query.addBindValue(birthday);

query.addBindValue(var);

value=query.exec();

if(value)      \{

QMessageBox::information(this,"adduser","Add user successed!");

else

QMessageBox::information(this,"adduser","Add user failed!");

\}\}

void SickInfo::on\_openimage\_clicked()

fileName = QFileDialog::getOpenFileName(this,

tr("Open File"), QDir::currentPath());

if (!fileName.isEmpty())

QMessageBox::information(this, tr("Image Viewer"),

tr("path: %1.").arg(fileName));

QImage image(fileName);

if (image.isNull())

QMessageBox::information(this, tr("Image Viewer"),

tr("Cannot load %1.").arg(fileName));

return;

//ui->img->setPixmap(QPixmap::fromImage(image));

ui->img->setPixmap(QPixmap(fileName).scaled(ui->img->size()));        \}\}

//rfid

void SickInfo::on\_readcard\_clicked()

unsigned int cardid;

unsigned char snr\[7\];

unsigned char mode =00;

int result = cardReader->UL\_Request(mode, snr);

if(result==0)

cardid= (snr\[0\]<<24) |(snr\[1\]<<16) | (snr\[2\]<<8) | (snr\[3\]);

ui->rfidno->setText(QString::number(cardid,16));

beer();    \}\}

//rfid

void SickInfo::beer()

int freq =20;

int duration = 1;

unsigned char buffer;

int result = cardReader->ControlBuzzer(freq, duration, &buffer);

\}//mysql

void SickInfo::connectMySql()\{

QSqlDatabase db =QSqlDatabase::addDatabase("QMYSQL"); // becomes the new default connection

db.setUserName("root");//用户名

db.setPassword("root");//密码

db.setHostName("172.16.170.47");

db.setDatabaseName("book");//数据库名

db.setConnectOptions("CLIENT\_SSL=1;CLIENT\_IGNORE\_SPACE=1");//使用SSL

db.setPort(3306);//端口

if(db.open())    \{

QMessageBox::information(this,"open","OK!");

else

QMessageBox::information(this,"open","False");

\}\}

更新病人资料：

updatesickinfo.c

\#ifndef UPDATESICKINFO\_H

\#define UPDATESICKINFO\_H

\#include

//rfid

\#include"reader.h"

//mysql

\#include

namespace Ui \{

class UpdateSickInfo;

class UpdateSickInfo : public QDialog

Q\_OBJECT

public:

explicit UpdateSickInfo(QWidget \*parent = 0);

~UpdateSickInfo();

void connectMySql();

void beer();

private slots:

void on\_openimage\_clicked();

void on\_readcard\_clicked();

void on\_ok\_clicked();

private:

Ui::UpdateSickInfo \*ui;

QString fileName;    //rfid

Reader \*cardReader;

\};

\#endif // UPDATESICKINFO\_H

updatesickinfo.cpp

\#include "updatesickinfo.h"

\#include "ui\_updatesickinfo.h"

\#include

extern QString globaldata;

UpdateSickInfo::UpdateSickInfo(QWidget \*parent) :

QDialog(parent),

ui(new Ui::UpdateSickInfo)

ui->setupUi(this);

//rfid

cardReader = new Reader(this);

//mysql读数据

QSqlQuery query;

query.prepare("select \* from tbl\_sick where id=?");

query.addBindValue(globaldata);

if(query.exec())    \{

query.next();

ui->rfidno->setText(query.value(0).toString());

ui->no->setText(query.value(1).toString());

ui->id->setText(query.value(2).toString());

ui->birthday->setDateTime(query.value(4).toDateTime());

ui->textEdit->setText(query.value(5).toString());        //显示学生头像

QPixmap photo;

photo.loadFromData(query.value(6).toByteArray());

ui->img->setPixmap(photo.scaled(ui->img->size()));  \}\}

UpdateSickInfo::~UpdateSickInfo()

delete ui;

//mysql的save

void UpdateSickInfo::on\_ok\_clicked()

QString s="";

s.append(ui->rfidno->text()+"\\n");

s.append(ui->no->text()+"\\n");

s.append(ui->id->text()+"\\n");

s.append(fileName+"\\n");

s.append(ui->sex->checkedButton()->text()+"\\n");

s.append(ui->birthday->text()+"\\n");

s.append(ui->textEdit->toPlainText());

QMessageBox::information(this,tr("infromation"),tr("%1").arg(s));

//读取数据

QString rfidno=ui->rfidno->text().trimmed();

QString no=ui->no->text().trimmed();

QString id=ui->id->text().trimmed();

QString sex=ui->sex->checkedButton()->text().trimmed();

QString birthday=ui->birthday->text();

QString intro=ui->textEdit->toPlainText();

//读取图片数据为二进制数据

QByteArray bytes;

QBuffer buffer(&bytes);

buffer.open(QIODevice::WriteOnly);

ui->img->pixmap()->save(&buffer, "PNG");

QByteArray data;

QFile\* file=new QFile(fileName);

file->open(QIODevice::ReadOnly);

data = file->readAll();

file->close();

QVariant var(data);

//mysql的insert操作

QSqlQuery query;

bool value;

query.prepare("update tbl\_sick set rfidno=?,no=?,sex=?,birthday=?,intro=?,image=? where id=?");

query.addBindValue(rfidno);

query.addBindValue(no);

query.addBindValue(sex);

query.addBindValue(birthday);

query.addBindValue(intro);

query.addBindValue(var);

query.addBindValue(id);

value=query.exec();

if(value)    \{

QMessageBox::information(this,"adduser","update user successed!");

\}else\{

QMessageBox::information(this,"adduser","update user failed!");

\}\}

void UpdateSickInfo::on\_openimage\_clicked()

fileName = QFileDialog::getOpenFileName(this,

tr("Open File"), QDir::currentPath());

if (!fileName.isEmpty())

QMessageBox::information(this, tr("Image Viewer"),

tr("path: %1.").arg(fileName));

QImage image(fileName);

if (image.isNull())

QMessageBox::information(this, tr("Image Viewer"),

tr("Cannot load %1.").arg(fileName));

return;

//ui->img->setPixmap(QPixmap::fromImage(image));

ui->img->setPixmap(QPixmap(fileName).scaled(ui->img->size()));        \}\}

//rfid

void UpdateSickInfo::on\_readcard\_clicked()

unsigned int cardid;

unsigned char snr\[7\];

unsigned char mode =00;

int result = cardReader->UL\_Request(mode, snr);

if(result==0)    \{

cardid= (snr\[0\]<<24) |(snr\[1\]<<16) | (snr\[2\]<<8) | (snr\[3\]);

ui->rfidno->setText(QString::number(cardid,16));

beer();

\}\}

//rfid

void UpdateSickInfo::beer()

int freq =20;

int duration = 1;

unsigned char buffer;

int result = cardReader->ControlBuzzer(freq, duration, &buffer);\}

//mysql

void UpdateSickInfo::connectMySql()

QSqlDatabase db =QSqlDatabase::addDatabase("QMYSQL"); // becomes the new default connection

db.setUserName("root");//用户名

db.setPassword("root");//密码

db.setHostName("172.16.170.47");

db.setDatabaseName("book");//数据库名

db.setConnectOptions("CLIENT\_SSL=1;CLIENT\_IGNORE\_SPACE=1");//使用SSL

db.setPort(3306);//端口

if(!db.open())    \{

QMessageBox::information(this,"open","False");    \}

1)        管理者登录页面：

![553663dcfd456d4ea08efb925227961e.png][]

2)        系统首界面：

![c5638f1979b6fef4091375e96e0ad3b7.png][]

3)        增加用户资料界面：

![5d82a6fd9fdd0b2c9fab48849789d6af.png][]

4)        RFID读取用户资料界面：

![781a35bed6139f14f58c79a43fe0050b.png][]

5)        操作全部用户资料界面：

![5134124119cfaa1022c4c349db006f78.png][]

6)        用户充值扣费界面：

![a331bc72980deae41e63186532a19b51.png][]

[553663dcfd456d4ea08efb925227961e.png]: /images/20221119/399e081b14b74fd4a5e486c7db321302.png
[c5638f1979b6fef4091375e96e0ad3b7.png]: https://img-blog.csdnimg.cn/img_convert/c5638f1979b6fef4091375e96e0ad3b7.png
[5d82a6fd9fdd0b2c9fab48849789d6af.png]: https://img-blog.csdnimg.cn/img_convert/5d82a6fd9fdd0b2c9fab48849789d6af.png
[781a35bed6139f14f58c79a43fe0050b.png]: https://img-blog.csdnimg.cn/img_convert/781a35bed6139f14f58c79a43fe0050b.png
[5134124119cfaa1022c4c349db006f78.png]: https://img-blog.csdnimg.cn/img_convert/5134124119cfaa1022c4c349db006f78.png
[a331bc72980deae41e63186532a19b51.png]: https://img-blog.csdnimg.cn/img_convert/a331bc72980deae41e63186532a19b51.png