public List<Tax> getTaxTableData() {
List<Tax> taxList = new ArrayList<Tax>();
Connection conn = getConnection.connection();
Statement stmt = null;
ResultSet rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM tax_table");
while (rs.next()) {
Tax tax = new Tax();
tax.setId(conUtil.convertStringToInteger(rs.getString("id")));
tax.setStatus(rs.getString("status"));
tax.setTaxRate1(conUtil.convertStringToDouble(rs.getString("taxRate1")));
tax.setTaxRate2(conUtil.convertStringToDouble(rs.getString("taxRate2")));
tax.setTaxRate3(conUtil.convertStringToDouble(rs.getString("taxRate3")));
tax.setTaxRate4(conUtil.convertStringToDouble(rs.getString("taxRate4")));
tax.setTaxRate5(conUtil.convertStringToDouble(rs.getString("taxRate5")));
tax.setTaxRate6(conUtil.convertStringToDouble(rs.getString("taxRate6")));
tax.setTaxRate7(conUtil.convertStringToDouble(rs.getString("taxRate7")));
taxList.add(tax);
}
} catch (SQLException ex) {
Logger.getLogger(TaxDAO.class.getName()).log(Level.SEVERE, null, ex);
} finally {
try {
if (conn != null || !conn.isClosed()) {
stmt.close();
rs.close();
conn.close();
}
} catch (SQLException ex) {
Logger.getLogger(TaxDAO.class.getName()).log(Level.SEVERE, null, ex);
}
}
return taxList;
}
