public   class  ToProcess  extends  HttpServlet  implements  SingleThreadModel 
{
   private   static   final  String CONTENT_TYPE = "text/html; charset=windows-1251";
   private  String un_t;
   private  String up_t;
  
   public   void  init(ServletConfig config)  throws  ServletException
  {
     super .init(config);
     try 
    {
       Class .forName("oracle.jdbc.driver.OracleDriver").newInstance();
    } catch (Exception ex)
    {
      
    }
  }

   public   void  doGet(HttpServletRequest request, HttpServletResponse response)  throws  ServletException, IOException
  {
     int  id_region =  0 ;     int  month_sv =  0 ;     int  year_sv =  0 ;
    String s_inn = ""; String s_kpp = "";
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    
    
    /*Пытаемся считать параметры*/
     try 
    {
        id_region = Integer.parseInt(request.getParameter("id_reg"));
        month_sv = Integer.parseInt(request.getParameter("month_num"));
        year_sv = Integer.parseInt(request.getParameter("year_num"));
        s_inn = request.getParameter("s_inn");
        s_kpp = request.getParameter("s_kpp");
      
    }
     catch (Exception e)
    {
      e.printStackTrace();
    }
        
     if (id_region!= 0  && month_sv != 0  && year_sv != 0  && s_inn.length()!= 0  && s_kpp.length()!= 0 )
    {           
         try 
        {
          DoSverka(un_t,up_t,id_region,month_sv,year_sv,s_inn, s_kpp,response,request); 
          response.sendRedirect("http://zeus.guszn.local/servlets/"+
                                "PrtList?ido=plist&id_reg="+id_region+"&month_sv="+month_sv+"&year_sv="+year_sv+"&s_inn="+s_inn+"&s_kpp="+s_kpp);    
        } catch (SQLException e){

          out.println(e.getMessage());
          out.close();
        }
      
    } else {
      
         try 
        {
           if (DoChek(response, request))
          {
            out.println();
            CreateSverkaList(response,un_t,up_t); 
          }
          
        } catch (SQLException e)
        {
          /*PrintWriter out = response.getWriter();
          response.setContentType(CONTENT_TYPE);*/
          //out.println(e.getMessage());
          //out.close();          
        }
    }       
  }
  
   public   void  DoSverka(String un, String up,  int  id_reg,  int  month_sv,  int  year_sv, String s_inn, String s_kpp,
                        HttpServletResponse response, HttpServletRequest request)  throws  SQLException, IOException
  {
    Connection cn =  null ;    PreparedStatement ps =  null ;
    //String user_n = un;      String pass = up;
    String sSQLBLOCK =  null ;
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter(); 
    
     try 
    {
      
      cn = DriverManager.getConnection("jdbc:oracle:oci8:"+un+"/"+up+"@zeus.guszn.local");      
 
/*Проверяем -------------------------------------------------------*/           
        sSQLBLOCK =  null ;
        sSQLBLOCK = "declare id_department integer; month_sv integer; year_sv integer;"+
                            "s_inn varchar(20); s_kpp varchar(20);"+
                    "begin "+
                    "id_department := ?; month_sv := ?; year_sv := ?; s_inn := ?; s_kpp := ?; "+
                    "edv.p_f_chek_1(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "edv.p_f_chek_2(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "edv.p_f_chek_3(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "edv.p_o_chek_1(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "edv.p_o_chek_2(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "edv.p_o_chek_3(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "edv.p_o_chek_4(id_department,1,month_sv,year_sv,s_inn,s_kpp);"+
                    "commit; end;";

         try 
        {
          ps = cn.prepareStatement(sSQLBLOCK);
          ps.setInt( 1 ,id_reg);  ps.setInt( 2 ,month_sv);
          ps.setInt( 3 ,year_sv);  ps.setString( 4 ,s_inn); ps.setString( 5 ,s_kpp);          
          ps.executeUpdate();
          
        } catch (SQLException ex)
        {
          out.println(ex.getMessage());
          out.flush();
          ps.close();
          cn.close();
          out.close();
        }
         catch (NullPointerException ex)
        {
          out.println(ex.getMessage());
          out.flush();
          ps.close();
          cn.close();
          out.close();
        }
      
/*----------------------------------------------------------------------------*/      
/*-------------------------------------------------------------------------*/      
       for  ( int  i= 1 ;i< 4 ;i++)
      {
        sSQLBLOCK =  null ;
        sSQLBLOCK = "begin edv.p_f_chek_"+i+"(?,0,?,?,?,?); commit; end;";        
         try 
        {
          ps = cn.prepareStatement(sSQLBLOCK);
          ps.setInt( 1 ,id_reg);  ps.setInt( 2 ,month_sv);
          ps.setInt( 3 ,year_sv);  ps.setString( 4 ,s_inn); ps.setString( 5 ,s_kpp);          
          ps.executeUpdate();
          
        } catch (SQLException ex)
        {
          ps.close();  cn.close();        out.close();
        }
      }
/*----------------------------------------------------------------------------*/      
       for  ( int  i= 1 ;i< 4 ;i++)
      {
        sSQLBLOCK =  null ;
        sSQLBLOCK = "begin edv.p_o_chek_"+i+"(?,0,?,?,?,?); commit; end;";
        
         try 
        {
          ps = cn.prepareStatement(sSQLBLOCK);
          ps.setInt( 1 ,id_reg);  ps.setInt( 2 ,month_sv);
          ps.setInt( 3 ,year_sv);  ps.setString( 4 ,s_inn); ps.setString( 5 ,s_kpp);          
          ps.executeUpdate();
          
        } catch (SQLException ex)
        {
          ps.close();          cn.close();          out.close();
        }
      }
/*----------------------------------------------------------------------------*/        
      ps.close();
      cn.close();
  
    } catch (SQLException e){
      ps.close();      cn.close();        out.close();
    } catch (Exception e){
      out.println(e.getMessage());
      ps.close();      cn.close();        out.close();
    }
/*----------------------------------------------------------------------------*/
/*----------------------------------------------------------------------------*/
}
   public   boolean  DoChek(HttpServletResponse response, HttpServletRequest request)  throws  IOException, SQLException
  {
       boolean  res = false;
      CheckConfiguration check =  new  CheckConfiguration();
      
       if (check.CheckConfiguration(request))
      {
        un_t = check.authUserName;
        up_t = check.authUserPass;
        res = true;        
      } else 
      {
         if (check.getAutorizationParam(request, response))
        {
          un_t = check.authUserName;
          up_t = check.authUserPass;
          res = true;
        } else 
        {
          response.setStatus(response.SC_UNAUTHORIZED);
          response.setHeader("WWW-Authenticate","Basic realm=\"realm\"");
        }
      }
       return  res;
  }  
   public   void  doPut(HttpServletRequest request, HttpServletResponse response)  throws  ServletException, IOException
  {
    doGet(request,response);
  }
}

}