Untitled

public class UserServlet extends javax.servlet.http.HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {}

    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 = "user";
        String password = "password";
        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>