qt .indexIn
时间: 2023-11-14 20:06:17 浏览: 36
`Qt` 是一个跨平台的应用程序框架,用于开发图形用户界面、网络应用程序和其他软件。`indexIn` 是 `QRegExp` 类的一个成员函数,用于在字符串中查找正则表达式模式的第一个匹配项的索引。如果没有找到匹配项,则返回 -1。 例如,以下代码将在字符串 `str` 中查找正则表达式 `regExp` 的第一个匹配项的索引:
```cpp
QRegExp regExp("[a-z]+");
QString str = "Hello World";
int index = regExp.indexIn(str);
```
在这个例子中,`index` 的值将是 1,因为第一个匹配项是 `ello`,它从索引 1 开始。
相关问题
import os from PyQt5.QtCore import Qt from PyQt5.QtGui import QPixmap, QIcon from PyQt5.QtWidgets import QApplication, QWidget, QLabel, QVBoxLayout, QHBoxLayout, QTreeView, QFileSystemModel class ImageViewer(QWidget): def init(self, folder_path): super().init() self.folder_path = folder_path self.image_dict = {} self.current_image = None self.setWindowTitle("Image Viewer") self.setFixedSize(1000, 600) self.image_label = QLabel(self) self.image_label.setAlignment(Qt.AlignCenter) self.tree_view = QTreeView() self.tree_view.setMinimumWidth(250) self.tree_view.setMaximumWidth(250) self.model = QFileSystemModel() self.model.setRootPath(folder_path) self.tree_view.setModel(self.model) self.tree_view.setRootIndex(self.model.index(folder_path)) self.tree_view.setHeaderHidden(True) self.tree_view.setColumnHidden(1, True) self.tree_view.setColumnHidden(2, True) self.tree_view.setColumnHidden(3, True) self.tree_view.doubleClicked.connect(self.tree_item_double_clicked) self.main_layout = QHBoxLayout(self) self.main_layout.addWidget(self.tree_view) self.main_layout.addWidget(self.image_label) self.load_images() self.update_image() def load_images(self): for file_name in os.listdir(self.folder_path): if file_name.lower().endswith((".jpg", ".jpeg", ".png", ".gif", ".bmp")): file_path = os.path.join(self.folder_path, file_name) self.image_dict[file_name] = file_path current_image = list(self.image_dict.keys())[0] def update_image(self): if self.current_image is not None: pixmap = QPixmap(self.image_dict[self.current_image]) self.image_label.setPixmap(pixmap.scaled(self.width() - self.tree_view.width(), self.height(), Qt.KeepAspectRatio, Qt.SmoothTransformation)) def tree_item_double_clicked(self, index): file_name = self.model.fileName(index) if file_name in self.image_dict: self.current_image = file_name self.update_image() def keyPressEvent(self, event): if event.key() == Qt.Key_A: self.previous_image() elif event.key() == Qt.Key_D: self.next_image() elif event.key() in [Qt.Key_1, Qt.Key_2, Qt.Key_3, Qt.Key_4, Qt.Key_5]: self.save_text_file(event.key() - Qt.Key_0) def previous_image(self): if self.current_image is not None: file_names = list(self.image_dict.keys()) current_index = file_names.index(self.current_image) if current_index > 0: self.current_image = file_names[current_index - 1] else: self.current_image = file_names[-1] self.update_image() def next_image(self): if self.current_image is not None: file_names = list(self.image_dict.keys()) current_index = file_names.index(self.current_image) if current_index < len(file_names) - 1: self.current_image = file_names[current_index + 1] else: self.current_image = file_names[0] self.update_image() def save_text_file(self, number): if self.current_image is not None: file_name = self.current_image txt_file_path = os.path.join(self.folder_path, os.path.splitext(file_name)[0] + ".txt") with open(txt_file_path, "w") as file: file.write(str(number)) if name == "main": import sys app = QApplication(sys.argv) viewer = ImageViewer("D:/图片/wallpaper") viewer.show() sys.exit(app.exec_())这份代码实现不了使用键盘的A键向上翻页以及D键向下翻页,也实现不了键盘数字键生成相应txt文档,帮我分析一下错在哪里
这份代码在实现键盘事件的时候,使用了错误的函数名称。应该使用`keyPressEvent`而不是`key_press_event`函数。另外,在`save_text_file`函数中,应该先判断当前图片是否为`None`,再执行后续的代码。以下是修改后的代码:
```
import os
from PyQt5.QtCore import Qt
from PyQt5.QtGui import QPixmap, QIcon
from PyQt5.QtWidgets import QApplication, QWidget, QLabel, QVBoxLayout, QHBoxLayout, QTreeView, QFileSystemModel
class ImageViewer(QWidget):
def __init__(self, folder_path):
super().__init__()
self.folder_path = folder_path
self.image_dict = {}
self.current_image = None
self.setWindowTitle("Image Viewer")
self.setFixedSize(1000, 600)
self.image_label = QLabel(self)
self.image_label.setAlignment(Qt.AlignCenter)
self.tree_view = QTreeView()
self.tree_view.setMinimumWidth(250)
self.tree_view.setMaximumWidth(250)
self.model = QFileSystemModel()
self.model.setRootPath(folder_path)
self.tree_view.setModel(self.model)
self.tree_view.setRootIndex(self.model.index(folder_path))
self.tree_view.setHeaderHidden(True)
self.tree_view.setColumnHidden(1, True)
self.tree_view.setColumnHidden(2, True)
self.tree_view.setColumnHidden(3, True)
self.tree_view.doubleClicked.connect(self.tree_item_double_clicked)
self.main_layout = QHBoxLayout(self)
self.main_layout.addWidget(self.tree_view)
self.main_layout.addWidget(self.image_label)
self.load_images()
self.update_image()
def load_images(self):
for file_name in os.listdir(self.folder_path):
if file_name.lower().endswith((".jpg", ".jpeg", ".png", ".gif", ".bmp")):
file_path = os.path.join(self.folder_path, file_name)
self.image_dict[file_name] = file_path
self.current_image = list(self.image_dict.keys())[0]
def update_image(self):
if self.current_image is not None:
pixmap = QPixmap(self.image_dict[self.current_image])
self.image_label.setPixmap(pixmap.scaled(self.width() - self.tree_view.width(), self.height(), Qt.KeepAspectRatio, Qt.SmoothTransformation))
def tree_item_double_clicked(self, index):
file_name = self.model.fileName(index)
if file_name in self.image_dict:
self.current_image = file_name
self.update_image()
def keyPressEvent(self, event):
if event.key() == Qt.Key_A:
self.previous_image()
elif event.key() == Qt.Key_D:
self.next_image()
elif event.key() in [Qt.Key_1, Qt.Key_2, Qt.Key_3, Qt.Key_4, Qt.Key_5]:
self.save_text_file(event.key() - Qt.Key_0)
def previous_image(self):
if self.current_image is not None:
file_names = list(self.image_dict.keys())
current_index = file_names.index(self.current_image)
if current_index > 0:
self.current_image = file_names[current_index - 1]
else:
self.current_image = file_names[-1]
self.update_image()
def next_image(self):
if self.current_image is not None:
file_names = list(self.image_dict.keys())
current_index = file_names.index(self.current_image)
if current_index < len(file_names) - 1:
self.current_image = file_names[current_index + 1]
else:
self.current_image = file_names[0]
self.update_image()
def save_text_file(self, number):
if self.current_image is not None:
file_name = self.current_image
txt_file_path = os.path.join(self.folder_path, os.path.splitext(file_name)[0] + ".txt")
with open(txt_file_path, "w") as file:
file.write(str(number))
if __name__ == "__main__":
import sys
app = QApplication(sys.argv)
viewer = ImageViewer("D:/图片/wallpaper")
viewer.show()
sys.exit(app.exec_())
```
self.query1_window = QueryResultWindow() def show_query1_result(self): # 查询数据 db = pymysql.connect(host='39.99.214.172', user='root', password='Solotion.123', db='jj_tset') cursor = db.cursor() db_sql = """ """ cursor.execute(db_sql) result = cursor.fetchall() db.close() if len(result) == 0: QMessageBox.information(self, "提示", "今日无员工工资记录") return self.query1_window.table_widget.setRowCount(0) self.query1_window.table_widget.setColumnCount(len(result[0])) self.query1_window.table_widget.setHorizontalHeaderLabels( ["员工ID", "员工姓名", "日期", "领取鸡爪重量(KG)", "效率(每小时KG)", "出成率", "基础工资", "重量奖励", "当日总工资"]) for row_num, row_data in enumerate(result): self.query1_window.table_widget.insertRow(row_num) for col_num, col_data in enumerate(row_data): self.query1_window.table_widget.setItem(row_num, col_num, QTableWidgetItem(str(col_data))) self.query1_window.show() class QueryResultWindow(QWidget): def __init__(self): super().__init__() # 设置窗口大小 self.setFixedSize(800, 600) self.setWindowFlags(Qt.WindowMinimizeButtonHint | Qt.WindowMaximizeButtonHint | Qt.WindowCloseButtonHint) self.download_btn = QPushButton('下载数据', self) self.download_btn.clicked.connect(self.download_data) # 创建表格控件 self.table_widget = QTableWidget() self.table_widget.setEditTriggers(QTableWidget.NoEditTriggers) self.table_widget.setSelectionBehavior(QTableWidget.SelectRows) # 创建窗口布局 layout = QVBoxLayout() layout.addWidget(self.table_widget) self.setLayout(layout)这个界面 怎么添加一个号下载界面所有数据的按钮
你可以在QueryResultWindow类中添加一个下载按钮,并连接到一个下载数据的函数。这个函数可以使用pandas库将查询结果转成DataFrame,然后保存为csv文件。
以下是修改后的代码:
```
from PyQt5.QtWidgets import QPushButton, QMessageBox
import pandas as pd
class QueryResultWindow(QWidget):
def __init__(self):
super().__init__()
# 设置窗口大小
self.setFixedSize(800, 600)
self.setWindowFlags(Qt.WindowMinimizeButtonHint | Qt.WindowMaximizeButtonHint | Qt.WindowCloseButtonHint)
# 创建表格控件
self.table_widget = QTableWidget()
self.table_widget.setEditTriggers(QTableWidget.NoEditTriggers)
self.table_widget.setSelectionBehavior(QTableWidget.SelectRows)
# 创建下载按钮
self.download_btn = QPushButton('下载数据', self)
self.download_btn.clicked.connect(self.download_data)
# 创建窗口布局
layout = QVBoxLayout()
layout.addWidget(self.table_widget)
layout.addWidget(self.download_btn)
self.setLayout(layout)
def download_data(self):
# 查询数据
db = pymysql.connect(host='39.99.214.172', user='root', password='Solotion.123', db='jj_tset')
cursor = db.cursor()
db_sql = """ """
cursor.execute(db_sql)
result = cursor.fetchall()
db.close()
if len(result) == 0:
QMessageBox.information(self, "提示", "今日无员工工资记录")
return
# 将查询结果转成DataFrame
columns = ["员工ID", "员工姓名", "日期", "领取鸡爪重量(KG)", "效率(每小时KG)", "出成率", "基础工资", "重量奖励", "当日总工资"]
df = pd.DataFrame(list(result), columns=columns)
# 保存为csv文件
save_path, _ = QFileDialog.getSaveFileName(self, "保存文件", "", "CSV Files (*.csv)")
if save_path:
df.to_csv(save_path, index=False)
QMessageBox.information(self, "提示", "数据已保存至{}".format(save_path))
```