myshopwind.jsp
来自「这是用JSP+ACESS构建的网上购物系统,适合JSP初学者.」· JSP 代码 · 共 52 行
JSP
52 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?