From 696f5b6779bd1f904c2497bb29a1cc991ab0477a Mon Sep 17 00:00:00 2001 From: wumu <mayi@mayi.com> Date: 星期一, 10 二月 2025 22:47:55 +0800 Subject: [PATCH] 250210 --- historydata.h | 11 +++++++++++ clientmainwindow.cpp | 2 ++ getstocklist.cpp | 3 +++ getstocklist.h | 1 + historydata.cpp | 43 ++++++++++++++++++++++++++++++++++++++++--- 5 files changed, 57 insertions(+), 3 deletions(-) diff --git a/clientmainwindow.cpp b/clientmainwindow.cpp index 47c405a..ebf0aea 100644 --- a/clientmainwindow.cpp +++ b/clientmainwindow.cpp @@ -52,4 +52,6 @@ connect(m_regular,SIGNAL(getClosePriceSignal(QString)),m_getStockList,SLOT(getLastClosePrice(QString))); connect(m_getStockList,SIGNAL(sendClosePrice(QString,QString)),m_regular,SLOT(showClosePrice(QString,QString))); + connect(m_getStockList,SIGNAL(sendCodeNames(QMap<QString,QString>&)),m_history,SLOT(putCodeNames(QMap<QString,QString>&))); + } diff --git a/getstocklist.cpp b/getstocklist.cpp index ea32aa9..ffd5dc6 100644 --- a/getstocklist.cpp +++ b/getstocklist.cpp @@ -270,6 +270,9 @@ m_model->appendRow(rowItems); } } + + // 鍙戝皠淇″彿 + emit sendCodeNames(m_codeNames); } diff --git a/getstocklist.h b/getstocklist.h index 59e642a..9d37a25 100644 --- a/getstocklist.h +++ b/getstocklist.h @@ -45,6 +45,7 @@ void sendChartData(QSplineSeries*); // 鏇茬嚎 void sendInfoMess(QString); // 鍙戦�佹秷鎭彁绀� void sendClosePrice(QString,QString); // 鍙戦�佹渶鏂扮殑浠锋牸锛氬悕瀛椼�佷环鏍� + void sendCodeNames(QMap<QString, QString> &); // 缁欏巻鍙插垎鏋愮晫闈㈠彂閫佸悕瀛椾唬鍙蜂俊鎭� private slots: void on_pushButton_get_clicked(); diff --git a/historydata.cpp b/historydata.cpp index 970ddd8..0cae05a 100644 --- a/historydata.cpp +++ b/historydata.cpp @@ -3,12 +3,15 @@ #include <QMessageBox> #include <QDebug> +#include <QDateTime> HistoryData::HistoryData(QWidget *parent) : QMainWindow(parent), ui(new Ui::HistoryData) { ui->setupUi(this); + + initMySQL(); // 鍒濆鍖朚ySQL } HistoryData::~HistoryData() @@ -16,11 +19,10 @@ delete ui; } -void HistoryData::on_pushButton_clicked() +void HistoryData::initMySQL() { - //娣诲姞涓�涓暟鎹簱 - QSqlDatabase db=QSqlDatabase::addDatabase("QMYSQL"); //鎷彿鍐呰鍐欏嚭鏁版嵁搴撶殑绫诲瀷 + db=QSqlDatabase::addDatabase("QMYSQL"); //鎷彿鍐呰鍐欏嚭鏁版嵁搴撶殑绫诲瀷 //璁剧疆鏁版嵁搴� db.setHostName("127.0.0.1"); //璁剧疆鏁版嵁搴撶殑涓绘満ip //璁剧疆鏁版嵁搴撶殑鐢ㄦ埛鍚� @@ -36,3 +38,38 @@ qDebug()<<"mysql conn ok"; } } + +void HistoryData::on_pushButton_clicked() +{ + + QSqlQuery que(db); + QString sql = "select * from stock_day_info"; + if(que.exec(sql)){ + qDebug()<<"select ok"; + }else{ + qDebug()<<"select fail"<<que.lastError().text(); + } +} + +void HistoryData::on_pushButton_update_clicked() +{ + // 鎶�5000鏀偂绁ㄦ尐涓幏鍙栧埌锛岀劧鍚庤繘琛屾暟鎹繚瀛橈紝瀛樺埌琛ㄦ牸涓� + // 鏇存柊鐨勬椂鍊欙紝榛樿鏀寔10骞寸殑鏁版嵁鏌ヨ + + QString time_tar=QString::number(QDateTime::currentMSecsSinceEpoch()); + QString dayCnt=QString::number(3000); + QString type = "day"; // day week month + for(auto code:m_codeNames.keys()){ + QString url = QString("https://stock.xueqiu.com/v5/stock/chart/kline.json?symbol=%1&begin=%2&period=%3&type=before&count=-%4&indicator=kline,pe,market_capital,ma").arg(code) + .arg(time_tar).arg(type).arg(dayCnt); + qDebug()<<"url:"<<url; + + } + +} + +void HistoryData::putCodeNames(QMap<QString, QString> &codeNames) +{ + m_codeNames = codeNames; + qDebug()<<"size:"<<m_codeNames.size(); +} diff --git a/historydata.h b/historydata.h index 6ff71a7..5444940 100644 --- a/historydata.h +++ b/historydata.h @@ -2,6 +2,7 @@ #define HISTORYDATA_H #include <QMainWindow> +#include <QMap> #include <QSqlDatabase> #include <QSqlError> #include <QSqlQuery> @@ -18,11 +19,21 @@ explicit HistoryData(QWidget *parent = 0); ~HistoryData(); + void initMySQL(); + private slots: void on_pushButton_clicked(); + void on_pushButton_update_clicked(); + + void putCodeNames(QMap<QString,QString> &codeNames); + private: Ui::HistoryData *ui; + + QSqlDatabase db; + + QMap<QString,QString> m_codeNames; // 鑲$エ浠e彿鍜屽悕瀛� }; #endif // HISTORYDATA_H -- Gitblit v1.8.0