<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@include file="/include/include.jsp"%> <% String call_home = r_call(request.getParameter("c_home")); String call_maker = r_call(request.getParameter("c_maker")); int sub_show_no = 0; int sub_check_no = 0; int sub_c_relation = 0; int sub_c_relation2 = 0; int sub_c_use = 0; String sql_sub_t = "select * from tbl_menu where c_home = " + call_home + " and c_maker = " + call_maker + " and c_name = 'Notice' and c_fix = 1"; ResultSet rs_sub_t = stmt.executeQuery(sql_sub_t); if(rs_sub_t.next()){ sub_show_no = rs_sub_t.getInt("c_no"); sub_check_no = rs_sub_t.getInt("c_up_no"); sub_c_relation = rs_sub_t.getInt("c_relation"); sub_c_relation2 = rs_sub_t.getInt("c_relation2"); sub_c_use = rs_sub_t.getInt("c_use"); }else{ } rs_sub_t.close(); %>
Notice
+
<% String sql1 = " select t.* from ( select a.* "; sql1 = sql1 + " from tbl_board a "; sql1 = sql1 + " where a.c_use= 0 and a.c_relation = "+ sub_c_relation +" and a.c_relation2 = "+ sub_c_relation2 +" and a.c_home = "+ call_home +" and a.c_maker = "+ call_maker +" and a.c_board_no = "+ sub_show_no +") t "; sql1 = sql1 + " order by t.c_no desc "; sql1 = sql1 + " limit 0 , 10 "; ResultSet rst = stmt.executeQuery(sql1); while(rst.next()){ %> <% } rst.close(); %>
"> <%if(rst.getString("c_title").length() > 20){%> <%=rst.getString("c_title").substring(0,20)%>.. <%}else{%> <%=rst.getString("c_title")%> <%}%> <%=rst.getString("c_date").substring(0,10)%>
<%@include file="/include/include_b.jsp"%>