📄 search.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="shop.logBean"%>
<%@ page import="java.sql.*"%>
<%!
public String codeString(String s){
String str=s;
try{
byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}catch(Exception e){return str;}
}
%>
<body bgcolor=#C0C0C0>
<%
if(session.isNew()){
%>
<jsp:forward page="index.jsp"/>
<%
}
else{
%>
<jsp:useBean id="log" class="shop.logBean" scope="session"/>
<%
String islog=log.getIslog();
if(!islog.equals("true")){
%>
<jsp:forward page="index.jsp"/>
<%
}
else{
%>
<center>
<jsp:getProperty name="log" property="id"/>
,商品查看页面
<%
if(log.getId().equals("admini")){
%>
<jsp:include page="adminihead.txt"/>
<%
}
else{
%>
<jsp:include page="head.txt"/>
<%
}
%>
</center>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con;
Statement sql;
ResultSet rs;
String id;
String type;
String name;
float price;
long amount;
String distr;
String product;
con=DriverManager.getConnection("jdbc:odbc:myshop","","");
sql=con.createStatement();
String condition="SELECT * FROM goods ";
rs=sql.executeQuery(condition);
int rowcount=0;
%>
<center>
<table width="800" bgcolor="#C0C0C0" >
<tr>
<td ><table border="1" width="800">
<td width="100" valign="middle" align="center">商品</td>
<td width="100" valign="middle" align="center">类型</td>
<td width="100" valign="middle" align="center">余量</td>
<td width="100" valign="middle" align="center">价格</td>
<td width="100" valign="middle" align="center">产地</td>
<td width="100" valign="middle" align="center">介绍</td>
<td width="100" valign="middle" align="center">数量</td>
<td width="100" valign="middle" align="center">购入</td>
</table></td>
</tr>
<%
while(rs.next()){
rowcount++;
id=rs.getString("id");
type=rs.getString("type");
name=rs.getString("name");
price=rs.getFloat("price");
amount=rs.getLong("amount");
distr=rs.getString("distr");
if(distr==null)distr="";
if(distr.equals(""))distr="无信息";
product=rs.getString("product");
if(product==null)product="";
if(product.equals(""))product="无信息";
%>
<tr>
<td><table border="1" width="800" height="50">
<form action="cart.jsp" method="post" name="form_<%=id%>">
<td width="100" valign="middle" align="center"><a href="img/<%=id%>.jpg"><img src="img/<%=id%>.jpg" width="100" height="100"></a></td>
<td width="100" valign="middle" align="center"><%=type%></td>
<td width="100" valign="middle" align="center"><%=amount%></td>
<td width="100" valign="middle" align="center"><%=price%></td>
<td width="100" valign="middle" align="center"><%=product%></td>
<td width="100" valign="middle" align="center"><%=distr%></td>
<td width="100" valign="middle" align="center">
<%
if(!log.getId().equals("admini"))
out.println("<input type=text maxlength=2 name=text size=4>");
%>
</td>
<td width="100" valign="middle" align="center">
<%
if(!log.getId().equals("admini"))
out.println("<input type=submit name=submit value=购入>");
%>
</td>
<input type=hidden name="hidden" value="<%=name%>">
</form>
</table></td>
</tr>
<%
}
%>
</table>
</center>
<%
con.close();
}catch(SQLException e){
%>
<jsp:forward page="index.jsp"/>
<%
}catch(ClassNotFoundException e){
%>
<jsp:forward page="index.jsp"/>
<%
}
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -