Sql文整理 小函数
来源:互联网 发布:vb里头mid函数的用法 编辑:程序博客网 时间:2024/04/28 14:30
private void showSql(String strIn)
{
String strOut = "";
strOut = strIn.toUpperCase();
strOut = strOut.replaceAll(" and ","/n/t and ");
strOut = strOut.replaceAll(" on ","/n/t on ");
strOut = strOut.replaceAll(" inner join ","/n inner join ");
strOut = strOut.replaceAll(" left outer join ","/n left outer join ");
strOut = strOut.replaceAll(" left join ","/n left join ");
strOut = strOut.replaceAll(" AND ","/n/t AND ");
strOut = strOut.replaceAll(" ON ","/n/t on ");
strOut = strOut.replaceAll(" INNER JOIN ","/n inner join ");
strOut = strOut.replaceAll(" LEFT OUTER JOIN ","/n left outer join ");
strOut = strOut.replaceAll(" LEFT JOIN ","/n left join ");
System.out.println(strOut);
return ;
}
{
String strOut = "";
strOut = strIn.toUpperCase();
strOut = strOut.replaceAll(" and ","/n/t and ");
strOut = strOut.replaceAll(" on ","/n/t on ");
strOut = strOut.replaceAll(" inner join ","/n inner join ");
strOut = strOut.replaceAll(" left outer join ","/n left outer join ");
strOut = strOut.replaceAll(" left join ","/n left join ");
strOut = strOut.replaceAll(" AND ","/n/t AND ");
strOut = strOut.replaceAll(" ON ","/n/t on ");
strOut = strOut.replaceAll(" INNER JOIN ","/n inner join ");
strOut = strOut.replaceAll(" LEFT OUTER JOIN ","/n left outer join ");
strOut = strOut.replaceAll(" LEFT JOIN ","/n left join ");
System.out.println(strOut);
return ;
}
- Sql文整理 小函数
- Sql语句小整理
- oracle 小函数整理
- sql字符串函数【整理】
- c# SQL函数整理
- SQL内置函数整理
- SQL时间函数整理
- sql函数整理
- T-SQL函数整理
- 常用sql函数整理
- SQL函数整理
- SQL函数整理
- 【SQL】SQL常用函数整理
- SQL几个小函数
- SQL字符串处理函数整理
- SQL字符串处理函数整理
- SQL Server内置函数整理
- Sql Server常用函数整理
- javac命令详解
- C++编程规范的重要性
- gconf-editor的使用
- SQL查询语句精华使用简要
- 利用js跨页面保存变量做菜单应用
- Sql文整理 小函数
- Autonomy Research Report
- 寒假特训计划
- .NET Framework 类库 介绍
- 关于C Run-Time 在 crtdefs.h 中定义的分析
- 硬盘安装NetBSD4.0
- 感染explorer.exe,使用映像劫持,ShellExecHook…的AV杀手GRHSGIH.EXE1
- Error 14274: 无法添加、更新或删除从MSX服务器上发起的作业.
- 请教OpenGL坐标旋转