search_deal.jsp~3~
来自「用JSP制作的个人网站」· JSP~3~ 代码 · 共 70 行
JSP~3~
70 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?