StudentsInnerTabsServlet.java

/*
 * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
 * Click nbfs://nbhost/SystemFileSystem/Templates/JSP_Servlet/Servlet.java to edit this template
 */
package com.finlogic.step.controller;

import com.finlogic.step.services.StudentService;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class StudentsInnerTabsServlet extends HttpServlet {

    StudentService studentservice = new StudentService();

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            String process = request.getParameter("process");

            if (process.equals("View")
                    || process.equals("Edit")
                    || process.equals("Delete")) {
                ResultSet rs = studentservice.ViewAllStudents();

                request.setAttribute("result", rs);
                request.setAttribute("process", process);

                RequestDispatcher view = request.getRequestDispatcher("StudentsInnerTabs.jsp");
                view.forward(request, response);

            } else if (process.equals("add")) {
                request.setAttribute("process", process);
                RequestDispatcher view = request.getRequestDispatcher("StudentsInnerTabs.jsp");
                view.forward(request, response);
            } else if (process.equals("insert")) {

                String name = request.getParameter("name");
                String email = request.getParameter("email");
                String address = request.getParameter("address");
                String city = request.getParameter("city");
                String state = request.getParameter("state");

                int rs = studentservice.InsertStudent(name, email, address, city, state);

                request.setAttribute("process", process);
                request.setAttribute("status", rs);
                RequestDispatcher view = request.getRequestDispatcher("mastertask.jsp");
                view.forward(request, response);

            } else if (process.equals("delete")) {
                int id = Integer.parseInt(request.getParameter("id"));
                studentservice.DeleteStudent(id);
                
            } else if (process.equals("edit")) {

                String name = request.getParameter("name");
                String email = request.getParameter("email");
                String address = request.getParameter("address");
                String city = request.getParameter("city");
                String state = request.getParameter("state");
                int id = Integer.parseInt(request.getParameter("id"));

                int rs = studentservice.EditStudent(id,name, email, address, city, state);
                if(rs>0){
                    out.println("1");
                }else{
                    out.println("0");
                }
            }
        } catch (SQLException ex) {
            System.out.println("error" + ex.getMessage());
        }
    }

    @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";
    }
}