📄 search.jsp~51~
字号:
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<%@page import="liangjuyan.conndb"%>
<%
conndb conn = new conndb();
String key=chStr.chStr(request.getParameter("key"));
ResultSet rs_haha = conn.executeQuery("select top 3 id,title ,detail from haha ");
String s_title="";
String s_detail="";
String df=request.getParameter("df");
String sql="";
if(!df.equals("")&&!df.equals(null)){if(df.equals("fuzhuang")){sql="select * from fuzhuang";}
else{
if(df.equals("shipin")){sql="select * from shipin";}
else{
if(df.equals("shenghuoyongpin")){sql="select * from shenghuoyongpin";}
else{sql="select * from qita";}}}
if(!key.equals("") && !key.equals(null)){
sql=sql+"where wupinming like '%"+key+"%'";
}
else{
if(!key.equals("") && !key.equals(null)){sql="select * from fuzhuang where wupinming like '%"+key+"%'";}
}
}
ResultSet rs_search=conn.executeQuery(sql);
int fuzhuangid=0;
int shipinid=0;
int shenghuoyongpinid=0;
int qitaid=0;
String s_wupinming ="";
String s_yanse="";
String s_changjia ="";
String s_cailiao = "";
String s_shiyongnianxian = "";
String s_shengchanriqi = "";
String s_goumaichishu = "";
String s_tuijianzhishu = "";
String s_youdian = "";
%>
<script src="JS/check.jsp"></script>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
.style1 {color: #CC3300}
.style2 {color: #FF3300}
.style3 {color: #FF6600}
</style>
</head>
<body>
<table width="760
" height="385" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="385" valign="top">
<jsp:include page="daohang.jsp"/><jsp:include page="dz.jsp"/>
<jsp:include page="zhongjian.jsp"/>
<table width="100%" height="136" border="0" cellpadding="0" cellspacing="0">
<tr><td width="74%" valign="top">
<table width="100%" height="135" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#e5edff">
<tr>
<td height="32" background="images/zuihou.png" bgcolor="#ff9966"> 搜索结果 </td>
</tr>
<tr>
<td height="101" valign="top"> <table width="100%" height="76" cellpadding="0" cellspacing="0" border="1" bordercolor="#cccccc">
<tr>
<td width="13%" height="41"><div align="center">编号</div></td>
<td width="13%" height="41"><div align="center">物品名</div></td>
<td width="8%"><div align="center">颜色</div></td>
<td width="10%"><div align="center">厂家</div></td>
<td width="11%"><div align="center">材料</div></td>
<td width="12%"><div align="center">使用年限</div></td>
<td width="13%"><div align="center">生产日期</div></td>
<td width="13%"><div align="center">购买次数</div></td>
<td width="10%">推荐指数</td>
<td width="10%"><div align="center">优点</div></td>
</tr>
<%
while (rs_search.next()) {
if(df.equals("fuzhuang")){
out.print(df);
fuzhuangid=rs_search.getInt("fuzhuangid");}
else{
if(df.equals("shipin")){ shipinid=rs_search.getInt("shipinid");}
else{ if(df.equals("shenghuoyongpin")){shenghuoyongpinid=rs_search.getInt("shenghuoyongpinid");}
else { qitaid=rs_search.getInt("qitaid");}
}
}
s_wupinming = rs_search.getString("wupinming");
s_yanse = rs_search.getString("yanse");
s_changjia = rs_search.getString("changjia");
s_cailiao = rs_search.getString("cailiao");
s_shiyongnianxian = rs_search.getString("shiyongnianxian");
s_shengchanriqi = rs_search.getString("shengchanriqi");
s_goumaichishu= rs_search.getString("goumaichishu");
s_tuijianzhishu= rs_search.getString("tuijianzhishu");
s_youdian= rs_search.getString("youdian");
%>
<tr>
<% if(df.equals("fuzhuang")){%><td height="33"><a href="fuzhuang_detail.jsp?ID=<%=fuzhuangid%>"><%=fuzhuangid%></a></td><%}
else{if(df.equals("shipin")){%><td height="33"><a href="shipin_detail.jsp?ID=<%=shipinid%>"><%=shipinid%></a></td><%}
else{if(df.equals("shenghuoyongpin")){%><td height="33"><a href="shenghuoyongpin_detail.jsp?ID=<%=shenghuoyongpinid%>"><%=shenghuoyongpinid%></a></td><%}
else{%><td height="33"><a href="qita_detail.jsp?ID=<%=qitaid%>"><%=qitaid%></a></td><%}
}}%>
<td><%=s_wupinming%></td>
<td><%=s_yanse%></td>
<td><%=s_changjia%></td>
<td><%=s_cailiao%></td>
<td><%=s_shiyongnianxian%></td>
<td><%=s_shengchanriqi%></td>
<td><%=s_goumaichishu%></td>
<td><%=s_tuijianzhishu%></td>
<td><%=s_youdian%></td>
</tr>
<%}%>
</table></td>
</tr>
</table>
</td>
</tr>
</table> </tr>
</table>
</body>
</html>
<%conn.close();%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -