¿esto deberia hacerlo con un array?... si es asi agradecere una ayuda fuerte en esto, ya que no lo manejo muy bien. muchas gracias
-----------------------------------------------------------------
<!-- Los import -->
<%@ page import = "java.sql.Connection"%>
<%@ page import = "java.sql.DriverManager"%>
<%@ page import = "java.sql.ResultSet"%>
<%@ page import = "java.sql.Statement"%>
<html>
<body>
<h1>Consulta a base de datos</h1>
<form method="post" action="history_support_ticket.jsp">
<p>
ingrese el numero de ticket <input type="text" name="leeticket" value="" size="15" />
<input type="submit" value=" elnviar "/>
</p>
</form>
--------------------------------------------------------------------------
<%@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>
<jsp:useBean id="mybean" scope="request" class="LeeTicket" />
<jsp:setProperty name="mybean" property="*"/>
<jsp:getProperty name="mybean" property="leeticket" />
<p> </p>
<%
LeeTicket lt = new LeeTicket();
try{
ResultSet rs = null;
Connection conex = Conexion.getConexion();
Statement st = conex.createStatement();
String query =("select * from support where id_a="+lt.getLeeTicket);
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.jsp"> Volver</A>
</body>
</html>
-----------------------------------------------------------------------------------
import java.sql.DriverManager;
import java.sql.Connection;
import oracle.jdbc.driver.*; //utilizar el driver correspondiente
public class Conexion {
public static Connection getConexion(){
Connection conex= null;
try{
String driverClassName="oracle.jdbc.driver.OracleDriver"; //aqui la cambiar por my sql
String driverUrl="jdbc:oracle:thin://localhost/tu_base_de_datos";
Class.forName(driverClassName);
conex = DriverManager.getConnection(driverUrl, "...username_de-la_base_de_datos", "....password...");
System.out.println("conexion exitosa");
} catch(Exception e) {
System.out.print("no se logro conección");
e.printStackTrace();
}
return conex;
}
}
----------------------------------------------------------------------------
import java.util.Timer;
import java.io.*;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;
import java.sql.Date;
public class LeeTicket {
public int leeticket;
public LeeTicket() {
//setLeeticket(0);
}
public int getLeeticket() {
return leeticket;
}
public void setLeeticket(int leeticket) {
this.leeticket = leeticket;
}
Mode Lineal
