>>> import re
>>> reg=re.compile("(\w+)=:(\w+)")
>>> s="""SELECT VC_TRADEACCO AS tradeacco FROM TACCOBANK WHERE VC_BANKACCO=:getBANKACCO AND VC_FUNDCODE=:getFUNDCODE"""
>>> reg.findall(s)
[('VC_BANKACCO', 'getBANKACCO'), ('VC_FUNDCODE', 'getFUNDCODE')]
>>>
你用过正则表达式吗