📄 gomai.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"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body bgcolor="#FFFFFF">
<p align="center">
<%
String product_name=request.getParameter("hiddenField");
String product_id=request.getParameter("hiddenField2");
String p_newprice=request.getParameter("hiddenField3");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:zhuce";
Connection con=DriverManager.getConnection(url,"","");
Statement st=con.createStatement();
String Sql="select * from cart where product_id='"+product_id+"'";
ResultSet rs=st.executeQuery(Sql);
if(rs.next())
{out.print("此商品已存在您的购物车中");%>
<p align="center"><a href="dan.jsp">返回主页继续购物</a>
<p>
<%return;}
else{
String strSql="insert into cart(product_name,product_id,p_newprice) values ('"+product_name+"','"+product_id+"','"+p_newprice+"')";
st.executeUpdate(strSql);
//st.close();
//rs.close();%>
<table width="60%" height="161" border="1" align="center" cellspacing="0" bordercolor="#6633FF" bgcolor="#ffdcdc">
<!--DWLayoutTable-->
<tr>
<td width="72"><div align="right"></div></td>
<td colspan="2" align="center" valign="middle" bgcolor="ffdcdc">
<div align="center">
<%out.print("您购买的产品已经放入购物车中");%>
</div></td>
<td width="82"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2" align="center" valign="middle"><img src="im/image029.gif" width="31" height="28">
</td>
<td> </td>
</tr>
<tr>
<td height="51"> </td>
<td width="144" align="center" valign="middle"><a href="gouwuche.jsp">查看购物车</a></td>
<td width="154" align="center" valign="middle"><a href="dan.jsp">继续购物</a></td>
<td> </td>
</tr>
</table>
<p><%}%> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -