📄 gouwuche.jsp
字号:
<%@page info="database handler" language="java" import="java.sql.*" import="java.util.*" import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="javax.servlet.http.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<p> </p>
<table width="54%" height="208" border="0" align="center" cellspacing="0">
<tr>
<td colspan="3"><div align="left">
<table width="100%" height="125" border="0" cellspacing="0">
<tr>
<td width="34%"><div align="center"><img src="im/hh.gif" width="75" height="75"></div></td>
<td width="66%"><font size="7" face="华文彩云">购物车</font></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td width="52%"><div align="center">商品名称</div></td>
<td width="21%"><div align="center">商品价格</div></td>
<td width="27%"> <div align="center"></div>
<div align="center"></div></td>
</tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:zhuce";
Connection con=DriverManager.getConnection(url,"","");
Statement st= con.createStatement();
String strSql="select * from cart";
st.executeQuery(strSql);
ResultSet rs=st.executeQuery(strSql);
while(rs.next())
{
%>
<tr>
<td height="41" colspan="3"> <form name="form2" method="post" action="dele.jsp">
<table width="100%" border="0" cellspacing="0">
<tr>
<td width="52%" height="39"> <div align="center">
<%out.print(rs.getString("product_name"));%>
</div></td>
<td width="21%"><div align="center">
<%out.print(rs.getString("p_newprice"));%>
</div></td>
<td width="27%" align="center" valign="middle"> <div align="center">
</div>
<input type="submit" name="Submit2" value="删除"> <input name="hiddenField2" type="hidden" value="<%out.print(rs.getString("product_id"));%>"></td>
</tr>
</table>
</form></td>
</tr>
<%}
rs.close();
st.close();
%>
</table>
<p> </p>
<table width="100%" border="0" cellspacing="0">
<tr>
<td width="31%"> </td>
<td width="20%"><a href="dan.jsp">继续购物</a></td>
<td width="21%"><a href="jiesuan.htm">结帐</a></td>
<td width="28%"> </td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -