📄 666467.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>力量</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>101</credit>
<TopicId>666467</TopicId>
<TopicName>用jsp+servlet+javabean+oracle实现的网上书店</TopicName>
<PostUserId>236625</PostUserId>
<PostUserName>powerball</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>5</ReplyNum>
<PostDateTime>2002-4-22 13:53:33</PostDateTime>
<Point>100</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我现在需要实现一个三层架构的网上书店，具体要求如下：jsp是表示层，用于数据反馈；servlet是事物层，用于处理逻辑运算；javabean负责连接数据库与servlet;oracle作为数据库服务器。我现在对于四者之间的相互联系不太清楚，jsp与servlet之间，servlet与bean之间，bean与oracle之间的联系方式请描述清楚。最好附上一个例子，如：图书订购或会员登陆。例子的解释和数据库中表的结构烦请说明。不胜感激，百分相送，略表敬意！！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>兔子林</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4382030</ReplyID>
<TopicID>666467</TopicID>
<PostUserId>191218</PostUserId>
<PostUserName>ronny5</PostUserName>
<Point>10</Point>
<Content>哇~~~~~~~全部写清楚大概可以出书了吧，前几天看到一本什么java实例教程就是讲这个问题的，现在很多的书就有例子的，而且统一的都是网上书店，你随便找一本就行了，何苦让程序员成为打字员呢</Content>
<PostDateTime>2002-4-22 14:04:12</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>力量</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>101</credit>
<ReplyID>4382344</ReplyID>
<TopicID>666467</TopicID>
<PostUserId>236625</PostUserId>
<PostUserName>powerball</PostUserName>
<Point>0</Point>
<Content>大部分的jsp书籍上的例子与我的要求不一样，书上的是两层架构，我说的是三层架构，希望大家可以推荐几本有关的参考书。</Content>
<PostDateTime>2002-4-22 14:19:39</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4396206</ReplyID>
<TopicID>666467</TopicID>
<PostUserId>232970</PostUserId>
<PostUserName>ERT</PostUserName>
<Point>30</Point>
<Content>这是一个相关例子：
Listing 1: 
EShop.jsp 
<%@ page session="true"%> 
<html> 
<head> 
<title>Music Without Borders</title> 
</head> 
<body bgcolor="#33CCFF"> 
<font face="Times New Roman,Times"size="+3"> 
Music Without Borders 
</font> 
<hr><p> 
<center> 
<form name="shoppingForm" 
action="/examples/servlet/ShoppingServlet" 
method="POST"> 
<b>CD:</b> 
<select name=CD> 
<option>Yuan | The Guo Brothers | China | $14.95</option> 
<option>Drums of Passion | Babatunde Olatunji | Nigeria | $16.95</option> 
<option>Kaira | Tounami Diabate| Mali | $16.95</option> 
<option>The Lion is Loose | Eliades Ochoa | Cuba | $13.95</option> 
<option>Dance the Devil Away | Outback | Australia | $14.95</option> 
<option>Record of Changes | Samulnori | Korea | $12.95</option> 
<option>Djelika | Tounami Diabate | Mali | $14.95</option> 
<option>Rapture | Nusrat Fateh Ali Khan | Pakistan | $12.95</option> 
<option>Cesaria Evora | Cesaria Evora | Cape Verde | $16.95</option> 
<option>Ibuki | Kodo | Japan | $13.95</option> 
</select> 
<b>Quantity:</b><input type="text"name="qty"SIZE="3"value=1> 
<input type="hidden"name="action"value="ADD"> 
<input type="submit"name="Submit"value="Add to Cart"> 
</form> 
</center> 
<p> 
<jsp:include page="Cart.jsp"flush="true"/> 
</body> 
</html> 
</Content>
<PostDateTime>2002-4-23 10:32:39</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4396217</ReplyID>
<TopicID>666467</TopicID>
<PostUserId>232970</PostUserId>
<PostUserName>ERT</PostUserName>
<Point>30</Point>
<Content>Listing 2: 
Cart.jsp 
<%@ page session="true"import="java.util.*, shopping.CD"%> 
<% 
Vector buylist = (Vector) session.getValue("shopping.shoppingcart"); 
if (buylist != null&&(buylist.size()>0)) { 
%> 
<center> 
<table border="0"cellpadding="0"width="100%"bgcolor="#FFFFFF"> 
<tr> 
<td><b>ALBUM</b></td> 
<td><b>ARTIST</b></td> 
<td><b>COUNTRY</b></td> 
<td><b>PRICE</b></td> 
<td><b>QUANTITY</b></td> 
<td></td> 
</tr> 
<% 
for (int index=0;index<buylist.size();index++) { 
CD anOrder = (CD) buylist.elementAt(index); 
%> 
<tr> 
<td><b><%= anOrder.getAlbum() %></b></td> 
<td><b><%= anOrder.getArtist() %></b></td> 
<td><b><%= anOrder.getCountry() %></b></td> 
<td><b><%= anOrder.getPrice() %></b></td> 
<td><b><%= anOrder.getQuantity() %></b></td> 
<td> 
<form name="deleteForm" 
action="/examples/servlet/ShoppingServlet" 
method="POST"> 
<input type="submit"value="Delete"> 
<input type="hidden"name="delindex"value=''<%= index %>''> 
<input type="hidden"name="action"value="DELETE"> 
</form> 
</td> 
</tr> 
<% } %> 
</table> 
<p> 
<form name="checkoutForm" 
action="/examples/servlet/ShoppingServlet" 
method="POST"> 
<input type="hidden"name="action"value="CHECKOUT"> 
<input type="submit"name="Checkout"value="Checkout"> 
</form> 
</center> 
<% } %> 
这里，Cart.jsp按照MVC的模式1处理基于SESSION的购物车的表现。请看Cart.jsp开始处的代码： 
<% 
Vector buylist = (Vector) session.getValue("shopping.shoppingcart"); 
if (buylist != null&&(buylist.size()>0)) { 
%> 
本质上，这段代码从SESSION中取出“购物车”。如果“购物车”为空或者没有被创建，它就什么也不显示。所以，在用户第一次访问应用时，其界面如图： 
如果“购物车”不为空，用户选择的商品从车中取出，依次显示在页面上： 
<% 
for (int index=0;index<buylist.size();index++) { 
CD anOrder = (CD) buylist.elementAt(index); 
%> 
一旦生成一个物品的说明，就使用JSP按照事先设定的模板将其插入静态HTML页面。下图显示了用户选购一些物品后的界面： 
需要注意的一个重要的地方是所有关于Eshop.jsp,Cart.jsp的处理有一个控制SERVLET，ShoppingServlet.java，代码在源程序3中： 
</Content>
<PostDateTime>2002-4-23 10:33:12</PostDateTime>
</Reply>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>4396238</ReplyID>
<TopicID>666467</TopicID>
<PostUserId>232970</PostUserId>
<PostUserName>ERT</PostUserName>
<Point>30</Point>
<Content>Listing 3: 
ShoppingServlet.java 
import java.util.*; 
import java.io.*; 
import javax.servlet.*; 
import javax.servlet.http.*; 
import shopping.CD; 
public class ShoppingServlet extends HttpServlet { 
public void init(ServletConfig conf) throws ServletException { 
super.init(conf); 
} 
public void doPost (HttpServletRequest req, HttpServletResponse res) 
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -