%@ page
import = "java.io.*"
import = "java.lang.*"
import = "java.sql.*"
session = "true"
%>
<%@ include file="conexion_include_SQLServer.jsp" %>
<%
// VARIABLES PARA CONSULTA
ResultSet RS=null;
String Q="";
String var="";
%>
<%
Object bs=request.getParameter("var");
if (bs!=null) var=bs.toString().toUpperCase();
else var="";
try{
Q="SELECT * FROM v_egresados";
Q+=" WHERE Alumno like \'%";
Q+=var;
Q+="%\'";
RS=stmt.executeQuery(Q);
}catch(Exception e){
out.print("Error al leer campos");
}
%>
Busquedas de Egresados
|
<%
while (RS.next()){
%>
|
<%
out.println(RS.getString("Alumno"));
%>
|
<%
out.println(RS.getString("nombre_prog"));
%>
|
<%
out.println(RS.getString("siglas_cent"));
%>
|
<%
}
%>
|