/** * Retrieve the det_id from a dcuHardId * * @param dcuId The dcuHard Id * @return The det_id corresponding to the dcu_id */ public int getDetId(int dcuId) throws java.sql.SQLException { ArrayList<ArrayList<String>> res = c.selectQuery("select detid from dcuInfo where dcuhardid=" + dcuId); if (res.size() == 0) throw new java.sql.SQLException("No detId found for DcuId " + dcuId); else return Integer.parseInt((res.get(0)).get(0)); }