用C为python3.1封装mysql接口(三)

#testsql.py
#此代码输出某个表格的所有列内容
import sys
from _oopmysql import mysql#这样就不用 sql = __oopmysql.mysql()了。直接mysql()
def test(a,b=3,c=5):
    print(a,b,c)

sql = mysql()
print(sql.connect("192.168.1.198", "root", "", "test"))
print(sql.setcode("utf8"))
print(sql.query("SELECT *FROM testdb"))
while True:
    if sql.nextrow() == False:
        break
    outstr = ""
    while True:
        field = sql.nextfield()
        if field == None:
            break
        outstr += field
        outstr += "\t"
    print(sql.getrownum(), "行为:", outstr)
sql.close()