Untitled

localhost:8080/user

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    Connection con = null;
    Statement st = null;
    ResultSet rs = null;

    String url = "jdbc:mysql://localhost:3306/joker";
    String user = "kryternext";
    String password = "11121997";


    ArrayList<Point> points = new ArrayList<Point>();
    String message = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");

        con = DriverManager.getConnection(url, user, password);
        st = con.createStatement();
        rs = st.executeQuery("SELECT * FROM joker.point;");
        while (rs.next()) {
            Point p = new Point();
            p.setId(rs.getInt("id"));
            p.setName(rs.getString("name"));
            points.add(p);
        }
        if (rs.next()) {
            message = rs.getString(1);
        }
    } catch (SQLException | ClassNotFoundException ex) {
        message = ex.getMessage();
    } finally {
        try {
            if (rs != null) {
                rs.close();
            }

            if (st != null) {
                st.close();
            }

            if (con != null) {
                con.close();
            }
        } catch (SQLException ex) {
            message = ex.getMessage();
        }
    }

    String page;
    try {
        page = request.getParameter("page");
    } catch (Exception e) {
        page = "home";
    }

    request.setAttribute("points", points);
    request.setAttribute("page", page);
    request.setAttribute("message", message);

    if (page != null) {
        switch (page) {
            case "about":
                request.getRequestDispatcher("/about.jsp").forward(request, response);
                break;
            case "contact":
                request.getRequestDispatcher("/contact.jsp").forward(request, response);
                break;
            default:
                request.getRequestDispatcher("/index.jsp").forward(request, response);
                break;
        }
    } else {
        request.getRequestDispatcher("/index.jsp").forward(request, response);
    }
}
}

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@page import="model.*" %>
<%@ page import="java.util.List,java.util.ArrayList,java.util.Iterator"%>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Joker</title>

    <!-- Bootstrap Core CSS -->
    <link href="css/bootstrap.css" rel="stylesheet">
    <!--[if lt IE 9]>
    <script src="js/html5shiv.js"></script>
    <script src="js/respond.js"></script>
    <![endif]-->
</head>
<body>
<%
    out.println("Your IP address is " + request.getRemoteAddr());

    ArrayList<Point> points = (ArrayList<Point>) request.getAttribute("points");
%>


<%@ include file="_menu.jsp" %>

<br/>

<div class="row">
    <div class="col-md-12">
        <h1>Home</h1>
        <p>${page}</p>
        <p>${message}</p>

        <ul>
            <% for (int i = 0; i < points.size(); i++) { %>
            <li>
                <%= points.get(i).getId() %>
                :
                <%= points.get(i).getName() %>
            </li>
            <%}%>
        </ul>


    </div>
</div>


<!-- jQuery -->
<script src="js/jquery.js"></script>
<!-- Bootstrap Core JavaScript -->
<script src="js/bootstrap.js"></script>

</body>

</html>