📄 cash.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/myjsp/tushu/inc/db.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
<head>
<link href=css.css rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>收银台</title></head>
<body topmargin="0">
<font color="#000000"><b>
<%!
int Cint(String cint)
{
try {
int n;
n= Integer.parseInt(cint);
return n;
}
catch (NumberFormatException e) {
return 0;
}
}
%>
<%!
String getStr(String str)
{
try
{
String temp_p=str;
byte[] temp_t=temp_p.getBytes("ISO8859-1");
String temp=new String(temp_t);
return temp;
}
catch(Exception e)
{
e.printStackTrace();
return null;
}
}
%>
<%
if(session.getAttribute("user_name")==null){
out.print("<br>1.你尚未登录!请登录后再订购本站商品!<br>2.第一次来本站，请先注册会员（免费）!<br><br>");
}
%>
</b></FONT>
<br>
<table width="400" border="0" cellspacing="0" cellpadding="0" align="center" height="50">
<tr>
<td align="center">
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td height="18" bgcolor="#DBC2B0" align="center">收银台</td>
</tr>
<tr>
<td height="25" valign="top"> <form method="POST" action="#">
<table width="100%" border="0" cellspacing="0" cellpadding="0" >
<tr>
<td valign="top">
<table border="0" width="416" cellspacing="0" height="34" cellpadding="0">
<tr>
<td width="378" height="120" valign="bottom" bgcolor="#F5EFE7"><p><br>
您订购的物品如下:</p>
<div align="center">
<center>
<table width="90%" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111">
<tr background="img/pics/tile_bg.gif">
<td width="195" height="25"><div align="center">商品名称</div></td>
<td width="60" height="25"><div align="center">单价</div></td>
<td width="60" height="25"><div align="center">数量</div></td>
<td width="80" height="25"><div align="center">合计</div></td>
</tr>
<%
String user_name=(String)session.getValue("user_name");
String sql="select * from basket where user_name='"+user_name+"'and basket_check=false";
ResultSet rs=stmt.executeQuery(sql);
int totalcash=0;
if(!rs.next())
out.print("你没有订购任何商品");
else{
rs.previous();
while(rs.next()){
String hw_cashs=rs.getString("hw_cash");
String basket_count=rs.getString("basket_count");
String jiag=rs.getString("daili");
String hw_name=rs.getString("hw_name");
int count=1;
%>
<tr>
<td width="195" height="25"><div align="center"><font color=red><%=hw_name%></font></div></td>
<td width="60" height="25"><div align="center"><%=jiag%>元</div></td>
<td width="60" height="25"><div align="center"><%=basket_count%></div></td>
<td width="80" height="25"><div align="center"><%=Cint(jiag)*Cint(basket_count)%>元</div></td>
</tr>
<%totalcash=totalcash+Cint(jiag)*Cint(basket_count);
}
%>
<tr>
<td height="25"><div align="center"><b class="dz1">总计：<font color=red><%=totalcash%></font>元</b></div></td>
<td height="25" colspan="3"><div align="center"><b class="dz1">
<input align=absMiddle alt=确认 cache name="B1" src="image/ok.gif" type=image tppabs="" width="45" height="20">
</b></div></td>
</tr>
</table>
</center>
</div>
<br> <table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle"><div align="center"><img src="img/pics/seperator.gif" width="359" height="1"></div></td>
</tr>
</table></td></tr>
</table>
</td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
}
stmt.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -