jsp+servlet+javabean - 简单网上购物车 - 图文

6）结算功能还未实现 4.附源码： //BookDao.java

package com.hbsi.dao;

import java.util.List;

import com.hbsi.domain.Book;

public interface BookDao { //获取所有的书 public List getAll(); //根据id获取书 public Book find(String id); }

//BookDaoImpl.java

package com.hbsi.dao;

import java.sql.Connection;

import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List;

import com.hbsi.domain.Book;

import com.hbsi.utils.DBManager;

public class BookDaoImpl implements BookDao{

@Override

public Book find(String id) { Connection conn = null;

PreparedStatement pt = null; ResultSet rs = null;

try {

conn = DBManager.getConnection();

String sql = \; pt = conn.prepareStatement(sql);

pt.setString(1, id);

rs = pt.executeQuery(); //Book b = null; if(rs.next()){

Book b = new Book();

b.setId(rs.getString(\));

b.setName(rs.getString(\));

b.setAuthor(rs.getString(\)); b.setPrice(rs.getDouble(\));

b.setDescription(rs.getString(\)); return b; }

return null;

} catch (Exception e) {

throw new RuntimeException(e);

} finally {

DBManager.closeDB(conn, pt, rs); } }

@Override

public List getAll() { Connection conn = null;

PreparedStatement pt = null; ResultSet rs = null;

try {

conn = DBManager.getConnection(); String sql = \id,name,author,price,description from book\;

pt = conn.prepareStatement(sql); rs = pt.executeQuery();

List list = new ArrayList();

while (rs.next()) {

Book b = new Book();

b.setId(rs.getString(\));

}

}

b.setName(rs.getString(\));

b.setAuthor(rs.getString(\)); b.setPrice(rs.getDouble(\));

b.setDescription(rs.getString(\)); list.add(b);

}

return list;

} catch (Exception e) {

throw new RuntimeException(e); } finally {

DBManager.closeDB(conn, pt, rs); }

//Book.java

package com.hbsi.domain;

public class Book { private String id; private String name; private String author; private double price;

private String description; public String getId() { return id; }

public void setId(String id) { this.id = id; }

public String getName() { return name; }

public void setName(String name) { this.name = name; }

public String getAuthor() { return author;

}

}

public void setAuthor(String author) { this.author = author; }

public double getPrice() { return price; }

public void setPrice(double price) { this.price = price; }

public String getDescription() { return description; }

public void setDescription(String description) { this.description = description; }

//Cart.java

package com.hbsi.domain;

import java.util.LinkedHashMap; import java.util.Map;

public class Cart { private Map map=new LinkedHashMap(); private double price;//所有购物项的价格总计 public void add(Book book){ CartItem item=map.get(book.getId()); if(item!=null){ item.setQuantity(item.getQuantity()+1); }else{ item=new CartItem(); item.setBook(book); item.setQuantity(1); //把新的购物项添加到map集合中 map.put(book.getId(),item); } } public Map getMap() { return map; }