📄 search_deal.jsp~3~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="liangjuyan.conndb" %>
<%
conndb conn=new conndb();
String select=request.getParameter("select");
String sql="";
if(select="服装"){sql="select * from fuzhuang ";}
else{
if(select="饰品"){
sql="select * from shipin";
}
if(select="生活用品"){
sql="select * from shenghuoyongpin";
}
if(select="其他"){
sql="select * from qita";
}
}
ResultSet rs_search=conn.executeQuery(sql);
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 = "";
%>
<html>
<head>
<title>
search_deal
</title>
</head>
<body bgcolor="#ffffff">
<%
while (rs_search.next()) {
s_fuzhuangid=rs_search.getInt(1);
s_fwupinming = rs_search.getString(2);
s_fyanse = rs_search.getString(3);
s_fchangjia = rs_search.getString(4);
s_fcailiao = rs_search.getString(5);
s_fshiyongnianxian = rs_search.getString(6);
s_fshengchanriqi = rs_search.getString(7);
s_fgoumaichishu= rs_search.getString(8);
s_ftuijianzhishu= rs_search.getString(9);
s_fyoudian= rs_search.getString(10);
%>
<table><tr> <td height="31"><%=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><% }%>
<h1>
JBuilder Generated JSP
</h1>
</body>
</html>
<%conn.close();%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -