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.cpp | 43 ++++++++++++++++++++++++++++++++++++++++---
1 files changed, 40 insertions(+), 3 deletions(-)
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();
+}
--
Gitblit v1.8.0