📄 index.jsp~6~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.wgh.DB.connDB" %>
<%
connDB conn=new connDB();
ResultSet rs_bbs=conn.executeQuery("select top 5 * from tb_bbs order by INTime desc");
ResultSet rs_sort=conn.executeQuery("select GoodsID,GoodsName, sum(number) as sumNum from V_order_detail group by GoodsName,GoodsID order by sumNum desc");
ResultSet rs_superType=conn.executeQuery("select ID,superType from V_Type group by ID,superType order by superType desc");
ResultSet rs_sale=conn.executeQuery("select top 2 ID,GoodsName,price,nowprice,picture from tb_goods where sale=1 order by INTime desc");
int sale_ID=0;
String s_goodsname="";
float s_price=0;
float s_nowprice=0;
String s_picture="";
ResultSet rs_new=conn.executeQuery("select top 4 ID,GoodsName,nowprice,introduce,picture from tb_goods where newGoods=1 order by INTime desc");
int new_ID=0;
String new_goodsname="";
float new_nowprice=0;
String new_introduce="";
String new_picture="";
if(new_introduce.length()>10){
new_introduce=new_introduce.substring(20)+"...";
}
%>
<html>
<head>
<title>Go购电子商城</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="CSS/style.css" rel="stylesheet">
</head>
<body>
<table width="790" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td class="tableBorder">
<table width="790" height="115" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#CCCCCC" height="6px"></td>
</tr>
</table>
<table width="100%" height="109" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="25%"><img src="images/shop_02.gif" width="275" height="109"></td>
<td width="75%"><table width="100%" height="109" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="52" align="right" valign="top"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0">
<tr align="center">
<td width="281"> </td>
<td width="7" valign="top"><img src="images/T_contact.gif" width="42" height="28"></td>
<td width="72"><a href="mailto:mingrisoft@mingrisoft.com">联系我们</a></td>
<td width="10" valign="top"><img src="images/T_favorite.gif" width="42" height="28"></td>
<td width="68"><a href="javascript:window.external.AddFavorite('http://www.mingrisoft.com','明日科技')">收藏本站</a></td>
<td width="10" valign="top"><img src="images/T_home.gif" width="42" height="28"></td>
<td width="70"><a href="#" onclick="this.style.behavior='url(#default#homepage)';this.sethomepage('http://www.mingrisoft.com')">设为首页</a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="57" valign="top" background="images/shop_07.gif"><table width="100%" height="53" border="0" cellpadding="0" cellspacing="0">
<tr align="center">
<td width="9%"><a href="index.jsp">首页<br>
Index</a></td>
<td width="2%"><img src="images/shop_09.gif" width="3" height="57"></td>
<td width="15%"><a href="NewGoods.jsp">新品上架<br>
NewGoods</a></td>
<td width="1%"><img src="images/shop_09.gif" width="3" height="57"></td>
<td width="14%"><a href="sale.jsp">特价商品<br>
At a sale</a></td>
<td width="1%"><img src="images/shop_09.gif" width="3" height="57"></td>
<td width="13%"><a href="Member.jsp">会员管理<br>
Member</a></td>
<td width="4%"><img src="images/shop_09.gif" width="3" height="57"></td>
<td width="11%"><a href="cart_see.jsp">购物车<br>
Cart</a></td>
<td width="1%"><img src="images/shop_09.gif" width="3" height="57"></td>
<td width="15%"><a href="order.jsp">订单管理<br>
Order</a></td>
<td width="1%"><img src="images/shop_09.gif" width="3" height="57"></td>
<td width="11%"><a href="SellSort.jsp">销售排行<br>
SellSort</a></td>
<td width="2%"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="790" height="236" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="182" height="182" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="83" align="center"><img src="images/shop_11.gif" width="182" height="83"></td>
</tr>
<tr>
<td height="98" align="center" background="images/shop_17.gif"> <form name="form1" method="post" action="Login_U.jsp">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10%"> </td>
<td width="90%" valign="top" background="Images/index_09.gif"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="94%" height="24">会员名
<input name="username" type="text" class="txt_grey" id="username" size="16"></td>
<td width="6%"> </td>
</tr>
<tr>
<td height="24">密 码
<input name="PWD" type="password" class="txt_grey" id="PWD" size="16" onKeydown="if(event.keyCode==13) form1.submit();"></td>
<td> </td>
</tr>
<tr>
<td height="31">
<input name="Button" type="button" class="btn_grey" value="注册" onClick="window.location.href='register.jsp'">
<input name="Submit2" type="button" class="btn_grey" value="登录" onClick="checkU(form1)"> <input name="Submit3" type="reset" class="btn_grey" value="重置"></td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</form></td>
</tr>
</table>
<table width="100%" height="155" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/shop_22.gif" width="182" height="58"></td>
</tr>
<tr>
<td height="97" align="center" valign="top" class="tableBorder_l"><table width="88%" border="0" cellspacing="0" cellpadding="0">
<%
int ID_bbs=0;
String title="";
while(rs_bbs.next()){
ID_bbs=rs_bbs.getInt(1);
title=rs_bbs.getString(2);
%>
<tr>
<td height="24" class="tableBorder_T_dashed"><a href="bbs_detail.jsp?ID=<%=ID_bbs%>"><%=title%></a></td>
</tr>
<% }%>
</table></td>
</tr>
</table>
<table width="100%" height="151" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="40" background="images/shop_33.gif"> </td>
</tr>
<tr>
<td align="center" valign="top" class="tableBorder_lb"><table width="88%" border="0" cellspacing="0" cellpadding="0">
<%
int ID_sort=0;
String goodsname="";
while(rs_sort.next()){
ID_sort=rs_sort.getInt(1);
goodsname=rs_sort.getString(2);
%>
<tr>
<td height="20" class="tableBorder_B_dashed"><a href="goods_detail.jsp?ID=<%=ID_sort%>"><%=goodsname%></a></td>
</tr>
<%}%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table></td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="33" background="images/shop_12.gif"></td>
<td width="505" height="33" align="right" valign="middle" background="images/shop_12.gif"><table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="8"></td>
</tr>
<tr>
<td align="right" class="word_green"><marquee direction="left" scrollamount="1" scrolldelay="1">^_^ 顾客您好！购买商品请先登录 <a href="register.jsp" class="word_green">[新用户注册]</a></marquee></td>
</tr>
</table></td>
<td width="10" background="images/shop_12.gif"> </td>
</tr>
<tr>
<td width="93" height="50" background="images/shop_15.gif"> </td>
<td colspan="2" background="images/shop_16.gif">
<form name="form2" method="post" action="search_deal.jsp">
<table width="100%" height="23" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2" height="7"></td>
</tr>
<tr>
<td width="85%">请输入查询条件：
<select name="select" class="textarea">
<option value="all" selected>全部分类</option>
</select> <input name="bookkey" type="text" class="txt_grey" size="33"> </td>
<td width="15%"><input name="search" type="submit" class="btn_grey" value="搜索"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="69%" height="189" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="98%" height="80" background="images/shop_18.gif"> </td>
<td width="2%"><img src="images/shop_19.gif" width="10" height="80"></td>
</tr>
<tr align="center" valign="top">
<td height="134" colspan="2"><table width="100%" height="162" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="49%" height="162" valign="top">
<%int s=1;
while (rs_sale.next()){
sale_ID=rs_sale.getInt(1);
s_goodsname=rs_sale.getString(2);
s_price=rs_sale.getFloat(3);
s_nowprice=rs_sale.getFloat(4);
s_picture=rs_sale.getString(5);
if(s%2==1){
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -