📄 shangpinchaxun.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>商品查询</title>
<style type="text/css">
<!--
body {
}
.style1 {font-family: "华文行楷"}
.style2 {font-family: "华文中宋"}
.style8 { color: #3333FF;
font-size: 18px;
font-family: "幼圆";
}
.style7 {font-family: "幼圆"; font-size: 18px; color: #0000FF; }
.style8 {font-family: "幼圆"; font-size: 18px; }
-->
</style></head>
<body bgcolor="#99CCFF" text="#000000" link="#750385">
<form name="form1" method="post" action="">
<table width="1000" height="162" align="center">
<tr>
<td height="97"><div align="center"><span class="style1 style16"></span></div></td>
</tr>
<tr>
<td><div align="center" class="style2"></div></td>
</tr>
<tr>
<td><%@page import="java.sql.*"%>
<%@page contentType="text/html;charset=gb2312"%></td>
</tr>
<tr>
<td><table width="762" height="183" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#006699">
<tr bgcolor="#E3E4E8" class="style16">
<td width="164"><div align="center"><span class="style25">产品图片</span></div></td>
<td width="112" height="30"><div align="center" class="style19">
<div align="center">商品类型</div>
</div></td>
<td width="122" height="30"><div align="center" class="style19">
<div align="center">商品型号</div>
</div></td>
<td width="118" class="style16 style21"><div align="center" class="style23">
<div align="center">卖家</div>
</div></td>
<td width="118" class="style16"><div align="center" class="style23">
<div align="center">地点</div>
</div></td>
<td width="114"><div align="center" class="style23">
<div align="center">价格</div>
</div></td>
</tr>
<%
String name=new String(request.getParameter("select"));
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr="jdbc:odbc:f";
String sql="select image,leixing,xinghao,maijia,didian,jiage from product where leixing like ";
try
{
Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
}
try
{
Connection conn=DriverManager.getConnection(ConnStr," "," ");
ResultSet rs;
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql+"'"+name+"'");
while(rs.next())
{String xinghao=rs.getString(3);
%>
<tr>
<td><div align="center"><img src="<%=rs.getString(1)%>" width="150" height="144"></div></td>
<td><div align="center"><%=rs.getString(2)%></div></td>
<td height="138"><div align="center"><%=xinghao%></div></td>
<td><div align="center"><%=rs.getString(4)%></div></td>
<td><div align="center"><%=rs.getString(5)%></div></td>
<td><div align="center"><span class="style13">￥</span> <%=rs.getString(6)%> 元</div></td>
</tr>
<%} stmt.close();
conn.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("数据没有写入");
}
%>
</table></td>
</tr>
</table>
</form>
<p> </p>
<p> </p>
<tr>
<td width="1131" height="30" align="left"> </p>
<div align="center"></div> </td>
</tr>
<tr>
<td height="12" align="center"><p align="center" class="style12"><a href="index.htm" class="style17">返回主页</a></p></td>
</tr>
<tr>
<td height="27" align="center"><hr size="1" class="style12">
<p align="center" class="style12"> </p></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -