studentValidity

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;

/**
 *
 * @author Tarequzzaman
 */
@WebServlet(name = "student_validity", urlPatterns = {"/student_validity"})
public class student_validity extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            try {


                Class.forName("oracle.jdbc.driver.OracleDriver");
                Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "pro", "sec");
                Statement st = con.createStatement();
                String registration = request.getParameter("reg");

                request.setAttribute("reg", registration);
                long reg = Long.parseLong(registration);

                String semester = request.getParameter("semester");
                request.setAttribute("semester", semester);
                String session_ = request.getParameter("session");
                request.setAttribute("session", session_);

                String sql = "SELECT registration_no,student_name from student where session_='" + session_ + "' and registration_no=" + reg + "";
                ResultSet rs = st.executeQuery(sql);
                int cou = 0;
                while (rs.next()) {
                    long reg_no = rs.getInt(1);
                    String name = rs.getString(2);
                    request.setAttribute("name", name);


                    cou = 1;
                }
              if(cou==0)
              {
                   response.sendRedirect("datanotfound.jsp");
              }
                sql = "SELECT registration_no from partA where session_='" + session_ + "' and semester="+semester+" and registration_no=" + reg + "";
                int tag=0;
               rs=st.executeQuery(sql);
               while(rs.next())
               {
                   long reg_no1= rs.getInt(1);
                  if(reg_no1==reg)
                  {
                   tag=1;
                   break;
                  }
               }

                sql = "SELECT registration_no from partB where session_='" + session_ + "' and semester="+semester+" and registration_no=" + reg + "";
                int tag_partB=0;
               rs=st.executeQuery(sql);
               while(rs.next())
               {
                   long reg_no1= rs.getInt(1);
                  if(reg_no1==reg)
                  {
                   tag_partB=1;
                   break;
                  }
               }

               sql = "SELECT registration_no from Termtest where session_='" + session_ + "' and semester="+semester+" and registration_no=" + reg + "";
               int tag_tt=0;
               rs=st.executeQuery(sql);
               while(rs.next())
               {
                   long reg_no1= rs.getInt(1);
                  if(reg_no1==reg)
                  {
                   tag_tt=1;
                   break;
                  }
               }

               sql = "SELECT registration_no from Termtest where session_='" + session_ + "' and semester="+semester+" and registration_no=" + reg + "";
               int tag_lb=0;
               rs=st.executeQuery(sql);
               while(rs.next())
               {
                   long reg_no1= rs.getInt(1);
                  if(reg_no1==reg)
                  {
                   tag_lb=1;
                   break;
                  }
               }

               if(cou==1 && tag==1 && tag_partB==1 && tag_lb==1 && tag_tt==1)
               {
                    request.getRequestDispatcher("result_view.jsp").forward(request, response);
                    response.sendRedirect("result_view.jsp");
               }
               else
               {
                   response.sendRedirect("result_not_process.jsp");
               }
            } catch (Exception e) {
            }

        } finally {
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}