在线搜索

来源:互联网 发布:sql删除表中带约束的列 编辑:程序博客网 时间:2024/04/18 17:04
在这个jsp页直接去调用。ConnectionDB类,从而去数据库去查找。并显示在页面中!

<%@ page language="java" import="java.util.*,javabean.*" pageEncoding="UTF-8"%>
<center><%@ include file="top.html"%></center>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  
<head>
    
<base href="<%=basePath%>">
    
    
<title>搜索的商品有如下:</title>
    
    
<meta http-equiv="pragma" content="no-cache">
    
<meta http-equiv="cache-control" content="no-cache">
    
<meta http-equiv="expires" content="0">
    
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    
<meta http-equiv="description" content="This is my page">
    
    
<!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    
-->
  
</head>
  
  
<body><br>
    
<CENTER><FONT color=red size=4>搜索的商品有如下:</font></CENTER>
    
<table border=1 cellspacing=0 bgcolor="#ffccff" align=center width=80%>
       
<tr>
     
<TD align=center>商品编号</TD><TD align=center>商品名称</TD><TD align=center>商品类型</TD>
     
<TD align=center>商品单价</TD><TD align=center>我要买</TD>
     
</tr>
      
<%
        request.setCharacterEncoding(
"gb2312");
        response.setContentType(
"text/html;charset=gb2312");
        ConnectionDB con 
= new ConnectionDB();
        Vector v
=(Vector)session.getAttribute("v");
        
if(v.size()==0){
          out.println(
"<br><br><center>");
          out.println(
"<h1> <font color='red'>  对不起!没有找到您所需要的商品!</font></h1>");
          out.println(
"<A href='jsp/Checkout.jsp'>返回购物主页</A>");
          out.println(
"<br><br></center>");
          out.close();
        }
        Iterator it
=v.iterator();
        Goods goods
=null;
        
while(it.hasNext()){
           goods
=(Goods)it.next();
      
%>     
    
<tr>
    
<TD align=center><%=goods.getId()%></TD>
    
<TD align=center><%=goods.getName()%></TD>
    
<TD align=center><%=goods.getType()%></TD>
    
<TD align=center><%=goods.getPrice()%></TD>
    
<TD align=center><form action="jsp/goods_show.jsp" method=post>
        
<input type=hidden name=id value=<%=goods.getId()%>>
        
<input type=hidden name=name value=<%=goods.getName()%>>
        
<input type=hidden name=type value=<%=goods.getType()%>>
        
<input type=hidden name=price value=<%=goods.getPrice()%>>
        
<input type=submit value="购买">
        
</form>
    
</TD>
    
</tr>
    
<%}%>
   
</table> <br>
         
<CENTER>
             
<href="jsp/Checkout.jsp">返回购物主页</A>
         
</CENTER>    
        
        
      
  
</body>
</html>
 
原创粉丝点击