python中string实现字符串占位符替换

if __name__ == '__main__':
    import string

    st = string.Template("select * from aa where ab = ${qiu} and ${zhang}")
    p = {'qiu': "'aaa'", 'zhang': "'bbb'"}
    print(st.substitute(p))

执行结果：

select * from aa where ab = 'aaa' and 'bbb'