%@ page import="java.io.*" contentType="text/html;charset=euc-jp" %> <%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%! static String optionList =""; static int counter; static String URL = ""; static final String SQL1 = "select category_index,name from service_category where status=0 order by category_index"; static final String SQL2 = "select url,name from service where status=0"; %> <% if(optionList.equals("")){ Dbac ac = new Dbac(); Dbac ac2 = new Dbac(); Statement select = ac.getStatement(); Statement select2 = ac2.getStatement(); counter = 1; ResultSet rs = select.executeQuery(SQL1); while(rs.next()){ final int category_index = rs.getInt(1); final String category_name = rs.getString(2); optionList += "" + "\n"; counter++; } }ac.close(); ac2.close(); } %>
![]() |