一个TypeError: 'str' object is not callable错误求助

水底游

1. #!/usr/bin/python
   
2. # -*- coding: utf-8 -*-
   
3. 
   
4. import MySQLdb as mdb
   
5. import sys
   
6. 
   
7. reload(sys)
   
8. sys.setdefaultencoding('utf-8')
   
9. 
   
10. con = mdb.connect(host='192.168.1.212',user='root',passwd='123456',port=3307,db='xy_db_community_s12',charset='utf8');
    
11. 
    
12. with con:
    
13. 
    
14.     name=" '%ac%' "
    
15.     print name
    
16.     print type(name)
    
17.     cur = con.cursor(r'SELECT xy_tbl_guildmember.MemberName FROM xy_tbl_guildmember, xy_tbl_guild WHERE xy_tbl_guildmember.GUILD = xy_tbl_guild.GUILD AND xy_tbl_guild.GuildName LIKE %s AND xy_tbl_guildmember.GuildPos < 4;' %name)
    
18.     #cur.execute("SELECT * FROM xy_tbl_guild")
    
19. 
    
20.     #rows = cur.fetchall()
    
21. 
    
22.     #for row in rows:
    
23.      #   print row
    
24.     '''
    
25.     numberrows=int(cur.rowcount)
    
26.     print numberrows
    
27. 
    
28.     for i in range(numberrows):
    
29.         row=cur.fetchone()
    
30.         print row[0],row[1],row[2],row[3],row[4],row[5],row[6],row[7],row[8],row[9],row[10],row[11]
    
31. 
    
32.     #rower=cur.fetchone()
    
33.     #print rower
    
34.     '''
    
35. 
    
36.     rows=cur.fetchall()
    
37.     for row in rows:
    
38.         row_list=list(row)
    
39.         print "%s" %(row_list[0])
    
40.         #print type(row)
    
41.         #print type(row_list)
    

复制代码

错误提示

1. /usr/bin/python /data/script/python/pycharm_obj_dir/python_exercise/mysql_02.py
   
2. Traceback (most recent call last):
   
3. '%ac%'
   
4.   File "/data/script/python/pycharm_obj_dir/python_exercise/mysql_02.py", line 17, in <module>
   
5. <type 'str'>
   
6.     cur = con.cursor(r'SELECT xy_tbl_guildmember.MemberName FROM xy_tbl_guildmember, xy_tbl_guild WHERE xy_tbl_guildmember.GUILD = xy_tbl_guild.GUILD AND xy_tbl_guild.GuildName LIKE %s AND xy_tbl_guildmember.GuildPos < 4;' %name)
   
7.   File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 243, in cursor
   
8. TypeError: 'str' object is not callable
   
9. 
   
10. Process finished with exit code 1
    

复制代码

这是 什么情况~

timespace

1. File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 243, in cursor

复制代码

有没有进去看看？LIKE的参数有什么特别要求

水底游

这个倒没进去看过~这个会有特殊要求么~回复 2# timespace


   

timespace

回复 3# 水底游
我没用过MySQLdb，不知道有什么特别要求，只是猜想，想到各种可能，才能一步一步定位么，当然了，需要你自己动手


   

r2007

with con:里面还要con.xxx吗？没查语法，不过记得别的语音with后不必再写with的那个object了

reyleon

你这个有问题啊..

1. cursor(self, cursorclass=None) method of MySQLdb.connections.Connection instance
   
2.     Create a cursor on which queries may be performed. The
   
3.     optional cursorclass parameter is used to create the
   
4.     Cursor. By default, self.cursorclass=cursors.Cursor is
   
5.     used.

复制代码

cursor 不能接这样的参数啊.

cur = con.cursor()
cur.execute('SELECT xy_tbl_guildmember.MemberName FROM xy_tbl_guildmember, xy_tbl_guild WHERE xy_tbl_guildmember.GUILD = xy_tbl_guild.GUILD AND xy_tbl_guild.GuildName LIKE %s AND xy_tbl_guildmember.GuildPos < 4' %name)

Linux_manne

没见过 这种啊
cur = con.cursor(r'SELECT xy_tbl_guildmember.MemberName FROM xy_tbl_guildmember, xy_tbl_guild WHERE xy_tbl_guildmember.GUILD = xy_tbl_guild.GUILD AND xy_tbl_guild.GuildName LIKE %s AND xy_tbl_guildmember.GuildPos < 4;' %name)
不是 先cur ＝ con.cursor()么？
然后通过cur.execute(..sql...) 和 cur.fetchall() 么