📄 myshopwind.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<jsp:useBean id="conn" scope="page" class="myshop.conn"/>
<%!
String id = "";
String sql = "";
ResultSet rs = null;
ResultSet rsTmp = null;
%>
<html>
<head>
<title>商品</title>
<link rel="stylesheet" type="text/css" href="myshop.css">
</head>
<%
id = request.getParameter("id");
sql="SELECT * from goods where ID=" + id;
rs = conn.executeQuery( sql );
if(!rs.next()) {
out.println("错误的ID号");
rs.close();
}else {
%>
<table width="100%" HEIGHT=100% border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#FAD195">
<td height=20 align=center><b><%=rs.getString("shopname")%></b></td>
</tr>
<tr>
<td valign=top>
<p><%=rs.getString("shopcontent")%>
</tr>
</table>
<%
while(rs.next()) {
%>
<li><a href=myshopwind.jsp?id=<%=rs.getInt("ID")%>><u>
<%=rs.getString("shopname")%></u></a>
<%=rs.getString("factory")%>
<%=rs.getDate("times").toString()%>
<%
}
rs.close();
}
%>
</ul>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -