我的程序流是这样的:
有3个jsp分别是
list.jsp(列表)
jump.jsp(跳转页)
show.jsp(详细页)1个.java文件是 DAL.java数据处理的
现在从list.jsp点击一条记录,把ID什么的传去jump.jsp,jump.jsp接收到后处理一下 调用DAL.java的一个方法进行数据查询,返回一个ResultSet到jump.jsp
到这里,我想在show.jsp接收这个数据集。要怎么弄?听说返回ResultSet不好,可以做成返回Collection的。但返回之后要怎么在show.jsp处理呢?!
刚接触java不熟悉指教!
有3个jsp分别是
list.jsp(列表)
jump.jsp(跳转页)
show.jsp(详细页)1个.java文件是 DAL.java数据处理的
现在从list.jsp点击一条记录,把ID什么的传去jump.jsp,jump.jsp接收到后处理一下 调用DAL.java的一个方法进行数据查询,返回一个ResultSet到jump.jsp
到这里,我想在show.jsp接收这个数据集。要怎么弄?听说返回ResultSet不好,可以做成返回Collection的。但返回之后要怎么在show.jsp处理呢?!
刚接触java不熟悉指教!
解决方案 »
- 在线求助(mysql字段扩容)
- struts2上传文件,action得不到对应JSP的字段的值
- urlrewriter 怎么实现域名重定向
- 在线求助 ·号显示乱码的问题
- struts框架 javascript的对象数组传递到action中去
- 请问网页上的下载按钮,弹出一个选择框让用户选择“打开”还是“下载”是怎么实现的?
- 如何把页面上显示的数据库记录另存为excel文件?
- 表单提交时+号等提交到了后台就不见了的问题???
- tomcat 提示No Java compiler was found错误,困惑N久(解决马上给分)
- 有经验的高手请帮忙解疑难:asp和jsp能否共同开发一个项目?不胜感激!
- struts2 jquery????
- 怎样用jsp实现报表图?
在XXX位置当java文件写啊
for(Iterator it = digits.iterator();it.hasNext();){
TruckDigitBean digit = (TruckDigitBean)it.next();
%>
<%=digit.getTruckDigit() %>
<%
}
%>
其中request.getAttribute("digits")中的digits就是传过来的哪个ArrayList。
TruckDigitBean 就是你传到页面上的每一个对象(每一行记录)。
[1]先写个这样的类,用于保存备用,可以保存变量
import java.util.List;/**
* 一个订单的JavaBean
*/
public class Order {
private int orderId; private String recvName;//收货人
private User user;
private String address; private String postcode; private String email; private String orderDate; private int flag;//0表示货没发出,1表示货已发出,2表示货冻结
private List orderItem; //一个用于装订单项的List public List getOrderItem() {
return orderItem;
} public void setOrderItem(List orderItem) {
this.orderItem = orderItem;
} public int getFlag() {
return flag;
} public void setFlag(int flag) {
this.flag = flag;
} public String getOrderDate() {
return orderDate;
} public void setOrderDate(String orderDate) {
this.orderDate = orderDate;
} public int getOrderId() {
return orderId;
} public void setOrderId(int orderId) {
this.orderId = orderId;
} public User getUser() {
return user;
} public void setUser(User user) {
this.user = user;
} public String getAddress() {
return address;
} public void setAddress(String address) {
this.address = address;
} public String getEmail() {
return email;
} public void setEmail(String email) {
this.email = email;
} public String getPostcode() {
return postcode;
} public void setPostcode(String postcode) {
this.postcode = postcode;
} public String getRecvName() {
return recvName;
} public void setRecvName(String recvName) {
this.recvName = recvName;
}
}【2】再写个这样的方法读取查询结果 public List selectOrder(String name) {
List list = new ArrayList();
Order or = null ;
DbUtil dao = new DbUtil();
PreparedStatement pre = null;
ResultSet re = null;
String sql = "select * from tb_order where name=?";
try {
pre = dao.getCon().prepareStatement(sql);
pre.setString(1, name);
re =pre.executeQuery();
while(re.next()){
or = new Order ();
User user = new User();
or.setOrderId(re.getInt("orderId"));
user.setName(re.getString("name"));
or.setRecvName(re.getString("recvName"));
user.setAddress(re.getString("address"));
user.setPostcode(re.getString("postcode"));
user.setEmail(re.getString("email"));
or.setUser(user);
or.setOrderDate(re.getString("orderDate"));
or.setFlag(re.getInt("flag"));
list.add(or);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public class User {
private int id; private String name; private String password; private String email; private String trueName; private String sex; private String birthday; private String address; private String postcode; private String phone; private String mphone; private String question; private String answer;
private String img;
private int score; public String getAddress() {
return address;
} public void setAddress(String address) {
this.address = address;
} public String getAnswer() {
return answer;
} public void setAnswer(String answer) {
this.answer = answer;
} public String getBirthday() {
return birthday;
} public void setBirthday(String birthday) {
this.birthday = birthday;
} public String getEmail() {
return email;
} public void setEmail(String email) {
this.email = email;
} public String getMphone() {
return mphone;
} public void setMphone(String mphone) {
this.mphone = mphone;
} public String getPhone() {
return phone;
} public void setPhone(String phone) {
this.phone = phone;
} public String getPostcode() {
return postcode;
} public void setPostcode(String postcode) {
this.postcode = postcode;
} public String getQuestion() {
return question;
} public void setQuestion(String question) {
this.question = question;
} public String getSex() {
return sex;
} public void setSex(String sex) {
this.sex = sex;
} public String getTrueName() {
return trueName;
} public void setTrueName(String trueName) {
this.trueName = trueName;
} public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getName() {
return name;
} public void setName(String name) {
this.name = name;
} public String getPassword() {
return password;
} public void setPassword(String password) {
this.password = password;
} public String getImg() {
return img;
} public void setImg(String img) {
this.img = img;
} public int getScore() {
return score;
} public void setScore(int score) {
this.score = score;
}
}
【3】大概流程如下
-->查看订单selectOrder--com.lovo.cq.shopping10_1.servlet.SelectOrder
调用ModelOrder model = new ModelOrder();的List list = model.selectOrder(name);
然后设置request.getSession().setAttribute("list", list);
然后response.sendRedirect("selfOrder.jsp");
--->selfOrder.jsp
然后通过
<c:forEach var="order" items="${list}">
<tr>
<td>${order.orderId}</td>
<td>${order.recvName}</td>
<td>${order.user.address}</td>
<td>${order.user.postcode}</td>
<td>${order.flag}</td>
<td><a href="son?id=${order.orderId}">查看</a></td>
</tr>
</c:forEach>
显示订单基本信息
如果用ArrayList要怎么操作呢?
<tr>
<td>${order.orderId}</td>
<td>${order.recvName}</td>
<td>${order.user.address}</td>
<td>${order.user.postcode}</td>
<td>${order.flag}</td>
<td><a href="son?id=${order.orderId}">查看</a></td>
</tr>
</c:forEach>
用这个标签吧