84 lines
2.6 KiB
Plaintext
84 lines
2.6 KiB
Plaintext
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
|
<%@include file="/manager_for_cms/include/manager_head.jsp"%>
|
|
<%
|
|
String c_home = r_call(request.getParameter("c_home"));
|
|
String c_survey_no = r_call(request.getParameter("c_survey_no"));
|
|
int col_no = 9;
|
|
%>
|
|
<center>
|
|
<table width="800" cellSpacing="0" cellPadding="0" border="0">
|
|
<tr >
|
|
<td style="padding-top:30px">
|
|
<table width="100%" cellSpacing="0" cellPadding="0" border="0" bgcolor=ffffff>
|
|
<tr >
|
|
<td style="font-size:15px">
|
|
<%
|
|
int change_ok = 0;
|
|
String sql_sr = "select * from tbl_edu where c_home = " +c_home + " and c_no = " + c_survey_no;
|
|
ResultSet rs_sr = stmt.executeQuery(sql_sr);
|
|
if(rs_sr.next()){
|
|
%>
|
|
<b><%=rs_sr.getString("c_name")%></b>
|
|
<%
|
|
}
|
|
rs_sr.close();
|
|
%>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
<table width="100%" cellSpacing="0" cellPadding="0" border="0" >
|
|
<%
|
|
sql_sr=" SELECT * from tbl_edu_curi where c_edu_no = " + c_survey_no + " and c_up_no = 0 and c_use=0 order by c_order asc";
|
|
rs_sr = stmt.executeQuery(sql_sr);
|
|
while (rs_sr.next()) {
|
|
%>
|
|
<tr >
|
|
<td height="40px" >
|
|
</td>
|
|
</tr>
|
|
<tr >
|
|
<td bgcolor="#cdcdcd" height="40px" align=left colspan=2 style="font-weight:bold;padding-left:10px;font-size:15px;">
|
|
<%=rs_sr.getString("c_title")%>
|
|
</td>
|
|
</tr>
|
|
<%
|
|
String sql_sr2=" SELECT * from tbl_edu_curi where c_edu_no = " + c_survey_no + " and c_up_no = "+ rs_sr.getInt("c_no") +" and c_use=0 order by c_order asc";
|
|
ResultSet rs_sr2 = stmt.executeQuery(sql_sr2);
|
|
while (rs_sr2.next()) {
|
|
%>
|
|
<tr bgcolor="#efefef" >
|
|
<td align=left colspan=2 style="font-weight:bold;padding-left:20px;height:30px; font-size:13px;" >
|
|
<%=rs_sr2.getString("c_title")%>
|
|
</td>
|
|
</tr>
|
|
<tr >
|
|
<td align=left style="width:40%;padding:20px;font-size:13px;vertical-align:top;" >
|
|
<%=rs_sr2.getString("c_exp").replaceAll("\n\r","<br />").replaceAll("\n","<br />")%>
|
|
</td>
|
|
<td align=left style="width:60%;font-weight:bold;padding:20px;padding-top:20px;font-size:13px;" >
|
|
<video oncontextmenu="return false;" id="myVideo" width="100%" controls >
|
|
<source src="http://apply.ci.concytec.gob.pe/upload/movie/<%=rs_sr2.getString("c_movie")%>" type="video/mp4">
|
|
|
|
</video>
|
|
</td>
|
|
</tr>
|
|
|
|
<%
|
|
}
|
|
rs_sr2.close();
|
|
%>
|
|
|
|
<%
|
|
}
|
|
rs_sr.close();
|
|
%>
|
|
|
|
</table>
|
|
<!---------------------------------------------------------------------------------------->
|
|
<br><br><br>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<%@include file="/manager_for_cms/include/manager_bottom.jsp"%>
|