📄 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>
<style type="text/css">
<!--
body {
background-color: #CCCCFF;
}
.style9 {color: #993366}
.style10 {font-size: large}
.style11 {
font-family: "幼圆";
color: #CC3399;
}
.style13 {font-size: large; font-family: "幼圆"; }
.style14 {color: #CC3399}
.style26 {font-size: large; font-family: "幼圆"; color: #CC3399; }
-->
</style>
</head>
<body >
<p> </p>
<table width="98%" height="216" border="0" align="center" cellspacing="0">
<tr>
<td colspan="7"> </td>
</tr>
<tr>
<td colspan="7"><div align="center"></div></td>
</tr>
<tr>
<td colspan="7">
<div align="center"><font size="7" face="华文彩云">购物车</font></div></td>
</tr>
<tr>
<td colspan="7"> </td>
</tr>
<tr>
<td colspan="7"> </td>
</tr>
<tr>
<td width="13%"><div align="center" class="style10 style11">商品型号</div></td>
<td width="12%"><div align="center" class="style13 style14">卖家</div></td>
<td width="12%"><div align="center" class="style26">地点</div></td>
<td width="12%"><div align="center" class="style26">商品价格</div></td>
<td width="11%"><div align="center" class="style26">数量</div></td>
<td width="12%"><div align="center" class="style26">修改数量?</div></td>
<td width="12%"> <div align="center" class="style26"></div>
<div align="center" class="style26">是否删除？</div></td>
</tr>
<%
String sql="select * from buy";
ResultSet rs=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载JDBC驱动程序
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("database:"+e.getMessage());
out.println("驱动没有加载");
}
try
{
Connection conn=DriverManager.getConnection("jdbc:odbc:c"," "," ");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
while(rs.next())
{String id=rs.getString(1);
String xinghao=rs.getString(2);
%>
<tr>
<td><div align="center"><%=xinghao%></div></td>
<td><div align="center"><%=rs.getString(3)%></div></td>
<td><div align="center"><%=rs.getString(4)%></div></td>
<td><div align="center">¥<%=rs.getString(5)%></div></td>
<td><div align="center"><%=rs.getString(6)%></div></td>
<td><div align="center"><a href="upnum.jsp?xinghao=<%=xinghao%>" class="style9">更改</a></div></td>
<td><div align="center"><a href="dele.jsp?xinghao=<%=xinghao%>" class="style9">删</a></div></td>
</tr>
<tr>
<td height="23"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="7"><div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center"></div> <div align="center">
</div> <div align="center"></div></td>
</tr>
<%} stmt.close();
conn.close();}
catch(SQLException e)
{
System.err.println("executeQuery:"+e.getMessage());
out.println("数据没有写入");
}
%>
</table>
<p> </p>
<table width="100%" border="0" cellspacing="0">
<tr>
<td width="31%"> </td>
<td width="20%"><div align="center"><a href="gouwu.jsp">继续购物</a></div></td>
<td width="21%"><div align="left"><a href="dingdan.htm">结帐</a></div></td>
<td width="28%"> </td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -