- /**
- * Title: 自定义调用线程类包
- * Description: 检测触发器有效性
- * @date : 2006-3-21
- * @author : zhanglei
- * @version : 1.0
- */
- package server;
- import oracle.sql.*;
- public class MyThreadClass {
- private JdbcWork ZzJw = new JdbcWork();
- private String Sql = "";
- private String tName[] = new String[10];
- public MyThreadClass() {
- int i = 0;
- try {
- tName[0] = "TR_RKBD_GA";
- tName[1] = "TR_ZPBD_GA";
- for (i=0; i<tName.length; i++) {
- if (tName[i] == null)
- continue;
- Sql = "select count(*) from USER_OBJECTS where OBJECT_TYPE='TRIGGER' and status = 'VALID' and OBJECT_NAME = '"
- + tName[i] + "'";
- if (ZzJw.GetCount(Sql) <= 0){
- SaveLog.SetInfo(tName[i] + "触发器无效!",1);
- }
- else {
- SaveLog.SetInfo(tName[i] + "触发器正常!",0);
- }
- }
- }
- catch (Exception ex) {
- SaveLog.SetInfo("MyTreadClass异常!"+ex, 2) ;
- }
- }
- }
mythreadclass
最新推荐文章于 2022-05-16 16:00:42 发布