Examples with User org.cerberus.crud.entity.User used on opensource projects

Example 11 with User

use of org.cerberus.crud.entity.User in project cerberus-source by cerberustesting.

the class UserDAO method findAllUserBySystem.

@Override
public List<User> findAllUserBySystem(String system) {
    List<User> list = null;
    final String query = "SELECT * " + "FROM `user` usr, usersystem us " + "WHERE usr.login = us.login " + "AND us.system = ? " + "ORDER BY usr.login";
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            preStat.setString(1, system);
            ResultSet resultSet = preStat.executeQuery();
            try {
                list = new ArrayList<User>();
                while (resultSet.next()) {
                    User user = this.loadFromResultSet(resultSet);
                    list.add(user);
                }
            } catch (SQLException exception) {
                LOG.warn("Unable to execute query : " + exception.toString());
            } finally {
                resultSet.close();
            }
        } catch (SQLException exception) {
            LOG.warn("Unable to execute query : " + exception.toString());
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.warn("Unable to execute query : " + exception.toString());
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            LOG.warn(e.toString());
        }
    }
    return list;
}

Example 12 with User

use of org.cerberus.crud.entity.User in project cerberus-source by cerberustesting.

the class UserDAO method findTestDataListByCriteria.

@Override
public List<User> findTestDataListByCriteria(int start, int amount, String column, String dir, String searchTerm, String individualSearch) {
    List<User> result = new ArrayList<User>();
    StringBuilder gSearch = new StringBuilder();
    StringBuilder searchSQL = new StringBuilder();
    StringBuilder query = new StringBuilder();
    query.append("SELECT * FROM user usr");
    gSearch.append(" where (usr.`login` like '%");
    gSearch.append(searchTerm);
    gSearch.append("%'");
    gSearch.append(" or usr.`name` like '%");
    gSearch.append(searchTerm);
    gSearch.append("%'");
    gSearch.append(" or usr.`team` like '%");
    gSearch.append(searchTerm);
    gSearch.append("%'");
    gSearch.append(" or usr.`defaultSystem` like '%");
    gSearch.append(searchTerm);
    gSearch.append("%'");
    gSearch.append(" or usr.`email` like '%");
    gSearch.append(searchTerm);
    gSearch.append("%'");
    gSearch.append(" or usr.`request` like '%");
    gSearch.append(searchTerm);
    gSearch.append("%')");
    if (!searchTerm.equals("") && !individualSearch.equals("")) {
        searchSQL.append(gSearch.toString());
        searchSQL.append(" and ");
        searchSQL.append(individualSearch);
    } else if (!individualSearch.equals("")) {
        searchSQL.append(" where `");
        searchSQL.append(individualSearch);
        searchSQL.append("`");
    } else if (!searchTerm.equals("")) {
        searchSQL.append(gSearch.toString());
    }
    query.append(searchSQL);
    query.append("order by `");
    query.append(column);
    query.append("` ");
    query.append(dir);
    if (amount != -1) {
        query.append(" limit ");
        query.append(start);
        query.append(" , ");
        query.append(amount);
    }
    User user;
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query.toString());
        try {
            ResultSet resultSet = preStat.executeQuery();
            try {
                while (resultSet.next()) {
                    result.add(this.loadFromResultSet(resultSet));
                }
            } catch (SQLException exception) {
                LOG.warn("Unable to execute query : " + exception.toString());
            } finally {
                resultSet.close();
            }
        } catch (SQLException exception) {
            LOG.warn("Unable to execute query : " + exception.toString());
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.warn("Unable to execute query : " + exception.toString());
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            LOG.warn(e.toString());
        }
    }
    return result;
}

Example 13 with User

use of org.cerberus.crud.entity.User in project cerberus-source by cerberustesting.

the class UserDAO method findUserByKey.

@Override
public User findUserByKey(String login) {
    User result = null;
    final String query = "SELECT * FROM user usr WHERE usr.login = ? ";
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            preStat.setString(1, login);
            ResultSet resultSet = preStat.executeQuery();
            try {
                if (resultSet.first()) {
                    result = this.loadFromResultSet(resultSet);
                }
            } catch (SQLException exception) {
                LOG.warn("Unable to execute query : " + exception.toString(), exception);
            } finally {
                resultSet.close();
            }
        } catch (SQLException exception) {
            LOG.warn("Unable to execute query : " + exception.toString(), exception);
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.warn("Unable to execute query : " + exception.toString(), exception);
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            LOG.warn(e.toString());
        }
    }
    return result;
}

Example 14 with User

use of org.cerberus.crud.entity.User in project cerberus-source by cerberustesting.

the class UserDAO method findAllUser.

@Override
public List<User> findAllUser() {
    List<User> list = null;
    final String query = "SELECT * FROM user usr ORDER BY userid";
    Connection connection = this.databaseSpring.connect();
    try {
        PreparedStatement preStat = connection.prepareStatement(query);
        try {
            ResultSet resultSet = preStat.executeQuery();
            try {
                list = new ArrayList<User>();
                while (resultSet.next()) {
                    User user = this.loadFromResultSet(resultSet);
                    list.add(user);
                }
            } catch (SQLException exception) {
                LOG.warn("Unable to execute query : " + exception.toString());
            } finally {
                resultSet.close();
            }
        } catch (SQLException exception) {
            LOG.warn("Unable to execute query : " + exception.toString());
        } finally {
            preStat.close();
        }
    } catch (SQLException exception) {
        LOG.warn("Unable to execute query : " + exception.toString());
    } finally {
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            LOG.warn(e.toString());
        }
    }
    return list;
}

Example 15 with User

use of org.cerberus.crud.entity.User in project cerberus-source by cerberustesting.

the class FactoryUser method create.

@Override
public User create(int userID, String login, String password, String resetPasswordToken, String request, String name, String team, String language, String reportingFavorite, String robotHost, String robotPort, String robotPlatform, String robotBrowser, String robotVersion, String robot, String defaultSystem, String email, String userPreferences) {
    User newUser = new User();
    newUser.setUserID(userID);
    newUser.setLogin(login);
    newUser.setPassword(password);
    newUser.setRequest(request);
    newUser.setName(name);
    newUser.setTeam(team);
    newUser.setLanguage(language);
    newUser.setReportingFavorite(reportingFavorite);
    newUser.setRobotHost(robotHost);
    newUser.setDefaultSystem(defaultSystem);
    newUser.setEmail(email);
    newUser.setRobotBrowser(robotBrowser);
    newUser.setRobotPlatform(robotPlatform);
    newUser.setRobotPort(robotPort);
    newUser.setRobotVersion(robotVersion);
    newUser.setRobot(robot);
    newUser.setUserPreferences(userPreferences);
    newUser.setResetPasswordToken(resetPasswordToken);
    return newUser;
}