字符串分隔工具

字符串分隔工具


运行类 Run.java类 或直接双击run.bat文件

功能：将字符串按行拆分，符合java字符串的连接
使用步骤：
一：将格式化后的sql脚本复制到 sql.txt文件中

然后执行 Run.java main，就会在控制台看到，打印出来的字符串
同时将结果保存到output.txt文件中


demo

sql.txt

SELECT
t.NUMMAILLISTGUID,
t.NUMMAILGUID,
t.VC2MAILTITLE,
t.VC2MAILCONTENT,
t.VC2SENDDATE,
t.NUMSENDFLAG,
t.VC2REMARK,
t.DATCREATEDATE,
t.NUMCREATECODE,
t.DATOPERDATE,
t.NUMOPERCODE,
t.NUMATTACHFLAG
FROM ct_sendmaillist_new t


解析为：output.txt

"SELECT "+
" t.NUMMAILLISTGUID,"+
" t.NUMMAILGUID,"+
" t.VC2MAILTITLE,"+
" t.VC2MAILCONTENT,"+
" t.VC2SENDDATE,"+
" t.NUMSENDFLAG,"+
" t.VC2REMARK,"+
" t.DATCREATEDATE,"+
" t.NUMCREATECODE,"+
" t.DATOPERDATE,"+
" t.NUMOPERCODE,"+
" t.NUMATTACHFLAG"+
" FROM ct_sendmaillist_new t"