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

Java Web Application Development | 

Experts In Java - BSCHANDEL - 

PART-19

Major Project 

Project Name : Library Management System

(LMS)

UpdateLibrarian.java

/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

package Administrator;

import connection.Databasecon;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.ResultSet;

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

{

    private String username = null;

    private String password = null;

    private String usertype = null;

     private Connection con = null;

    private Statement stmt = null;

    private ResultSet rs = null;

    Databasecon dbcon = new Databasecon();

    

   

    

    @Override

    protected 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 login set password = '"+request.getParameter("password")+"',userType = '"+request.getParameter("usertype")+"' where username = '"+request.getParameter("username")+"'";

                 stmt.executeUpdate(query);

                 rds = request.getRequestDispatcher("AdminControls/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");

        }

    } 

}