/** * Counts the number of rows that are loaded from the database * * @throws Exception if the number of rows cannot be calculated * @return the entire number of rows */ private int getRowCount() throws Exception { String query = "SELECT COUNT(*) FROM " + endOfQuery(false); if (m_DataBaseConnection.execute(query) == false) { throw new Exception("Cannot count results tuples."); } ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); int i = rs.getInt(1); rs.close(); return i; }
/** * Counts the number of rows that are loaded from the database * * @throws Exception if the number of rows cannot be calculated * @return the entire number of rows */ private int getRowCount() throws Exception { String query = "SELECT COUNT(*) FROM " + endOfQuery(false); if (m_DataBaseConnection.execute(query) == false) { throw new Exception("Cannot count results tuples."); } ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); int i = rs.getInt(1); rs.close(); return i; }
String countS = "SELECT COUNT(*) FROM " + m_resolvedTableName; m_DataBaseConnection.execute(countS); ResultSet countRS = m_DataBaseConnection.getResultSet(); countRS.next(); m_count = countRS.getInt(1);
String countS = "SELECT COUNT(*) FROM " + m_resolvedTableName; m_DataBaseConnection.execute(countS); ResultSet countRS = m_DataBaseConnection.getResultSet(); countRS.next(); m_count = countRS.getInt(1);
ResultSet rs = m_DataBaseConnection.getResultSet(); "SELECT COUNT(DISTINCT( " + columnName + " )) FROM " + end; if (m_DataBaseConnection.execute(query) == true) { rs1 = m_DataBaseConnection.getResultSet(); rs1.next(); int count = rs1.getInt(1); break; rs1 = m_DataBaseConnection.getResultSet(); } else { rs1 = m_DataBaseConnection.getResultSet(); stringToNominal(rs1, i); rs1.close(); if (m_DataBaseConnection.getResultSet() != null) { rs.close();
ResultSet rs = m_DataBaseConnection.getResultSet(); "SELECT COUNT(DISTINCT( " + columnName + " )) FROM " + end; if (m_DataBaseConnection.execute(query) == true) { rs1 = m_DataBaseConnection.getResultSet(); rs1.next(); int count = rs1.getInt(1); break; rs1 = m_DataBaseConnection.getResultSet(); } else { rs1 = m_DataBaseConnection.getResultSet(); stringToNominal(rs1, i); rs1.close(); if (m_DataBaseConnection.getResultSet() != null) { rs.close();
ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); Instance current = readInstance(rs);
ResultSet rs = m_DataBaseConnection.getResultSet(); rs.next(); Instance current = readInstance(rs);