afhfgj

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html; charset=UTF-8");
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String requestType= request.getParameter("requestType");

        if (requestType == null) {
            createDynamicPageError(response, "Invalid request type");
        }
        if (requestType.equalsIgnoreCase("Login")){
            String username = request.getParameter("username");
            String password = request.getParameter("password");

            try{
                Connection con = datasource.getConnection();

                PreparedStatement stmt = con.prepareStatement("SELECT * FROM patient WHERE username=? AND password=?");
                stmt.setString(1, username);
                stmt.setString(2, password);
                ResultSet rs = stmt.executeQuery();

                while(rs.next()){
                    if(rs.getString("username").equals(username) && rs.getString("password").equals(password)){
                        createDynamicPageSuccess(response, "You have logged in successfully");
                        break;
                    }
                    else{
                        createDynamicPageError(response, "Your username or password is incorrect");
                    }
                }

                rs.close();
                con.close();

            }   catch(SQLException sqle) {
                sqle.printStackTrace();
            }
        }
    }