<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import = "java.sql.Connection"%>
<%@page import = "java.sql.DriverManager"%>
<%@page import = "java.sql.ResultSet"%>
<%@page import = "java.sql.Statement"%>
<%@page import = "oracle.jdbc.driver.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>confirmacón de soporte</title>
</head>
<body>
<%
LeeTicket lt = new LeeTicket();
try{
ResultSet rs = null;
Connection conex = duoc.support.ini.Conexion.getConexion();
Statement st = conex.createStatement();
String query =("select * from support where id_a="+
request.getParameter("leeticket").toString());
rs = st.executeQuery(query);
out.println("<table border=\"1\"><tr><td>id</td><td>Nombre</td><td>.....</td><td>.....</td></tr>");
while (rs.next())
{
out.println("<tr>");
out.println("<td>"+rs.getObject("id_a")+"</td>");
out.println("<td>"+rs.getObject("user_a")+"</td>");
out.println("<td>"+rs.getObject("emailuser_a")+"</td>");
out.println("<td>"+rs.getObject("descripcion_a")+" </td>");
out.println("</tr>");
}
out.println("</table>");}
catch (Exception e){
e.printStackTrace();
}
%>
<A HREF="history_support_ticket.html"> Volver</A>
</body>
</html>