我想通过phpmyadmin获取mysql数据库 . 我从youtube尝试了这段代码 . 但我的电脑操作系统是Mac . 它不适用于我的 . 它一直在说
发生异常:ModuleNotFoundError没有名为'MySQLdb'文件的模块“/Users/simboyoung/Desktop/tablewidget2.py”,第10行,导入MySQLdb为mdb
也许是因为Mac不提供mob文件?如果我要使用sql文件来处理这段代码 . 哪个部分我应该编辑?
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'tablewidget.ui'
#
# Created by: PyQt5 UI code generator 5.9.2
#
# WARNING! All changes made in this file will be lost!
from PyQt5 import QtCore, QtGui, QtWidgets
import MySQLdb as mdb
class Ui_MainWindow(object):
def InsertData(self):
name = [self.tableWidget.item(row, 0).text() for row in range(self.tableWidget.rowCount())]
phone = [self.tableWidget.item(row, 1).text() for row in range(self.tableWidget.rowCount())]
point = [self.tableWidget.item(row, 2).text() for row in range(self.tableWidget.rowCount())]
con = mdb.connect('localhost', 'root', 'PASSWORD', 'hufpos')
with con:
cur= con.cursor()
cur.execute("INSERT INTO cust_info(c_name, c_numb, c_point)"
"VALUES('%s', '%s', '%d')" %(''.join(name),''.join(phone),''.join(point)))
print("Data Inserted Successfully")
def setupUi(self, MainWindow):
MainWindow.setObjectName("MainWindow")
MainWindow.resize(317, 351)
self.centralwidget = QtWidgets.QWidget(MainWindow)
self.centralwidget.setObjectName("centralwidget")
self.pushButton = QtWidgets.QPushButton(self.centralwidget)
self.pushButton.setGeometry(QtCore.QRect(90, 300, 151, 21))
self.pushButton.setObjectName("pushButton")
self.pushButton.clicked.connect(self.InsertData)
self.tableWidget = QtWidgets.QTableWidget(self.centralwidget)
self.tableWidget.setGeometry(QtCore.QRect(0, 0, 321, 281))
self.tableWidget.setObjectName("tableWidget")
self.tableWidget.setColumnCount(3)
self.tableWidget.setRowCount(1)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setVerticalHeaderItem(0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(0, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(1, item)
item = QtWidgets.QTableWidgetItem()
self.tableWidget.setHorizontalHeaderItem(2, item)
MainWindow.setCentralWidget(self.centralwidget)
self.statusbar = QtWidgets.QStatusBar(MainWindow)
self.statusbar.setObjectName("statusbar")
MainWindow.setStatusBar(self.statusbar)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
def retranslateUi(self, MainWindow):
_translate = QtCore.QCoreApplication.translate
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow"))
self.pushButton.setText(_translate("MainWindow", "회원 정보를 입력 하세요"))
item = self.tableWidget.verticalHeaderItem(0)
item.setText(_translate("MainWindow", "1"))
item = self.tableWidget.horizontalHeaderItem(0)
item.setText(_translate("MainWindow", "name"))
item = self.tableWidget.horizontalHeaderItem(1)
item.setText(_translate("MainWindow", "phone"))
item = self.tableWidget.horizontalHeaderItem(2)
item.setText(_translate("MainWindow", "point"))
if __name__ == "__main__":
import sys
app = QtWidgets.QApplication(sys.argv)
MainWindow = QtWidgets.QMainWindow()
ui = Ui_MainWindow()
ui.setupUi(MainWindow)
MainWindow.show()
sys.exit(app.exec_())