ServletRecord

public class ServletRecord extends HttpServlet {

    private static final long serialVersionUID = 1L;
    private RecordDAOImpl recordDAOImpl;
    private PlayerDAOImpl playerDAOImpl;
    private LevelDAOImpl levelDAOImpl;

    public void init() {
        String jdbcURL = getServletContext().getInitParameter("jdbcURL");
        String jdbcUsername = getServletContext().getInitParameter("jdbcUsername");
        String jdbcPassword = getServletContext().getInitParameter("jdbcPassword");

        DbConnection dbConnection = new DbConnection(jdbcURL, jdbcUsername, jdbcPassword);
        recordDAOImpl= new RecordDAOImpl(dbConnection);
        playerDAOImpl= new PlayerDAOImpl(dbConnection);
        levelDAOImpl= new LevelDAOImpl(dbConnection);

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

    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String action = request.getServletPath();

        try {
            switch (action) {
                case "/newR":
                    showNewForm(request, response);
                    break;
                case "/insertR":
                    insertRecord(request, response);
                    break;
                case "/deleteR":
                    deleteRecord(request, response);
                    break;
                case "/editR":
                    showEditForm(request, response);
                    break;
                case "/updateR":
                    updateRecord(request, response);
                    break;
                case "/listR":
                    listRecord(request, response);
                    break;
                case "/listRecord_Record":
                    request.getRequestDispatcher("/ServletRecord").forward(request, response);
                    break;
                case "/listRecord_Level":
                    request.getRequestDispatcher("/ServletLevel").forward(request, response);
                    break;
                case "/listRecord_Player":
                    request.getRequestDispatcher("/ServletPlayer").forward(request, response);
                    break;

                default:
                    listRecord(request, response);
                    break;
            }
        } catch (SQLException ex) {
            throw new ServletException(ex);
        }
    }
    private void listRecord(HttpServletRequest request, HttpServletResponse response)
            throws SQLException, IOException, ServletException {
        List<Record> listRecord = recordDAOImpl.GetAll();
        List<Player> listPlayer = playerDAOImpl.GetAll();
        List<Level> listLevel = levelDAOImpl.GetAll();
        request.getSession().setAttribute("listLevel", listLevel);
        request.getSession().setAttribute("listPlayer", listPlayer);
        request.getSession().setAttribute("listRecord", listRecord);
        request.getRequestDispatcher("Record.jsp").forward(request, response);

    }

    private void showNewForm(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException, SQLException {
        List<Record> listRecord = recordDAOImpl.GetAll();
        List<Player> listPlayer = playerDAOImpl.GetAll();
        List<Level> listLevel = levelDAOImpl.GetAll();
        request.getSession().setAttribute("listLevel", listLevel);
        request.getSession().setAttribute("listPlayer", listPlayer);
        request.getSession().setAttribute("listRecord", listRecord);
        RequestDispatcher dispatcher = request.getRequestDispatcher("AddRecord.jsp");
        dispatcher.forward(request, response);
    }

    private void showEditForm(HttpServletRequest request,
                              HttpServletResponse response)
            throws SQLException, ServletException, IOException {
        int id_player = Integer.parseInt(request.getParameter("id_player"));
        int id_level = Integer.parseInt(request.getParameter("id_level"));

        Record existingRecord = recordDAOImpl.getId(id_player,id_level);
        RequestDispatcher dispatcher = request.getRequestDispatcher("AddRecord.jsp");
        request.setAttribute("record", existingRecord);
        dispatcher.forward(request, response);

    }