📄 wishlist_page.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="en-us">
<title>Wishlist Page</title>
</head>
<body bgcolor="#C0C0C0" topmargin="0" background="http:\\localhost:8000\music\Background.bmp" >
<table border="0" width="100%">
<tr>
<td width="100%">
<table border="0" width="97%" height="19">
<tr>
<td width="18%" height="13" valign="middle" align="right">
<font face="Arial" size="5" color="#800000"><b><i>eMusicWorld-----> The World of Music</i></b></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%@ page language = "java" %>
<%! float grandTotal=0;%>
<form method="POST" action="http://localhost:8000/music/user_home_page.jsp">
<table border="1" width="100%">
<tr>
<td width="11%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a href="Offers.jsp">Offers</a></b></font></td>
<td width="20%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/shopping_cart.jsp">Shopping Cart</a></b></font></td>
<td width="16%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/wishlist_page.jsp">Wishlist</a></b></font></td>
<td width="8%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/feedback_page.jsp">Feedback</a></b></font></td>
<td width="13%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/user_buy_page.htm">Buy</b></font></a></b></font></td>
<td width="9%" height="13" valign="middle" align="center"><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/logout_page.jsp">Logout</a></b></font></td>
</tr>
</table>
<table border="1" width="100%">
<tr>
<td width="18%">
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/user_home_page.jsp">Home</a></b></font></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/chart_toppers.jsp">Chart Toppers</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/SearchContext/SearchAlias">Search</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/vote_page.htm">Vote</a></font></b></p>
<p><b><font face="Arial" size="2" color="#800000"><a HREF="http://localhost:8000/music/new_release_page.jsp">New Releases</a></font></b>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/Register/RegisterPage.htm">Register</a></b></font>
<p><font face="Arial" size="2" color="#800000"><b><a HREF="http://localhost:8000/music/help_page.htm">Help</a></b></font></p>
<p> </p>
</td>
<td width="82%">
<%! String username;%>
<%
try
{
username=session.getAttribute("username").toString();
}
catch(Exception e)
{
out.println("<p><font face=\"Arial\" size=\"2\" color=\"#800000\"><b>");
out.println("Please login before viewing the wishlist.");
out.println("</font></b>");
}
%>
<p><font face="Arial" size="2" color="#800000">Dear <%=session.getAttribute("username")%>, </font></p>
<p><font face="Arial" size="2" color="#800000">You have following items in the
wishlist.</font></p>
<table border="0" width="105%">
<tr>
<td width="11%"><font face="Arial" size="2" color="#800000"><b>Item Code</b></font></td>
<td width="18%"><font face="Arial" size="2" color="#800000"><b>Item
Description</b></font></td>
<td width="10%"><font face="Arial" size="2" color="#800000"><b>Price ($)</b></font></td>
<td width="7%"><font face="Arial" size="2" color="#800000"><b>Qty</b></font></td>
<td width="32%" colspan="3"><font face="Arial" size="2" color="#800000"><b>Total ($)
</b></font></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
Statement state;
state = connect.createStatement();
String strQuery1 = "select * from Wishlist_Info where User_name='"+username+ "'";
String str;
ResultSet result1 = state.executeQuery(strQuery1);
ResultSet result2;
String strQuery2;
int ctr1=0;
String desc=new String("");
String strRate=new String();
float rate=0;
int qty;
grandTotal=0;
float total=0;
while(result1.next())
{
out.println("<tr>");
out.println("<td width=\"10%\" valign=\"top\" height=\"15\"><font face=\"Arial\" size=\"2\" color=\"#800000\">");
str=result1.getString("Item_code");
out.println(str);
Statement state1;
Connection connect1;
connect1=DriverManager.getConnection("jdbc:odbc:RegisterDataSource","wasiqr","bhalbabatu");
state1 = connect1.createStatement();
strQuery2 = "select * from Item_Master where Item_Code='"+str+ "'";
result2 = state1.executeQuery(strQuery2);
while(result2.next())
{
rate=result2.getInt(3);
desc=result2.getString(4);
}
out.println("<td width=\"13%\" valign=\"top\" height=\"15\"><font face=\"Arial\" size=\"2\" color=\"#800000\">");
out.println(desc);
out.println("<td width=\"19%\" valign=\"top\" height=\"15\"><font face=\"Arial\" size=\"2\" color=\"#800000\">");
out.println(rate);
out.println("<td width=\"13%\" valign=\"top\" height=\"15\"><font face=\"Arial\" size=\"2\" color=\"#800000\">");
qty=result1.getInt("Qty");
out.println(qty);
total=(rate*qty);
out.println("<td width=\"19%\" valign=\"top\" height=\"15\"><font face=\"Arial\" size=\"2\" color=\"#800000\">");
out.println(total);
out.println("</tr>");
connect1.close();
grandTotal=grandTotal+total;
}
}
catch(Exception e){
out.println("done exception" +e);
}
%>
</table>
<table border="0" width="75%">
<tr>
<td>
<p align="right"><font face="Arial" size="2" color="#800000"><b>Total Amount Payable($): <%= grandTotal %></b></font>
</tr>
</td>
</table>
<p> </p>
<p>
<font face="Arial" size="2" color="#800000"><a href="http://localhost:8000/music/user_buy_page.htm">Want to buy more?</a></font></p>
<p> </td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -