发布时间 : 星期一 文章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
//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
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
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