loan_request.java

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

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 *
 * @author lenovo1
 */
public class loan_request extends HttpServlet {
    Connection cn=null;
    Statement st=null;

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        Database db=new Database();
        String result=db.Connectdb();
        System.out.println(result);
        
        HttpSession session = req.getSession();
        PrintWriter out = resp.getWriter();
        
        String user_id = req.getParameter("user_id");
        String id=req.getParameter("id");
        String status=req.getParameter("status");
        
        String event=req.getParameter("submit");
        
        out.println(user_id);
        out.println(id);
        out.println(status);
        
        
        
        
        
        
        if(event.equals("approved"))
        {
            if(status.equals("approved"))
            {
                 resp.setContentType("text/html");
                   out.println("   <script type=\"text/javascript\">   ");
                   out.println("   alert('Loan has been already approved and cheque book number is assigned');                ");
                   out.println("   location='loan_request.jsp';            ");
                   out.println("   </script>                           ");
            }
            else
            {
                try
               {
                           
                    String update = db.update("update loan set status='approved'  where (user_id='"+user_id+"' && id='"+id+"' ) ");
                    out.println(update);
                    resp.setContentType("text/html");
                    out.println("   <script type=\"text/javascript\">   ");
                    out.println("   alert('"+update+"');                ");
                    out.println("   location='loan_request.jsp';            ");
                    out.println("   </script>                           ");      
                            
                    
               }
               catch(Exception ex)
               {
                   resp.setContentType("text/html");
                   out.println("   <script type=\"text/javascript\">   ");
                   out.println("   alert('"+ex.toString()+"');                ");
                   out.println("   location='loan_request.jsp';            ");
                   out.println("   </script>                           ");
               }
            }
         
         }
        
        if(event.equals("Rejected"))
        {
            if(status.equals("Rejected"))
            {
                 resp.setContentType("text/html");
                   out.println("   <script type=\"text/javascript\">   ");
                   out.println("   alert('Loan has been already Rejected');                ");
                   out.println("   location='loan_request.jsp';            ");
                   out.println("   </script>                           ");
            }
            else
            {
                try
               {
                           
                    String update = db.update("update loan set status='Reject' where ( id='"+id+"' ) ");
                    out.println(update);
                    resp.setContentType("text/html");
                    out.println("   <script type=\"text/javascript\">   ");
                    out.println("   alert('"+update+"');                ");
                    out.println("   location='loan_request.jsp';            ");
                    out.println("   </script>                           ");      
                            
                    
               }
               catch(Exception ex)
               {
                   resp.setContentType("text/html");
                   out.println("   <script type=\"text/javascript\">   ");
                   out.println("   alert('"+ex.toString()+"');                ");
                   out.println("   location='loan_request.jsp';            ");
                   out.println("   </script>                           ");
               }
            }
         
  

}
        
        

    }
    

}