String busSql=new StringBuilder("delete from CMMS_CHANNEL_BUSINESS_FOCUS where USER_CODE=? and CHANNEL_ID in (")
.append(" select CHANNEL_ID from CMMS_DIRECTOR_CHANNEL where USER_CODE =?")
.append(" and CHANNEL_ID in (select CHANNEL_ID from CMMS_FOCUS_CHANNEL_TAB_RELAT t1")
.append(" where t1.TAB_ID =? and not exists (select 1")
.append(" from CMMS_FOCUS_CHANNEL_TABS t2, CMMS_FOCUS_CHANNEL_TAB_RELAT t3")
.append(" where t2.TAB_ID = t3.TAB_ID and t2.OWN_USER_CODE =?")
.append(" and t2.TAB_ID <> t1.TAB_ID and t3.CHANNEL_ID=t1.CHANNEL_ID)))").toString();
getSimpleJdbc().update(busSql,userCode,userCode,tabId, userCode);String dirSql=new StringBuilder("delete from CMMS_DIRECTOR_CHANNEL where USER_CODE =?")
.append(" and CHANNEL_ID in (select CHANNEL_ID from CMMS_FOCUS_CHANNEL_TAB_RELAT t1")
.append(" where t1.TAB_ID =? and not exists (select 1")
.append(" from CMMS_FOCUS_CHANNEL_TABS t2, CMMS_FOCUS_CHANNEL_TAB_RELAT t3")
.append(" where t2.TAB_ID = t3.TAB_ID and t2.OWN_USER_CODE =?")
.append(" and t2.TAB_ID <> t1.TAB_ID and t3.CHANNEL_ID=t1.CHANNEL_ID))").toString();
getSimpleJdbc().update(dirSql,userCode,tabId, userCode);
如何优化这两段数据库?
.append(" select CHANNEL_ID from CMMS_DIRECTOR_CHANNEL where USER_CODE =?")
.append(" and CHANNEL_ID in (select CHANNEL_ID from CMMS_FOCUS_CHANNEL_TAB_RELAT t1")
.append(" where t1.TAB_ID =? and not exists (select 1")
.append(" from CMMS_FOCUS_CHANNEL_TABS t2, CMMS_FOCUS_CHANNEL_TAB_RELAT t3")
.append(" where t2.TAB_ID = t3.TAB_ID and t2.OWN_USER_CODE =?")
.append(" and t2.TAB_ID <> t1.TAB_ID and t3.CHANNEL_ID=t1.CHANNEL_ID)))").toString();
getSimpleJdbc().update(busSql,userCode,userCode,tabId, userCode);String dirSql=new StringBuilder("delete from CMMS_DIRECTOR_CHANNEL where USER_CODE =?")
.append(" and CHANNEL_ID in (select CHANNEL_ID from CMMS_FOCUS_CHANNEL_TAB_RELAT t1")
.append(" where t1.TAB_ID =? and not exists (select 1")
.append(" from CMMS_FOCUS_CHANNEL_TABS t2, CMMS_FOCUS_CHANNEL_TAB_RELAT t3")
.append(" where t2.TAB_ID = t3.TAB_ID and t2.OWN_USER_CODE =?")
.append(" and t2.TAB_ID <> t1.TAB_ID and t3.CHANNEL_ID=t1.CHANNEL_ID))").toString();
getSimpleJdbc().update(dirSql,userCode,tabId, userCode);
如何优化这两段数据库?
解决方案 »
- 200分 求教 如何修改throwable里面的StackTraceElement的内容 都来看看哇 很简单的问题 但是我不会
- JTree修改当前节点时,怎样获取修改后的节点名称?
- JDBC 调用 Record 参数类型的 存储过程的问题
- 我的JSP程序无法运行,提示附在下面,但我怎么看也不像,大家帮帮忙啊??
- 请各位高手看一下,就一下
- 为什么没有结果
- ServerSocket中的队列长度是什么含义?
- 谁有InstallAnywhere6.1的注册码阿?或者注册版下载
- 问一个有点BT的问题!关于把PDF转换成jpg行不行??
- 新手上路:窗体关闭的问题
- 接着刚刚的问题
- 我导入一个已经写好的maven项目,这个项目是可以运行的,我导入后启动就报监听器错误
去掉一大堆 append ,代码量就少了