Examples with NodeUser2 mom.trd.opentheso.bdd.helper.nodes.NodeUser2 used on opensource projects

Example 1 with NodeUser2

use of mom.trd.opentheso.bdd.helper.nodes.NodeUser2 in project opentheso by miledrousset.

the class UserHelper2 method getUser.

/**
 * cette fonction permet de retourner les informations de l'utilisateur
 *
 * @param ds
 * @param idUser
 * @return #MR
 */
public NodeUser2 getUser(HikariDataSource ds, int idUser) {
    NodeUser2 nodeUser = null;
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT" + "  users.id_user," + "  users.username," + "  users.active," + "  users.mail," + "  users.passtomodify," + "  users.alertmail," + "  users.issuperadmin" + " FROM users" + " WHERE " + " users.id_user = " + idUser;
                resultSet = stmt.executeQuery(query);
                if (resultSet.next()) {
                    nodeUser = new NodeUser2();
                    nodeUser.setIdUser(idUser);
                    nodeUser.setName(resultSet.getString("username"));
                    nodeUser.setIsActive(resultSet.getBoolean("active"));
                    nodeUser.setMail(resultSet.getString("mail"));
                    nodeUser.setIsAlertMail(resultSet.getBoolean("alertmail"));
                    nodeUser.setPasstomodify(resultSet.getBoolean("passtomodify"));
                    nodeUser.setIsSuperAdmin(resultSet.getBoolean("issuperadmin"));
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    return nodeUser;
}

Example 2 with NodeUser2

use of mom.trd.opentheso.bdd.helper.nodes.NodeUser2 in project opentheso by miledrousset.

the class UserHelperTest method getUser.

// TODO add test methods here.
// The methods must be annotated with annotation @Test. For example:
// 
@Test
public void getUser() {
    int idUser = 15;
    ConnexionTest connexionTest = new ConnexionTest();
    HikariDataSource conn = connexionTest.getConnexionPool();
    UserHelper2 userHelper2 = new UserHelper2();
    NodeUser2 nodeUser = userHelper2.getUser(conn, idUser);
    conn.close();
}