python数据库查询 python数据库查询生成树

sql中有中文条件查询死活不出来
把中文给变量然后%s传参也不行，只能传编码多嵌套一层去查中文名称
暂时没有找到解决方法

这个库貌似也没办法写入中文名

from PIL import Image, ImageDraw
import pymssql




class RelationTree:
    def __init__(self, basewidth=100, basedepth=100):
        self.basewidth = basewidth
        self.basedepth = basedepth
        self.root = None

    def gentree(self, db, mothervalue, tablename, childcol, mothercol):
        self.root = decisionnode(mothervalue)
        cur = db.cursor()

        def swap_gentree(node):
            cur.execute("select  %s from %s where %s = '%s' and SSMK = 4  " % \
                        (childcol, tablename, mothercol, node.value))
            results = cur.fetchall()
            print("数据库查询完成")



            # 如果是叶子节点，则直接返回
            if not results:

                return decisionnode(node.value, isleaf=True, maxlevel=1)
                # return decisionnode(results[1], isleaf=True, maxlevel=1)

                # 程序运行到这里，说明是非叶子节点
                # 对非叶子节点进行其下包含的叶子节点进行统计（leafcounts）
                # 该节点之下最深的深度maxlevel收集

            maxlevel = 1
            for each in results:
                print(each)

                entrynode = swap_gentree(decisionnode(each[0]))


                if (entrynode.isleaf): #如果是叶子节点
                    node.leafcounts += 1

                else:#如果不是叶子节点
                    node.leafcounts += entrynode.leafcounts

                #扩展深度
                if (entrynode.maxlevel > maxlevel):
                    maxlevel = entrynode.maxlevel
                node.addchild(entrynode)

            node.maxlevel = maxlevel + 1
            return node

        swap_gentree(self.root)


    def draweachnode(self, tree, draw, x, y):
        draw.text((x, y), tree.value, (0, 0, 0))

        if not tree.childs:
            return


        childs_leafcounts = [child.leafcounts if child.leafcounts else 1 for child in tree.childs]

        leafpoint = x - sum(childs_leafcounts) * self.basewidth / 2

        cumpoint = 0
        for childtree, point in zip(tree.childs, childs_leafcounts):
            centerpoint = leafpoint + self.basewidth * cumpoint + self.basewidth * point / 2
            cumpoint += point
            draw.line((x, y, centerpoint, y + self.basedepth), (255, 0, 0))
            self.draweachnode(childtree, draw, centerpoint, y + self.basedepth)

    def drawTree(self, filename='tree.png'):
        width = self.root.leafcounts * self.basewidth + self.basewidth
        depth = self.root.maxlevel * self.basedepth + self.basedepth
        img = Image.new(mode="RGB", size=(width, depth), color=(255, 255, 255))
        draw = ImageDraw.Draw(img)
        self.draweachnode(self.root, draw, width / 2, 20)

        img.save(filename)


class decisionnode:
    def __init__(self, value, isleaf=False, leafcounts=0, maxlevel=1):
        self.childs = []
        self.value = value
        self.isleaf = isleaf
        self.leafcounts = leafcounts
        self.maxlevel = maxlevel

    def addchild(self, child):
        self.childs.append(child)


if __name__ == '__main__':
# gentree 方法用于生成整棵树，需要传值：db:数据库连接，mathervalue：根节点的数值    tablename：数据库表名     childcol：子节点在表中的对应的字段名称     mothercol：上级节点在表中的字段名称
# gentree(self, db, mothervalue, tablename, childcol, mothercol):
#             数据库连接：根节点的数值：数据库表名：子节点在表中的对应的字段名称 ：上级节点在表中的字段名称
    db = pymssql.connect(  ........charset='GBK')
    tree = RelationTree()
    tree.gentree(db,........)



    tree.drawTree('tree.png')