<%@ 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; %>
<% 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()){ %> <%=rs_sr.getString("c_name")%> <% } rs_sr.close(); %>
<% 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()) { %> <% 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()) { %> <% } rs_sr2.close(); %> <% } rs_sr.close(); %>
<%=rs_sr.getString("c_title")%>
<%=rs_sr2.getString("c_title")%>
<%=rs_sr2.getString("c_exp").replaceAll("\n\r","
").replaceAll("\n","
")%>



<%@include file="/manager_for_cms/include/manager_bottom.jsp"%>