📄 buy.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>
<style type="text/css">
<!--
body {
}
.style8 {font-family: "幼圆"; font-size: 18px; }
-->
</style></head>
<body>
<p align="center">
<form name="form1" method="post" action="">
<table width="772" height="63" align="center">
<tr>
<td> </td>
</tr>
<tr>
<td><div align="center"><span class="style8"> </span></div></td>
</tr>
<tr>
<td><div align="center">
<%String id=new String(request.getParameter("id"));//在购买商品页面设置隐藏域，隐藏域中写入商品的信息用来传递数据
String xinghao=new String(request.getParameter("hiddenField2"));
String maijia=new String(request.getParameter("hiddenField3"));
String didian=new String(request.getParameter("hiddenField4"));
String jiage=new String(request.getParameter("hiddenField5"));
String nu=new String(request.getParameter("hiddenField6"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:c";
Connection con=DriverManager.getConnection(url,"","");
PreparedStatement select_stm=con.prepareStatement("select xinghao from buy where xinghao=?");
select_stm.setString(1,xinghao);
ResultSet result_stm=select_stm.executeQuery();
String debug_username=null;
if(result_stm.next())
debug_username=result_stm.getString(1);
result_stm.close();
if(debug_username!=null)
{out.println("商品已经存在<p><a href=gouwu.jsp>返回重新购买</a></p>");//用户注册过程中也用到这种方法，如果选择的商品重复就会出现下面信息
return;
}
else{
PreparedStatement stm=con.prepareStatement("insert into buy(id,xinghao,maijia,didian,jiage,nu) values(?,?,?,?,?,?)");
stm.setString(1,id);
stm.setString(2,xinghao);
stm.setString(3,maijia);
stm.setString(4,didian);
stm.setString(5,jiage);
stm.setString(6,nu);
try
{
stm.executeUpdate();
}
catch(Exception e){out.print(e);}
%>
</div></td>
</tr>
<tr>
<td><table width="60%" height="161" border="1" align="center" cellspacing="0" bordercolor="#6633FF" bgcolor="#CCCCFF">
<!--DWLayoutTable-->
<tr>
<td width="72"><div align="right"></div></td>
<td colspan="2" align="center" valign="middle"><div align="center">
<%out.print("您购买的产品已经放入购物车中");%>
</div></td>
<td width="82"> </td>
</tr>
<tr>
<td> </td>
<td colspan="2" align="center" valign="middle"><!--DWLayoutEmptyCell--> </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="gouwu.jsp">继续购物</a></td>
<td> </td>
</tr>
</table></td>
</tr>
</table>
</form>
<p align="center">
<%
con.close();
}
%>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -