package _osinerg; import oracle.jsp.runtime.*; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.jsp.*; import java.io.*; import java.util.*; import java.lang.reflect.*; import java.beans.*; import java.sql.*; import javax.sql.*; import oracle.jsp.dbutil.ConnCacheBean; public class _usuario extends oracle.jsp.runtime.HttpJsp { public final String _globalsClassName = null; // ** Begin Declarations // ** End Declarations public void _jspService(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { response.setContentType( "text/html;charset=iso-8859-1"); /* set up the intrinsic variables using the pageContext goober: ** session = HttpSession ** application = ServletContext ** out = JspWriter ** page = this ** config = ServletConfig ** all session/app beans declared in globals.jsa */ JspFactory factory = JspFactory.getDefaultFactory(); PageContext pageContext = factory.getPageContext( this, request, response, null, true, JspWriter.DEFAULT_BUFFER, true); // Note: this is not emitted if the session directive == false HttpSession session = pageContext.getSession(); if (pageContext.getAttribute(OracleJspRuntime.JSP_REQUEST_REDIRECTED, PageContext.REQUEST_SCOPE) != null) { pageContext.setAttribute(OracleJspRuntime.JSP_PAGE_DONTNOTIFY, "true", PageContext.PAGE_SCOPE); factory.releasePageContext(pageContext); return; } ServletContext application = pageContext.getServletContext(); JspWriter out = pageContext.getOut(); _usuario page = this; ServletConfig config = pageContext.getServletConfig(); try { // global beans // end global beans out.print(__jsp_StaticText.text[0]); out.print(__jsp_StaticText.text[1]); String connStr=request.getParameter("connStr"); if (connStr==null) { connStr=(String)session.getValue("connStr"); } else { session.putValue("connStr",connStr); } if (connStr==null) { connStr="jdbc:oracle:thin:@11.160.124.12:1521:osidb"; } out.print(__jsp_StaticText.text[2]); oracle.jsp.dbutil.ConnCacheBean ccbean; if ((ccbean = (oracle.jsp.dbutil.ConnCacheBean) pageContext.getAttribute( "ccbean", PageContext.APPLICATION_SCOPE)) == null) { ccbean = (oracle.jsp.dbutil.ConnCacheBean) new oracle.jsp.dbutil.ConnCacheBean(); pageContext.setAttribute( "ccbean", ccbean, PageContext.APPLICATION_SCOPE); out.print(__jsp_StaticText.text[3]); ccbean.setUser("invitado"); out.print(__jsp_StaticText.text[4]); ccbean.setPassword("invitado"); out.print(__jsp_StaticText.text[5]); ccbean.setURL( OracleJspRuntime.toStr( connStr)); out.print(__jsp_StaticText.text[6]); ccbean.setMaxLimit(5); out.print(__jsp_StaticText.text[7]); ccbean.setCacheScheme( OracleJspRuntime.toInt( ConnCacheBean.FIXED_RETURN_NULL_SCHEME)); out.print(__jsp_StaticText.text[8]); } out.print(__jsp_StaticText.text[9]); try { Connection conn = ccbean.getConnection(); Statement stmt = conn.createStatement (); ResultSet rset = stmt.executeQuery ("select pagcotros.titulo, pagotrportal.cod_otros, pagotrportal.cod_pag "+ " from osinerg.pagotrportal pagotrportal, osinerg.pagcotros pagcotros" + " where pagcotros.cod_otros = pagotrportal.cod_otros " + " and cod_pag = '0008' order by pagcotros.titulo"); if (rset.next()) { out.print(__jsp_StaticText.text[10]); out.print( rset.getString(1)); out.print(__jsp_StaticText.text[11]); try { Statement stmt2 = conn.createStatement (); ResultSet rset2 = stmt2.executeQuery (" SELECT SUBTITULO, URL FROM osinerg.pagdotros pagdotros" + " where cod_otros = '"+rset.getString(2)+"'"); if (rset2.next()) { out.print(__jsp_StaticText.text[12]); out.print( rset2.getString(2)); out.print(__jsp_StaticText.text[13]); out.print( rset2.getString(1)); out.print(__jsp_StaticText.text[14]); while (rset2.next()) { out.print(__jsp_StaticText.text[15]); out.print( rset2.getString(2)); out.print(__jsp_StaticText.text[16]); out.print( rset2.getString(1)); out.print(__jsp_StaticText.text[17]); } out.print(__jsp_StaticText.text[18]); } else { out.print(__jsp_StaticText.text[19]); } rset2.close(); stmt2.close(); } catch (SQLException e) { out.println("

" + "Error en Consutlta:"); out.println ("

" + e + "
\n

"); } out.print(__jsp_StaticText.text[20]); while (rset.next()) { out.print(__jsp_StaticText.text[21]); out.print( rset.getString(1)); out.print(__jsp_StaticText.text[22]); try { Statement stmt2 = conn.createStatement (); ResultSet rset2 = stmt2.executeQuery (" SELECT SUBTITULO, URL FROM osinerg.pagdotros pagdotros" + " where cod_otros = '"+rset.getString(2)+"'"); if (rset2.next()) { out.print(__jsp_StaticText.text[23]); out.print( rset2.getString(2)); out.print(__jsp_StaticText.text[24]); out.print( rset2.getString(1)); out.print(__jsp_StaticText.text[25]); while (rset2.next()) { out.print(__jsp_StaticText.text[26]); out.print( rset2.getString(2)); out.print(__jsp_StaticText.text[27]); out.print( rset2.getString(1)); out.print(__jsp_StaticText.text[28]); } out.print(__jsp_StaticText.text[29]); } else { out.print(__jsp_StaticText.text[30]); } rset2.close(); stmt2.close(); } catch (SQLException e) { out.println("

" + "Error en Consutlta:"); out.println ("

" + e + "
\n

"); } out.print(__jsp_StaticText.text[31]); } out.print(__jsp_StaticText.text[32]); } else { out.print(__jsp_StaticText.text[33]); } rset.close(); stmt.close(); conn.close(); conn = null; } catch (SQLException e) { out.println("

" + "Error en Consutlta:"); out.println ("

" + e + "
\n

"); } out.print(__jsp_StaticText.text[34]); try { Connection conn = ccbean.getConnection(); Statement stmt = conn.createStatement (); ResultSet rset = stmt.executeQuery (" select pagdnovedad.url, pagdnovedad.subtitulo, pagnovportal.cod_pag, " + " pagcnovedad.cod_novedad from osinerg.pagnovportal pagnovportal, osinerg.pagdnovedad pagdnovedad, osinerg.pagcnovedad pagcnovedad " + " where pagcnovedad.cod_novedad = pagnovportal.cod_novedad " + " and pagcnovedad.cod_novedad = pagdnovedad.cod_novedad " + " and pagnovportal.cod_pag = '0008'"); if (rset.next()) { out.print(__jsp_StaticText.text[35]); out.print( rset.getString(1)); out.print(__jsp_StaticText.text[36]); out.print( rset.getString(2)); out.print(__jsp_StaticText.text[37]); while (rset.next()) { out.print(__jsp_StaticText.text[38]); out.print( rset.getString(1)); out.print(__jsp_StaticText.text[39]); out.print( rset.getString(2)); out.print(__jsp_StaticText.text[40]); } out.print(__jsp_StaticText.text[41]); } else { out.print(__jsp_StaticText.text[42]); } rset.close(); stmt.close(); conn.close(); conn = null; } catch (SQLException e) { out.println("

" + "Error en Consutlta:"); out.println ("

" + e + "
\n

"); } out.print(__jsp_StaticText.text[43]); out.flush(); } catch( Exception e) { try { if (out != null) out.clear(); } catch( Exception clearException) { } pageContext.handlePageException( e); } finally { if (out != null) out.close(); factory.releasePageContext(pageContext); } } private static class __jsp_StaticText { private static final char text[][]=new char[44][]; static { text[0] = "\n".toCharArray(); text[1] = "\n\n".toCharArray(); text[2] = "\n\n".toCharArray(); text[3] = "\n".toCharArray(); text[4] = "\n".toCharArray(); text[5] = "\n".toCharArray(); text[6] = "\n".toCharArray(); text[7] = "\n".toCharArray(); text[8] = "\n".toCharArray(); text[9] = "\n\n\n\n\nOSINERGMIN - Body\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n \n \n \n \n \n
\n \n\t \n \n \n \n
\n
\n
\n \n \n \n \n \n \n \n
Atiende en forma \n satisfactoria las necesidades y demandas de los consumidores de \n energía eléctrica e inversionistas potenciales y de las actividades \n comerciales en Hidrocarburos. Además, OSINERG cuenta con el servicio \n de orientación al usuario que opera mediante una central telefónica \n identificada con los números 2193410 - 2193411, que brinda información \n sobre los deberes y derechos de los usuarios del servicio de electricidad \n e hidrocarburos, al mismo tiempo que da ha conocer el estado de \n sus expedientes. 
\n
\n
\n
\n".toCharArray(); text[10] = " \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
".toCharArray(); text[11] = "
 
\n \n ".toCharArray(); text[12] = "\n \n \n \n \n \n \n ".toCharArray(); text[15] = "\n \n \n \n \n \n \n ".toCharArray(); text[18] = "\n ".toCharArray(); text[19] = "\n

Disculpa no existe registros!

\n ".toCharArray(); text[20] = "\n
".toCharArray(); text[14] = "
".toCharArray(); text[17] = "
\n
 
\n
\n\t\t\t\n\t".toCharArray(); text[21] = "\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
".toCharArray(); text[22] = "
 
\n \n ".toCharArray(); text[23] = "\n \n \n \n \n \n \n ".toCharArray(); text[26] = "\n \n \n \n \n \n \n ".toCharArray(); text[29] = "\n ".toCharArray(); text[30] = "\n

Disculpa no existe registros!

\n ".toCharArray(); text[31] = "\n
".toCharArray(); text[25] = "
".toCharArray(); text[28] = "
\n
 
\n
\n\t\t\t\n ".toCharArray(); text[32] = "\n".toCharArray(); text[33] = "\n

Disculpa no existe registros!

\n ".toCharArray(); text[34] = "\n
\n\t\n 		\n\n \n \n \n \n \n \n \n \n \n
\n\t
\n
\n

\n
\n \n \n \n ".toCharArray(); text[35] = "\n \n \n \n \n ".toCharArray(); text[38] = "\n \n \n \n \n ".toCharArray(); text[41] = "\n ".toCharArray(); text[42] = "\n

Disculpa no existe registros!

\n ".toCharArray(); text[43] = "\n
".toCharArray(); text[37] = "
".toCharArray(); text[40] = "
\n
\n
\n
\n
\n
\n
\n
\n
 \n \n
\n\n\n".toCharArray(); } } }