cpzzj/filethread.cpp at master · xing9634/cpzzj · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
#include "filethread.h"

void FileThread::store_file_text()
{
    file->setFileName(kind +".txt");
    file->open(QIODevice::ReadOnly);
    QByteArray t ;
    int i  = 0;
    qDebug()<<file->isOpen();
    while(!file->atEnd() && i < 32) {
        t = file->readLine();
        QByteArray str;
        str.append(t);
        str.replace(" ","\t");
        readF.a = str.split('\t');
        qDebug()<<readF.a[0]<<readF.a[1]<<kind<<endl;
        QSqlQuery qsq;
        QDateTime current_date_time =QDateTime::currentDateTime();
        QString current_date = current_date_time.toString("yyyy-MM-dd");
        if(kind == "dlt_data" ) {
            qsq.prepare("insert into dlt_data(real_id,one,two,three,four,five,date,is_new) values(?,?,?,?,?,?,?,0)");
            for(int j = 0;j < 6;j ++) {
                qsq.addBindValue(readF.a[j].toInt());
            }
            qsq.addBindValue(current_date);
        } else if(kind == "ssq_data" ) {
            qsq.prepare("insert into ssq_data(real_id,one,two,three,four,five,six,date,is_new)values(?,?,?,?,?,?,?,?,0)");
            for(int j = 0;j < 7;j ++) {
                qsq.addBindValue(readF.a[j].toInt());
            }
            qsq.addBindValue(current_date);
        } else if(kind == "pl3_data" ) {
            qsq.prepare("insert into pl3_data(real_id,one,two,three,date,is_new) values(?,?,?,?,?,0)");
            for(int j = 0;j < 4;j ++) {
                qsq.addBindValue(readF.a[j].toInt());
            }
            qsq.addBindValue(current_date);
        } else if(kind == "pl5_data" ) {
            qsq.prepare("insert into pl5_data(real_id,one,two,three,four,five,date,is_new) values(?,?,?,?,?,?,?,0)");
            for(int j = 0;j < 6;j ++) {
                qsq.addBindValue(readF.a[j].toInt());
            }
            qsq.addBindValue(current_date);
        } else if(kind == "qxc_data" ) {
            qsq.prepare("insert into qxc_data(real_id,one,two,three,four,five,six,seven,date,is_new) values(?,?,?,?,?,?,?,?,?,0)");
            for(int j = 0;j < 8;j ++) {
                qsq.addBindValue(readF.a[j].toInt());
            }
            qsq.addBindValue(current_date);
        } else if(kind == "fc3d_data" ) {
            qsq.prepare("insert into fc3d_data(real_id,one,two,three,date,is_new) values(?,?,?,?,?,0)");
            for(int j = 0;j < 4;j ++) {
                qsq.addBindValue(readF.a[j].toInt());
            }
            qsq.addBindValue(current_date);
        }
        qsq.exec();
        qDebug()<<"ok";
        i++;
    }
    file->close();
}