package com.ilp.tsi.um.servlet;

import java.io.IOException;
import java.sql.Connection;
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;

import com.ilp.tsi.um.constant.BankConstant;

import com.ilp.tsi.um.dao.BankDao;
import com.ilp.tsi.um.bean.BankBean;
import com.ilp.tsi.um.service.BankService;

/**
 * Servlet implementation class AdminServlet
 */
public class BankServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
    Connection conn;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public BankServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub

        try
        {
            conn=BankDao.createconnection();
        }
        catch(Exception e)
        {
            e.printStackTrace();

        }
        BankService loginService = new BankService();
        BankBean loginBean = new BankBean();
        loginBean.setUsername(request.getParameter("username"));
        loginBean.setPassword(request.getParameter("password"));
        boolean check = false;
        try
        {
            check = loginService.authenticate(loginBean,conn);
            conn.close();
        }
        catch(SQLException e)
        {
            e.printStackTrace();
        }

        if(check){
            RequestDispatcher rd=request.getRequestDispatcher("customerinfo.jsp");
            rd.forward(request,response);
        }
        else{
            request.setAttribute("Message",BankConstant.MESSAGE);
            RequestDispatcher rd=request.getRequestDispatcher("failed.jsp");
            rd.forward(request,response);
        }//end else



    }

}

//2.servlet

package com.ilp.tsi.um.servlet;


import java.io.IOException;

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

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.ilp.tsi.um.dao.BankDao;


public class CustDet extends HttpServlet
              //perform operation to get retailer information
{
    private static final long serialVersionUID = 1L;
    Connection connection = null;
    /**
     * @see HttpServlet#HttpServlet()
     */
    public CustDet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub

            response.setContentType("text/html");
            PrintWriter pw = response.getWriter();  
            //send response to browser
            String acc_num=request.getParameter("acc");
            String name=request.getParameter("name");
            String addr=request.getParameter("address");
            String ph=request.getParameter("phno");
            int n;

             try {
                 Class.forName("oracle.jdbc.driver.OracleDriver");
                 //driver definition
                 Connection con=BankDao.createconnection();
                 //establishing database connection
                 Statement stmt= con.createStatement();
                 n=stmt.executeUpdate("update customer set acc='"+acc_num+"',name='"+name+"',address='"+addr+"',phoneno='"+ph+"' where acc='"+acc_num+"'");

             }
             catch (ClassNotFoundException ce) {
                 ce.printStackTrace();
             }//end catch
             catch(SQLException e)
             {
            e.printStackTrace();
             }//end catch
             RequestDispatcher rd = request.getRequestDispatcher("update1.jsp"); 
             rd.forward(request,response);  
               }
            }

//3.servlet


package com.ilp.tsi.um.servlet;


import java.io.IOException;

import java.sql.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.ilp.tsi.um.dao.BankDao;


public class CustomerDetail extends HttpServlet {
                 //update retailer details
    private static final long serialVersionUID = 1L;
    Connection connection = null;



    /**
     * @see HttpServlet#HttpServlet()
     */
    public CustomerDetail() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
     *      response)
     */
    protected void doGet(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
     *      response)
     */
    protected void doPost(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
            response.setContentType("text/html");

            //send response to browser
            String s=request.getParameter("acc");

             try {



            Connection con=BankDao.createconnection();
            //establishing database connection
            Statement stmt= con.createStatement();
            ResultSet rs= stmt.executeQuery("select * from customer where acc='"+s+"'");
                //iterating the resultset for data from database
                while(rs.next())
                {
                    request.setAttribute("acc",rs.getString(1));
                    request.setAttribute("name",rs.getString(2));
                    request.setAttribute("address",rs.getString(3));
                    request.setAttribute("phno",rs.getString(4));
                    RequestDispatcher rd = request.getRequestDispatcher("updateinfo.jsp"); 
                    rd.forward(request,response); 
                }


        }

        catch(SQLException e)
        {
            e.printStackTrace();

        }//end catch


    }
            }