需求

格式化sql到java代码

sourceFilename = "sql.txt"
targetFilename = "after.txt"

f = open(targetFilename,"w")
with open(sourceFilename, 'r') as file_to_read:
  while True:
    # 逐行读取
    line = file_to_read.readline()
    # 去掉换行和制表符
    str = line.replace('\n','').replace('\t','    ')
    # 手动加上换行符和需要的format格式
    str='+ "'+str+' "\n'
    # 写入目标文件
    f.write(str)
    # 读到末尾退出
    if not line:
        file_to_read.close()
        f.close()
        break

sql.txt

SELECT
	member_id,
	com_name
FROM

问题

解决换行符和制表符的问题

# 方法一
#     f=open("test_text.txt")
#     line = f.read().splitlines()
# 方法二
#     line = line.lstrip('\n')
#     line = line.lstrip('\t')
# 方法三
#     line = line.replace('\n ','').replace('\t','') 

open参数

参考

https://www.cnblogs.com/hackpig/p/8215786.html