Advanced Finder

Manufacturer / Dealer Find

Product (Min. 3 characters)   City (Min. 3 characters)

Or

Product Find

Product (Min. 3 characters) City (Min. 3 characters) Category All <% java.sql.ResultSet rsp = null; java.sql.Connection conp = null; java.sql.Statement stmtp = null; %> <% try { conp=com.ipf.global.app.IPFDBUtils.getConnection(); stmtp = conp.createStatement(); rsp=stmtp.executeQuery("select cgrfnbr,cgname from category where cgrfnbr in(select crccgnbr from cgryrel where crpcgnbr is null) order by cgname"); while(rsp.next()) { %> <%= rsp.getString("cgname") %> <%} } catch(Exception e) { e.printStackTrace(); response.sendRedirect("/Error/error.jsp"); } finally { try { if(rsp!=null) {rsp.close(); rsp=null;} if(stmtp!=null) {stmtp.close(); stmtp=null;} if(conp!=null) {conp.close(); conp=null;} } catch(Exception e) {// this catch block will be empty } }%>