Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <c:forEach var = "i" begin = "1" end = "5">
- Item <c:out value = "${i}"/><p>
- </c:forEach>
- ...
- <%
- ArrayList<UserModel> users = UserMaker.getUsers();
- %>
- ...
- <c:forEach items="${users}" var="user">
- <tr>
- <td>${user.name}</td>
- <td>${user.login}</td>
- <td>${user.group}</td>
- <td>${user.bestResult}</td>
- </tr>
- </c:forEach>
- ...
- public class UserModel {
- private String login;
- private String name;
- private String group;
- private String bestResult;
- public UserModel(){
- ...
- }
- ...
- public String getName() {
- return name;
- }
- public String getGroup() {
- return group;
- }
- public String getLogin() {
- return login;
- }
- public String getBestResult() {
- return bestResult;
- }
- }
- public class Users {
- ...
- public static ArrayList<UserModel> getUsers() throws SQLException {
- ArrayList<UserModel> users = new ArrayList<UserModel>();
- String query = "SELECT * FROM users u LEFT JOIN groups g ON u.id_group = g.id";
- ResultSet result = FirebirdDB.getInstance().execSelect(query);
- while (result.next()){
- UserModel user = new UserModel();
- user.setLogin(result.getString("LOGIN"));
- user.setName(result.getString("FULL_NAME"));
- user.setGroup(result.getString("NAME_GROUP"));
- user.setBestResult(result.getString("COUNT_TRUE_ANSWERS") + "/" + result.getString("COUNT_QUESTIONS"));
- users.add(user);
- }
- return users;
- }
- ...
- }
Add Comment
Please, Sign In to add comment