<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@include file="/field_manager/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_survey 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_survey_problem where c_survey_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_survey_problem where c_survey_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()) { %> <% if(rs_sr2.getInt("c_type") < 2){ %> <% } %> <% if(rs_sr2.getInt("c_type") == 2){ %> <% } %> <% if(rs_sr2.getInt("c_type") == 3){ %> <% } %> <% } rs_sr2.close(); %> <% } rs_sr.close(); %> <%=rs_sr.getString("c_title")%> <%=rs_sr2.getString("c_title")%> <% String sql_sr3=" SELECT * from tbl_survey_answer where c_survey_no = " + c_survey_no + " and c_problem_no = "+ rs_sr2.getInt("c_no") +" and c_use=0 order by c_order asc"; ResultSet rs_sr3 = stmt.executeQuery(sql_sr3); while (rs_sr3.next()) { String input_type = "chekcbox"; if(rs_sr2.getInt("c_type") == 1){ input_type = "checkbox"; }else{ input_type = "radio"; }%> " type="<%=input_type%>"> <%=rs_sr3.getString("c_title")%> <%if(rs_sr3.getInt("c_type") == 1){%> <%}%>      <% } rs_sr3.close(); %>

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