📄 index.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<jsp:useBean id="conn" scope="page" class="myshop.conn"/>
<%!
String sql = "";
int totalRecords = 1;
ResultSet rs = null;
ResultSet rsTmp = null;
%>
<%@ page contentType="text/html;charset=GBK" %>
<%
int Counter = 0;
// 得到所有的Cookie
Cookie cookies[] = request.getCookies();
if(cookies != null) {
for(int i=0; i<cookies.length; i++) {
if(cookies[i].getName().equals("Counter"))
Counter = Integer.parseInt(cookies[i].getValue()) + 1;
}
}
// 首次登陆，需要创建Cookie ； 以后登陆，需更新Cookie
Cookie c = new Cookie("Counter", ""+Counter);
c.setMaxAge(60*60*24*365); // Cookie 的有效期为 1 年
response.addCookie(c);
%>
<html>
<head>
<title>网络小店</title>
</head>
<body bgcolor="#FFFFFF" background="image/1.jpg">
<%
if(Counter == 0) {
out.println("<Script>");
out.println("alert('欢迎首次光临！')");
out.println("</Script>");
}
else {
out.println("<Script>");
out.println("alert('您已经光临了" + Counter + " 次')");
out.println("</Script>");
}
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="myshop.css">
<Script language="JavaScript">
//打开新窗口函数NewsWindow
function NewsWindow(id)
{
window.open('myshopwind.jsp?id='+id,'infoWin', 'height=400,width=600,scrollbars=yes,resizable=yes');
}
</Script>
<FONT SIZE="5" COLOR="#FF6633">
<h1 align="center"><B>~~~~网络小店~~~~</B></h1></FONT>
<hr>
<table width="80%"><font color="#000000">
<tr>
<td><a href="login.jsp"><font color="#6600FF">管理员登录</font></a></td>
<td><a href="cart.jsp"><font color="#6600FF">查看购物车</font></a></td>
<td><a href="che.jsp"><font color="#6600FF">添加购物车</font></a></td>
</tr>
</font></table>
<hr>
<table width = "%70"><FONT SIZE="3" COLOR="#CC0000"><div align="left">
<B>小店简介</B>:
<pre> 本店新开张，产品质量优良，价格合理，均为出厂销售，货源充足。欢迎新老顾客咨询。
手机：13560402104 QQ：63506991
</pre> </div></FONT></table>
<%
rsTmp = conn.executeQuery("select count(id) as countid from goods");
rsTmp.next();
totalRecords = rsTmp.getInt("countid");
rsTmp.close();
sql="SELECT * from goods order by ID desc";
rs = conn.executeQuery( sql );
if(!rs.next()) {
out.println("<p>还 没 有 任 何 商品</p>");
} else {
%>
<p><strong>全部商品</strong><table border=1 borderColorDark=#ffffec borderColorLight=#5e5e00 cellPadding=1 cellSpacing=0 width=85% ><br>
<tr bgcolor=cccccc align=center><td>商品名称</td><td>单价(元）</td><td>生产厂家</td><td>生产日期</td><td>数量</td></tr>
<%
int cc = 1;
do {
// 不同行之间以不同颜色显示
if(cc % 2 == 1)
out.println("<tr bgcolor=#E7E7E7>");
else
out.println("<tr BGCOLOR=#F4F4F4>");
%>
<td><a href="javascript:NewsWindow(<%=rs.getInt("ID")%>)"><u>
<%=rs.getString("shopname")%></u></a></td>
<td><%=rs.getString("price")%></td>
<td><%=rs.getString("factory")%></td>
<td><%=rs.getDate("times").toString()%></td>
<td><%=rs.getString("number")%></td>
<%
out.println("</td></tr>");
cc++;
} while(rs.next());
out.println("</table><p>共" + totalRecords + "件商品");
}
rs.close();
%>
<br><br><br>
<hr>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -