📄 item.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="bouquetbean.*"%>
<jsp:useBean class="bouquetbean.BouquetBean" id="bouquet" scope="page"></jsp:useBean>
<head>
<title>淳.清凉花坊鲜花礼品网</title>
<meta name="keywords" content="淳.清凉花坊鲜花礼品网">
<meta name="description" content="淳.清凉花坊鲜花礼品网">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<!--
.style3 {
font-size: 10pt;
font-weight: bold;
color: #F6EDEA;
}
.style6 {color: #999999}
.style7 {
color: #333333;
font-weight: bold;
}
-->
</style>
<SCRIPT language="JavaScript">
<!--
function openwin(str)
{ window.open("addcart.jsp?id="+str,
"cart","width=300,height=200,resizable=1,scrollbars=2");
return;
}
//-->
</SCRIPT>
</head>
<%! //处理字符串的常用方法
public String getString(String s) {
if(s == null) s = "";
try{
byte a[] = s.getBytes("ISO-8859-1");
s = new String(a);
}
catch(Exception e) { }
return s;
}
%>
<%
if(session.isNew())
{
%>
<script language="javascript">
alert("请您登陆鲜花网首页!");
</script>
<%
response.sendRedirect("login.jsp");
}
else //获取session值，以及防止非法访问本页面
{ String userid= (String)session.getAttribute("userid");
String password= (String)session.getAttribute("password");
userid=getString(userid);
password=getString(password);
%>
<% String bouquetid=(String)request.getParameter("id");
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { System.out.print("runing here"); }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
String condition="select * from bouquet where bouquetid='"+bouquetid+"'";
rs=sql.executeQuery(condition);
while(rs.next())
{
String ID=rs.getString("bouquetid");
String name=rs.getString("bouquetname");
String classify=rs.getString("classify");
float price=rs.getFloat("price");
// int storage=rs.getInt("phone");
String meaning=rs.getString("meaning");
String discript=rs.getString("discript");
String image=rs.getString("image") ;
%>
<body bgcolor="#FFFFFF" >
<table width="858" border="0" align="center" cellspacing="0" cellpadding="0">
<tr>
<td width="686" height="903" align="center" valign="top">
<table width="639" height="889" border="1" cellpadding="0" cellspacing="0" bordercolor="#009900" id="Table_06">
<tr>
</tr>
<tr>
<td width="360" height="115">
<img src="images/4_img1.jpg" width="108" height="109" align="absmiddle"><font size="2">您的位置：<a href="index.jsp">HOME</a> 查看商品详细信息</font></td>
<td width="261" height="115" align="left" ><p>
<font size="2" color="#800080"> <img border="0" src="images/6xiang_06.gif" width="24" height="23">订购电话:0429-2492870</font></p>
<p><font size="2" color="#800080"> <img border="0" src="images/6xiang_06.gif" width="24" height="23">
email:chun.qingliang@163.com</font></p>
<p><font size="2" color="#800080"> <img border="0" src="images/6xiang_06.gif" width="24" height="23">
QQ客服:137846162 598840843</font></p></td>
</tr>
<tr>
<td height="756" colspan="2" align="center" valign="top" bordercolor="#00CC00"><br>
<table width="100%" border="0" cellpadding="2" cellspacing="1">
<tr valign="middle" bgcolor="#ECE9D8">
<td height="320" colspan="3" align="center" bgcolor="#FFFFFF"><img src="<%=image%>" width="320" height="320" border="0"><br>
<br>
<span class="style6">因地区差异等原因，实物可能会与图片略有差别。 </span></td>
</tr>
<tr bgcolor="#EEE2D2">
<td width="25%" height="25" align="right">商品名称：</td>
<td colspan="2"><font color="#660033"><%=name%></font></td>
</tr>
<tr bgcolor="#F7F1EA">
<td height="25" align="right" bgcolor="#F7F1EA">商品编号：</td>
<td align="left"><font color="#660033">【<%=ID%>】</font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td height="25" align="right">市 场 价：</td>
<td width="44%">￥<font color="#FF0000"><%=price%> </font></td>
<td width="31%" align="center"><a href='javascript:openwin("<%=ID %>")'><img src="images/cart.gif" width="75" height="15" border="0"></a></td>
</tr>
<tr bgcolor="#EEE2D2">
<td height="25" align="right">商品简介：</td>
<td colspan="2" style="line-height:20px; "><font color="#660033"><%=discript%></font></td>
</tr>
<tr bgcolor="#F7F1EA">
<td height="25" align="right" bgcolor="#F7F1EA">清凉花语：</td>
<td colspan="2" style="line-height:20px; "><font color="#660033"><%=meaning%></font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td height="25" align="right">主料分类：</td>
<td colspan="2"><%=classify %></td>
</tr>
<tr bgcolor="#F7F1EA">
<td height="25" align="right"><span class="style7">替换原则：</span></td>
<td height="50" colspan="2" bgcolor="#F7F1EA" style="line-height:19px; ">
假如由于地域或季节的限制，本站鲜花产品需要更换主花材时，我们将使用Mail或Tel向订货人提出更换建议，假如在有效配送时间内得不到订货人的确认，我们将采用同等价值或相同寓意的花材代替。
</td>
</tr>
<tr bgcolor="#EEE2D2">
<td height="25" align="right"><span class="style7">本站贴士：</span></td>
<td height="50" colspan="2" bgcolor="#EEE2D2" style="line-height:19px; ">
非节日期间，可指定时间段送达；并且允许指定送达收货人的最快时间为三小时；节日期间，只能够保证当日送达。
</td>
</tr>
<tr bgcolor="#F7F1EA">
<td height="25" align="right"><span class="style7">客户服务：</span></td>
<td height="90" colspan="2" bgcolor="#F7F1EA" style="line-height:19px; ">
<font size="2">星期一至星期天： 上午 9：00 至 晚上 24：00 <br>
客服热线：0429-84301986 <br>
短信订购：13258143962<br>
客服QQ：137846162 598840843<br>
邮件订购：chun.qingliang@163.com<br>
</font>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</form>
<%
con.close();
}
}
catch(SQLException e1) { System.out.println("where");}
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -