?? submitresult.jsp
字號:
<%--
***************文件名 ： submitResult.jsp
***************功能 ： 訂單提交結果頁（修改數據庫并顯示操作結果）
***************作者 ： 馬俊
***************接口參數：
***************實現過程：
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<HTML><HEAD>
<meta http-equiv="Content-Language" content="zh-cn">
<TITLE>提交結果</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<SCRIPT language=JavaScript type=text/JavaScript>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</SCRIPT>
<SCRIPT src="images/alt.js"></SCRIPT>
<LINK href="images/default.css" type=text/css
rel=stylesheet>
<META content="Microsoft FrontPage 6.0" name=GENERATOR></HEAD>
<BODY background=images/crossbig.gif
onmouseover="window.status='【歡迎你光臨我們的網站】如果您喜歡本站,別忘了把本站介紹給您的好友哦！：）';return true"
leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<SCRIPT language=JavaScript>
<!--
function checkss()
{
if(checkspace(document.searchform.searchkey.value !='請輸入關鍵字')) {
document.searchform.searchkey.focus();
alert("請輸入查詢關鍵字！");
return false;
}
if(checkspace(document.searchform.searchkey.value)) {
document.searchform.searchkey.focus();
alert("請輸入查詢關鍵字！");
return false;
}
document.searchform.submit();
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
//-->
</SCRIPT>
<%
//獲得登錄名，若為空則表示未登錄
String logName=(String) session.getValue("logName");
%>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD width=771 height=14>
<applet archive="ansnow.jar" code="ansnow.class" width="771" height="120">
<param name="credits" value="Applet by Fabio Ciucci (www.anfyteam.com)">
<param name="flakes1" value="500">
<param name="flakes2" value="300">
<param name="flakes3" value="100">
<param name="flakes4" value="0">
<param name="windmax" value="1">
<param name="windvariation" value="7">
<param name="speed" value="7">
<param name="backimage" value="images/111.jpg">
<param name="bgcolor" value="000135">
<param name="overtext" value="NO">
<param name="overimg" value="NO">
<param name="overimgX" value="0">
<param name="overimgY" value="0">
<param name="textscroll" value="snowscr.txt">
<param name="texttype" value="zooming">
<param name="textvspace" value="10">
<param name="textminfont" value="8">
<param name="textmaxfont" value="172">
<param name="textoffset" value="0">
<param name="textspeed" value="1">
<param name="textfont" value="TimesRoman">
<param name="textbold" value="YES">
<param name="textitalic" value="YES">
<param name="textsize" value="28">
<param name="textshadow" value="YES">
<param name="TextSColR" value="0">
<param name="TextSColG" value="0">
<param name="TextSColB" value="0">
<param name="TextColR" value="255">
<param name="TextColG" value="80">
<param name="TextColB" value="80">
<param name="TextJumpAmp" value="0">
<param name="TextJumpSpd" value="0">
<param name="TextSineAmp" value="0">
<param name="TextSineSpd" value="0">
<param name="TextSineAngle" value="0">
<param name="regcode" value="NO">
<param name="reglink" value="NO">
<param name="regnewframe" value="NO">
<param name="regframename" value="_blank">
<param name="statusmsg" value="Snow">
<param name="memdelay" value="1000">
<param name="priority" value="3">
<param name="MinSYNC" value="10">
Please <A HREF="http://www.anfyteam.com/java/">download Java(tm)</A>.
</applet> </TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center
background="images/INDEX_r2_c1.jpg" border=0>
<TBODY>
<TR>
<TD width=160 height=25>
<SCRIPT language=JavaScript type=text/JavaScript>
today=new Date();
function initArray(){
this.length=initArray.arguments.length
for(var i=0;i<this.length;i++)
this[i+1]=initArray.arguments[i] }
var d=new initArray(
"星期日",
"星期一",
"星期二",
"星期三",
"星期四",
"星期五",
"星期六");
document.write(
"<font color=#ffffff>"+
today.getYear()+"年"+
(today.getMonth()+1)+"月"+
today.getDate()+"日 "+
d[today.getDay()+1]+
"</font>");
</SCRIPT>
</TD>
<% if(logName==null)
{
%>
<TD width=616><IMG height=10 src="images/b.gif"
width=10 align=absMiddle><FONT color=#333333><font color="#FFFFFF"> </font> <A
class=a1 href="index.jsp" target=_top>
<% }
else
{
%>
<TD width=616><IMG height=10 src="images/b.gif"
width=10 align=absMiddle><FONT color=#333333><font color="#FFFFFF"> </font> <A
class=a1 href="main.jsp" target=_top>
<% }
%>
<font color="#FFFFFF">首 頁</font></A></FONT><FONT color=#333333><font color="#FFFFFF"> | </font>
<A class=a1 href="userPannel.jsp" target=_top>
<font color="#FFFFFF">個人信息面板</font></FONT><FONT color=#333333><font color="#FFFFFF"> | </font></FONT></a>
<A class=a1 href="newList.jsp?pubDate=2001/2/4&ToPage=1" target=_top>
<font color="#FFFFFF">新品上架</font></A><FONT color=#FFFFFF> | </FONT>
<A class=a1 href="sortList.jsp?sort=計算機硬件&ToPage=1" target=_top>
<font color="#FFFFFF">圖書分類</font></A><FONT color=#FFFFFF> |</FONT>
<A class=a1 href="commendList.jsp?limitNum=10&ToPage=1" target=_top>
<font color="#FFFFFF">精品推薦</font></A><FONT color=#FFFFFF> | </FONT>
<A class=a1 href="topList.jsp?limitNum=10&ToPage=1" target=_top>
<font color="#FFFFFF">排行榜</font></A><FONT color=#FFFFFF> | </FONT>
<a class="a1" target="_top" href="help.jsp">
<font color="#FFFFFF">在線幫助</font></a><FONT color=#FFFFFF>|</FONT>
<FONT color=#ffffff> </FONT>
<% if(logName==null)
{
%>
<FONT color=#FF0000>您還沒有登錄!!!</FONT>
<% }
else
{
%>
<FONT color=#FF0000>當前登錄用戶：<%=logName%></FONT>
<%
}
%>
<DIV></DIV></TD></TR></TBODY></TABLE>
<TABLE id=Table1 cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<FORM id=Search name=searchform
action=searchResult.jsp?ToPage=1 method=post>
<TD bgColor=#cce3e7 height=26>
<DIV align=center> </DIV>
<DIV align=center><IMG height=16
src="images/search.gif" width=64 align=absMiddle>
<INPUT onfocus="this.value=''" value=請輸入關鍵字 name=searchkey size="20">
<SELECT id=action name=condition>
<OPTION value=1 selected>書 名</OPTION>
<OPTION value=2>作 者</OPTION>
<OPTION value=3>出版社</OPTION>
<OPTION value=4>ISBN</OPTION>
</SELECT>
<INPUT id=Submit1 style="BORDER-RIGHT: #333333 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #333333 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #333333 1px solid; COLOR: #333333; LINE-HEIGHT: normal; BORDER-BOTTOM: #333333 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 18px; BACKGROUND-COLOR: #cee7ef; FONT-VARIANT: normal" onclick="return checkss();" type=submit value=立即查詢 name=Submit>
</DIV></TD></FORM></TR></TBODY></TABLE>
<%@ page import="java.sql.*"%>
<%@ page import="page.buyList"%>
<%@ page import="java.util.*"%>
<%
////獲得購物車信息
Vector shop=new Vector(); //(Vector)session.getValue("shop");
String sql=new String();
String str=(String)session.getValue("totalPrice");
double totalPrice=Double.parseDouble(str);
int grade=0; //用戶級別
double rate=0.0; //享受的折扣1－2 0.9 3-4 0.8 5-6 0.75
if(logName.length()==0) //沒有登錄
{
%>
<p>
<p align=center>
<img border="0" src="images/2.gif" width="175" height="25"><p>
<%
}
else //已經登錄
{
////
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.println(e.toString());
}
////
double price; //價格
String bookName=new String(); //圖書名
String bookAuthor=new String(); //作者
String publisher=new String(); //出版社
try
{
////查詢用戶信息
sql="SELECT * FROM client WHERE logName='"+logName+"'";
Connection con = DriverManager.getConnection("jdbc:odbc:bookStore");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
grade=rs.getInt("grade");
if(grade>=1 && grade<=2)
rate=0.9;
else if(grade>=3 && grade<=4)
rate=0.8;
else if(grade>=5 && grade<=6)
rate=0.75;
}
rs.close();
stmt.close();
con.close();
con = DriverManager.getConnection("jdbc:odbc:bookStore");
stmt = con.createStatement();
////修改數據庫
shop=(Vector)session.getValue("shop"); //獲得session中的shop信息
//添加訂單
java.util.Date today=new java.util.Date();
//更具提交訂單的精確時間以及用戶的ID作為訂單ID
String orderID=logName+today.getYear()+today.getMonth()+today.getDay()+today.getHours()+today.getMinutes()+today.getSeconds();
String orderDate=today.toLocaleString();
// orderID+=logName;
sql="INSERT INTO myorder(orderID,logName,totalCost,orderDate) VALUES('"; //+orderID+"','"+logName+"','"+totalPrice+"','"+orderDate+"')";
sql=sql+orderID+"','";
sql=sql+logName+"','";
sql=sql+totalPrice+"','";
sql=sql+today.toLocaleString()+"')";
stmt.executeUpdate(sql);
//添加定購項
if(shop!=null) //購物車非空
{
sql="INSERT INTO item(bookID,orderID,bookNum,unitPrice) VALUES('";
for(int i=0;i<shop.size();i++)
{
buyList tempList=(buyList)shop.elementAt(i);
String tempSQL=sql+tempList.bookID+"','";
tempSQL=tempSQL+orderID+"','";
tempSQL=tempSQL+tempList.bookNum+"','";
tempSQL=tempSQL+tempList.bookPrice+"')";
stmt.executeUpdate(tempSQL);
}
}
else
shop=new Vector();
if(shop.size()==0) //購物車為空
{
%>
<p align=center><br>
<img border="0" src="images/1.gif" width="175" height="25">
<% }
else
session.removeValue("shop");
%>
<%
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD vAlign=top>
</TD>
</TR></TBODY></TABLE>
<TABLE height=1 cellSpacing=0 cellPadding=0 width=769 align=center border=3 bordercolor="#FFFFFF">
<TBODY>
<TR>
<TD height=1 width="716" align=left> <font color="#0000FF"> </font><font color="#0000FF"><font size="4">
</font></font>
<p>
<img border="0" src="images/7.gif" width="200" height="80"></p>
</TR>
<TR>
<TD height=5 width="716" align=center rowspan="2" valign="middle"><font size="4" color=blue> </font>
<p><a href="main.jsp"><font size="4" color=blue><img border="0" src="images/4.gif" width="70" height="20"></a></font></p>
</TD>
</TR>
</TBODY></TABLE>
<%
}
%>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=1 cellPadding=0 width="100%" align=center
bgColor=#89bec6 border=0>
<TBODY>
<TR bgColor=#aacfd5>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 10px"> </TD>
<TD style="PADDING-LEFT: 26px"> </TD></TR>
</TBODY></TABLE>
<DIV align=center></DIV></TD></TR>
<TR>
<TD height=6></TD></TR>
</TBODY></TABLE>
<HR align=center width=776 color=#339999 SIZE=1>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD align=middle>版權所有 2003-2004 © All rights MagicTeam reseverd</TD></TR></TBODY></TABLE>
<DIV align=center></DIV></BODY></HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -