Guest User

Untitled

a guest
Dec 14th, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. <c:forEach var = "i" begin = "1" end = "5">
  2. Item <c:out value = "${i}"/><p>
  3. </c:forEach>
  4.  
  5. ...
  6.  
  7. <%
  8. ArrayList<UserModel> users = UserMaker.getUsers();
  9. %>
  10.  
  11. ...
  12.  
  13. <c:forEach items="${users}" var="user">
  14. <tr>
  15. <td>${user.name}</td>
  16. <td>${user.login}</td>
  17. <td>${user.group}</td>
  18. <td>${user.bestResult}</td>
  19. </tr>
  20. </c:forEach>
  21.  
  22. ...
  23.  
  24. public class UserModel {
  25.  
  26. private String login;
  27. private String name;
  28. private String group;
  29. private String bestResult;
  30.  
  31. public UserModel(){
  32. ...
  33. }
  34.  
  35. ...
  36.  
  37. public String getName() {
  38. return name;
  39. }
  40.  
  41. public String getGroup() {
  42. return group;
  43. }
  44.  
  45. public String getLogin() {
  46. return login;
  47. }
  48.  
  49. public String getBestResult() {
  50. return bestResult;
  51. }
  52.  
  53. }
  54.  
  55. public class Users {
  56.  
  57. ...
  58.  
  59. public static ArrayList<UserModel> getUsers() throws SQLException {
  60. ArrayList<UserModel> users = new ArrayList<UserModel>();
  61. String query = "SELECT * FROM users u LEFT JOIN groups g ON u.id_group = g.id";
  62. ResultSet result = FirebirdDB.getInstance().execSelect(query);
  63. while (result.next()){
  64. UserModel user = new UserModel();
  65. user.setLogin(result.getString("LOGIN"));
  66. user.setName(result.getString("FULL_NAME"));
  67. user.setGroup(result.getString("NAME_GROUP"));
  68. user.setBestResult(result.getString("COUNT_TRUE_ANSWERS") + "/" + result.getString("COUNT_QUESTIONS"));
  69. users.add(user);
  70. }
  71. return users;
  72. }
  73.  
  74. ...
  75.  
  76. }
Add Comment
Please, Sign In to add comment