Examples with User_Role mom.trd.opentheso.core.exports.privatesdatas.tables.User_Role used on opensource projects

Example 1 with User_Role

use of mom.trd.opentheso.core.exports.privatesdatas.tables.User_Role in project opentheso by miledrousset.

the class ExportPrivatesDatas method getUser_Roles.

public ArrayList<User_Role> getUser_Roles(HikariDataSource ds) {
    ArrayList<User_Role> list_User_Role = new ArrayList<>();
    ResultSet resultSet;
    Connection conn;
    Statement stmt;
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT * FROM user_role";
                resultSet = stmt.executeQuery(query);
                while (resultSet.next()) {
                    User_Role user_Role1 = new User_Role();
                    user_Role1.setId_user(resultSet.getInt("id_user"));
                    user_Role1.setId_role(resultSet.getInt("id_role"));
                    user_Role1.setId_thesaurus(resultSet.getString("id_thesaurus"));
                    user_Role1.setId_group(resultSet.getString("id_group"));
                    list_User_Role.add(user_Role1);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(Table.class.getName()).log(Level.SEVERE, null, ex);
    }
    return list_User_Role;
}