Untitled

JSP

<%@page import="java.sql.*"%>
<% Class.forName("com.mysql.jdbc.Driver"); %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Selecting Data From A DB</title>
    </head>
    <body>
        <h1>Selecting Data From A DB</h1>

        <%!
            public class Student {
          String URL = "jdbc:mysql://localhost:3306/school_db_newnew?useTimezone=true&serverTimezone=GMT";
          String USER = "root";
          String PASSWORD = "123456";

          Connection connection = null;
          PreparedStatement selectStudents = null;
          ResultSet resultSet = null;

          public Student() {
           try {
                connection = DriverManager.getConnection(URL, USER, PASSWORD);

                selectStudents = connection.prepareStatement("SELECT student.name, student.surname FROM student");
            } catch (SQLException e){
                e.printStackTrace();
}

}


            public ResultSet getStudents() {
                try {
                     resultSet = selectStudents.executeQuery();
        }catch (SQLException e){
            e.printStackTrace();
}
        return resultSet;
}
    }

        %>

        <%
            Student student = new Student();
            ResultSet students = student.getStudents();
            %>
            <table border="1">

                <tbody>
                    <tr>
                        <td>Name</td>
                        <td>Surname</td>
                    </tr>
                    <% while (students.next()) {%>
                    <tr>
                        <td><%= students.getString("student.name")%></td>
                        <td><%= students.getString("student.surname")%></td>
                    </tr>
                    <%}%>
                </tbody>
            </table>


    </body>
</html>

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class MyServlet extends HttpServlet {


    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            /* TODO output your page here. You may use following sample code. */
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet MyServlet</title>");
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>Servlet MyServlet at " + request.getContextPath() + "</h1>");
            out.println("</body>");
            out.println("</html>");
        }
    }


    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }


    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }


    @Override
    public String getServletInfo() {
        return "Short description";
    }

}