How to use loadFromResultSet method of org.cerberus.crud.dao.impl.UserDAO class

Best Cerberus-source code snippet using org.cerberus.crud.dao.impl.UserDAO.loadFromResultSet

Source:UserDAO.java

...72                preStat.setString(1, login);73                ResultSet resultSet = preStat.executeQuery();74                try {75                    if (resultSet.first()) {76                        result = this.loadFromResultSet(resultSet);77                    }78                } catch (SQLException exception) {79                    LOG.warn("Unable to execute query : " + exception.toString());80                } finally {81                    resultSet.close();82                }83            } catch (SQLException exception) {84                LOG.warn("Unable to execute query : " + exception.toString());85            } finally {86                preStat.close();87            }88        } catch (SQLException exception) {89            LOG.warn("Unable to execute query : " + exception.toString());90        } finally {91            try {92                if (connection != null) {93                    connection.close();94                }95            } catch (SQLException e) {96                LOG.warn(e.toString());97            }98        }99        return result;100    }101    @Override102    public List<User> findAllUser() {103        List<User> list = null;104        final String query = "SELECT * FROM user usr ORDER BY userid";105        Connection connection = this.databaseSpring.connect();106        try {107            PreparedStatement preStat = connection.prepareStatement(query);108            try {109                ResultSet resultSet = preStat.executeQuery();110                try {111                    list = new ArrayList<User>();112                    while (resultSet.next()) {113                        User user = this.loadFromResultSet(resultSet);114                        list.add(user);115                    }116                } catch (SQLException exception) {117                    LOG.warn("Unable to execute query : " + exception.toString());118                } finally {119                    resultSet.close();120                }121            } catch (SQLException exception) {122                LOG.warn("Unable to execute query : " + exception.toString());123            } finally {124                preStat.close();125            }126        } catch (SQLException exception) {127            LOG.warn("Unable to execute query : " + exception.toString());128        } finally {129            try {130                if (connection != null) {131                    connection.close();132                }133            } catch (SQLException e) {134                LOG.warn(e.toString());135            }136        }137        return list;138    }139    @Override140    public boolean insertUser(User user) {141        boolean bool = false;142        final String query = "INSERT INTO user (Login, Password, Name, Request, ReportingFavorite, RobotHost, DefaultSystem, Team, Language, Email, UserPreferences) VALUES (?, SHA(?), ?, ?, ?, ?, ?, ?, ?, ?, '')";143        Connection connection = this.databaseSpring.connect();144        try {145            PreparedStatement preStat = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);146            try {147                preStat.setString(1, user.getLogin());148                preStat.setString(2, user.getPassword());149                preStat.setString(3, user.getName());150                preStat.setString(4, user.getRequest());151                preStat.setString(5, user.getReportingFavorite());152                preStat.setString(6, user.getRobotHost());153                preStat.setString(7, user.getDefaultSystem());154                preStat.setString(8, user.getTeam());155                preStat.setString(9, user.getLanguage());156                preStat.setString(10, user.getEmail());157                preStat.executeUpdate();158                ResultSet resultSet = preStat.getGeneratedKeys();159                try {160                    if (resultSet.first()) {161                        user.setUserID(resultSet.getInt(1));162                        bool = true;163                    }164                } catch (SQLException exception) {165                    LOG.warn("Unable to execute query : " + exception.toString());166                } finally {167                    resultSet.close();168                }169            } catch (SQLException exception) {170                LOG.warn("Unable to execute query : " + exception.toString());171            } finally {172                preStat.close();173            }174        } catch (SQLException exception) {175            LOG.warn("Unable to execute query : " + exception.toString());176        } finally {177            try {178                if (connection != null) {179                    connection.close();180                }181            } catch (SQLException e) {182                LOG.warn(e.toString());183            }184        }185        return bool;186    }187    @Override188    public boolean deleteUser(User user) {189        boolean bool = false;190        final String query = "DELETE FROM user WHERE userid = ?";191        Connection connection = this.databaseSpring.connect();192        try {193            PreparedStatement preStat = connection.prepareStatement(query);194            try {195                preStat.setInt(1, user.getUserID());196                bool = preStat.executeUpdate() > 0;197            } catch (SQLException exception) {198                LOG.warn("Unable to execute query : " + exception.toString());199            } finally {200                preStat.close();201            }202        } catch (SQLException exception) {203            LOG.warn("Unable to execute query : " + exception.toString());204        } finally {205            try {206                if (connection != null) {207                    connection.close();208                }209            } catch (SQLException e) {210                LOG.warn(e.toString());211            }212        }213        return bool;214    }215    @Override216    public boolean updateUser(User user) {217        boolean bool = false;218        StringBuilder query = new StringBuilder();219        query.append("UPDATE user SET Login = ?, Name = ?, Request = ?, ReportingFavorite = ?, RobotHost = ?,");220        query.append("Team = ?, Language = ?, DefaultSystem = ?, Email= ? , robotPort = ?, ");221        query.append("robotPlatform = ?, ");222        query.append("robotBrowser = ?, robotVersion = ? , robot = ? , userPreferences = ?  WHERE userid = ?");223        Connection connection = this.databaseSpring.connect();224        try {225            PreparedStatement preStat = connection.prepareStatement(query.toString());226            try {227                preStat.setString(1, user.getLogin());228                preStat.setString(2, user.getName());229                preStat.setString(3, user.getRequest());230                preStat.setString(4, user.getReportingFavorite());231                preStat.setString(5, user.getRobotHost());232                preStat.setString(6, user.getTeam());233                preStat.setString(7, user.getLanguage());234                preStat.setString(8, user.getDefaultSystem());235                preStat.setString(9, user.getEmail());236                preStat.setString(10, String.valueOf(user.getRobotPort()));237                preStat.setString(11, user.getRobotPlatform());238                preStat.setString(12, user.getRobotBrowser());239                preStat.setString(13, user.getRobotVersion());240                preStat.setString(14, user.getRobot());241                preStat.setString(15, user.getUserPreferences());242                preStat.setInt(16, user.getUserID());243                bool = preStat.executeUpdate() > 0;244            } catch (SQLException exception) {245                LOG.warn("Unable to execute query : " + exception.toString());246            } finally {247                preStat.close();248            }249        } catch (SQLException exception) {250            LOG.warn("Unable to execute query : " + exception.toString());251        } finally {252            try {253                if (connection != null) {254                    connection.close();255                }256            } catch (SQLException e) {257                LOG.warn(e.toString());258            }259        }260        return bool;261    }262    @Override263    public AnswerItem<User> updateUserPassword(User user, String password, String requestNewPassword) {264        AnswerItem<User> answer = new AnswerItem<User>();265        MessageEvent msg;266        boolean res = false;267        final String sql = "UPDATE user SET Password = SHA(?) , Request = ? WHERE Login LIKE ?";268        Connection connection = this.databaseSpring.connect();269        try {270            PreparedStatement preStat = connection.prepareStatement(sql);271            try {272                preStat.setString(1, password);273                preStat.setString(2, requestNewPassword);274                preStat.setString(3, user.getLogin());275                res = preStat.executeUpdate() > 0;276            } catch (SQLException exception) {277                LOG.warn("Unable to execute query : " + exception.toString());278                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);279                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Update Password - Unable to execute query"));280            } finally {281                if (preStat != null) {282                    preStat.close();283                }284            }285        } catch (SQLException exception) {286            LOG.warn("Unable to execute query : " + exception.toString());287            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);288            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Update Password - Unable to execute query"));289        } finally {290            try {291                if (connection != null) {292                    connection.close();293                }294            } catch (SQLException e) {295                LOG.warn(e.toString());296            }297        }298        if (res) {299            answer.setItem(this.findUserByKey(user.getLogin()));300            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);301            msg.setDescription(msg.getDescription().replace("%ITEM%", "User").replace("%OPERATION%", "Update password"));302        } else {303            answer.setItem(user);304            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_EXPECTED);305            msg.setDescription(msg.getDescription().replace("%ITEM%", "User").306                    replace("%OPERATION%", "Update Password").replace("%REASON%", "Your password was not updated. "307                    + "Please contact your Cerberus' administrator to learn more information."));308        }309        answer.setResultMessage(msg);310        return answer;311    }312    @Override313    public Answer clearResetPasswordToken(User user) {314        Answer ans = new Answer();315        MessageEvent msg = null;316        final String sql = "UPDATE user SET resetPasswordToken = '' WHERE Login LIKE ?";317        try (Connection connection = databaseSpring.connect();318                PreparedStatement preStat = connection.prepareStatement(sql)) {319            // Prepare and execute query320            preStat.setString(1, user.getLogin());321            preStat.executeUpdate();322            // Set the final message323            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK).resolveDescription("ITEM", OBJECT_NAME)324                    .resolveDescription("OPERATION", "UPDATE");325        } catch (Exception e) {326            LOG.warn("Unable to update user: " + e.getMessage());327            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED).resolveDescription("DESCRIPTION",328                    e.toString());329        } finally {330            ans.setResultMessage(msg);331        }332        return ans;333    }334    @Override335    public boolean verifyPassword(User user, String password) {336        boolean bool = false;337        final String sql = "SELECT Password, SHA(?) AS currentPassword FROM user WHERE Login LIKE ?";338        Connection connection = this.databaseSpring.connect();339        try {340            PreparedStatement preStat = connection.prepareStatement(sql);341            try {342                preStat.setString(1, password);343                preStat.setString(2, user.getLogin());344                ResultSet rs = preStat.executeQuery();345                try {346                    if (rs.first()) {347                        bool = rs.getString("Password").equals(rs.getString("currentPassword"));348                    }349                } catch (SQLException ex) {350                    LOG.warn(ex.toString());351                } finally {352                    rs.close();353                }354            } catch (SQLException exception) {355                LOG.warn("Unable to execute query : " + exception.toString());356            } finally {357                preStat.close();358            }359        } catch (SQLException exception) {360            LOG.warn("Unable to execute query : " + exception.toString());361        } finally {362            try {363                if (connection != null) {364                    connection.close();365                }366            } catch (SQLException e) {367                LOG.warn(e.toString());368            }369        }370        return bool;371    }372    @Override373    public boolean verifyResetPasswordToken(User user, String resetPasswordToken) {374        boolean bool = false;375        final String sql = "SELECT resetPasswordToken, SHA(?) AS currentPassword FROM user WHERE Login LIKE ?";376        Connection connection = this.databaseSpring.connect();377        try {378            PreparedStatement preStat = connection.prepareStatement(sql);379            try {380                preStat.setString(1, resetPasswordToken);381                preStat.setString(2, user.getLogin());382                ResultSet rs = preStat.executeQuery();383                try {384                    if (rs.first()) {385                        bool = rs.getString("resetPasswordToken").equals(rs.getString("currentPassword"));386                    }387                } catch (SQLException ex) {388                    LOG.warn(ex.toString());389                } finally {390                    rs.close();391                }392            } catch (SQLException exception) {393                LOG.warn("Unable to execute query : " + exception.toString());394            } finally {395                preStat.close();396            }397        } catch (SQLException exception) {398            LOG.warn("Unable to execute query : " + exception.toString());399        } finally {400            try {401                if (connection != null) {402                    connection.close();403                }404            } catch (SQLException e) {405                LOG.warn(e.toString());406            }407        }408        return bool;409    }410    @Override411    public List<User> findTestDataListByCriteria(int start, int amount, String column, String dir, String searchTerm, String individualSearch) {412        List<User> result = new ArrayList<User>();413        StringBuilder gSearch = new StringBuilder();414        StringBuilder searchSQL = new StringBuilder();415        StringBuilder query = new StringBuilder();416        query.append("SELECT * FROM user usr");417        gSearch.append(" where (usr.`login` like '%");418        gSearch.append(searchTerm);419        gSearch.append("%'");420        gSearch.append(" or usr.`name` like '%");421        gSearch.append(searchTerm);422        gSearch.append("%'");423        gSearch.append(" or usr.`team` like '%");424        gSearch.append(searchTerm);425        gSearch.append("%'");426        gSearch.append(" or usr.`defaultSystem` like '%");427        gSearch.append(searchTerm);428        gSearch.append("%'");429        gSearch.append(" or usr.`email` like '%");430        gSearch.append(searchTerm);431        gSearch.append("%'");432        gSearch.append(" or usr.`request` like '%");433        gSearch.append(searchTerm);434        gSearch.append("%')");435        if (!searchTerm.equals("") && !individualSearch.equals("")) {436            searchSQL.append(gSearch.toString());437            searchSQL.append(" and ");438            searchSQL.append(individualSearch);439        } else if (!individualSearch.equals("")) {440            searchSQL.append(" where `");441            searchSQL.append(individualSearch);442            searchSQL.append("`");443        } else if (!searchTerm.equals("")) {444            searchSQL.append(gSearch.toString());445        }446        query.append(searchSQL);447        query.append("order by `");448        query.append(column);449        query.append("` ");450        query.append(dir);451        if (amount != -1) {452            query.append(" limit ");453            query.append(start);454            query.append(" , ");455            query.append(amount);456        }457        User user;458        Connection connection = this.databaseSpring.connect();459        try {460            PreparedStatement preStat = connection.prepareStatement(query.toString());461            try {462                ResultSet resultSet = preStat.executeQuery();463                try {464                    while (resultSet.next()) {465                        result.add(this.loadFromResultSet(resultSet));466                    }467                } catch (SQLException exception) {468                    LOG.warn("Unable to execute query : " + exception.toString());469                } finally {470                    resultSet.close();471                }472            } catch (SQLException exception) {473                LOG.warn("Unable to execute query : " + exception.toString());474            } finally {475                preStat.close();476            }477        } catch (SQLException exception) {478            LOG.warn("Unable to execute query : " + exception.toString());479        } finally {480            try {481                if (connection != null) {482                    connection.close();483                }484            } catch (SQLException e) {485                LOG.warn(e.toString());486            }487        }488        return result;489    }490    @Override491    public Integer getNumberOfUserPerCriteria(String searchTerm, String inds) {492        Integer result = 0;493        StringBuilder query = new StringBuilder();494        StringBuilder gSearch = new StringBuilder();495        String searchSQL = "";496        query.append("SELECT count(*) FROM `user` ");497        gSearch.append(" where (`login` like '%");498        gSearch.append(searchTerm);499        gSearch.append("%'");500        gSearch.append(" or `name` like '%");501        gSearch.append(searchTerm);502        gSearch.append("%'");503        gSearch.append(" or `team` like '%");504        gSearch.append(searchTerm);505        gSearch.append("%'");506        gSearch.append(" or `defaultSystem` like '%");507        gSearch.append(searchTerm);508        gSearch.append("%'");509        gSearch.append(" or `email` like '%");510        gSearch.append(searchTerm);511        gSearch.append("%'");512        gSearch.append(" or `request` like '%");513        gSearch.append(searchTerm);514        gSearch.append("%')");515        if (!searchTerm.equals("") && !inds.equals("")) {516            searchSQL = gSearch.toString() + " and " + inds;517        } else if (!inds.equals("")) {518            searchSQL = " where " + inds;519        } else if (!searchTerm.equals("")) {520            searchSQL = gSearch.toString();521        }522        query.append(searchSQL);523        Connection connection = this.databaseSpring.connect();524        try {525            PreparedStatement preStat = connection.prepareStatement(query.toString());526            try {527                ResultSet resultSet = preStat.executeQuery();528                try {529                    if (resultSet.first()) {530                        result = resultSet.getInt(1);531                    }532                } catch (SQLException exception) {533                    LOG.warn("Unable to execute query : " + exception.toString());534                } finally {535                    resultSet.close();536                }537            } catch (SQLException exception) {538                LOG.warn("Unable to execute query : " + exception.toString());539            } finally {540                preStat.close();541            }542        } catch (SQLException exception) {543            LOG.warn("Unable to execute query : " + exception.toString());544        } finally {545            try {546                if (connection != null) {547                    connection.close();548                }549            } catch (SQLException e) {550                LOG.warn(e.toString());551            }552        }553        return result;554    }555    @Override556    public List<User> findAllUserBySystem(String system) {557        List<User> list = null;558        final String query = "SELECT * "559                + "FROM `user` usr, usersystem us "560                + "WHERE usr.login = us.login "561                + "AND us.system = ? "562                + "ORDER BY usr.login";563        Connection connection = this.databaseSpring.connect();564        try {565            PreparedStatement preStat = connection.prepareStatement(query);566            try {567                preStat.setString(1, system);568                ResultSet resultSet = preStat.executeQuery();569                try {570                    list = new ArrayList<User>();571                    while (resultSet.next()) {572                        User user = this.loadFromResultSet(resultSet);573                        list.add(user);574                    }575                } catch (SQLException exception) {576                    LOG.warn("Unable to execute query : " + exception.toString());577                } finally {578                    resultSet.close();579                }580            } catch (SQLException exception) {581                LOG.warn("Unable to execute query : " + exception.toString());582            } finally {583                preStat.close();584            }585        } catch (SQLException exception) {586            LOG.warn("Unable to execute query : " + exception.toString());587        } finally {588            try {589                if (connection != null) {590                    connection.close();591                }592            } catch (SQLException e) {593                LOG.warn(e.toString());594            }595        }596        return list;597    }598    @Override599    public AnswerItem readByKey(String login) {600        AnswerItem ans = new AnswerItem();601        User result;602        final String query = "SELECT * FROM `user` usr WHERE usr.`login` = ?";603        MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);604        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));605        Connection connection = this.databaseSpring.connect();606        try {607            PreparedStatement preStat = connection.prepareStatement(query);608            try {609                preStat.setString(1, login);610                ResultSet resultSet = preStat.executeQuery();611                try {612                    if (resultSet.first()) {613                        result = loadFromResultSet(resultSet);614                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);615                        msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "SELECT"));616                        ans.setItem(result);617                    } else {618                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_NO_DATA_FOUND);619                    }620                } catch (SQLException exception) {621                    LOG.error("Unable to execute query : " + exception.toString());622                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);623                    msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));624                } finally {625                    resultSet.close();626                }627            } catch (SQLException exception) {628                LOG.error("Unable to execute query : " + exception.toString());629                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);630                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));631            } finally {632                preStat.close();633            }634        } catch (SQLException exception) {635            LOG.error("Unable to execute query : " + exception.toString());636            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);637            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));638        } finally {639            try {640                if (connection != null) {641                    connection.close();642                }643            } catch (SQLException exception) {644                LOG.warn("Unable to close connection : " + exception.toString());645            }646        }647        //sets the message648        ans.setResultMessage(msg);649        return ans;650    }651    @Override652    public AnswerList readByCriteria(int start, int amount, String column, String dir, String searchTerm, String individualSearch) {653        AnswerList response = new AnswerList();654        MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);655        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));656        List<User> applicationList = new ArrayList<User>();657        StringBuilder searchSQL = new StringBuilder();658        StringBuilder query = new StringBuilder();659        //SQL_CALC_FOUND_ROWS allows to retrieve the total number of columns by disrearding the limit clauses that 660        //were applied -- used for pagination p661        query.append("SELECT SQL_CALC_FOUND_ROWS * FROM user usr ");662        searchSQL.append(" where 1=1 ");663        if (!StringUtil.isNullOrEmpty(searchTerm)) {664            searchSQL.append(" and (usr.`login` like ?");665            searchSQL.append(" or usr.`name` like ?");666            searchSQL.append(" or usr.`team` like ?");667            searchSQL.append(" or usr.`language` like ?");668            searchSQL.append(" or usr.`ReportingFavorite` like ?");669            searchSQL.append(" or usr.`robotHost` like ?");670            searchSQL.append(" or usr.`robotPort` like ?");671            searchSQL.append(" or usr.`robotPlatform` like ?");672            searchSQL.append(" or usr.`robotBrowser` like ?");673            searchSQL.append(" or usr.`robotVersion` like ?");674            searchSQL.append(" or usr.`robot` like ?");675            searchSQL.append(" or usr.`DefaultSystem` like ?");676            searchSQL.append(" or usr.`Email` like ?)");677        }678        if (!StringUtil.isNullOrEmpty(individualSearch)) {679            searchSQL.append(" and (`").append(individualSearch).append("`)");680        }681        query.append(searchSQL);682        if (!StringUtil.isNullOrEmpty(column)) {683            query.append(" order by `").append(column).append("` ").append(dir);684        }685        if ((amount <= 0) || (amount >= MAX_ROW_SELECTED)) {686            query.append(" limit ").append(start).append(" , ").append(MAX_ROW_SELECTED);687        } else {688            query.append(" limit ").append(start).append(" , ").append(amount);689        }690        // Debug message on SQL.691        if (LOG.isDebugEnabled()) {692            LOG.debug("SQL : " + query.toString());693        }694        Connection connection = this.databaseSpring.connect();695        try {696            PreparedStatement preStat = connection.prepareStatement(query.toString());697            try {698                int i = 1;699                if (!StringUtil.isNullOrEmpty(searchTerm)) {700                    preStat.setString(i++, "%" + searchTerm + "%");701                    preStat.setString(i++, "%" + searchTerm + "%");702                    preStat.setString(i++, "%" + searchTerm + "%");703                    preStat.setString(i++, "%" + searchTerm + "%");704                    preStat.setString(i++, "%" + searchTerm + "%");705                    preStat.setString(i++, "%" + searchTerm + "%");706                    preStat.setString(i++, "%" + searchTerm + "%");707                    preStat.setString(i++, "%" + searchTerm + "%");708                    preStat.setString(i++, "%" + searchTerm + "%");709                    preStat.setString(i++, "%" + searchTerm + "%");710                    preStat.setString(i++, "%" + searchTerm + "%");711                    preStat.setString(i++, "%" + searchTerm + "%");712                    preStat.setString(i++, "%" + searchTerm + "%");713                }714                ResultSet resultSet = preStat.executeQuery();715                try {716                    //gets the data717                    while (resultSet.next()) {718                        applicationList.add(this.loadFromResultSet(resultSet));719                    }720                    //get the total number of rows721                    resultSet = preStat.executeQuery("SELECT FOUND_ROWS()");722                    int nrTotalRows = 0;723                    if (resultSet != null && resultSet.next()) {724                        nrTotalRows = resultSet.getInt(1);725                    }726                    if (applicationList.size() >= MAX_ROW_SELECTED) { // Result of SQl was limited by MAX_ROW_SELECTED constrain. That means that we may miss some lines in the resultList.727                        LOG.error("Partial Result in the query.");728                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_WARNING_PARTIAL_RESULT);729                        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Maximum row reached : " + MAX_ROW_SELECTED));730                        response = new AnswerList(applicationList, nrTotalRows);731                    } else {732                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);733                        msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "SELECT"));734                        response = new AnswerList(applicationList, nrTotalRows);735                    }736                } catch (SQLException exception) {737                    LOG.error("Unable to execute query : " + exception.toString());738                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);739                    msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));740                } finally {741                    if (resultSet != null) {742                        resultSet.close();743                    }744                }745            } catch (SQLException exception) {746                LOG.error("Unable to execute query : " + exception.toString());747                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);748                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));749            } finally {750                if (preStat != null) {751                    preStat.close();752                }753            }754        } catch (SQLException exception) {755            LOG.error("Unable to execute query : " + exception.toString());756            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);757            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));758        } finally {759            try {760                if (!this.databaseSpring.isOnTransaction()) {761                    if (connection != null) {762                        connection.close();763                    }764                }765            } catch (SQLException exception) {766                LOG.warn("Unable to close connection : " + exception.toString());767            }768        }769        response.setResultMessage(msg);770        response.setDataList(applicationList);771        return response;772    }773    @Override774    public AnswerList readByCriteria(int start, int amount, String column, String dir, String searchTerm, Map<String, List<String>> individualSearch) {775        AnswerList response = new AnswerList();776        MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);777        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));778        List<User> applicationList = new ArrayList<User>();779        StringBuilder searchSQL = new StringBuilder();780        List<String> individalColumnSearchValues = new ArrayList<String>();781        StringBuilder query = new StringBuilder();782        //SQL_CALC_FOUND_ROWS allows to retrieve the total number of columns by disrearding the limit clauses that783        //were applied -- used for pagination p784        query.append("SELECT DISTINCT SQL_CALC_FOUND_ROWS usr.* FROM user usr ");785        if (!StringUtil.isNullOrEmpty(searchTerm)) {786            query.append("LEFT JOIN usergroup usg ON usg.`Login` = usr.`Login`");787        }788        searchSQL.append(" where 1=1 ");789        if (!StringUtil.isNullOrEmpty(searchTerm)) {790            searchSQL.append(" and (usr.`login` like ?");791            searchSQL.append(" or usr.`name` like ?");792            searchSQL.append(" or usr.`team` like ?");793            searchSQL.append(" or usr.`language` like ?");794            searchSQL.append(" or usr.`ReportingFavorite` like ?");795            searchSQL.append(" or usr.`robotHost` like ?");796            searchSQL.append(" or usr.`robotPort` like ?");797            searchSQL.append(" or usr.`robotPlatform` like ?");798            searchSQL.append(" or usr.`robotBrowser` like ?");799            searchSQL.append(" or usr.`robotVersion` like ?");800            searchSQL.append(" or usr.`robot` like ?");801            searchSQL.append(" or usr.`DefaultSystem` like ?");802            searchSQL.append(" or usr.`Email` like ?");803            searchSQL.append(" or usg.`GroupName` like ?)");804        }805        if (individualSearch != null && !individualSearch.isEmpty()) {806            searchSQL.append(" and ( 1=1 ");807            for (Map.Entry<String, List<String>> entry : individualSearch.entrySet()) {808                searchSQL.append(" and ");809                searchSQL.append(SqlUtil.getInSQLClauseForPreparedStatement(entry.getKey(), entry.getValue()));810                individalColumnSearchValues.addAll(entry.getValue());811            }812            searchSQL.append(" )");813        }814        query.append(searchSQL);815        if (!StringUtil.isNullOrEmpty(column)) {816            query.append(" order by `").append(column).append("` ").append(dir);817        }818        if ((amount <= 0) || (amount >= MAX_ROW_SELECTED)) {819            query.append(" limit ").append(start).append(" , ").append(MAX_ROW_SELECTED);820        } else {821            query.append(" limit ").append(start).append(" , ").append(amount);822        }823        // Debug message on SQL.824        if (LOG.isDebugEnabled()) {825            LOG.debug("SQL : " + query.toString());826        }827        Connection connection = this.databaseSpring.connect();828        try {829            PreparedStatement preStat = connection.prepareStatement(query.toString());830            try {831                int i = 1;832                if (!StringUtil.isNullOrEmpty(searchTerm)) {833                    preStat.setString(i++, "%" + searchTerm + "%");834                    preStat.setString(i++, "%" + searchTerm + "%");835                    preStat.setString(i++, "%" + searchTerm + "%");836                    preStat.setString(i++, "%" + searchTerm + "%");837                    preStat.setString(i++, "%" + searchTerm + "%");838                    preStat.setString(i++, "%" + searchTerm + "%");839                    preStat.setString(i++, "%" + searchTerm + "%");840                    preStat.setString(i++, "%" + searchTerm + "%");841                    preStat.setString(i++, "%" + searchTerm + "%");842                    preStat.setString(i++, "%" + searchTerm + "%");843                    preStat.setString(i++, "%" + searchTerm + "%");844                    preStat.setString(i++, "%" + searchTerm + "%");845                    preStat.setString(i++, "%" + searchTerm + "%");846                    preStat.setString(i++, "%" + searchTerm + "%");847                }848                for (String individualColumnSearchValue : individalColumnSearchValues) {849                    preStat.setString(i++, individualColumnSearchValue);850                }851                ResultSet resultSet = preStat.executeQuery();852                try {853                    //gets the data854                    while (resultSet.next()) {855                        applicationList.add(this.loadFromResultSet(resultSet));856                    }857                    //get the total number of rows858                    resultSet = preStat.executeQuery("SELECT FOUND_ROWS()");859                    int nrTotalRows = 0;860                    if (resultSet != null && resultSet.next()) {861                        nrTotalRows = resultSet.getInt(1);862                    }863                    if (applicationList.size() >= MAX_ROW_SELECTED) { // Result of SQl was limited by MAX_ROW_SELECTED constrain. That means that we may miss some lines in the resultList.864                        LOG.error("Partial Result in the query.");865                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_WARNING_PARTIAL_RESULT);866                        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", "Maximum row reached : " + MAX_ROW_SELECTED));867                        response = new AnswerList(applicationList, nrTotalRows);868                    } else {869                        msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);870                        msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "SELECT"));871                        response = new AnswerList(applicationList, nrTotalRows);872                    }873                } catch (SQLException exception) {874                    LOG.error("Unable to execute query : " + exception.toString());875                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);876                    msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));877                } finally {878                    if (resultSet != null) {879                        resultSet.close();880                    }881                }882            } catch (SQLException exception) {883                LOG.error("Unable to execute query : " + exception.toString());884                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);885                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));886            } finally {887                if (preStat != null) {888                    preStat.close();889                }890            }891        } catch (SQLException exception) {892            LOG.error("Unable to execute query : " + exception.toString());893            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);894            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));895        } finally {896            try {897                if (!this.databaseSpring.isOnTransaction()) {898                    if (connection != null) {899                        connection.close();900                    }901                }902            } catch (SQLException exception) {903                LOG.warn("Unable to close connection : " + exception.toString());904            }905        }906        response.setResultMessage(msg);907        response.setDataList(applicationList);908        return response;909    }910    @Override911    public Answer create(User user) {912        MessageEvent msg = null;913        StringBuilder query = new StringBuilder();914        query.append("INSERT INTO user (Login, Password, Name, Request, ReportingFavorite, RobotHost, DefaultSystem, Team, Language, Email, UserPreferences)");915        query.append("  VALUES (?, SHA(?), ?, ?, ?, ?, ?, ?, ?, ?, '')");916        // Debug message on SQL.917        if (LOG.isDebugEnabled()) {918            LOG.debug("SQL : " + query.toString());919        }920        Connection connection = this.databaseSpring.connect();921        try {922            PreparedStatement preStat = connection.prepareStatement(query.toString());923            try {924                preStat.setString(1, user.getLogin());925                preStat.setString(2, user.getPassword());926                preStat.setString(3, user.getName());927                preStat.setString(4, user.getRequest());928                preStat.setString(5, user.getReportingFavorite());929                preStat.setString(6, user.getRobotHost());930                preStat.setString(7, user.getDefaultSystem());931                preStat.setString(8, user.getTeam());932                preStat.setString(9, user.getLanguage());933                preStat.setString(10, user.getEmail());934                preStat.executeUpdate();935                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);936                msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "INSERT"));937            } catch (SQLException exception) {938                LOG.error("Unable to execute query : " + exception.toString());939                if (exception.getSQLState().equals(SQL_DUPLICATED_CODE)) { //23000 is the sql state for duplicate entries940                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_DUPLICATE);941                    msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "INSERT").replace("%REASON%", exception.toString()));942                } else {943                    msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);944                    msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));945                }946            } finally {947                preStat.close();948            }949        } catch (SQLException exception) {950            LOG.error("Unable to execute query : " + exception.toString());951            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);952            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));953        } finally {954            try {955                if (connection != null) {956                    connection.close();957                }958            } catch (SQLException exception) {959                LOG.warn("Unable to close connection : " + exception.toString());960            }961        }962        return new Answer(msg);963    }964    @Override965    public Answer delete(User user) {966        MessageEvent msg = null;967        final String query = "DELETE FROM user WHERE userid = ? ";968        // Debug message on SQL.969        if (LOG.isDebugEnabled()) {970            LOG.debug("SQL : " + query);971        }972        Connection connection = this.databaseSpring.connect();973        try {974            PreparedStatement preStat = connection.prepareStatement(query);975            try {976                preStat.setInt(1, user.getUserID());977                preStat.executeUpdate();978                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);979                msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "DELETE"));980            } catch (SQLException exception) {981                LOG.error("Unable to execute query : " + exception.toString());982                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);983                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));984            } finally {985                preStat.close();986            }987        } catch (SQLException exception) {988            LOG.error("Unable to execute query : " + exception.toString());989            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);990            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));991        } finally {992            try {993                if (connection != null) {994                    connection.close();995                }996            } catch (SQLException exception) {997                LOG.warn("Unable to close connection : " + exception.toString());998            }999        }1000        return new Answer(msg);1001    }1002    @Override1003    public Answer update(User user) {1004        MessageEvent msg = null;1005        StringBuilder query = new StringBuilder();1006        query.append("UPDATE user SET Login = ?, Name = ?, Request = ?, ReportingFavorite = ?, RobotHost = ?,");1007        query.append(" Team = ?, Language = ?, DefaultSystem = ?, Email= ? , robotPort = ?,");1008        query.append(" robotPlatform = ?, robotBrowser = ?, robotVersion = ? , robot = ?, resetPasswordToken = SHA(?), ");1009        query.append(" userPreferences = ?   WHERE userid = ?");1010        // Debug message on SQL.1011        if (LOG.isDebugEnabled()) {1012            LOG.debug("SQL : " + query);1013        }1014        Connection connection = this.databaseSpring.connect();1015        try {1016            PreparedStatement preStat = connection.prepareStatement(query.toString());1017            try {1018                preStat.setString(1, user.getLogin());1019                preStat.setString(2, user.getName());1020                preStat.setString(3, user.getRequest());1021                preStat.setString(4, user.getReportingFavorite());1022                preStat.setString(5, user.getRobotHost());1023                preStat.setString(6, user.getTeam());1024                preStat.setString(7, user.getLanguage());1025                preStat.setString(8, user.getDefaultSystem());1026                preStat.setString(9, user.getEmail());1027                preStat.setString(10, String.valueOf(user.getRobotPort()));1028                preStat.setString(11, user.getRobotPlatform());1029                preStat.setString(12, user.getRobotBrowser());1030                preStat.setString(13, user.getRobotVersion());1031                preStat.setString(14, user.getRobot());1032                preStat.setString(15, user.getResetPasswordToken());1033                preStat.setString(16, user.getUserPreferences());1034                preStat.setInt(17, user.getUserID());1035                preStat.executeUpdate();1036                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_OK);1037                msg.setDescription(msg.getDescription().replace("%ITEM%", OBJECT_NAME).replace("%OPERATION%", "UPDATE"));1038            } catch (SQLException exception) {1039                LOG.error("Unable to execute query : " + exception.toString());1040                msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1041                msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));1042            } finally {1043                preStat.close();1044            }1045        } catch (SQLException exception) {1046            LOG.error("Unable to execute query : " + exception.toString());1047            msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);1048            msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", exception.toString()));1049        } finally {1050            try {1051                if (connection != null) {1052                    connection.close();1053                }1054            } catch (SQLException exception) {1055                LOG.warn("Unable to close connection : " + exception.toString());1056            }1057        }1058        return new Answer(msg);1059    }1060    private User loadFromResultSet(ResultSet rs) throws SQLException {1061        int userID = ParameterParserUtil.parseIntegerParam(rs.getString("usr.userid"), 0);1062        String login = ParameterParserUtil.parseStringParam(rs.getString("usr.login"), "");1063        String password = ParameterParserUtil.parseStringParam(rs.getString("usr.password"), "");1064        String resetPasswordToken = ParameterParserUtil.parseStringParam(rs.getString("usr.resetPasswordToken"), "");1065        String request = ParameterParserUtil.parseStringParam(rs.getString("usr.request"), "");1066        String name = ParameterParserUtil.parseStringParam(rs.getString("usr.name"), "");1067        String team = ParameterParserUtil.parseStringParam(rs.getString("usr.team"), "");1068        String language = ParameterParserUtil.parseStringParam(rs.getString("usr.language"), "");1069        String reportingFavorite = ParameterParserUtil.parseStringParam(rs.getString("usr.reportingFavorite"), "");1070        String robotHost = ParameterParserUtil.parseStringParam(rs.getString("usr.robotHost"), "");1071        String defaultSystem = ParameterParserUtil.parseStringParam(rs.getString("usr.defaultSystem"), "");1072        String email = ParameterParserUtil.parseStringParam(rs.getString("usr.email"), "");1073        String robotPort = ParameterParserUtil.parseStringParam(rs.getString("usr.robotPort"), "");1074        String robotPlatform = ParameterParserUtil.parseStringParam(rs.getString("usr.robotPlatform"), "");...

loadFromResultSet

Using AI Code Generation

1public void loadFromResultSet(ResultSet rs) throws SQLException {2    this.login = ParameterParserUtil.parseStringParam(rs.getString("Login"), "");3    this.password = ParameterParserUtil.parseStringParam(rs.getString("Password"), "");4    this.name = ParameterParserUtil.parseStringParam(rs.getString("Name"), "");5    this.email = ParameterParserUtil.parseStringParam(rs.getString("Email"), "");6    this.defaultSystem = ParameterParserUtil.parseStringParam(rs.getString("DefaultSystem"), "");7    this.theme = ParameterParserUtil.parseStringParam(rs.getString("Theme"), "");8    this.language = ParameterParserUtil.parseStringParam(rs.getString("Language"), "");9    this.active = ParameterParserUtil.parseBooleanParam(rs.getString("Active"), false);10    this.admin = ParameterParserUtil.parseBooleanParam(rs.getString("Admin"), false);11    this.token = ParameterParserUtil.parseStringParam(rs.getString("Token"), "");12    this.tokenValidity = ParameterParserUtil.parseStringParam(rs.getString("TokenValidity"), "");13    this.lastConnection = ParameterParserUtil.parseStringParam(rs.getString("LastConnection"), "");14    this.lastPage = ParameterParserUtil.parseStringParam(rs.getString("LastPage"), "");15    this.lastIp = ParameterParserUtil.parseStringParam(rs.getString("LastIp"), "");16    this.lastHost = ParameterParserUtil.parseStringParam(rs.getString("LastHost"), "");17    this.mobileKey = ParameterParserUtil.parseStringParam(rs.getString("MobileKey"), "");18    this.mobileKeyValidity = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyValidity"), "");19    this.mobileKeyDevice = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyDevice"), "");20    this.mobileKeyPlatform = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyPlatform"), "");21    this.mobileKeyVersion = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyVersion"), "");22    this.mobileKeyToken = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyToken"), "");23    this.mobileKeyTokenValidity = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyTokenValidity"), "");24    this.mobileKeyTokenDevice = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyTokenDevice"), "");25    this.mobileKeyTokenPlatform = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyTokenPlatform"), "");26    this.mobileKeyTokenVersion = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyTokenVersion"), "");27    this.mobileKeyTokenIp = ParameterParserUtil.parseStringParam(rs.getString("MobileKeyTokenIp"), "");

loadFromResultSet

Using AI Code Generation

1UserDAO userDAO = new UserDAO();2ResultSet rs = null;3User user = userDAO.loadFromResultSet(rs);4UserDAO userDAO = new UserDAO();5ResultSet rs = null;6User user = userDAO.loadFromResultSet(rs);7UserDAO userDAO = new UserDAO();8ResultSet rs = null;9User user = userDAO.loadFromResultSet(rs);10UserDAO userDAO = new UserDAO();11ResultSet rs = null;12User user = userDAO.loadFromResultSet(rs);13UserDAO userDAO = new UserDAO();14ResultSet rs = null;15User user = userDAO.loadFromResultSet(rs);16UserDAO userDAO = new UserDAO();17ResultSet rs = null;18User user = userDAO.loadFromResultSet(rs);19UserDAO userDAO = new UserDAO();20ResultSet rs = null;21User user = userDAO.loadFromResultSet(rs);22UserDAO userDAO = new UserDAO();23ResultSet rs = null;24User user = userDAO.loadFromResultSet(rs);25UserDAO userDAO = new UserDAO();26ResultSet rs = null;27User user = userDAO.loadFromResultSet(rs);28UserDAO userDAO = new UserDAO();29ResultSet rs = null;30User user = userDAO.loadFromResultSet(rs);31UserDAO userDAO = new UserDAO();32ResultSet rs = null;33User user = userDAO.loadFromResultSet(rs);

loadFromResultSet

Using AI Code Generation

1    public void testLoadFromResultSet() throws SQLException {2        UserDAO dao = new UserDAO();3        ResultSet rs = Mockito.mock(ResultSet.class);4        Mockito.when(rs.getString("Login")).thenReturn("login");5        Mockito.when(rs.getString("Password")).thenReturn("password");6        Mockito.when(rs.getString("Name")).thenReturn("name");7        Mockito.when(rs.getString("Email")).thenReturn("email");8        Mockito.when(rs.getString("Theme")).thenReturn("theme");9        Mockito.when(rs.getString("Language")).thenReturn("language");10        Mockito.when(rs.getString("DefaultSystem")).thenReturn("defaultSystem");11        Mockito.when(rs.getString("DefaultEnvironment")).thenReturn("defaultEnvironment");12        Mockito.when(rs.getString("DefaultCountry")).thenReturn("defaultCountry");13        Mockito.when(rs.getString("Active")).thenReturn("Y");14        Mockito.when(rs.getString("Type")).thenReturn("type");15        Mockito.when(rs.getString("Token")).thenReturn("token");16        Mockito.when(rs.getString("TokenExpire")).thenReturn("2017-01-01 00:00:00");17        Mockito.when(rs.getString("TokenOrigin")).thenReturn("tokenOrigin");18        Mockito.when(rs.getString("RemoteAddr")).thenReturn("remoteAddr");19        Mockito.when(rs.getString("RemoteHost")).thenReturn("remoteHost");20        Mockito.when(rs.getString("RemoteUser")).thenReturn("remoteUser");21        Mockito.when(rs.getString("ScreenSize")).thenReturn("screenSize");22        Mockito.when(rs.getString("LastConnection")).thenReturn("2017-01-01 00:00:00");23        Mockito.when(rs.getString("Creation")).thenReturn("2017-01-01 00:00:00");24        Mockito.when(rs.getString("Creator")).thenReturn("creator");25        Mockito.when(rs.getString("LastUpdate")).thenReturn("2017-01-01 00:00:00");26        Mockito.when(rs.getString("LastModifier")).thenReturn("lastModifier");27        Mockito.when(rs.getString("UserAgent")).thenReturn("userAgent");28        Mockito.when(rs.getString("PasswordReset")).thenReturn("Y");29        Mockito.when(rs.getString("PasswordResetDate")).thenReturn("2017-01-01 00:00:00");30        Mockito.when(rs.getString("PasswordResetToken")).thenReturn("passwordResetToken");31        Mockito.when(rs.getString("PasswordResetTokenExpire")).thenReturn("2017-01-01 00:00:00");32        Mockito.when(rs.getString("PasswordResetTokenOrigin")).thenReturn("passwordResetTokenOrigin");33        Mockito.when(rs.getString

loadFromResultSet

Using AI Code Generation

1public User loadFromResultSet(ResultSet rs) throws SQLException {2        String login = ParameterParserUtil.parseStringParam(rs.getString("Login"), "");3        String password = ParameterParserUtil.parseStringParam(rs.getString("Password"), "");4        String name = ParameterParserUtil.parseStringParam(rs.getString("Name"), "");5        String email = ParameterParserUtil.parseStringParam(rs.getString("Email"), "");6        String defaultSystem = ParameterParserUtil.parseStringParam(rs.getString("DefaultSystem"), "");7        String theme = ParameterParserUtil.parseStringParam(rs.getString("Theme"), "");8        String language = ParameterParserUtil.parseStringParam(rs.getString("Language"), "");9        String[] mySystems = ParameterParserUtil.parseStringParam(rs.getString("MySystems"), "").split(";");10        String[] myProjects = ParameterParserUtil.parseStringParam(rs.getString("MyProjects"), "").split(";");11        String[] myEnvironments = ParameterParserUtil.parseStringParam(rs.getString("MyEnvironments"), "").split(";");12        String[] myCountries = ParameterParserUtil.parseStringParam(rs.getString("MyCountries"), "").split(";");13        String[] myRobotDecli = ParameterParserUtil.parseStringParam(rs.getString("MyRobotDecli"), "").split(";");14        String[] myRobotHost = ParameterParserUtil.parseStringParam(rs.getString("MyRobotHost"), "").split(";");15        String[] myRobotPort = ParameterParserUtil.parseStringParam(rs.getString("MyRobotPort"), "").split(";");16        String[] myRobotBrowser = ParameterParserUtil.parseStringParam(rs.getString("MyRobotBrowser"), "").split(";");17        String[] myRobotPlatform = ParameterParserUtil.parseStringParam(rs.getString("MyRobotPlatform"), "").split(";");18        String[] myRobotVersion = ParameterParserUtil.parseStringParam(rs.getString("MyRobotVersion"), "").split(";");19        String[] myRobotActive = ParameterParserUtil.parseStringParam(rs.getString("MyRobotActive"), "").split(";");20        String[] myApplication = ParameterParserUtil.parseStringParam(rs.getString("MyApplication"), "").split(";");21        String[] myApplicationActive = ParameterParserUtil.parseStringParam(rs.getString("MyApplicationActive"), "").split(";");22        String[] myApplicationObject = ParameterParserUtil.parseStringParam(rs.getString("MyApplicationObject"), "").split(";");23        String[] myApplicationObjectActive = ParameterParserUtil.parseStringParam(rs.getString("

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.