Examples with Member com.webcohesion.enunciate.modules.jackson1.model.Member used on opensource projects

Example 11 with Member

use of com.webcohesion.enunciate.modules.jackson1.model.Member in project project_internship by phamthao8383.

the class MemberRepository method getMemberNumber.

public List<Member> getMemberNumber() {
    List<Member> memberList = new ArrayList<>();
    String sql = "Select distinct us.*, ap.accumulated_point from user us left join " + "accumulated_point ap on us.user_id = ap.user_id";
    try {
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            String name = resultSet.getString("name");
            int point = resultSet.getInt("accumulated_point");
            int userId = resultSet.getInt("user_id");
            String email = resultSet.getString("email");
            String phone = resultSet.getString("phone");
            String address = resultSet.getString("address");
            String image = "";
            int role = 0;
            String account = resultSet.getString("username");
            Member member = new Member(userId, name, email, phone, address, image, account, point, role);
            memberList.add(member);
        }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }
    return memberList;
}

Example 12 with Member

use of com.webcohesion.enunciate.modules.jackson1.model.Member in project project_internship by phamthao8383.

the class MemberRepository method searchMemberList.

public List<Member> searchMemberList(int indexPage, String nameSearch) {
    List<Member> members = new ArrayList<>();
    Member member;
    String sql = "SELECT u.user_id, u.username, `name`, email, address, phone, image, ap.accumulated_point, ur.role_id\n" + "from accumulated_point ap\n" + "right join `user` u on u.user_id = ap.user_id\n" + "inner join user_role ur on ur.username = u.username\n" + "where u.`name` like ?" + "order by u.user_id\n" + // Phân trang bảng Thành viên, bắt đầu từ index (?) hiển thị (?) Thành viên.
    "limit ?, ?;";
    try {
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1, "%" + nameSearch + "%");
        preparedStatement.setInt(2, (indexPage - 1) * entryDisplay);
        preparedStatement.setInt(3, entryDisplay);
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            member = new Member(resultSet.getInt("user_id"), resultSet.getString("name"), resultSet.getString("email"), resultSet.getString("phone"), resultSet.getString("address"), resultSet.getString("image"), resultSet.getString("username"), resultSet.getInt("accumulated_point"), resultSet.getInt("role_id"));
            members.add(member);
        }
        resultSet.close();
        preparedStatement.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return members;
}

Example 13 with Member

use of com.webcohesion.enunciate.modules.jackson1.model.Member in project project_internship by phamthao8383.

the class MemberRepository method getMemberList.

public List<Member> getMemberList(int indexPage) {
    List<Member> members = new ArrayList<>();
    String sql = "SELECT u.user_id, u.username, `name`, email, address, phone, image, ap.accumulated_point, ur.role_id\n" + "from accumulated_point ap\n" + "right join `user` u on u.user_id = ap.user_id\n" + "inner join user_role ur on ur.username = u.username\n" + "order by u.user_id\n" + // Phân trang bảng Thành viên, bắt đầu từ index (?) hiển thị (?) Thành viên.
    "limit ?, ?;";
    try {
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setInt(1, (indexPage - 1) * entryDisplay);
        preparedStatement.setInt(2, entryDisplay);
        ResultSet resultSet = preparedStatement.executeQuery();
        while (resultSet.next()) {
            members.add(new Member(resultSet.getInt("user_id"), resultSet.getString("name"), resultSet.getString("email"), resultSet.getString("phone"), resultSet.getString("address"), resultSet.getString("image"), resultSet.getString("username"), resultSet.getInt("accumulated_point"), resultSet.getInt("role_id")));
        }
        resultSet.close();
        preparedStatement.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return members;
}

Example 14 with Member

use of com.webcohesion.enunciate.modules.jackson1.model.Member in project enunciate by stoicflame.

the class ObjectDataTypeImpl method getProperties.

@Override
public List<? extends Property> getProperties() {
    List<Member> members = this.typeDefinition.getMembers();
    ArrayList<Property> properties;
    if (this.typeDefinition.getTypeIdInclusion() == JsonTypeInfo.As.PROPERTY) {
        properties = new ArrayList<Property>(members.size() + 1);
        if (this.typeDefinition.getTypeIdProperty() != null && members.stream().noneMatch(m -> this.typeDefinition.getTypeIdProperty().equals(m.getName()))) {
            properties.add(new TypeReferencePropertyImpl(this.typeDefinition.getTypeIdProperty()));
        }
    } else {
        properties = new ArrayList<Property>(members.size());
    }
    FacetFilter facetFilter = this.registrationContext.getFacetFilter();
    for (Member member : members) {
        if (!facetFilter.accept(member)) {
            continue;
        }
        if (member.getChoices().size() > 1) {
            JsonTypeInfo.As inclusion = member.getSubtypeIdInclusion();
            if (inclusion == JsonTypeInfo.As.WRAPPER_ARRAY || inclusion == JsonTypeInfo.As.WRAPPER_OBJECT) {
                for (Member choice : member.getChoices()) {
                    properties.add(new PropertyImpl(choice, registrationContext, member.isCollectionType()));
                }
            } else {
                properties.add(new PropertyImpl(member, registrationContext));
            }
        } else {
            properties.add(new PropertyImpl(member, registrationContext));
        }
    }
    return properties;
}