字符串分隔工具

字符串分隔工具


运行类   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"