jia_tan_diyic/handle/database.h

#ifndef DATABASE_H
#define DATABASE_H

#include <QDebug>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QSqlTableModel>

struct dabao
{
    int goods_id;
    int code_single;
    int quantity;
    int level_id;
    int tube_number;
    double gross_weight;
    double net_weight;
    QString machine_no;
    QString packing_time;
    QString packing_type;
    QString carton_type;
    int user_id;
    int case_number;
    double backet_weight;
    QString sort;
    QString tongbu;
    QString remark;
};

class Database : public QObject
{
    Q_OBJECT
public:
    explicit Database(QObject *parent = 0);
    ~Database();
//    void connectDB(QString dbName, QString username, QString password);
//    void insertData();
//    void deleteData();
    void SetTableName(QString table);
    bool openDB();
    bool createDatabase();
    bool changeState(QString xianghao);
    bool insert(QString &table, QStringList &names, QStringList &values);
    bool update(QString &table, QStringList &names, QStringList &values, QString &expression);
    bool del(QString &table, QString &expression);
    QList<QStringList> GetValues(QString &table, QStringList &values);


private:
    QSqlDatabase _database;
    QSqlTableModel *model;
    QString _tableName;
    QList<QStringList> dbmxlist;
    QStringList dbmxdata;
};

#endif // DATABASE_H