📄 cart.jsp
字号:
<html>
<head>
<title>Shopping Cart</title>
</head>
<body bgcolor="#CCFFFF">
<CENTER>
<H1> <u>Online Shopping Cart</u> </H1>
</CENTER>
<BR>
<a href="Logout.jsp" ><font size="4" >Click here to Logout</font></a>
<%@ page errorPage="errorpage.jsp" language="java" import="java.sql.*" %>
<%
int i;
String user_src=null;
user_src=(String)session.getValue("user");
if (user_src!=null)
{
int counter=0;
counter=Integer.parseInt((String)session.getValue("TotalSel"));
int[] bookid=new int[counter];
Connection conn;
conn=null;
ResultSet rs;
rs=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection("jdbc:odbc:Data","scott","tiger");
PreparedStatement stat=null;
int ctr=0,bookprice=0;
for(i=1;i<=counter;i++)
{
if((String)session.getValue("chk_var"+i)!=null)
{
bookid[i-1]=Integer.parseInt((String)session.getValue("chk_var"+i));
}
}
session.putValue("BookArr",bookid);
%>
<h3>Your Cart Details are as follows:</h3>
<form name="shop" action="Cart_Quantity.jsp">
<table border=1>
<tr>
<td>S.No</td>
<td>Book Name</td>
<td>Price (in Rs.)</td>
</tr>
<%
int price=0;
for (int j=1;j<=counter;j++)
{
out.println("<tr><td>"+j);
String query="select title, price from book_details where bookid=?";
stat= conn.prepareStatement(query);
stat.setInt(1,bookid[j-1]);
rs = stat.executeQuery();
while (rs.next())
{
out.println("<td>");
out.println(rs.getString(1));
out.println("<td>");
price=rs.getInt(2);
out.println(price);
}
rs.close();
bookprice=bookprice+price;
session.putValue("bPrice",String.valueOf(bookprice));
out.println("</tr>");
}
ResultSet rscombo=null;
String query1="select * from category_details";
PreparedStatement stat_combo = conn.prepareStatement(query1);
rscombo=stat_combo.executeQuery();%>
<tr>
<td colspan=3>Total Cart Amount(in Rs.)=
<%=bookprice%><td>
</tr>
</table>
<br>
<input type=submit value="Place Order">
</form>
<br><hr><h3>Search More</h3>
<form name="search" action="NewSearch.jsp" method="POST">
<table border=1>
<tr>
<td><input type="radio" value="Category" checked name="R1"></td>
<td>Search based on Category</td>
<td>
<select size="1" name="BookCategory">
<option selected value="Select">Select Category</option>
<%
while(rscombo.next())
{
String category=rscombo.getString(2);
%>
<option value="<%=category%>"><%=category%></option>
<%}%>
</select>
</td>
</tr>
<tr>
<td><input type="radio" name="R1" value="Title"></td>
<td>Search by Book Title</td>
<td><input type="text" name="BookTitle" size="25"></td>
</tr>
<tr>
<td><input type="radio" name="R1" value="Author"></td>
<td>Search by Book Author</td>
<td><input type="text" name="BookAuthor" size="25"></td>
</tr>
<tr>
<td><input type="radio" name="R1" value="Publisher"></td>
<td>Search by Book Publisher</td>
<td><input type="text" name="BookPublisher" size="25"></td>
</tr>
<tr>
<td><input type="radio" name="R2" value="A">Advanced Search</td>
<td><input type="radio" name="R2" value="N" checked>New Search</td>
<td><input type=submit value="Search"></td>
</tr>
</table>
</form>
<%}
else
{
response.sendRedirect("Unauthorised.htm");
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -