📄 nuojiya.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-image: url(image/u=3751729908,81688770&gp=1.jpg);
}
-->
</style></head>
<body><%
String gouwu=new String();
String name=new String();
String price=new String();
String user=new String();
String number=new String();
user=(String)session.getValue("user");
if(user==null){%>
如果您是会员请您先登陆再选购,谢谢！<a href="denglu.jsp">登陆</a>
如果您是非会员请先注册再选购,谢谢!<a href="zhuce.jsp">新用户注册</a>
<%
}
else{
gouwu=request.getParameter("hiddenField");
number=request.getParameter("textfield");
%>
<%
String url=new String();
url="jdbc:odbc:userg1";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String SQL=new String();
SQL="SELECT * FROM nuojiya WHERE shoujiname='"+gouwu+"'";
ResultSet rs=stmt.executeQuery(SQL);
if(rs.next()){
name=rs.getString("shoujiname");
price=rs.getString("price");
session.putValue("name1",name);
session.putValue("price1",price);
rs.close();
String SQL3=new String();
SQL3="INSERT INTO "+user+" (name,price,shuliang) VALUES('"+name+"','"+price+"','"+number+"')";
stmt.executeUpdate(SQL3);
stmt.close();
con.close();
}
%>
<p> 用户<%=user%>您好!你已经选购:</p>
<table border="2" bgcolor="#33FFFF" width="500" align="center">
<tr><td>
<p>货号:
<%=name%></p>
<p>价格:
<%=price%></p>
<p> 数量:
<%=number%></p><%
int x=0,y,z,p;
String zongji=new String();
y=Integer.parseInt(price);
z=Integer.parseInt(number);
p=x+y*z;
zongji=zongji.valueOf(p);
%>合计:<%=zongji%>元</td></tr></table>
<P><a href="index.jsp">继续购物</a></P>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -