Java Web Application Development | Experts In Java - BSCHANDEL - PART-16

Java Web Application Development | 

Experts In Java - BSCHANDEL - 

PART-16

Major Project 

Project Name : Library Management System

(LMS)

UpdateStuRecord.java

package userLogin;

import connection.Databasecon;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.Statement;

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 UpdateStuRecord extends HttpServlet

{

    private String studentid = null;

    private String studentbranch = null;

    private String studentyear = null;

    private String FirstName = null;

    private String lastname = null;

    private String fathername = null;

    private String presentaddr = null;

    private String permanentaddr = null;

    private String homecontect = null;

    private String mobileno = null;

    private Connection con = null;

    private Statement stmt = null;

    Databasecon dbcon = new Databasecon();

   

   

    @Override

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

    {

        response.setContentType("text/html;charset=UTF-8");

        PrintWriter out = response.getWriter();

        RequestDispatcher rds;

         if(dbcon!=null)

         {

            try

            {

                

                 con = dbcon.getConnection();

                 stmt = con.createStatement();

                 String query = "update studentinfo set studentbranch = '"+request.getParameter("studentbranch")+"',studentyear = '"+request.getParameter("studentyear")+"',FirstName = '"+request.getParameter("FirstName")+"' ,lastname = '"+request.getParameter("lastname")+"',fathername = '"+request.getParameter("fathername")+"',presentaddr = '"+request.getParameter("presentaddr")+"',permanentaddr = '"+request.getParameter("permanentaddr")+"',homecontect = '"+request.getParameter("homecontect")+"',mobileno = '"+request.getParameter("mobileno")+"' where studentid = '"+request.getParameter("studentid")+"'";

                 

                 stmt.executeUpdate(query);

                 rds = request.getRequestDispatcher("UserControl/UpdateRec.jsp");

                 rds.forward(request,response);

            }

            catch(Exception ex)

            {

                System.out.println("The Database Exception : "+ex);

            }

        }

        else

        {

             System.out.println("This is a Connection Error");

        }

        

    } 

    

}