// return the records count number according sql public long getRecordsCountFromSql(String sql) throws FrameworkDAOException { // Initialize values ResultSet ret = null; Statement stmt = null; Connection connection = null; int count = 0; try { // String sSQL = sql; connection = ((DatabaseQuerier) getConnection()).getSafeConnection(); stmt = connection.createStatement(); ret = stmt.executeQuery(sql); while (ret.next()) { count++; } } catch (Exception exc) { throw new FrameworkDAOException( "S_Framework_Entry_UIDAO:getRecordsCountFromSql - " + exc, exc); } finally { String errorMsg = "Inside S_Framework_Entry_UIDAO:getRecordsCountFromSql()"; try { if (ret != null) { ret.close(); ret = null; } } catch (Exception e) { FrameworkDefaultLogger.error(errorMsg + " - 关闭时出错!\n" + e); } try { if (stmt != null) { stmt.close(); stmt = null; } } catch (Exception e) { FrameworkDefaultLogger.error(errorMsg + " - 关闭时出错!\n" + e); } try { if (connection != null) { connection.close(); connection = null; } } catch (Exception e) { FrameworkDefaultLogger.error(errorMsg + " - 关闭时出错!\n" + e); } } return count; }
/** * @return * @throws FrameworkDAOException */ public long getMaxOIDForS_Framework_Entry_UIValueObjects() throws FrameworkDAOException { // Initialize values ResultSet ret = null; Statement stmt = null; Connection connection = null; long count = 0; String sGetMaxOIDSql = "select max(testid) from test"; try { connection = ((DatabaseQuerier) getConnection()).getSafeConnection(); stmt = connection.createStatement(); ret = stmt.executeQuery(sGetMaxOIDSql); while (ret.next()) { count = ret.getLong(1); } } catch (Exception exc) { throw new FrameworkDAOException( "S_Framework_Entry_UIDAO:getMaxOIDForS_Framework_Entry_UIValueObjects - " + exc, exc); } finally { String errorMsg = "Inside S_Framework_Entry_UIDAO:getMaxOIDForS_Framework_Entry_UIValueObjects()"; try { if (ret != null) { ret.close(); ret = null; } } catch (Exception e) { FrameworkDefaultLogger.error(errorMsg + " - 关闭时出错!\n" + e); } try { if (stmt != null) { stmt.close(); stmt = null; } } catch (Exception e) { FrameworkDefaultLogger.error(errorMsg + " - 关闭时出错!\n" + e); } try { if (connection != null) { connection.close(); connection = null; } } catch (Exception e) { FrameworkDefaultLogger.error(errorMsg + " - 关闭时出错!\n" + e); } } return count; }