编辑代码

# coding:utf-8

class StudentManager():

    def add_student(self,tablename,**kwargs):
        columns=[]
        values=[]
        for col,val in kwargs.items():
            columns.append(col)
            values.append(val)
        columnsSqlPart= ",".join('`'+col+'`' for col in columns ) 
        valuesSqlPart=",".join(  '"'+val+'"' if val is not None else 'null' for val in values)
        sql="insert into %s(%s) values(%s)" % (tablename,columnsSqlPart,valuesSqlPart)
        print(sql)




sm=StudentManager()
 
sm.add_student("student",name='zhansan',sex='nan',age=None)