Charting

<%-- Document : frm_muestra_grafica_app Created on : 31/01/2012, 12:42:41 PM Author : psoto --%> <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import = "conexion.*" import = "java.sql.*" import = "extras.formatFecha" import = "general.Config" import = "general.Permisos" import = "own.codec.*" import = "java.text.NumberFormat" import = "java.util.Date" import = "java.util.Calendar" import = "java.util.Hashtable" import = "java.util.ArrayList" import = "java.text.SimpleDateFormat" %> Charting <% /****** Despliega la lista de cines del sistema filtrados por el texto de b�squeda de buscar_cines.jsp (no obligatorio)***********/ /********************************************creado por: L.I. Salvador D�az Parra*******************************************************/ out.println(""); String nompag[] = request.getRequestURI().split("/"); Date hoy = new Date(); SimpleDateFormat formato = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String fecha_hoy = formato.format(hoy); %> <% ConexionEquipos c = null; Connection lcnt_con = null; ResultSet lrs_res = null; Statement lst_stm = null; String ls_query = new String(""); ResultSet lrs_res2 = null; Statement lst_stm2 = null; String ls_query2 = new String(""); String emergent_error = new String(""); boolean lb_connection = false; String debug = new String("si"); // Conexi�n a la base de datos try { if (!Config.getParametro("debug").equals("si")) { debug = "no"; } c = new ConexionEquipos(); lcnt_con = c.getConnection(); lst_stm = lcnt_con.createStatement(); lst_stm2 = lcnt_con.createStatement(); lb_connection = true; } catch (Exception e) { emergent_error = "Error al conectarse a la base de datos "; if (debug.equals("si")) { emergent_error += e; } lb_connection = false; } if (lb_connection) { try { %>

"> "> ">

<% int tam_cat=1; ls_query = "SELECT id_cat_categorias, nombre_categoria FROM cat_categorias WHERE status=true ORDER BY nombre_categoria "; lrs_res = lst_stm.executeQuery(ls_query); while (lrs_res.next()) { out.println("" + "" + ""); tam_cat++; } %>

Seleciona Categorias de tickets
" + lrs_res.getString("nombre_categoria") + "	" + " " + "

<% int tam_areas=1; ls_query = "SELECT id_area, nombre,clave_area FROM cat_areas WHERE status=true ORDER BY nombre "; lrs_res = lst_stm.executeQuery(ls_query); while (lrs_res.next()) { out.println("" + "" + ""); tam_areas++; } %>

Seleciona �reas
" + lrs_res.getString("nombre") + " ( "+lrs_res.getString("clave_area") +" )	" + " " + "

<% } catch (Exception e) { emergent_error += "Error: " + e.toString() + " Ultimo query: " + ls_query; %>

<%=emergent_error%>

<% } finally { lst_stm.close(); } } else { %>

<%=emergent_error%>

<% } %>