디지털피아노의 대명사 다이나톤

<%@ page contentType="text/html; charset=euc-kr" language="java" import="java.sql.*" errorPage="/include/error.jsp" session="true" %> <%@ include file = "/include/dbconnect.jsp"%> <%-- 데이터 베이스 연결 --%> <%-- 커넥션 변수 Conn --%> <% java.sql.Statement stmt = null; ResultSet rs = null; int nIndex=0; if(request.getParameter("productid") == null) throw new Exception("선택된 제품이 없습니다."); else nIndex = Integer.parseInt(request.getParameter("productid")); String strQueryProduct="Select image,largeimage,productmodel,productcode,catalog from t_product where productid=" + nIndex; String strQueryDetail= "Select subtitle, description from t_productdetail where productid=" + nIndex + " order by orders"; String strImage="/webapps/img/noimage.gif"; String strLargeImage="/webapps/img/noimage.gif"; String strModel=""; String strCode=""; String strCatalog=""; String strTitleImage=""; stmt = conn.createStatement(); rs = stmt.executeQuery(strQueryProduct); if(!rs.next()) throw new Exception("선택된 제품이 없습니다."); if(rs.getString("image") !=null && rs.getString("image").length() >=1) strImage=rs.getString("image"); if(rs.getString("largeimage") !=null && rs.getString("largeimage").length() >=1) strLargeImage=rs.getString("largeimage"); if(rs.getString("productmodel") !=null && rs.getString("productmodel").length() >=1) strModel=rs.getString("productmodel"); if(rs.getString("productcode") !=null && rs.getString("productmodel").length() >=1) strCode=rs.getString("productcode"); if(rs.getString("catalog") !=null && rs.getString("catalog").length() >=1) strCatalog=rs.getString("catalog"); if(strCode.equals("a")) { strTitleImage = "/webapps/img/product/pro-title1.gif"; } else if(strCode.equals("b")) { strTitleImage = "/webapps/img/product/pro-title2.gif"; } else if(strCode.equals("c")) { strTitleImage = "/webapps/img/product/pro-title3.gif"; } else if(strCode.equals("d")) { strTitleImage = "/webapps/img/product/pro-title4.gif"; } else if(strCode.equals("e")) { strTitleImage = "/webapps/img/product/pro-title5.gif"; } else if(strCode.equals("f")) { strTitleImage = "/webapps/img/product/pro-title6.gif"; } else { strTitleImage = "/webapps/img/product/pro-title1.gif"; } rs.close(); rs = stmt.executeQuery(strQueryDetail); %> 디지털피아노의 대명사 다이나톤

<%@ include file="/include/bottom.jsp" %>

<%@ include file="/include/top.jsp" %> <%@ include file="/include/flash_product.jsp" %>

<%@ include file="/include/login.jsp" %> <%@ include file="/include/search.jsp" %> <%@ include file="/include/product_menu.jsp" %>

Home > 제품소개

border=0>

<% if (strCatalog != "") { %> <% } %> <% if((strCode.equals("a")) || (strCode.equals("b")) ) { %> <% } %>

<%=strModel%>

<% while(rs.next()) { out.print(rs.getString("subtitle") + "

"); out.print(rs.getString("description") + "

"); } rs.close(); stmt.close(); %>

&productid=<%=nIndex%>>

<%@ include file = "/include/dbclose.jsp"%>