<%@page contentType="text/html;charset=utf-8"
import="java.sql.*,java.util.*,jerehnet.jsp.database.*,jerehnet.jsp.util.*,java.text.SimpleDateFormat,java.util.regex.Matcher,java.util.regex.Pattern"%>
<%
PoolManager pool = new PoolManager();
if (pool == null) {
pool = new PoolManager();
}
Connection conn = null;
DataManager db = new DataManager();
try {
conn = pool.getConnection();
String no=Common.getFormatStr(request.getParameter("prono"));
String sql="select pro.*,ch.name as type,ch.no as partno,ch.parent_no as parentno from jrcms_products pro left join jrcms_website_channel ch on ch.no=pro.channel_node where pro.id="+no;
ResultSet prs = db.executeQuery(conn,sql);
String proname="";String protype="";String partno="";
String parentNo="";
if(prs!=null&&prs.next()){
proname=Common.getFormatStr(prs.getString("type"));
partno=Common.getFormatStr(prs.getString("partno"));
parentNo=Common.getFormatStr(prs.getString("parentno"));
}
String parentsql=" select * from jrcms_website_channel where website_no='20150623163145344' and no='"+parentNo+"'";
ResultSet parentrs = db.executeQuery(conn,parentsql);
if(parentrs!=null&&parentrs.next()){
protype=Common.getFormatStr(parentrs.getString("name"));
}
%>
产品订单_奥特