public ArrayList<ArrayList<String>> getDataForTable(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 getDataForTable(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.getDataForTable(dbType, hostname, portnumber, username, password, tableName, dBorSIDName); return generateWorksheet(dbUtil, data); }