📄 index.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>淳.清凉花坊</title>
<meta name="keywords" content="淳.清凉花坊">
<meta name="description" content="淳.清凉花坊">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style16 {font-size: 12px; color: #660000; }
.style18 {font-size: 12px}
.style20 {font-size: 14px; color: #660000; }
.style21 {font-size: 12px; color: #003300; }
.style27 {font-size: 14px; color: #000000; }
-->
</style>
</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;
}
%>
<% //获取session值，以及防止非法访问本页面
String userid= (String)session.getAttribute("userid");
userid=getString(userid);
%>
<body bgcolor="#FFFFFF" >
<table width="200" border="0" align="center">
<tr>
<td colspan="2"><table width="857" height="118" border="0" background="images/6xiang_166.gif">
<tr>
<td width="213" height="26" bgcolor="#FFFFFF"><img src="images/wel.gif"> </td>
<td width="64" bgcolor="#FFFFFF"><div align="center" class="style2 style18"><a href="index.jsp">花坊首页</a></div></td>
<td width="59" bgcolor="#FFFFFF"><div align="center" class="style2 style18"><a href="usercenter.jsp">会员中心</a></div></td>
<td width="67" bgcolor="#FFFFFF"><div align="center" class="style2 style18"><a href="login.jsp">会员登陆</a></div></td>
<td width="81" bgcolor="#FFFFFF"><div align="center" class="style2 style18"><a href="user_reg.jsp">新会员注册 </a></div></td>
<td width="73" bgcolor="#FFFFFF"><div align="center" class="style2 style18"><a href="cart.jsp">我的购物车</a></div></td>
<td width="70" bgcolor="#FFFFFF"><div align="center" class="style2 style18"><a href="help.jsp">帮助中心</a></div></td>
<td width="178"> </td>
</tr>
<tr>
<td height="15" colspan="8"> </td>
</tr>
<tr>
<td height="25" colspan="8"> </td>
</tr>
<tr>
<td colspan="8"> </td>
</tr>
</table>
</tr>
<tr>
<td width="120" height="224" valign="top">
<table width="108" align="center" >
<tr>
<td align="center"> </td>
</tr>
<tr>
<td height="65" align="center"><img src="images/behome1.gif" width="108" height="128"></td>
</tr>
<tr>
<td width="108" align="center"><a href="login.jsp" ><img src="images/1.jpg" width="108" height="42" border="0"></a></td>
</tr>
<tr>
<td align="center" ><img src="images/d2_03.gif" width="84" height="31"></td>
</tr>
<tr>
<td align="center" ><a href="usercenter.jsp"><img src="images/2.jpg" width="108" height="42" border="0"></a></td>
</tr>
<tr>
<td align="center" ><img src="images/d2_03.gif" width="84" height="31"></td>
</tr>
<tr>
<td align="center"><a href="order[1].jsp"><img src="images/3.jpg" width="108" height="42" border="0"></a></td>
</tr>
<tr>
<td align="center" ><img src="images/d2_03.gif" width="84" height="31"></td>
</tr>
<tr>
<td align="center"><a href="cart.jsp"><img src="images/4.jpg" width="108" height="42" border="0"></a></td>
</tr>
<tr>
<td align="center" ><img src="images/d2_03.gif" width="84" height="31"></td>
</tr>
<tr>
<td align="center"><a href="help.jsp"><img src="images/5.jpg" width="108" height="42" border="0"></a></td>
</tr>
<tr>
<td align="center"><img src="images/behome1.gif" width="108" height="128"></td>
</tr>
</table></td>
<td width="725" valign="top">
<table width=700 align=center cellpadding="0" bordercolor="#D4D0C8">
<td align="left"> <span class="style27"> 您的位置：<a href="index.jsp">HOME</a> >> 花坊首页 </span></td>
<form name="form1" method="post" action="sortquery.jsp"> <td align="right" ><font color="#003300" size="+0">鲜花类别：</font></td>
<td>
<select name="kind" class="input">
<option value="">未选择</option>
<option value="绿植">绿植</option>
<option value="瓶插">瓶插</option>
<option value="花盒">花盒</option>
<option value="花蓝">花蓝</option>
<option value="盆栽">盆栽</option>
<option value="组合花 " >组合花 </option>
</select></td><td align="left" ><input type="submit" name="Submit" value="搜索"></td>
</form>
</table>
<%int PageSize=4; //????????
int RowCount; //????
int PageCount; //???
int Page; //?????
int showPage;
int i,j,k;
String strPage = request.getParameter("showPage");
if (strPage==null){
//???QueryString???page?????,?????????
Page = 1;
} else{
//?????????
Page = Integer.parseInt(strPage);
if(Page<1) Page = 1;
}%>
<%
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
String condition="select count(*) from bouquet";
rs =sql.executeQuery(condition);
rs.next();
RowCount =rs.getInt(1);
rs.close();
PageCount = (RowCount+PageSize-1) / PageSize; //?????
if(Page>PageCount) Page = PageCount; //????????
String swe = "select * from bouquet order by bouquetid";
rs = sql.executeQuery(swe); //??SQL????????
i = (Page-1) * PageSize; //???????????????????
for(j=0;j<i;j++) rs.next(); %>
<%
String integer=request.getParameter("showPage");
if(integer==null)
{
integer="1";
}
try{showPage=Integer.parseInt(integer);
}
catch(NumberFormatException e1)
{
showPage=1;
}
if(showPage<=1)
{
showPage=1;
}
if(showPage>=PageCount)
{
showPage=PageCount;
}
%>
<table width=700 border="1" align=center cellpadding="0" cellspacing="1" bordercolor="#D4D0C8">
<td colspan="2" ><span class="style20">花坊现有鲜花列表(</span><span class="style14 style22 style23"><span class="style21">共<%=PageCount%>页</span><span class=" style20">):</span>
<div align="right" class="style21"><%if(showPage<2){%>
<span class="style14">首页</span>
<%}%><%else{%><a href="index.jsp?showPage=1" class="style14">首页</a>
<%}%>
<%if(showPage<2){%>
<span class="style14">上一页</span>
<%}%><%if(showPage>1){%>
<a href="index.jsp?showPage=<%=showPage-1%>" class="style14">上一页</a>
<%
}%><%if(showPage-PageCount>=0){%>
<span class="style14">下一页</span>
<%}%><%if(showPage<PageCount){%>
<a href="index.jsp?showPage=<%=showPage+1%>" class="style14">下一页</a>
<%
}
%> <%if(showPage-PageCount>=0){%>
<span class="style14">尾页</span>
<%}%><%else{%><a href="index.jsp?showPage=<%=PageCount%>" class="style14">尾页</a></div></td>
<%}%> <%
i = 0;
while(i<PageSize && rs.next()){
String ID = rs.getString("bouquetid");
String name=rs.getString("bouquetname");
String classify=rs.getString("classify");
float price=rs.getFloat("price");
String meaning=rs.getString("meaning");
String discript=rs.getString("discript");
String image=rs.getString("image");
%>
<tr> <td width='25%' height="196">
<table width='700' border='0' cellspacing='0' cellpadding='0' bgcolor='#FFFEFD'>
<tr>
<td height='18'align='center'> </td>
<td align='left'> </td>
</tr>
<tr>
<td height='18' width="129"align='center'><a href="item.jsp?id=<%=ID%>"><img width="110" leight="118" src="<%=image%>" border="0"> </A></td>
<td width="589"align='left'><span class="style16">花语：<%=meaning%></span></td>
</tr>
<tr>
<td height='18' align='center'><font color="#660000" size="-1"><a href="item.jsp?id=<%=ID%>"><%=name%> </A></font></td>
<td width="589" rowspan="3"align='left' class="style16">鲜花描述信息：<%=discript%></td>
</tr>
<tr>
<td height='18' align='center'> <font color="#660000" size="-1"> 编 号:<%=ID%></font></td>
</tr>
<tr>
<td height='18' align='center'><font color="#660000" size="-1">购买价格:<%=price%></font></td>
</tr>
</table>
</td>
<% i++; }
%>
</table>
<p> </p>
<p>
<% con.close();}
catch(SQLException e) { }
%>
</p>
</td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -