?? left.jsp
字號:
<%@ include file="top.jsp"%>
<td width="181">
<!--'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''用戶信息和登陸''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''-->
<table width="180" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td valign="top">
<table border="0" width="180" cellspacing="0" cellpadding="0" height="18">
<%
//是否登陸
if((String)session.getValue("user_name")!=null)
{
%>
<tr>
<% sql="select * from member where user_name='"+(String)session.getValue("user_name")+"'";
rs=mdb.executeQuery(sql);
%>
</tr>
<tr>
<td width="100%" height="18">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#ECECEC" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td>
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td width="86%" height="20" bgcolor="#989DA5">
<div align="center"><b>用戶信息</b></div>
</td>
</tr>
<tr>
<td>
<table border="0" width="100%" cellspacing="0" bgcolor="#ECECEC" style="border-collapse: collapse" bordercolor="#111111" cellpadding="0">
<tr>
<td width="100%" colspan="2" bgcolor="#FFFFFF">
</td>
</tr>
<tr>
<td height="25" bgcolor="#ECECEC" valign="top">
<img src="img/pics/main_head_menu002.gif" width="13" height="13" align="absmiddle">
用戶名:</td>
<td height="25" bgcolor="#ECECEC"><%=rs.getString("user_name")%></td>
</tr>
<tr>
<td height="25" bgcolor="#ECECEC" valign="top"><img src="img/pics/main_head_menu004.gif" width="13" height="13" align="absmiddle">
地址:</td>
<td height="25" bgcolor="#ECECEC"><%=rs.getString("user_adds")%></td>
</tr>
<tr>
<td height="25" bgcolor="#ECECEC" valign="top"><img src="img/pics/main_head_menu001.gif" width="13" height="13" align="absmiddle"> E-mail:</td>
<td height="25" bgcolor="#ECECEC"><%=rs.getString("user_mail")%></td>
</tr>
<tr>
<td height="25" bgcolor="#ECECEC" valign="top"><img src="img/pics/main_head_menu005.gif" width="13" height="13" align="absmiddle">
電話:</td>
<td height="25" bgcolor="#ECECEC"><%=rs.getString("user_tel")%></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
</td>
</tr>
<%
}else
//沒有登陸
{
%>
<tr>
<td width="100%" height="18">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> </tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#ECECEC" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td align="center">
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td width="86%" align="center" height="20" bgcolor="#989DA5"><b>用戶登陸</b></td>
</tr>
<form method="POST" action="login.jsp">
<tr>
<td height="110" bgcolor="#ECECEC">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td width="32%" bgcolor="#ECECEC">
<div align="center">客戶：</div>
</td>
<td width="68%" bgcolor="#ECECEC">
<div align="center">
<input name="user_name" type="text" class=input id="user_name" style="FONT-SIZE: 12px; WIDTH: 110px" size="10" maxlength="18">
</div>
</td>
</tr>
<tr>
<td bgcolor="#ECECEC">
<div align="center">密碼：</div>
</td>
<td bgcolor="#ECECEC">
<div align="center">
<input style="FONT-SIZE: 12px; WIDTH: 110px" type="password" name="user_pass" size="10" class=input maxlength="18">
</div>
</td>
</tr>
</table>
<div align="center"></div>
<div align="center">
<center>
<table width="90%" border="0" cellspacing="0" cellpadding="0" bgcolor="#ECECEC" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td width="80"><a href="reg.jsp" target="_blank"><img src="img/pics/reg.gif" width="81" height="25" border="0"></a></td>
<td>
<div align="center">
<input
align=absMiddle alt=進入 cache name=submit2
src="img/pics/login.gif" type=image tppabs="" width="56" height="25">
</div>
</td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</form>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<%
}//判斷登陸結束
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!--'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''用戶信息和登陸結束''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''-->
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="5">
<tr>
<td></td>
</tr>
<tr>
<td></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td bgcolor="#989DA5" height="20" align="center"><b>型號搜索</b></td>
</tr>
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table border="0" width="100%" cellspacing="0" height="70">
<tr>
<td height="28" bgcolor="#ECECEC" align="center">輸入商品關鍵字查詢商品信息</td>
</tr>
<tr>
<form method="POST" action="search.jsp">
<td valign="top" bgcolor="#ECECEC">
<input type="text" name="hw_name" size="15" class=input>
<input type="image" border="0" name="imageField" src="img/serarch.gif" width="34" height="20">
</td>
</form>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="5">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#ECECEC" style="border-collapse: collapse" bordercolor="#111111">
<tr>
<td height="18">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="23">
<tr>
<td align="center" height="4">
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td align="center" height="19" bgcolor="#989DA5"> <b>商品分類</b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111" height="16">
<tr>
<td valign="top" height="16">
<%
sql="select * from sort";
rs=mdb.executeQuery(sql);
if(!rs.next()){
out.print("沒有任何分類");
}
else
{
while(rs.next())
{
%>
<table cellspacing=0 cellpadding=0 width=95% background=""
border=0>
<tbody>
<tr height=22>
<td width=34 align="center"><img
src="img/dot.gif" width="15" height="15"></td>
<td width="124"><a href="sort.jsp?sort_id=<%=rs.getInt("sort_id")%>"><u><%=rs.getString("sort_name")%></u></a></td>
</tr>
</tbody>
</table>
<%
}
}
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0" height="18">
<tr>
<td align="center">
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td align="center" height="20" bgcolor="#989DA5"> <b>站內公告</b></td>
</tr><tr>
<td bgcolor="#ECECEC">
<%
sql="select * from pub order by ID DESC limit 0,3";
rs=mdb.executeQuery(sql);
if(!rs.next())
{
%>
<p style="margin:0 5; ">暫無公告<br>
<%
}
int i=0;
while(rs.next())
{
i=i+1;
%>
<p style="margin:5; "><b><%=rs.getString("title")%></b><br>
<%=rs.getString("msg")%> <br>
<%=rs.getDate("date")%></p>
<%
if(i>=3){
break;
}
}
%></td></tr></table>
</td>
</tr>
<tr>
</table>
</td>
</tr>
</table>
</td>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -