def generate_set_element(fields):
fields_list = fields.split(', ')
set_element = "<set>\n"
for field in fields_list:
set_element += f" <if test=\"{field} != null\">{field} = #{{{field}}},</if>\n"
set_element += " </set>"
return set_element
def main():
# 输入字段的字符串
input_fields =input("请输入字段字符串: 必须是id, category_id, name, price, status, description, image, create_time, update_time, create_user, update_user这种形式")
# 生成 <set> 元素
set_element = generate_set_element(input_fields)
# 输出结果
print(set_element)
print("WHERE id = #{id}")
if __name__ == "__main__":
main()
主要是用手写数据库mapper太麻烦了,还有insert,都是为了省去麻烦,有时候想直接用mybatisPlus但是引入老工程的时候又会有bug,不得不直接写mapper.xml
"""
一个给输入字符串改成#{}形式
"""
def extract_fields(input_string):
filelist = [field.strip() for field in input_string.split(",")]
filelist = ["#{"+ word + "}" for word in filelist]
fileString = ""
for word in filelist:
fileString = fileString+word+","
return fileString
input_string = input("请输入字段字符串: ")
print(extract_fields(input_string)[:-1])