<%@ 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_ji_no = r_call(request.getParameter("c_ji_no")); int col_no = 9; %>

Survey Item <% int change_ok = 0; String sql_ji = "select * from tbl_point_ji where c_home = " +c_home + " and c_no = " + c_ji_no; ResultSet rs_ji = stmt.executeQuery(sql_ji); if(rs_ji.next()){ change_ok = rs_ji.getInt("c_change"); %> Survey : <%=rs_ji.getString("c_name")%> <% } rs_ji.close(); %> <% int total_point = 0; int o_no = 0; int o_order = 0; int o_no2 = 0; int o_order2 = 0; String sql1=" SELECT a.*,(select count(c_no) from tbl_point_ji_detail where c_up_no = a.c_no and c_use=0 ) as down_no from tbl_point_ji_detail a where a.c_ji_no = " + c_ji_no + " and a.c_up_no = 0 and a.c_use=0 order by a.c_order asc"; ResultSet rst = stmt.executeQuery(sql1); int i_no = 0; while (rst.next()) { i_no = i_no + 1; %> <% o_no2 = 0; o_order2 = 0; String sql12=" SELECT * from tbl_point_ji_detail where c_ji_no = " + c_ji_no + " and c_up_no = "+ rst.getInt("c_no") +" and c_use=0 order by c_order asc"; ResultSet rst2 = stmt.executeQuery(sql12); int i_no2 = 0; while (rst2.next()) { total_point = total_point + rst2.getInt("c_point"); i_no2 = i_no2 + 1; %> <%if(i_no2 > 1){%> <%}%> <% o_no2 = rst2.getInt("c_no"); o_order2 = rst2.getInt("c_order"); } rst2.close(); %> <% } if(i_no == 0){ %> <% } rst.close(); %> Item Note points "> <%=rst.getString("c_title")%> <%=rst2.getString("c_title")%> <%=rst2.getString("c_exp").replaceAll("\r"," ").replaceAll("\n\r"," ")%> <%for(int pp=0;pp < rst2.getInt("c_point") + 1;pp++){%> <%=pp%> <%}%> There is no data. Total score <%=total_point%>

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