📄 che.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 sql = "";
int id = 1;
ResultSet rs = null;
ResultSet rsTmp = null;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新闻</title>
<link rel="stylesheet" type="text/css" href="myshop.css">
<script language="JavaScript">
function NewsWindow(id)
{
window.open('myshopwind.jsp?id='+id,'infoWin', 'height=400,width=600,scrollbars=yes,resizable=yes');
}
</script>
</head>
<body background="image/5.jpg">
<%
if(request.getParameter("del")!=null) conn.executeQuery("delete * from goods where id=" + request.getParameter("del"));
sql="SELECT * from goods order by ID desc";
rs = conn.executeQuery(sql);
if(!rs.next())
out.println("<p>还 没 有 任 何 商品</p>");
else {
%>
<p><strong>全部商品</strong><br><br><table width=100%>
<%
do {
id = rs.getInt("ID");
%>
<tr><td><a href="javascript:NewsWindow(<%=id%>)"><u>
<%=rs.getString("shopname")%></u></a>--
<td><%=rs.getString("price")%></td>
<td><%=rs.getString("factory")%></td>
<td><%=rs.getDate("times").toString()%></td>
<td><%=rs.getString("number")%></td>
</td><td align=right><a href=buy.jsp?id=<%=id%>>购买</a>
<%
}while(rs.next());
}
rs.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -