%@ page
import = "java.io.*"
import = "java.lang.*"
import = "java.sql.*"
session = "true"
%>
<%
{
Connection conn=null;
ResultSet RS=null;
ResultSet RS2=null;
Statement stmt=null;
String Q="";
String CFN="";
String dbstring="";
String id_grado="";
String id_detalle_grado="";
String grado="";
String detalle="";
String sinopsis="";
String desc_detalle="";
String mensaje="";
String mylink="";
String ls_color_fila="";
String id_centro="";
Object O = request.getParameter("id_detalle_grado");
if (O!=null) id_detalle_grado=O.toString(); else id_detalle_grado="";
O = request.getParameter("id_grado");
if (O!=null) id_grado=O.toString(); else id_grado="";
O = request.getParameter("desc_detalle_grado");
if (O!=null) desc_detalle=O.toString(); else desc_detalle="";
%>
<%//@ include file="encabezado_academico_colmex.htm"%>
<%//@ include file="barra_superior.jsp"%>
<%
try{
Class.forName("org.postgresql.Driver");
conn=DriverManager.getConnection("jdbc:postgresql://db1.colmex.mx/pro_webcolmex", "consulta", "c0n5ult4");
// conn=DriverManager.getConnection("jdbc:postgresql://db1.colmex.mx/pro_webcolmex", "aherrero", "");
stmt = conn.createStatement();
}catch(Exception e){
out.print("Error al conectarse a la base de datos");
}
String K="select grados.nombre,grados.sinopsis from grados,info_grados where grados.id_grado=info_grados.id_grado AND info_grados.id_grado=\'";
K+=id_grado;
K+="\'";
try{
RS=stmt.executeQuery(K);
RS.first();
grado=RS.getString("nombre");
sinopsis=RS.getString("sinopsis");
}catch(Exception e){}
%>
<%
out.print("");out.print(grado);out.print("-");out.print(desc_detalle);out.print(" ");
%>
<%
K="select * from info_grados where id_grado=";
K=K+"\'"+ id_grado +"\'";
K=K+" ORDER BY orden";
try{
RS=stmt.executeQuery(K);
while(RS.next()){
out.println(" ");
out.print(" ");
out.print("");
out.print(RS.getString("nombre"));
out.print(" ");
out.print(" ");
}
}catch(Exception e){
out.print("Error al leer campos para el menú izquierdo");
}
%>
<%
out.print("");
out.print(grado);
out.print(" ");
%>
<%
K="select * from info_grados where id_info_grado=";
K=K+"\'"+ id_detalle_grado +"\' ORDER BY orden";
try{
String texto="";
if (id_detalle_grado.equals("")) texto=""+sinopsis+" "; else {RS=stmt.executeQuery(K);RS.first();texto=RS.getString("contenido");}
out.print(texto);
}catch(Exception e){
out.print("Error al leer contenido");
}
%>
2006© El Colegio de México, A.C
<%
try{
conn.close();
}catch(Exception e2){
out.print("Error al cerrar la base de datos");
}
}
%>