Servlet Request and Response Code Part 1 Programming Logic and Code with Syntax

Servlet Request and Response Code Part 1

package com.sawan;


import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class WenTeacherUpadeFianl
 */
@WebServlet("/WenTeacherUpadeFianl")
public class WenTeacherUpadeFianl extends HttpServlet {
 private static final long serialVersionUID = 1L;
 ResultSet rs=null;
 Connection con=null;
 Statement st=null; 
 String tabltname;
 int sawan=0;
 public WenTeacherUpadeFianl() {
  super();
  // TODO Auto-generated constructor stub
 }

 /**
  * @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
  */
 protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

  if((request.getParameter("id").equals("null"))||(request.getParameter("a1").equals("null"))||(request.getParameter("a2").equals("null")))
  {
   getServletContext().getRequestDispatcher("/Administrative.jsp").forward(request, response);
   return;
  }
  else
  {
   DataBase db=new DataBase();
   con=db.getConnection();
   ReadData rd=new ReadData();
   tabltname="MPSS"+request.getParameter("id")+"FA";
   String sql1="Update Attendance."+tabltname+" SET STUDENTNAME='"+request.getParameter("a1")+"',"
     + "STUDENTFNAME='"+request.getParameter("a2")+"',"
     + "STUDENTCODE='"+request.getParameter("a3")+"',"
     + "STUDENTPASS='"+request.getParameter("a4")+"',"
     + "STUDENTMOBILE='"+request.getParameter("a5")+"',"
     + "STUDENTEMAIL='"+request.getParameter("a6")+"',"
     + "DrictorNotice='No Notice',"
     + "HodNotice='NO Notice',"
     + "HodNo=0,"
     + "DRICTORHODNOTICE='No Notice',"
     + "Hodyes=0"
     + " WHERE STUDENTFNAME='"+request.getParameter("a2")+"'";
   try {
    st = con.createStatement();
    st.executeUpdate(sql1);
    System.out.println("sawan............");
    String collegeid=request.getParameter("id");
    request.setAttribute("cid", collegeid);
    getServletContext().getRequestDispatcher("/Adminstrative.jsp").forward(request, response); 
    return; 
   } catch (Exception e) {
    String collegeid=request.getParameter("id");
    request.setAttribute("cid", collegeid);
    getServletContext().getRequestDispatcher("/brns.jsp").forward(request, response); 
    e.printStackTrace();
    System.out.println(e);
    return;
   }    
  }
 }
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

  response.getWriter().append("Served at: ").append(request.getContextPath());
 }
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

  doGet(request, response);
 }

}

Servlet Code for upload the Teacher data in SQL

package com.sawan;

import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class WebTeacherUpdate
 */
@WebServlet("/WebTeacherUpdate")
public class WebTeacherUpdate extends HttpServlet {
 private static final long serialVersionUID = 1L;
 ResultSet rs=null;
 int sawan=0;
 Connection con=null;
 String tablename;
    public WebTeacherUpdate() {
        super();
        // TODO Auto-generated constructor stub
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  DataBase db=new DataBase();
  con=db.getConnection();
  ReadData rd=new ReadData();
  tablename="MPSS"+request.getParameter(("id"))+"FA";
  String sql1="select * from Attendance."+tablename+" WHERE STUDENTFNAME='"+request.getParameter(("CODE"))+"'";
  try {
   rs= ((ReadData) rd).getInf(con, sql1);
   rs.next(); 
   String sawan2=request.getParameter(("id"));
   System.out.println(sawan2);
  
   request.setAttribute("name", rs.getString("STUDENTNAME"));
   request.setAttribute("fname", rs.getString("STUDENTFNAME"));
   request.setAttribute("code", rs.getString("STUDENTCODE"));
   request.setAttribute("pass", rs.getString("STUDENTPASS"));
   request.setAttribute("mob", rs.getString("STUDENTMOBILE"));
   request.setAttribute("email", rs.getString("STUDENTEMAIL"));
   System.out.println("sawan.......demo page .....");
   sawan=1;
   if(sawan==1)
   {
    String collegeid=request.getParameter("cid");
    request.setAttribute("cid", sawan2);
    getServletContext().getRequestDispatcher("/TecacherEdit.jsp").forward(request, response); 
    return;

   }
   else
   {
    System.out.println("sawan.faltu...........");

    String collegename=request.getParameter("cname");
    String collegeid=request.getParameter("cid");
    request.setAttribute("cname", collegename);
    request.setAttribute("cid", collegeid);
    getServletContext().getRequestDispatcher("/brans.jsp").forward(request, response); 
    return;
   }
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }

 }

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

  doGet(request, response);
 }

}


Home Work Update Complete Code in JAVA With Servlet
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Enumeration;



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 org.json.JSONException;

import org.json.JSONObject;



@WebServlet("/AdminHomeWorkUpdate")

public class AdminHomeWorkUpdate extends HttpServlet {

 private static final long serialVersionUID = 1L;

  Statement st=null;

  String dayss,monss,yearss;



 public AdminHomeWorkUpdate() {

  super();

  // TODO Auto-generated constructor stub

 }

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



  JSONObject json = new JSONObject();

  Enumeration paramNames = request.getParameterNames();

  String params[] = new String[13];

  int i = 0;

  while (paramNames.hasMoreElements()) {

   String paramName = (String) paramNames.nextElement();

   String[] paramValues = request.getParameterValues(paramName);

   params[i] = paramValues[0];

   i++;

  }

   String datesawan = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());

         String redate2[] = datesawan.split("_");

         char[] chsawan = redate2[0].toCharArray();

         String date3sawan = chsawan.toString();

         yearss= redate2[0].substring(0, 4);

         monss = redate2[0].substring(4, 6);

         dayss = redate2[0].substring(6);

         String classnamecolumn1 = "null";

   String classnamecolumn2 = "null";

   String classnamecolumn3 = "null";

   String classnamecolumn4 = "null";

   String classnamecolumn5 = "null";

   String classnamecolumn6 = "null";

   String classnamecolumn7 = "null";

   String classnamecolumn8 = "null";

   String classnamecolumn9 = "null";

   String classnamecolumn10 = "null";

   String classnamecolumn = "null";

   int classvalue=Integer.parseInt(params[1]);

   switch (classvalue) {

   case 22:

    //classvalue = 22;

    classnamecolumn = "Nur";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A221";

     classnamecolumn2 = "A222";

     classnamecolumn3 = "A223";

     classnamecolumn4 = "A224";

     classnamecolumn5 = "A225";

     classnamecolumn6 = "A226";

     classnamecolumn7 = "A227";

     classnamecolumn8 = "A228";

     classnamecolumn9 = "A229";

     classnamecolumn10 = "A2210";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B221";

     classnamecolumn2 = "B222";

     classnamecolumn3 = "B223";

     classnamecolumn4 = "B224";

     classnamecolumn5 = "B225";

     classnamecolumn6 = "B226";

     classnamecolumn7 = "B227";

     classnamecolumn8 = "B228";

     classnamecolumn9 = "B229";

     classnamecolumn10 = "B2210";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C221";

     classnamecolumn2 = "C222";

     classnamecolumn3 = "C223";

     classnamecolumn4 = "C224";

     classnamecolumn5 = "C225";

     classnamecolumn6 = "C226";

     classnamecolumn7 = "C227";

     classnamecolumn8 = "C228";

     classnamecolumn9 = "C229";

     classnamecolumn10 = "C2210";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D221";

     classnamecolumn2 = "D222";

     classnamecolumn3 = "D223";

     classnamecolumn4 = "D224";

     classnamecolumn5 = "D225";

     classnamecolumn6 = "D226";

     classnamecolumn7 = "D227";

     classnamecolumn8 = "D228";

     classnamecolumn9 = "D229";

     classnamecolumn10 = "D2210";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E221";

     classnamecolumn2 = "E222";

     classnamecolumn3 = "E223";

     classnamecolumn4 = "E224";

     classnamecolumn5 = "E225";

     classnamecolumn6 = "E226";

     classnamecolumn7 = "E227";

     classnamecolumn8 = "E228";

     classnamecolumn9 = "E229";

     classnamecolumn10 = "E2210";

    } else {

     classnamecolumn1 = "F221";

     classnamecolumn2 = "F222";

     classnamecolumn3 = "F223";

     classnamecolumn4 = "F224";

     classnamecolumn5 = "F225";

     classnamecolumn6 = "F226";

     classnamecolumn7 = "F227";

     classnamecolumn8 = "F228";

     classnamecolumn9 = "F229";

     classnamecolumn10 = "F2210";

    }



    break;

   case 23:

    //classvalue = 23;

    classnamecolumn = "LKG";

   if (params[2].equals("A")) {

     classnamecolumn1 = "A231";

     classnamecolumn2 = "A232";

     classnamecolumn3 = "A233";

     classnamecolumn4 = "A234";

     classnamecolumn5 = "A235";

     classnamecolumn6 = "A236";

     classnamecolumn7 = "A237";

     classnamecolumn8 = "A238";

     classnamecolumn9 = "A239";

     classnamecolumn10 = "A2310";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B231";

     classnamecolumn2 = "B232";

     classnamecolumn3 = "B233";

     classnamecolumn4 = "B234";

     classnamecolumn5 = "B235";

     classnamecolumn6 = "B236";

     classnamecolumn7 = "B237";

     classnamecolumn8 = "B238";

     classnamecolumn9 = "B239";

     classnamecolumn10 = "B2310";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C231";

     classnamecolumn2 = "C232";

     classnamecolumn3 = "C233";

     classnamecolumn4 = "C234";

     classnamecolumn5 = "C235";

     classnamecolumn6 = "C236";

     classnamecolumn7 = "C237";

     classnamecolumn8 = "C238";

     classnamecolumn9 = "C239";

     classnamecolumn10 = "C2310";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D231";

     classnamecolumn2 = "D232";

     classnamecolumn3 = "D233";

     classnamecolumn4 = "D234";

     classnamecolumn5 = "D235";

     classnamecolumn6 = "D236";

     classnamecolumn7 = "D237";

     classnamecolumn8 = "D238";

     classnamecolumn9 = "D239";

     classnamecolumn10 = "D2310";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E231";

     classnamecolumn2 = "E232";

     classnamecolumn3 = "E233";

     classnamecolumn4 = "E234";

     classnamecolumn5 = "E235";

     classnamecolumn6 = "E236";

     classnamecolumn7 = "E237";

     classnamecolumn8 = "E238";

     classnamecolumn9 = "E239";

     classnamecolumn10 = "E2310";

    } else {

     classnamecolumn1 = "F231";

     classnamecolumn2 = "F232";

     classnamecolumn3 = "F233";

     classnamecolumn4 = "F234";

     classnamecolumn5 = "F235";

     classnamecolumn6 = "F236";

     classnamecolumn7 = "F237";

     classnamecolumn8 = "F238";

     classnamecolumn9 = "F239";

     classnamecolumn10 = "F2310";

    }



    break;

   case 24:

    //classvalue = 24;

    classnamecolumn = "UKG";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A241";

     classnamecolumn2 = "A242";

     classnamecolumn3 = "A243";

     classnamecolumn4 = "A244";

     classnamecolumn5 = "A245";

     classnamecolumn6 = "A246";

     classnamecolumn7 = "A247";

     classnamecolumn8 = "A248";

     classnamecolumn9 = "A249";

     classnamecolumn10 = "A2410";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B241";

     classnamecolumn2 = "B242";

     classnamecolumn3 = "B243";

     classnamecolumn4 = "B244";

     classnamecolumn5 = "B245";

     classnamecolumn6 = "B246";

     classnamecolumn7 = "B247";

     classnamecolumn8 = "B248";

     classnamecolumn9 = "B249";

     classnamecolumn10 = "B2410";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C241";

     classnamecolumn2 = "C242";

     classnamecolumn3 = "C243";

     classnamecolumn4 = "C244";

     classnamecolumn5 = "C245";

     classnamecolumn6 = "C246";

     classnamecolumn7 = "C247";

     classnamecolumn8 = "C248";

     classnamecolumn9 = "C249";

     classnamecolumn10 = "C2410";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D241";

     classnamecolumn2 = "D242";

     classnamecolumn3 = "D243";

     classnamecolumn4 = "D244";

     classnamecolumn5 = "D245";

     classnamecolumn6 = "D246";

     classnamecolumn7 = "D247";

     classnamecolumn8 = "D248";

     classnamecolumn9 = "D249";

     classnamecolumn10 = "D2410";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E241";

     classnamecolumn2 = "E242";

     classnamecolumn3 = "E243";

     classnamecolumn4 = "E244";

     classnamecolumn5 = "E245";

     classnamecolumn6 = "E246";

     classnamecolumn7 = "E247";

     classnamecolumn8 = "E248";

     classnamecolumn9 = "E249";

     classnamecolumn10 = "E2410";

    } else {

     classnamecolumn1 = "F241";

     classnamecolumn2 = "F242";

     classnamecolumn3 = "F243";

     classnamecolumn4 = "F244";

     classnamecolumn5 = "F245";

     classnamecolumn6 = "F246";

     classnamecolumn7 = "F247";

     classnamecolumn8 = "F248";

     classnamecolumn9 = "F249";

     classnamecolumn10 = "F2410";

    }



    break;

   case 21:

    //classvalue = 21;

    classnamecolumn = "Play";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A211";

     classnamecolumn2 = "A212";

     classnamecolumn3 = "A213";

     classnamecolumn4 = "A214";

     classnamecolumn5 = "A215";

     classnamecolumn6 = "A216";

     classnamecolumn7 = "A217";

     classnamecolumn8 = "A218";

     classnamecolumn9 = "A219";

     classnamecolumn10 = "A2110";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B211";

     classnamecolumn2 = "B212";

     classnamecolumn3 = "B213";

     classnamecolumn4 = "B214";

     classnamecolumn5 = "B215";

     classnamecolumn6 = "B216";

     classnamecolumn7 = "B217";

     classnamecolumn8 = "B218";

     classnamecolumn9 = "B219";

     classnamecolumn10 = "B2110";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C211";

     classnamecolumn2 = "C212";

     classnamecolumn3 = "C213";

     classnamecolumn4 = "C214";

     classnamecolumn5 = "C215";

     classnamecolumn6 = "C216";

     classnamecolumn7 = "C217";

     classnamecolumn8 = "C218";

     classnamecolumn9 = "C219";

     classnamecolumn10 = "C2110";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D211";

     classnamecolumn2 = "D212";

     classnamecolumn3 = "D213";

     classnamecolumn4 = "D214";

     classnamecolumn5 = "D215";

     classnamecolumn6 = "D216";

     classnamecolumn7 = "D217";

     classnamecolumn8 = "D218";

     classnamecolumn9 = "D219";

     classnamecolumn10 = "D2110";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E211";

     classnamecolumn2 = "E212";

     classnamecolumn3 = "E213";

     classnamecolumn4 = "E214";

     classnamecolumn5 = "E215";

     classnamecolumn6 = "E216";

     classnamecolumn7 = "E217";

     classnamecolumn8 = "E218";

     classnamecolumn9 = "E219";

     classnamecolumn10 = "E2110";

    } else {

     classnamecolumn1 = "F211";

     classnamecolumn2 = "F212";

     classnamecolumn3 = "F213";

     classnamecolumn4 = "F214";

     classnamecolumn5 = "F215";

     classnamecolumn6 = "F216";

     classnamecolumn7 = "F217";

     classnamecolumn8 = "F218";

     classnamecolumn9 = "F219";

     classnamecolumn10 = "F2110";

    }



    break;

   case 1:

    classvalue = 1;

 

    classnamecolumn = "FIRSTS";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A011";

     classnamecolumn2 = "A012";

     classnamecolumn3 = "A013";

     classnamecolumn4 = "A014";

     classnamecolumn5 = "A015";

     classnamecolumn6 = "A016";

     classnamecolumn7 = "A017";

     classnamecolumn8 = "A018";

     classnamecolumn9 = "A019";

     classnamecolumn10 = "A0110";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B011";

     classnamecolumn2 = "B012";

     classnamecolumn3 = "B013";

     classnamecolumn4 = "B014";

     classnamecolumn5 = "B015";

     classnamecolumn6 = "B016";

     classnamecolumn7 = "B017";

     classnamecolumn8 = "B018";

     classnamecolumn9 = "B019";

     classnamecolumn10 = "B0110";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C011";

     classnamecolumn2 = "C012";

     classnamecolumn3 = "C013";

     classnamecolumn4 = "C014";

     classnamecolumn5 = "C015";

     classnamecolumn6 = "C016";

     classnamecolumn7 = "C017";

     classnamecolumn8 = "C018";

     classnamecolumn9 = "C019";

     classnamecolumn10 = "C0110";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D011";

     classnamecolumn2 = "D012";

     classnamecolumn3 = "D013";

     classnamecolumn4 = "D014";

     classnamecolumn5 = "D015";

     classnamecolumn6 = "D016";

     classnamecolumn7 = "D017";

     classnamecolumn8 = "D018";

     classnamecolumn9 = "D019";

     classnamecolumn10 = "D0110";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E011";

     classnamecolumn2 = "E012";

     classnamecolumn3 = "E013";

     classnamecolumn4 = "E014";

     classnamecolumn5 = "E015";

     classnamecolumn6 = "E016";

     classnamecolumn7 = "E017";

     classnamecolumn8 = "E018";

     classnamecolumn9 = "E019";

     classnamecolumn10 = "E0110";

    } else {

     classnamecolumn1 = "F011";

     classnamecolumn2 = "F012";

     classnamecolumn3 = "F013";

     classnamecolumn4 = "F014";

     classnamecolumn5 = "F015";

     classnamecolumn6 = "F016";

     classnamecolumn7 = "F017";

     classnamecolumn8 = "F018";

     classnamecolumn9 = "F019";

     classnamecolumn10 = "F0110";

    }



    break;

   case 2:

    classvalue = 2;

    classnamecolumn = "SECONDS";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A021";

     classnamecolumn2 = "A022";

     classnamecolumn3 = "A023";

     classnamecolumn4 = "A024";

     classnamecolumn5 = "A025";

     classnamecolumn6 = "A026";

     classnamecolumn7 = "A027";

     classnamecolumn8 = "A028";

     classnamecolumn9 = "A029";

     classnamecolumn10 = "A0210";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B021";

     classnamecolumn2 = "B022";

     classnamecolumn3 = "B023";

     classnamecolumn4 = "B024";

     classnamecolumn5 = "B025";

     classnamecolumn6 = "B026";

     classnamecolumn7 = "B027";

     classnamecolumn8 = "B028";

     classnamecolumn9 = "B029";

     classnamecolumn10 = "B0210";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C021";

     classnamecolumn2 = "C022";

     classnamecolumn3 = "C023";

     classnamecolumn4 = "C024";

     classnamecolumn5 = "C025";

     classnamecolumn6 = "C026";

     classnamecolumn7 = "C027";

     classnamecolumn8 = "C028";

     classnamecolumn9 = "C029";

     classnamecolumn10 = "C0210";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D021";

     classnamecolumn2 = "D022";

     classnamecolumn3 = "D023";

     classnamecolumn4 = "D024";

     classnamecolumn5 = "D025";

     classnamecolumn6 = "D026";

     classnamecolumn7 = "D027";

     classnamecolumn8 = "D028";

     classnamecolumn9 = "D029";

     classnamecolumn10 = "D0210";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E021";

     classnamecolumn2 = "E022";

     classnamecolumn3 = "E023";

     classnamecolumn4 = "E024";

     classnamecolumn5 = "E025";

     classnamecolumn6 = "E026";

     classnamecolumn7 = "E027";

     classnamecolumn8 = "E028";

     classnamecolumn9 = "E029";

     classnamecolumn10 = "E0210";

    } else {

     classnamecolumn1 = "F021";

     classnamecolumn2 = "F022";

     classnamecolumn3 = "F023";

     classnamecolumn4 = "F024";

     classnamecolumn5 = "F025";

     classnamecolumn6 = "F026";

     classnamecolumn7 = "F027";

     classnamecolumn8 = "F028";

     classnamecolumn9 = "F029";

     classnamecolumn10 = "F0210";

    }



    break;

   case 3:

    classvalue = 3;

    classnamecolumn = "THIRD";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A031";

     classnamecolumn2 = "A032";

     classnamecolumn3 = "A033";

     classnamecolumn4 = "A034";

     classnamecolumn5 = "A035";

     classnamecolumn6 = "A036";

     classnamecolumn7 = "A037";

     classnamecolumn8 = "A038";

     classnamecolumn9 = "A039";

     classnamecolumn10 = "A0310";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B031";

     classnamecolumn2 = "B032";

     classnamecolumn3 = "B033";

     classnamecolumn4 = "B034";

     classnamecolumn5 = "B035";

     classnamecolumn6 = "B036";

     classnamecolumn7 = "B037";

     classnamecolumn8 = "B038";

     classnamecolumn9 = "B039";

     classnamecolumn10 = "B0310";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C031";

     classnamecolumn2 = "C032";

     classnamecolumn3 = "C033";

     classnamecolumn4 = "C034";

     classnamecolumn5 = "C035";

     classnamecolumn6 = "C036";

     classnamecolumn7 = "C037";

     classnamecolumn8 = "C038";

     classnamecolumn9 = "C039";

     classnamecolumn10 = "C0310";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D031";

     classnamecolumn2 = "D032";

     classnamecolumn3 = "D033";

     classnamecolumn4 = "D034";

     classnamecolumn5 = "D035";

     classnamecolumn6 = "D036";

     classnamecolumn7 = "D037";

     classnamecolumn8 = "D038";

     classnamecolumn9 = "D039";

     classnamecolumn10 = "D0310";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E031";

     classnamecolumn2 = "E032";

     classnamecolumn3 = "E033";

     classnamecolumn4 = "E034";

     classnamecolumn5 = "E035";

     classnamecolumn6 = "E036";

     classnamecolumn7 = "E037";

     classnamecolumn8 = "E038";

     classnamecolumn9 = "E039";

     classnamecolumn10 = "E0310";

    } else {

     classnamecolumn1 = "F031";

     classnamecolumn2 = "F032";

     classnamecolumn3 = "F033";

     classnamecolumn4 = "F034";

     classnamecolumn5 = "F035";

     classnamecolumn6 = "F036";

     classnamecolumn7 = "F037";

     classnamecolumn8 = "F038";

     classnamecolumn9 = "F039";

     classnamecolumn10 = "F0310";

    }



    break;

   case 4:

    classvalue = 4;

    classnamecolumn = "FOURTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A041";

     classnamecolumn2 = "A042";

     classnamecolumn3 = "A043";

     classnamecolumn4 = "A044";

     classnamecolumn5 = "A045";

     classnamecolumn6 = "A046";

     classnamecolumn7 = "A047";

     classnamecolumn8 = "A048";

     classnamecolumn9 = "A049";

     classnamecolumn10 = "A0410";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B041";

     classnamecolumn2 = "B042";

     classnamecolumn3 = "B043";

     classnamecolumn4 = "B044";

     classnamecolumn5 = "B045";

     classnamecolumn6 = "B046";

     classnamecolumn7 = "B047";

     classnamecolumn8 = "B048";

     classnamecolumn9 = "B049";

     classnamecolumn10 = "B0410";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C041";

     classnamecolumn2 = "C042";

     classnamecolumn3 = "C043";

     classnamecolumn4 = "C044";

     classnamecolumn5 = "C045";

     classnamecolumn6 = "C046";

     classnamecolumn7 = "C047";

     classnamecolumn8 = "C048";

     classnamecolumn9 = "C049";

     classnamecolumn10 = "C0410";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D041";

     classnamecolumn2 = "D042";

     classnamecolumn3 = "D043";

     classnamecolumn4 = "D044";

     classnamecolumn5 = "D045";

     classnamecolumn6 = "D046";

     classnamecolumn7 = "D047";

     classnamecolumn8 = "D048";

     classnamecolumn9 = "D049";

     classnamecolumn10 = "D0410";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E041";

     classnamecolumn2 = "E042";

     classnamecolumn3 = "E043";

     classnamecolumn4 = "E044";

     classnamecolumn5 = "E045";

     classnamecolumn6 = "E046";

     classnamecolumn7 = "E047";

     classnamecolumn8 = "E048";

     classnamecolumn9 = "E049";

     classnamecolumn10 = "E0410";

    } else {

     classnamecolumn1 = "F041";

     classnamecolumn2 = "F042";

     classnamecolumn3 = "F043";

     classnamecolumn4 = "F044";

     classnamecolumn5 = "F045";

     classnamecolumn6 = "F046";

     classnamecolumn7 = "F047";

     classnamecolumn8 = "F048";

     classnamecolumn9 = "F049";

     classnamecolumn10 = "F0410";

    }



    break;

   case 5:

    classvalue = 5;

    classnamecolumn = "FIFTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A051";

     classnamecolumn2 = "A052";

     classnamecolumn3 = "A053";

     classnamecolumn4 = "A054";

     classnamecolumn5 = "A055";

     classnamecolumn6 = "A056";

     classnamecolumn7 = "A057";

     classnamecolumn8 = "A058";

     classnamecolumn9 = "A059";

     classnamecolumn10 = "A0510";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B051";

     classnamecolumn2 = "B052";

     classnamecolumn3 = "B053";

     classnamecolumn4 = "B054";

     classnamecolumn5 = "B055";

     classnamecolumn6 = "B056";

     classnamecolumn7 = "B057";

     classnamecolumn8 = "B058";

     classnamecolumn9 = "B059";

     classnamecolumn10 = "B0510";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C051";

     classnamecolumn2 = "C052";

     classnamecolumn3 = "C053";

     classnamecolumn4 = "C054";

     classnamecolumn5 = "C055";

     classnamecolumn6 = "C056";

     classnamecolumn7 = "C057";

     classnamecolumn8 = "C058";

     classnamecolumn9 = "C059";

     classnamecolumn10 = "C0510";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D051";

     classnamecolumn2 = "D052";

     classnamecolumn3 = "D053";

     classnamecolumn4 = "D054";

     classnamecolumn5 = "D055";

     classnamecolumn6 = "D056";

     classnamecolumn7 = "D057";

     classnamecolumn8 = "D058";

     classnamecolumn9 = "D059";

     classnamecolumn10 = "D0510";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E051";

     classnamecolumn2 = "E052";

     classnamecolumn3 = "E053";

     classnamecolumn4 = "E054";

     classnamecolumn5 = "E055";

     classnamecolumn6 = "E056";

     classnamecolumn7 = "E057";

     classnamecolumn8 = "E058";

     classnamecolumn9 = "E059";

     classnamecolumn10 = "E0510";

    } else {

     classnamecolumn1 = "F051";

     classnamecolumn2 = "F052";

     classnamecolumn3 = "F053";

     classnamecolumn4 = "F054";

     classnamecolumn5 = "F055";

     classnamecolumn6 = "F056";

     classnamecolumn7 = "F057";

     classnamecolumn8 = "F058";

     classnamecolumn9 = "F059";

     classnamecolumn10 = "F0510";

    }



    break;

   case 6:

    classvalue = 6;

    classnamecolumn = "SIXTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A061";

     classnamecolumn2 = "A062";

     classnamecolumn3 = "A063";

     classnamecolumn4 = "A064";

     classnamecolumn5 = "A065";

     classnamecolumn6 = "A066";

     classnamecolumn7 = "A067";

     classnamecolumn8 = "A068";

     classnamecolumn9 = "A069";

     classnamecolumn10 = "A0610";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B061";

     classnamecolumn2 = "B062";

     classnamecolumn3 = "B063";

     classnamecolumn4 = "B064";

     classnamecolumn5 = "B065";

     classnamecolumn6 = "B066";

     classnamecolumn7 = "B067";

     classnamecolumn8 = "B068";

     classnamecolumn9 = "B069";

     classnamecolumn10 = "B0610";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C061";

     classnamecolumn2 = "C062";

     classnamecolumn3 = "C063";

     classnamecolumn4 = "C064";

     classnamecolumn5 = "C065";

     classnamecolumn6 = "C066";

     classnamecolumn7 = "C067";

     classnamecolumn8 = "C068";

     classnamecolumn9 = "C069";

     classnamecolumn10 = "C0610";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D061";

     classnamecolumn2 = "D062";

     classnamecolumn3 = "D063";

     classnamecolumn4 = "D064";

     classnamecolumn5 = "D065";

     classnamecolumn6 = "D066";

     classnamecolumn7 = "D067";

     classnamecolumn8 = "D068";

     classnamecolumn9 = "D069";

     classnamecolumn10 = "D0610";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E061";

     classnamecolumn2 = "E062";

     classnamecolumn3 = "E063";

     classnamecolumn4 = "E064";

     classnamecolumn5 = "E065";

     classnamecolumn6 = "E066";

     classnamecolumn7 = "E067";

     classnamecolumn8 = "E068";

     classnamecolumn9 = "E069";

     classnamecolumn10 = "E0610";

    } else {

     classnamecolumn1 = "F061";

     classnamecolumn2 = "F062";

     classnamecolumn3 = "F063";

     classnamecolumn4 = "F064";

     classnamecolumn5 = "F065";

     classnamecolumn6 = "F066";

     classnamecolumn7 = "F067";

     classnamecolumn8 = "F068";

     classnamecolumn9 = "F069";

     classnamecolumn10 = "F0610";

    }



    break;

   case 7:

    classvalue = 7;

    classnamecolumn = "SENETH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A071";

     classnamecolumn2 = "A072";

     classnamecolumn3 = "A073";

     classnamecolumn4 = "A074";

     classnamecolumn5 = "A075";

     classnamecolumn6 = "A076";

     classnamecolumn7 = "A077";

     classnamecolumn8 = "A078";

     classnamecolumn9 = "A079";

     classnamecolumn10 = "A0710";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B071";

     classnamecolumn2 = "B072";

     classnamecolumn3 = "B073";

     classnamecolumn4 = "B074";

     classnamecolumn5 = "B075";

     classnamecolumn6 = "B076";

     classnamecolumn7 = "B077";

     classnamecolumn8 = "B078";

     classnamecolumn9 = "B079";

     classnamecolumn10 = "B0710";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C071";

     classnamecolumn2 = "C072";

     classnamecolumn3 = "C073";

     classnamecolumn4 = "C074";

     classnamecolumn5 = "C075";

     classnamecolumn6 = "C076";

     classnamecolumn7 = "C077";

     classnamecolumn8 = "C078";

     classnamecolumn9 = "C079";

     classnamecolumn10 = "C0710";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D071";

     classnamecolumn2 = "D072";

     classnamecolumn3 = "D073";

     classnamecolumn4 = "D074";

     classnamecolumn5 = "D075";

     classnamecolumn6 = "D076";

     classnamecolumn7 = "D077";

     classnamecolumn8 = "D078";

     classnamecolumn9 = "D079";

     classnamecolumn10 = "D0710";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E071";

     classnamecolumn2 = "E072";

     classnamecolumn3 = "E073";

     classnamecolumn4 = "E074";

     classnamecolumn5 = "E075";

     classnamecolumn6 = "E076";

     classnamecolumn7 = "E077";

     classnamecolumn8 = "E078";

     classnamecolumn9 = "E079";

     classnamecolumn10 = "E0710";

    } else {

     classnamecolumn1 = "F071";

     classnamecolumn2 = "F072";

     classnamecolumn3 = "F073";

     classnamecolumn4 = "F074";

     classnamecolumn5 = "F075";

     classnamecolumn6 = "F076";

     classnamecolumn7 = "F077";

     classnamecolumn8 = "F078";

     classnamecolumn9 = "F079";

     classnamecolumn10 = "F0710";

    }



    break;

   case 8:

    classvalue = 8;

    classnamecolumn = "EIGHT";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A081";

     classnamecolumn2 = "A082";

     classnamecolumn3 = "A083";

     classnamecolumn4 = "A084";

     classnamecolumn5 = "A085";

     classnamecolumn6 = "A086";

     classnamecolumn7 = "A087";

     classnamecolumn8 = "A088";

     classnamecolumn9 = "A089";

     classnamecolumn10 = "A0810";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B081";

     classnamecolumn2 = "B082";

     classnamecolumn3 = "B083";

     classnamecolumn4 = "B084";

     classnamecolumn5 = "B085";

     classnamecolumn6 = "B086";

     classnamecolumn7 = "B087";

     classnamecolumn8 = "B088";

     classnamecolumn9 = "B089";

     classnamecolumn10 = "B0810";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C081";

     classnamecolumn2 = "C082";

     classnamecolumn3 = "C083";

     classnamecolumn4 = "C084";

     classnamecolumn5 = "C085";

     classnamecolumn6 = "C086";

     classnamecolumn7 = "C087";

     classnamecolumn8 = "C088";

     classnamecolumn9 = "C089";

     classnamecolumn10 = "C0810";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D081";

     classnamecolumn2 = "D082";

     classnamecolumn3 = "D083";

     classnamecolumn4 = "D084";

     classnamecolumn5 = "D085";

     classnamecolumn6 = "D086";

     classnamecolumn7 = "D087";

     classnamecolumn8 = "D088";

     classnamecolumn9 = "D089";

     classnamecolumn10 = "D0810";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E081";

     classnamecolumn2 = "E082";

     classnamecolumn3 = "E083";

     classnamecolumn4 = "E084";

     classnamecolumn5 = "E085";

     classnamecolumn6 = "E086";

     classnamecolumn7 = "E087";

     classnamecolumn8 = "E088";

     classnamecolumn9 = "E089";

     classnamecolumn10 = "E0810";

    } else {

     classnamecolumn1 = "F081";

     classnamecolumn2 = "F082";

     classnamecolumn3 = "F083";

     classnamecolumn4 = "F084";

     classnamecolumn5 = "F085";

     classnamecolumn6 = "F086";

     classnamecolumn7 = "F087";

     classnamecolumn8 = "F088";

     classnamecolumn9 = "F089";

     classnamecolumn10 = "F0810";

    }



    break;

   case 9:

    classvalue = 9;

    classnamecolumn = "NINGTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A091";

     classnamecolumn2 = "A092";

     classnamecolumn3 = "A093";

     classnamecolumn4 = "A094";

     classnamecolumn5 = "A095";

     classnamecolumn6 = "A096";

     classnamecolumn7 = "A097";

     classnamecolumn8 = "A098";

     classnamecolumn9 = "A099";

     classnamecolumn10 = "A0910";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B091";

     classnamecolumn2 = "B092";

     classnamecolumn3 = "B093";

     classnamecolumn4 = "B094";

     classnamecolumn5 = "B095";

     classnamecolumn6 = "B096";

     classnamecolumn7 = "B097";

     classnamecolumn8 = "B098";

     classnamecolumn9 = "B099";

     classnamecolumn10 = "B0910";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C091";

     classnamecolumn2 = "C092";

     classnamecolumn3 = "C093";

     classnamecolumn4 = "C094";

     classnamecolumn5 = "C095";

     classnamecolumn6 = "C096";

     classnamecolumn7 = "C097";

     classnamecolumn8 = "C098";

     classnamecolumn9 = "C099";

     classnamecolumn10 = "C0910";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D091";

     classnamecolumn2 = "D092";

     classnamecolumn3 = "D093";

     classnamecolumn4 = "D094";

     classnamecolumn5 = "D095";

     classnamecolumn6 = "D096";

     classnamecolumn7 = "D097";

     classnamecolumn8 = "D098";

     classnamecolumn9 = "D099";

     classnamecolumn10 = "D0910";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E091";

     classnamecolumn2 = "E092";

     classnamecolumn3 = "E093";

     classnamecolumn4 = "E094";

     classnamecolumn5 = "E095";

     classnamecolumn6 = "E096";

     classnamecolumn7 = "E097";

     classnamecolumn8 = "E098";

     classnamecolumn9 = "E099";

     classnamecolumn10 = "E0910";

    } else {

     classnamecolumn1 = "F091";

     classnamecolumn2 = "F092";

     classnamecolumn3 = "F093";

     classnamecolumn4 = "F094";

     classnamecolumn5 = "F095";

     classnamecolumn6 = "F096";

     classnamecolumn7 = "F097";

     classnamecolumn8 = "F098";

     classnamecolumn9 = "F099";

     classnamecolumn10 = "F0910";

    }



    break;

   case 10:

    classvalue = 10;

    classnamecolumn = "TENGTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A101";

     classnamecolumn2 = "A102";

     classnamecolumn3 = "A103";

     classnamecolumn4 = "A104";

     classnamecolumn5 = "A105";

     classnamecolumn6 = "A106";

     classnamecolumn7 = "A107";

     classnamecolumn8 = "A108";

     classnamecolumn9 = "A109";

     classnamecolumn10 = "A1010";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B101";

     classnamecolumn2 = "B102";

     classnamecolumn3 = "B103";

     classnamecolumn4 = "B104";

     classnamecolumn5 = "B105";

     classnamecolumn6 = "B106";

     classnamecolumn7 = "B107";

     classnamecolumn8 = "B108";

     classnamecolumn9 = "B109";

     classnamecolumn10 = "B1010";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C101";

     classnamecolumn2 = "C102";

     classnamecolumn3 = "C103";

     classnamecolumn4 = "C104";

     classnamecolumn5 = "C105";

     classnamecolumn6 = "C106";

     classnamecolumn7 = "C107";

     classnamecolumn8 = "C108";

     classnamecolumn9 = "C109";

     classnamecolumn10 = "C1010";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D101";

     classnamecolumn2 = "D102";

     classnamecolumn3 = "D103";

     classnamecolumn4 = "D104";

     classnamecolumn5 = "D105";

     classnamecolumn6 = "D106";

     classnamecolumn7 = "D107";

     classnamecolumn8 = "D108";

     classnamecolumn9 = "D109";

     classnamecolumn10 = "D1010";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E101";

     classnamecolumn2 = "E102";

     classnamecolumn3 = "E103";

     classnamecolumn4 = "E104";

     classnamecolumn5 = "E105";

     classnamecolumn6 = "E106";

     classnamecolumn7 = "E107";

     classnamecolumn8 = "E108";

     classnamecolumn9 = "E109";

     classnamecolumn10 = "E1010";

    } else {

     classnamecolumn1 = "F101";

     classnamecolumn2 = "F102";

     classnamecolumn3 = "F103";

     classnamecolumn4 = "F104";

     classnamecolumn5 = "F105";

     classnamecolumn6 = "F106";

     classnamecolumn7 = "F107";

     classnamecolumn8 = "F108";

     classnamecolumn9 = "F109";

     classnamecolumn10 = "F1010";

    }



    break;

   case 11:

    classvalue = 11;

    classnamecolumn = "ELEVENTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A111";

     classnamecolumn2 = "A112";

     classnamecolumn3 = "A113";

     classnamecolumn4 = "A114";

     classnamecolumn5 = "A115";

     classnamecolumn6 = "A116";

     classnamecolumn7 = "A117";

     classnamecolumn8 = "A118";

     classnamecolumn9 = "A119";

     classnamecolumn10 = "A1110";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B111";

     classnamecolumn2 = "B112";

     classnamecolumn3 = "B113";

     classnamecolumn4 = "B114";

     classnamecolumn5 = "B115";

     classnamecolumn6 = "B116";

     classnamecolumn7 = "B117";

     classnamecolumn8 = "B118";

     classnamecolumn9 = "B119";

     classnamecolumn10 = "B1110";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C111";

     classnamecolumn2 = "C112";

     classnamecolumn3 = "C113";

     classnamecolumn4 = "C114";

     classnamecolumn5 = "C115";

     classnamecolumn6 = "C116";

     classnamecolumn7 = "C117";

     classnamecolumn8 = "C118";

     classnamecolumn9 = "C119";

     classnamecolumn10 = "C1110";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D111";

     classnamecolumn2 = "D112";

     classnamecolumn3 = "D113";

     classnamecolumn4 = "D114";

     classnamecolumn5 = "D115";

     classnamecolumn6 = "D116";

     classnamecolumn7 = "D117";

     classnamecolumn8 = "D118";

     classnamecolumn9 = "D119";

     classnamecolumn10 = "D1110";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E111";

     classnamecolumn2 = "E112";

     classnamecolumn3 = "E113";

     classnamecolumn4 = "E114";

     classnamecolumn5 = "E115";

     classnamecolumn6 = "E116";

     classnamecolumn7 = "E117";

     classnamecolumn8 = "E118";

     classnamecolumn9 = "E119";

     classnamecolumn10 = "E1110";

    } else {

     classnamecolumn1 = "F111";

     classnamecolumn2 = "F112";

     classnamecolumn3 = "F113";

     classnamecolumn4 = "F114";

     classnamecolumn5 = "F115";

     classnamecolumn6 = "F116";

     classnamecolumn7 = "F117";

     classnamecolumn8 = "F118";

     classnamecolumn9 = "F119";

     classnamecolumn10 = "F1110";

    }



    break;

   case 12:

    classvalue = 12;

    classnamecolumn = "TWELTH";

    if (params[2].equals("A")) {

     classnamecolumn1 = "A121";

     classnamecolumn2 = "A122";

     classnamecolumn3 = "A123";

     classnamecolumn4 = "A124";

     classnamecolumn5 = "A125";

     classnamecolumn6 = "A126";

     classnamecolumn7 = "A127";

     classnamecolumn8 = "A128";

     classnamecolumn9 = "A129";

     classnamecolumn10 = "A1210";

    } else if (params[2].equals("B")) {

     classnamecolumn1 = "B121";

     classnamecolumn2 = "B122";

     classnamecolumn3 = "B123";

     classnamecolumn4 = "B124";

     classnamecolumn5 = "B125";

     classnamecolumn6 = "B126";

     classnamecolumn7 = "B127";

     classnamecolumn8 = "B128";

     classnamecolumn9 = "B129";

     classnamecolumn10 = "B1210";

    } else if (params[2].equals("C")) {

     classnamecolumn1 = "C121";

     classnamecolumn2 = "C122";

     classnamecolumn3 = "C123";

     classnamecolumn4 = "C124";

     classnamecolumn5 = "C125";

     classnamecolumn6 = "C126";

     classnamecolumn7 = "C127";

     classnamecolumn8 = "C128";

     classnamecolumn9 = "C129";

     classnamecolumn10 = "C1210";

    } else if (params[2].equals("D")) {

     classnamecolumn1 = "D121";

     classnamecolumn2 = "D122";

     classnamecolumn3 = "D123";

     classnamecolumn4 = "D124";

     classnamecolumn5 = "D125";

     classnamecolumn6 = "D126";

     classnamecolumn7 = "D127";

     classnamecolumn8 = "D128";

     classnamecolumn9 = "D129";

     classnamecolumn10 = "D1210";

    } else if (params[2].equals("E")) {

     classnamecolumn1 = "E121";

     classnamecolumn2 = "E122";

     classnamecolumn3 = "E123";

     classnamecolumn4 = "E124";

     classnamecolumn5 = "E125";

     classnamecolumn6 = "E126";

     classnamecolumn7 = "E127";

     classnamecolumn8 = "E128";

     classnamecolumn9 = "E129";

     classnamecolumn10 = "E1210";

    } else {

     classnamecolumn1 = "F121";

     classnamecolumn2 = "F122";

     classnamecolumn3 = "F123";

     classnamecolumn4 = "F124";

     classnamecolumn5 = "F125";

     classnamecolumn6 = "F126";

     classnamecolumn7 = "F127";

     classnamecolumn8 = "F128";

     classnamecolumn9 = "F129";

     classnamecolumn10 = "F1210";

    }

    break;

    default:

    classvalue = 50;

    classnamecolumn = "Nur";

    break;

   }

  String table=params[0];

  int u=0;

 table=table.substring(0,11);

  DataBase  db=new DataBase();

  Connection con=db.getConnection();

  int classname=Integer.parseInt(params[1]);

  try {

   st = con.createStatement();

    

          String sql = "UPDATE attendance"

    + "."+table+ "  SET  SUBJECT1='"+params[3]+"',"

    + "SUBJECT2='"+params[4]+"',"

    + "SUBJECT3='"+params[5]+"',"

    + "SUBJECT4='"+params[6]+"',"

    + "SUBJECT5='"+params[7]+"',"

    + "SUBJECT6='"+params[8]+"',"

    + "SUBJECT7='"+params[9]+"',"

    + "SUBJECT8='"+params[10]+"',"

    + "SUBJECT9='"+params[11]+"',"

    + "SUBJECT10='"+params[12]+"'"

    +" where STUDENTBRANCH="+classname+" AND STUDENTSECTION='"+params[2]+"'";



  u = st.executeUpdate(sql);

   String sql2 = "Update Attendance." + params[0] + "data SET "+classnamecolumn1+"='" +params[3]  + "', "+classnamecolumn2+"='" + params[4]

     + "',"+classnamecolumn3+"='" + params[5] + "',"+classnamecolumn4+"='" + params[6] + "',"+classnamecolumn5+"='" + params[7] + "',"+classnamecolumn6+"='" + params[8]

     + "',"+classnamecolumn7+"='" + params[9] + "',"+classnamecolumn8+"='" + params[10] + "',"+classnamecolumn9+"='" + params[11] + "',"+classnamecolumn10+"='" + params[12]

     + "' WHERE dated=" + dayss + " AND  monthd="+monss+" AND yeard="+yearss+"";

   u = st.executeUpdate(sql2);

  }catch (SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

  }

  if

  (u!=0)

  {



   try {

    json.put("info", "success");

   } catch (JSONException e) {



    e.printStackTrace();

   }

  }

  else

  {

   try {

    json.put("info", "failure");

   } catch (JSONException e) {



    e.printStackTrace();

   }

  }



  response.setContentType("application/json");

  response.setCharacterEncoding("UTF-8");

  response.getWriter().write(json.toString());



 }



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



  doGet(request, response);

 }



}






JAVA Code for Update of details With SQL CODE AND Responce
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Enumeration;



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 org.json.JSONException;

import org.json.JSONObject;



@WebServlet("/Admindetailupdate")

public class Admindetailupdate extends HttpServlet {

 private static final long serialVersionUID = 1L;

 Statement st;



 public Admindetailupdate() {

  super();

  // TODO Auto-generated constructor stub

 }



 protected void doGet(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {



  JSONObject json = new JSONObject();

  Enumeration paramNames = request.getParameterNames();

  String params[] = new String[11];

  int i = 0;

  while (paramNames.hasMoreElements()) {

   String paramName = (String) paramNames.nextElement();

   String[] paramValues = request.getParameterValues(paramName);

   params[i] = paramValues[0];



   i++;

  }

  String table = params[0];

  table = table.substring(0, 11);

  DataBase db = new DataBase();

  Connection con = db.getConnection();

  try {

   st = con.createStatement();

  } catch (SQLException e) {

   // TODO Auto-generated catch block

   e.printStackTrace();

  }

  if (true) {



   String sql = "UPDATE attendance" + "." + table + "  SET  STUDENTFATHER='" + params[2] + "',"

     + "MotherName='" + params[3] + "',"



     + "DOB='" + params[4] + "'," + "GENDER='" + params[5] + "'," + "STUDENTEMAIL='" + params[6] + "',"

     + "STUDENTFATHERMOB='" + params[7] + "'," + "STUDENTMOB='" + params[8] + "'," + "ADARCARD='"

     + params[9] + "'," + "ADDRESS='" + params[10] + "'"



     + " where STUDENTROLL='" + params[1] + "'";

   int u = 0;

   try {

    u = st.executeUpdate(sql);

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }



   if (u != 0) {



    try {

     json.put("info", "success");

    } catch (JSONException e) {



     e.printStackTrace();

    }

   } else {

    try {

     json.put("info", "failure");

    } catch (JSONException e) {



     e.printStackTrace();

    }

   }



   response.setContentType("application/json");

   response.setCharacterEncoding("UTF-8");

   response.getWriter().write(json.toString());

  } else if (params[16].equals("Student")) {

   String sql = "UPDATE attendance" + "." + table + "  SET  STUDENTBRANCH=" + params[3] + ","

     + "STUDENTSECTION='" + params[4] + "'" +

     " where STUDENTROLL='" + params[2] + "'";

   System.out.println("sql query is : " + sql);

   int u = 0;

   try {

    u = st.executeUpdate(sql);

   } catch (SQLException e) {

    // TODO Auto-generated catch block

    e.printStackTrace();

   }



   if (u != 0) {



    try {

     json.put("info", "success");

    } catch (JSONException e) {



     e.printStackTrace();

    }

   } else {

    try {

     json.put("info", "failure");

    } catch (JSONException e) {



     e.printStackTrace();

    }

   }



  

   response.setContentType("application/json");

   response.setCharacterEncoding("UTF-8");

   response.getWriter().write(json.toString());

  }

 }



 protected void doPost(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {



  doGet(request, response);

 }



}




JAVA Code Direct Attendance update with Server Response and SQL Update
package com.sawan;

import java.io.IOException;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Enumeration;

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 org.json.JSONObject;





@WebServlet("/AdminAttendanceStudentList")

public class AdminAttendanceStudentList extends HttpServlet {

 private static final long serialVersionUID = 1L;

  Statement stmt = null;

    public AdminAttendanceStudentList() {

        super();

    }





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

  // TODO Auto-generated method stub

    JSONObject json = new JSONObject();

 

   Enumeration paramNames = request.getParameterNames();

      String params[] = new String[3];

      int i = 0;

      while (paramNames.hasMoreElements())

      {

          String paramName = (String) paramNames.nextElement();

          String[] paramValues = request.getParameterValues(paramName);

          params[i] = paramValues[0];

          i++;

      }

      ResultSet rs=null;

      String table=params[1];

      String cutoff=params[0];

      DataBase  db=new DataBase();

      Connection con=db.getConnection();

      table=table.substring(0, 11);

      String Roll=params[0];

      int code=Integer.parseInt(params[0]);

      String sql="SELECT * FROM attendance."+table+"  WHERE STUDENTBRANCH ="+code+" AND STUDENTSECTION='"+params[2]+"'";

      try {

       stmt=con.createStatement();

       rs = stmt.executeQuery(sql);

 int u=0;

       int s=0;

     while (rs.next()) {

                 json.put("home"+s,rs.getString("STUDENTNAME"));

               json.put("homec"+s,rs.getInt("STUDENTBRANCH"));

               json.put("homes"+s,rs.getString("STUDENTSECTION"));

               json.put("no",s);

              u=1;

              s++;

           }

           if(u==0)

           {

              json.put("info", "fail");

           }

           else

           {

              json.put("info","success");

           }

      } catch (Exception e) {

          e.printStackTrace();

      }

      response.setContentType("application/json");

      response.setCharacterEncoding("UTF-8");

      response.getWriter().write(json.toString());

}

}








JAVA Code Attendance with Server Response and SQL Update
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Calendar;

import java.util.Enumeration;

import java.util.Iterator;



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 org.json.JSONException;

import org.json.JSONObject;





@WebServlet("/AdminappAttendanceUpdate")

public class AdminappAttendanceUpdate extends HttpServlet {

 private static final long serialVersionUID = 1L;

 Statement st = null;

 ResultSet rs;

 JSONObject json = new JSONObject();



 public AdminappAttendanceUpdate() {

  super();

  // TODO Auto-generated constructor stub

 }



 protected void doGet(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {

  Enumeration paramNames = request.getParameterNames();

  ArrayList<String> params = new ArrayList<String>();

  int i = 0;

  while (paramNames.hasMoreElements()) {

   String paramName = (String) paramNames.nextElement();

   String[] paramValues = request.getParameterValues(paramName);

   params.add(paramValues[0]);



   i++;

  }



  int ror = 0;

  int length = 0;

  Iterator itr = params.iterator();

  Iterator itr2 = params.iterator();

  while (itr.hasNext()) {

   length++;

   itr.next();

  }

  int m = 0;

  String arr[] = new String[length];

  while (itr2.hasNext()) {

   arr[m] = (String) itr2.next();

   m++;

  }

  String facultyCode = arr[length - 1];

  String table = arr[length - 2];

  int row = Integer.parseInt(arr[length - 3]);

  table = table.substring(0, 11);

  DataBase db = new DataBase();

  Connection con = db.getConnection();

  int u = 0;

  try {

   st = con.createStatement();

   int t = 0;



   for (int j = 0; j < row; j++) {

    int att = Integer.parseInt(arr[t + 4]);

    String sql2 = "select * from attendance." + table + " where STUDENTROLL='" + arr[t + 1] + "'";

    PreparedStatement stmt = con.prepareStatement(sql2);

    rs = stmt.executeQuery();



    rs.next();

    int valueattt = 0;

    int atte = rs.getInt("STUDENTHIGH");

    int atte2 = rs.getInt("STUDENTSEMESTER");



    if (Integer.parseInt(arr[t + 4]) == 0) {

     atte = atte;

     atte2 = atte2 + 1;



    } else {

     valueattt = 1;

     atte = atte + 1;

     atte2 = atte2 + 1;



    }

    String sql = "UPDATE attendance" + "." + table + "  SET STUDENTHIGH=" + atte + " ,STUDENTSEMESTER="

      + atte2 + " WHERE  STUDENTROLL='" + arr[t + 1] + "'";

    st.executeUpdate(sql);

    String date = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());

    String redate2[] = date.split("_");



    char[] ch = redate2[0].toCharArray();

    String date3 = ch.toString();

    String year = redate2[0].substring(0, 4);

    String month = redate2[0].substring(4, 6);

    String day = redate2[0].substring(6);



    String redate = day + "/" + month + "/" + year;



    String sql3 = "INSERT INTO attendance" + "." + table + "record (STUDENTROLL,STUDENTNAME,"

      + "SUBJECTCODE,FACULTYCODE,LACTUREDAY,LACTUREMONTH,LACTUREYEAR,LACTURETIME,LACTUREVARIFICATION) VALUES(?,?,?,?,?,?,?,?,?)";



    PreparedStatement pst = con.prepareStatement(sql3);

    pst.setString(1, arr[t + 1]);

    pst.setString(2, "");

    pst.setInt(3, 1);

    pst.setInt(4, 1);

    pst.setString(5, day);

    pst.setString(6, month);

    pst.setString(7, year);

    pst.setString(8, redate2[1]);



    if (valueattt == 0) {

     pst.setInt(9, 0);

    } else {

     pst.setInt(9, 1);

    }

    pst.execute();

    pst.close();



    u = 1;

    t = t + 5;

   }

  } catch (SQLException e) {

   u = 0;



   e.printStackTrace();

  }



  if (u != 0) {



   try {

    json.put("info", "success");

   } catch (JSONException e) {



    e.printStackTrace();

   }

  } else {

   try {



    json.put("info", "failure");

   } catch (JSONException e) {



    e.printStackTrace();

   }

  }

  response.setContentType("application/json");

  response.setCharacterEncoding("UTF-8");

  response.getWriter().write(json.toString());

 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {



  doGet(request, response);

 }



}








JAVA Code Academic Calendar with Server Response and SQL Update with admin delete authority 
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Enumeration;



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 org.json.JSONException;

import org.json.JSONObject;



/**

 * Servlet implementation class AdminAccountDelete

 */

@WebServlet("/AdminAccountDelete")

public class AdminAccountDelete extends HttpServlet {

 private static final long serialVersionUID = 1L;

 PreparedStatement st = null;



 public AdminAccountDelete() {

  super();

  // TODO Auto-generated constructor stub

 }



 protected void doGet(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {

  JSONObject json = new JSONObject();

  Enumeration paramNames = request.getParameterNames();

  String params[] = new String[17];

  int i = 0;

  while (paramNames.hasMoreElements()) {

   String paramName = (String) paramNames.nextElement();

   String[] paramValues = request.getParameterValues(paramName);

   params[i] = paramValues[0];

   i++;

  }

  if (params[2].equals("sawan1")) {

   String table = params[0];

   table = table.substring(0, 11);

   table = table + "DI";

   DataBase db = new DataBase();

   int u = 0;

   Connection con = db.getConnection();

   try {



    String sql = "DELETE FROM attendance" + "." + table + "  WHere  STUDENTFNAME=?";

    PreparedStatement preparedStmt = con.prepareStatement(sql);

    preparedStmt.setString(1, params[1]);

    preparedStmt.execute();

    u = 1;

   } catch (SQLException e) {

    u = 0;

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

   try {

    if (u == 0) {

     json.put("info", "failure");



    } else {

     json.put("info", "success");

    }

   } catch (Exception e) {

    e.printStackTrace();

   }



   response.setContentType("application/json");

   response.setCharacterEncoding("UTF-8");

   response.getWriter().write(json.toString());



  }

  if (params[2].equals("sawan2")) {

   String table = params[0];

   table = table.substring(0, 11);

   table = table + "HO";

   DataBase db = new DataBase();

   int u = 0;

   Connection con = db.getConnection();

   try {



    String sql = "DELETE FROM attendance" + "." + table + "  WHere  STUDENTFNAME=?";

    PreparedStatement preparedStmt = con.prepareStatement(sql);

    preparedStmt.setString(1, params[1]);

    preparedStmt.execute();

    u = 1;

   } catch (SQLException e) {

    u = 0;

    e.printStackTrace();

   }

   try {

    if (u == 0) {

     json.put("info", "failure");

    } else {

     json.put("info", "success");

    }

   } catch (Exception e) {

    e.printStackTrace();

   }



   response.setContentType("application/json");

   response.setCharacterEncoding("UTF-8");

   response.getWriter().write(json.toString());

  }

  if (params[2].equals("sawan3")) {

   String table = params[0];

   table = table.substring(0, 11);

   table = table + "FA";

   DataBase db = new DataBase();

   int u = 0;

   Connection con = db.getConnection();

   try {



    String sql = "DELETE FROM attendance" + "." + table + "  WHere  STUDENTFNAME=?";

    PreparedStatement preparedStmt = con.prepareStatement(sql);

    preparedStmt.setString(1, params[1]);

    preparedStmt.execute();

    u = 1;

   } catch (SQLException e) {

    u = 0;

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

   try {

    if (u == 0) {

     json.put("info", "failure");



    } else {

     json.put("info", "success");

    }

   } catch (Exception e) {

    e.printStackTrace();

   }



   response.setContentType("application/json");

   response.setCharacterEncoding("UTF-8");

   response.getWriter().write(json.toString());



  }

  if (params[2].equals("sawan4")) {

   String table = params[0];

   table = table.substring(0, 11);



   DataBase db = new DataBase();

   int u = 0;

   Connection con = db.getConnection();

   try {



    String sql = "DELETE FROM attendance" + "." + table + "  WHERE  STUDENTROLL=?";

    PreparedStatement preparedStmt = con.prepareStatement(sql);

    preparedStmt.setString(1, params[1]);

    preparedStmt.execute();

    u = 1;

   } catch (SQLException e) {

    u = 0;

    // TODO Auto-generated catch block

    e.printStackTrace();

   }

   try {

    if (u == 0) {

     json.put("info", "failure");



    } else {

     json.put("info", "success");

    }

   } catch (Exception e) {

    e.printStackTrace();

   }



   response.setContentType("application/json");

   response.setCharacterEncoding("UTF-8");

   response.getWriter().write(json.toString());



  }

 }



 protected void doPost(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {



  doGet(request, response);

 }



}






JAVA Code Academic Calendar with Server Response and SQL Update
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.SimpleDateFormat;

import java.util.Calendar;



import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



/**

 * Servlet implementation class AcademicCalendar

 */

@WebServlet("/AcademicCalendar")

public class AcademicCalendar extends HttpServlet {

 private static final long serialVersionUID = 1L;

 String dayss, monss, yearss;

 ResultSet rs = null;

 Connection con = null;

 PreparedStatement stmt = null;

 Statement st = null;

 int sawan = 0;



 public AcademicCalendar() {

  super();

  // TODO Auto-generated constructor stub

 }



 /**

  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse

  *      response)

  */

 protected void doGet(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {

  DataBase db = new DataBase();

  con = db.getConnection();

  String datesawan = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());

  String redate2[] = datesawan.split("_");

  char[] chsawan = redate2[0].toCharArray();

  String date3sawan = chsawan.toString();

  yearss = redate2[0].substring(0, 4);

  monss = redate2[0].substring(4, 6);

  dayss = redate2[0].substring(6);

  ReadData rd = new ReadData();

  if (request.getParameter("requestcode").equals("insertClassData")) {

   try {

    String sql2 = "insert into attendance.mpss" + request.getParameter("photo")

      + "cal (content,datee,monthh,yearr,accss) values (?,?,?,?,?)";

    PreparedStatement pst = con.prepareStatement(sql2);



    for (int j = 1; j <= 30; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 4 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 5 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 30; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 6 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 7 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 8 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 30; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 9 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 10 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 30; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 11 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 12 + "");

     pst.setString(4, yearss);

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 1 + "");

     pst.setString(4, (Integer.parseInt(yearss) + 1) + "");

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 29; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 2 + "");

     pst.setString(4, (Integer.parseInt(yearss) + 1) + "");

     pst.setInt(5, 0);

     pst.execute();

    }

    for (int j = 1; j <= 31; j++) {

     pst.setString(1, "");

     pst.setString(2, j + "");

     pst.setString(3, 3 + "");

     pst.setString(4, (Integer.parseInt(yearss) + 1) + "");

     pst.setInt(5, 0);

     pst.execute();

    }

    pst.close();



    request.setAttribute("roll", request.getParameter("WebStudentDetailForfeeSubmition"));

   } catch (SQLException e) {

    e.printStackTrace();

   }



   getServletContext().getRequestDispatcher("/Adminstrative.jsp").forward(request, response);

   return;

  } else if (request.getParameter("requestcode").equals("studentsubject")) {



   String sql1 = "select * from Attendance.mpss" + request.getParameter("cid") + "cal";

   try {

    stmt = con.prepareStatement(sql1);

    rs = stmt.executeQuery();

    int calcultor = 0;

    while (rs.next()) {

     {

      request.setAttribute("tc1" + calcultor, rs.getString("content"));

      request.setAttribute("tc2" + calcultor, rs.getString("datee"));

      request.setAttribute("tc3" + calcultor, rs.getString("monthh"));

      request.setAttribute("tc4" + calcultor, rs.getString("yearr"));

      request.setAttribute("tc5" + calcultor, rs.getString("noo"));

      request.setAttribute("tc6" + calcultor, rs.getString("accss"));

      calcultor++;

      sawan++;

     }

    }

    request.setAttribute("total", calcultor + "");

    request.setAttribute("cid", request.getParameter("cid"));

   } catch (SQLException e) {

    e.printStackTrace();

   }

   getServletContext().getRequestDispatcher("/AcademicCalendarDataFilling.jsp").forward(request, response);

   return;

  } else if (request.getParameter("requestcode").equals("sawancha")) {

   String sql1 = "select * from Attendance.mpss" + request.getParameter("cid") + "cal where noo="

     + Integer.parseInt(request.getParameter("seq")) + "";

   try {

    stmt = con.prepareStatement(sql1);

    rs = stmt.executeQuery();

    rs.next();

    request.setAttribute("tc1", rs.getString("content"));

    request.setAttribute("tc2", request.getParameter("seq"));

    request.setAttribute("tc3", rs.getInt("accss"));

    request.setAttribute("cid", request.getParameter("cid"));

   } catch (SQLException e) {

    e.printStackTrace();

   }

   getServletContext().getRequestDispatcher("/AcademicDataUpdation.jsp").forward(request, response);

   return;

  } else if (request.getParameter("requestcode").equals("schoolnoticeupdate")) {

   String sql1 = "update  Attendance.mpss" + request.getParameter("cid") + "cal set content='"

     + request.getParameter("PreviousMessegePaarameter") + "',accss=1 where noo="

     + Integer.parseInt(request.getParameter("seq")) + "";

   try {

    st = con.createStatement();

    st.executeUpdate(sql1);



    request.setAttribute("cid", request.getParameter("cid"));

   } catch (SQLException e) {

    e.printStackTrace();

   }

   getServletContext().getRequestDispatcher("/Adminstrative.jsp").forward(request, response);

   return;

  }

 }

}






Code for Server  Response with SQL Update  Programming Logic and Code with Syntax 
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Enumeration;



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 org.json.JSONException;

import org.json.JSONObject;



/**

 * Servlet implementation class Academic

 */

@WebServlet("/Academic")

public class Academic extends HttpServlet {

 private static final long serialVersionUID = 1L;

    

 String dayss, monss, yearss;

 PreparedStatement stmt = null;

 ResultSet rs;

 JSONObject json = new JSONObject();

    public Academic() {

        super();

        // TODO Auto-generated constructor stub

    }



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

  JSONObject json = new JSONObject();

  Enumeration paramNames = request.getParameterNames();

  String params[] = new String[1];

  int i = 0;

  while (paramNames.hasMoreElements()) {

   String paramName = (String) paramNames.nextElement();

   String[] paramValues = request.getParameterValues(paramName);

   params[i] = paramValues[0];

   i++;

  }

 

   String table = params[0];

   table = table.substring(0, 11);

   DataBase db = new DataBase();

   int clsstrength = 0;

   Connection con = db.getConnection();

   String date = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());

   String redate2[] = date.split("_");

   char[] ch = redate2[0].toCharArray();

   String date3 = ch.toString();

   yearss = redate2[0].substring(0, 4);

   monss = redate2[0].substring(4, 6);

   dayss = redate2[0].substring(6);

   String redate = dayss + "/" + dayss + "/" + dayss;

   int monthsss=Integer.parseInt(monss);

   int daysss=Integer.parseInt(dayss);

   monss=monthsss+"";

   dayss=daysss+"";

   String sql = "SELECT * FROM attendance." + table + "cal  WHERE datee='" + dayss

     + "' AND monthh='" + monss + "' AND yearr='" + yearss + "'";

   try {

    stmt = con.prepareStatement(sql);

    rs = stmt.executeQuery();

    int totalattendance = 1;

    rs.next();

    int noo1=rs.getInt("noo");

    String sql2 = "SELECT * FROM attendance." + table + "cal  WHERE datee='30' AND monthh='03' AND yearr='" + (Integer.parseInt(yearss)+1)+"" + "'";

    stmt = con.prepareStatement(sql2);

    rs = stmt.executeQuery();

    rs.next();

    int j = 0;

    String sql3 = "SELECT * FROM attendance." + table + "cal  WHERE noo >= "+noo1+" and accss=1 ";

    stmt = con.prepareStatement(sql3);

    rs = stmt.executeQuery();

    while (rs.next()) {

     String datee=rs.getString("datee");

     String monthh=rs.getString("monthh");

     String yearrr=rs.getString("yearr");

     json.put("name" + j, datee+"-"+monthh+"-"+yearrr);

     json.put("branch" + j, rs.getString("content"));

     j++;

    }

    json.put("absent", j + "");

    json.put("info", "success");

   } catch (JSONException e1) {

    try {

     json.put("info", "failure");

    } catch (JSONException e) {

     e.printStackTrace();

    }

    e1.printStackTrace();

   } catch (Exception e) {

    e.printStackTrace();

   }

   try {

    response.setContentType("application/json");

    response.setCharacterEncoding("UTF-8");

    response.getWriter().write(json.toString());

   } catch (Exception e) {

    System.out.println(e);

   }

  

  }



 }










Java Code for Request and Response for android application from MYSQL Database  Programming Logic and Code with Syntax 
package com.sawan;



import java.io.IOException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Enumeration;



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 org.json.JSONException;

import org.json.JSONObject;



/**

 * Servlet implementation class AbesentData

 */

@WebServlet("/AbesentData")

public class AbesentData extends HttpServlet {

 private static final long serialVersionUID = 1L;

 String dayss, monss, yearss;

 PreparedStatement stmt = null;

 ResultSet rs;

 JSONObject json = new JSONObject();



 public AbesentData() {

  super();

 }



 protected void doGet(HttpServletRequest request, HttpServletResponse response)

   throws ServletException, IOException {

  JSONObject json = new JSONObject();

  Enumeration paramNames = request.getParameterNames();

  String params[] = new String[3];

  int i = 0;

  while (paramNames.hasMoreElements()) {

   String paramName = (String) paramNames.nextElement();

   String[] paramValues = request.getParameterValues(paramName);

   params[i] = paramValues[0];

   i++;

  }

  if (params[1].equals("AbsentStudent")) {

   String table = params[0];

   table = table.substring(0, 11);

   DataBase db = new DataBase();

   int clsstrength = 0;

   Connection con = db.getConnection();

   String date = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());

   String redate2[] = date.split("_");

   char[] ch = redate2[0].toCharArray();

   String date3 = ch.toString();

   yearss = redate2[0].substring(0, 4);

   monss = redate2[0].substring(4, 6);

   dayss = redate2[0].substring(6);

   String redate = dayss + "/" + dayss + "/" + dayss;

   String sql = "SELECT STUDENTNAME FROM attendance." + table + "record  WHERE LACTUREDAY='" + dayss

     + "' AND LACTUREMonth='" + monss + "' AND LACTUREyear='" + yearss + "'";

   String sql2 = "SELECT STUDENTNAME FROM attendance." + table + "record  WHERE LACTUREDAY='" + dayss

     + "' AND LACTUREMonth='" + monss + "' AND LACTUREyear='" + yearss + "' AND LactureVarification=0";

   

   try {

    stmt = con.prepareStatement(sql);

    rs = stmt.executeQuery();

    int totalattendance = 1;

    while (rs.next()) {

     totalattendance++;

    }

    stmt = con.prepareStatement(sql2);

    rs = stmt.executeQuery();

    int j = 0;

    while (rs.next()) {

     String sql3 = "SELECT STUDENTNAME,STUDENTBRANCH,STUDENTSECTION FROM attendance." + table

       + "  WHERE STUDENTROLL='" + rs.getString("STUDENTNAME") + "'";

     stmt = con.prepareStatement(sql3);

     ResultSet rs3 = stmt.executeQuery();

     rs3.next();

     json.put("name" + j, rs3.getString("STUDENTNAME"));

     json.put("branch" + j, rs3.getInt("STUDENTBRANCH") + "");

     json.put("Section" + j, rs3.getString("STUDENTSECTION"));

     j++;

    }

    json.put("absent", j + "");

    json.put("totalll", totalattendance + "");

    json.put("info", "success");

   } catch (JSONException e1) {

    try {

     json.put("info", "failure");

    } catch (JSONException e) {

     e.printStackTrace();

    }

    e1.printStackTrace();

   } catch (Exception e) {

    e.printStackTrace();

   }

   try {

    response.setContentType("application/json");

    response.setCharacterEncoding("UTF-8");

    response.getWriter().write(json.toString());

   } catch (Exception e) {

  

   }

  } else if (params[1].equals("AbsentStudent2")) {

   String table = params[0];

   table = table.substring(0, 11);

   DataBase db = new DataBase();

   int clsstrength = 0;

   Connection con = db.getConnection();

   String date = new SimpleDateFormat("yyyyMMdd_HHmmss").format(Calendar.getInstance().getTime());

   String redate2[] = date.split("_");

   char[] ch = redate2[0].toCharArray();

   String date3 = ch.toString();

   yearss = redate2[0].substring(0, 4);

   monss = redate2[0].substring(4, 6);

   dayss = redate2[0].substring(6);

   String redate = dayss + "/" + dayss + "/" + dayss;

   int saw = Integer.parseInt(dayss);

   try {

    int j = 0;

    int totalattendance = 1;

    for (int sa = 1; sa <= saw; sa++) {



     String sql = "SELECT STUDENTNAME FROM attendance." + table + "record  WHERE LACTUREDAY='" + sa

       + "' AND LACTUREMonth='" + monss + "' AND LACTUREyear='" + yearss + "'";



     String sql2 = "SELECT STUDENTNAME FROM attendance." + table + "record  WHERE LACTUREDAY='" + sa

       + "' AND LACTUREMonth='" + monss + "' AND LACTUREyear='" + yearss

       + "' AND LactureVarification=0";

     stmt = con.prepareStatement(sql);

     rs = stmt.executeQuery();



     while (rs.next()) {

      totalattendance++;

     }

     stmt = con.prepareStatement(sql2);

     rs = stmt.executeQuery();



     while (rs.next()) {

      String sql3 = "SELECT * FROM attendance." + table + "  WHERE STUDENTROLL='"

        + rs.getString("STUDENTNAME") + "'";

      stmt = con.prepareStatement(sql3);

      ResultSet rs3 = stmt.executeQuery();

      rs3.next();

      json.put("name" + j, rs3.getString("STUDENTNAME"));

      json.put("name2" + j, rs3.getString("STUDENTROLL"));

      json.put("branch" + j, rs3.getInt("STUDENTBRANCH") + "");

      json.put("Section" + j, rs3.getString("STUDENTSECTION"));

      json.put("sawan1" + j, 1 + "");

      json.put("sawan2" + j, 1 + " ");

      json.put("sawan3" + j, 1 + "");

      j++;

     }

    }

    json.put("absent", j + "");

    json.put("totalll", totalattendance + "");

    json.put("info", "success");

   } catch (JSONException e1) {

    try {

     json.put("info", "failure");

    } catch (JSONException e) {

     e.printStackTrace();

    }

    e1.printStackTrace();

   }



   catch (Exception e) {

    e.printStackTrace();

   }

   try {

    response.setContentType("application/json");

    response.setCharacterEncoding("UTF-8");

    response.getWriter().write(json.toString());

   } catch (Exception e) {

    System.out.println(e);

   }

  }



 }

}