?? datacheck.java
字號:
/**
* Title: 通用組件開發
* Description: com.huiton.functions.DataCheck 檢查數據完整性
* Copyright: Copyright (c) 2001
* Company: huiton
* @author 吳劍
* @version 1.0
*/
package com.huiton.pub.dbx;
import java.sql.*;
import com.huiton.pub.dbx.*;
public class DataCheck
{String m_sessionCode = "",m_sysCode = "";
JdbObj store;
String errMsg = "";
public DataCheck(String sessionCode, String sysCode) {
m_sessionCode = sessionCode;
m_sysCode = sysCode;
try {
store = new JdbObj(m_sessionCode, m_sysCode);
}catch (Exception e) {
errMsg = this.getClass().getName() + ": " + e;
}
}
public boolean checkPK(String table, String[] primaryKey) {
try {
DatabaseMetaData dbmd = store.conn.getMetaData();
ResultSet pkRS = dbmd.getPrimaryKeys(null, null, table);
//形成按關鍵字的條件與句
String strCri = "";
for(int i=0;pkRS.next();i++)
strCri += " AND " + pkRS.getString(4) + " = '" + primaryKey[i] + "' ";
strCri = strCri.substring(5, strCri.length());
//獲取該條件的記錄個數
com.huiton.pub.dbx.LookField lf = new LookField();
int recNum = Integer.parseInt(lf.dCount("*", table, strCri));
return recNum<=0;
}
catch(SQLException e) {
errMsg = this.getClass().getName() + ".checkPK: " + e;
return false;
}
}
//獲取錯誤信息
public String getErrMsg() {
return errMsg;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -