public ArrayList<ArrayList<String>> getDataForQuery(DBType dbType, String hostname, int portnumber, String username, String password, String tableName, String dBorSIDName) throws SQLException, ClassNotFoundException { Connection conn = getConnection(hostname, portnumber, username, password, dBorSIDName); return getDataForQuery(conn, tableName); }
public Worksheet generateWorksheetForAllRows() throws SQLException, ClassNotFoundException { /** * Get the data from the database table * */ AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType); ArrayList<ArrayList<String>> data = dbUtil.getDataForQuery(dbType, hostname, portnumber, username, password, query, dBorSIDName); return generateWorksheet(dbUtil, data); }