mmp我搞了半天发现是在做字符串的转换,这个是必然报错的,但是我们用连接操作就可以了,利用MySQLhelper的get_one方法去传就可以了,自己真的菜啊看来
#方法一:
#encoding=utf8from fengzhaung import *ih=input("输入编号")print(id(ih))sql="select * from stu where stu_id="+ihhelper=MysqlHelper(‘192.168.65.146‘,3306,‘student‘,‘root‘,‘toor‘)s=helper.get_one(sql)print(s)
#方法二
#encoding=utf8from fengzhaung import *
ih=input("请输入编号:")
sql="select * from stu where stu_id=%s"
param=[ih]
helper=MysqlHelper(‘192.168.65.146‘,3306,‘student‘,‘root‘,‘toor‘)
s=helper.get_one(sql,param)
print(s)