我尝试使用QLineEdit小部件从用户检索一些值。当QPushButton引发一个clicked事件时,我希望从所有QLineEdit小部件中检索文本并存储在本地MySQL数据库中。但是,当我试图在insert语句中使用string substation时,这些值不会被替换。下面是我的sql语句:
sql = 'INSERT INTO jobs (incident_id, organization, organization_poc, media_type) VALUES ("%s", "%s", "%s", "%s")' % (self.edi_IncidentID.text(), self.edi_OrganizationAffected.text(), self.edi_OrganizationContact.text(), self.edi_MediaType.text())
所有self.edi_xxx公司变量只是QLineEdit小部件。当按下按钮时,会触发以下命令:
^{pr2}$submit只需创建一个数据库对象并将值写入数据库。但是,为了调试,我打印出构建的SQL语句,结果如下: 插入作业(事件标识、组织、组织、poc、介质类型)值(“,”“,”“,”“”)。在
我也尝试过使用str()函数将一个QString转换为一个字符串,但是发生了同样的事情。在
任何帮助都将不胜感激:)?在
我
编辑:以下是减去导入的完整代码:
class Database():
def __init__(self):
self.db_host = "localhost"
self.db_user = "***********"
self.db_pass = "***********"
self.db_name = "incidents"
def openConn(self):
self.db = MySQLdb.connect(self.db_host, self.db_user, self.db_pass, self.db_name)
def closeConn(self):
self.db.close()
def writeValues(self, sql):
self.openConn()
self.cursor = self.db.cursor()
self.cursor.execute(sql)
self.cursor.fetchone()
self.closeConn()
class NewIncidentForm(QtGui.QWidget):
def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.setWindowTitle('New Incident')
lbl_IncidentID = QtGui.QLabel('Incident ID:')
lbl_MediaType = QtGui.QLabel('Media Type:')
lbl_OrganizationAffected = QtGui.QLabel('Organization Affected:')
lbl_OrganizationContact = QtGui.QLabel('Organization Point of Contact: ')
self.edi_IncidentID = QtGui.QLineEdit()
self.edi_MediaType = QtGui.QLineEdit()
self.edi_OrganizationAffected = QtGui.QLineEdit()
self.edi_OrganizationContact = QtGui.QLineEdit()
btn_Submit = QtGui.QPushButton('Submit')
grid = QtGui.QGridLayout()
grid.setSpacing(10)
grid.addWidget(lbl_IncidentID, 1, 0)
grid.addWidget(self.edi_IncidentID, 1, 1)
grid.addWidget(lbl_MediaType, 3, 0)
grid.addWidget(self.edi_MediaType, 3, 1)
grid.addWidget(lbl_OrganizationAffected, 4, 0)
grid.addWidget(self.edi_OrganizationAffected, 4, 1)
grid.addWidget(lbl_OrganizationContact, 5, 0)
grid.addWidget(self.edi_OrganizationContact, 5, 1)
grid.addWidget(btn_Submit, 15, 0)
self.sql = 'INSERT INTO jobs (incident_id, organization, organization_poc, media_type) VALUES ("%s", "%s", "%s", "%s")' % (self.edi_IncidentID.text(), self.edi_OrganizationAffected.text(), self.edi_OrganizationContact.text(), self.edi_MediaType.text())
self.connect(btn_Submit, QtCore.SIGNAL('clicked()'), self.submitForm)
self.setLayout(grid)
self.resize(350, 300)
def submitForm(self):
db = Database()
db.writeValues(self.sql)
app = QtGui.QApplication(sys.argv)
qb = NewIncidentForm()
qb.show()
sys.exit(app.exec_())
该程序缺少的另一部分是commit()函数,该函数用于存储数据或在脚本请求时自动提交(true)
原因很简单:
在自我.sql应该在里面 定义提交格式(自身):
不在 definit(self,parent=None):
因为其他人是空的!在
:天 QString有
__str__
函数,请尝试以下操作:添加了
''.join()
或者QString有toUtf8()
因此,将
^{pr2}$self.edi_IncidentIS.text()
改为:整个说明:
相关问题 更多 >
编程相关推荐