use of com.bitcamp.ex01.model.Member in project project_internship by phamthao8383.
the class MemberServlet method updateMember.
private void updateMember(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int memberIDSearch = Integer.parseInt(request.getParameter("idUpdate"));
String memberUsernameSearch = request.getParameter("usernameUpdate");
Member memberSearch = new Member(memberIDSearch, memberUsernameSearch);
String name = handleString.handleName(handleString.handleFont(request.getParameter("name")));
String email = request.getParameter("email");
String phone = request.getParameter("phone");
String address = handleString.handleFont(request.getParameter("address"));
int role = Integer.parseInt(request.getParameter("role"));
Member memberUpdate = new Member(name, email, phone, address, role);
memberService.updateMember(memberSearch, memberUpdate);
response.sendRedirect("/admin/manage-user");
}
use of com.bitcamp.ex01.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;
}
use of com.bitcamp.ex01.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;
}
use of com.bitcamp.ex01.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;
}
use of com.bitcamp.ex01.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;
}
Aggregations