public BeanTest[] getViewAllTestForUser(String CUserName, String CCatName) throws SQLException { ArrayList<BeanTest> test2 = new ArrayList<>(); PreparedStatement statement = connection.prepareStatement(Constants.sqlCommands.getViewAllTestForUserSql); statement.setString(1, CCatName); statement.setString(2, CUserName); ResultSet rs = statement.executeQuery(); BeanTest objTest; while (rs.next()) { objTest = new BeanTest(); objTest.setTestName(rs.getString(1)); objTest.setTestDate(rs.getDate(2)); objTest.setTestDuration(rs.getInt(3)); objTest.setTestId(rs.getInt(4)); if (rs.getDouble(5) == 0.0 && rs.getInt(6) == 0 && rs.getInt(7) == 0) objTest.setTestDesc("Not Attempted"); else objTest.setTestDesc("Attempted"); test2.add(objTest); } rs.close(); statement.close(); // connection.close(); return test2.toArray(new BeanTest[test2.size()]); }
public BeanTest[] getNotRegisterTestForUser(String CUserName, String CCatName) throws SQLException { ArrayList<BeanTest> test1 = new ArrayList<>(); PreparedStatement statement = connection.prepareStatement(Constants.sqlCommands.getNotRegisterTestForUserSql); statement.setString(1, CCatName); statement.setString(2, CUserName); ResultSet rs = statement.executeQuery(); BeanTest objTest; while (rs.next()) { objTest = new BeanTest(); objTest.setTestName(rs.getString(1)); objTest.setTestDate(rs.getDate(2)); objTest.setTestDuration(rs.getInt(3)); objTest.setTestId(rs.getInt(4)); test1.add(objTest); } rs.close(); statement.close(); return test1.toArray(new BeanTest[test1.size()]); }