📄 gukegouwudan.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">
<!--
.style1 {
color: #FF9933;
font-size: 18px;
}
.style2 {
color: #FFCC33;
font-size: 18px;
}
.style4 {
font-family: "华文琥珀";
color: #FF0000;
}
-->
</style>
</head>
<body>
<%
String name=new String();
String price=new String();
String number=new String();
String user=new String();
user=(String)session.getValue("user");
if(user==null){ %>
<span class="style1">如果您是会员请您先登陆,如您不是请您注册并登陆后查看;</span><a href="index.jsp">返回</a>
<%
}
else{
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 "+user+"";
ResultSet rs=stmt.executeQuery(SQL);
int b=0;
%>
<span class="style1">您已经选购:</span>
<table width="500" border="2" bordercolor="#FFCC00" background="file:///C|/Documents%20and%20Settings/lins/My%20Documents/My%20Pictures/u=776820477,1276022782&gp=1.jpg">
<%
while(rs.next()){
b=1;
int i=0;
i++;
name=name.valueOf(i);
name=rs.getString("name");
price=rs.getString("price");
number=rs.getString("shuliang");
%>
<tr><td><div align="center"><span class="style4">货号:</span> <%=name%></div></td>
<td><div align="center"><span class="style4">价格:</span> <%=price%></div></td>
<td><div align="center"><span class="style4">数量:</span> <%=number%></div></td>
<td>
<form name="form1" method="post" action="chexiao.jsp">
<div align="center">
<input name="hiddenfield" type="hidden" value="<%=name%>">
<input name="提交" type="submit" value="取消">
</div>
</form></td>
<%
} %>
</tr></table>
<%
if(b==0){
%>
<span class="style2">您的购物记录为空!</span><a href="index.jsp">返回</a>
<%
}
rs.close();
stmt.close();
con.close();
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -