public int updateBook(Book bo) {
int x = 0;
try {
con = JdbcUtil.getMysqlConnection();
System.out.println("update 2");
ps =
con.prepareStatement(
"update jlcbooks set bname=?,author=?,pub=?,cost=?,edition=?,isbn=? where bid=?");
System.out.println("update 3");
System.out.println(bo.getBid());
ps.setString(7, bo.getBid());
ps.setString(1, bo.getBname());
ps.setString(2, bo.getAuthor());
ps.setString(3, bo.getPub());
ps.setString(4, bo.getCost());
ps.setString(5, bo.getEdi());
ps.setString(6, bo.getIsbn());
x = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtil.cleanup(ps, con);
}
return x;
}
public void getData() {
for (int i = model.getRowCount() - 1; i >= 0; i--) {
model.removeRow(i);
}
ArrayList<Book> list = bm.bookAllData();
for (Book book : list) {
String[] data = {String.valueOf(book.getNo()), book.getTitle(), book.getAuthor()};
model.addRow(data);
}
}
public void getFindData() {
for (int i = model.getRowCount() - 1; i >= 0; i--) {
model.removeRow(i);
}
String pub = box.getSelectedItem().toString();
ArrayList<Book> list = bm.bookFindData(pub);
tf.setText(pub);
for (Book book : list) {
String[] data = {String.valueOf(book.getNo()), book.getTitle(), book.getAuthor()};
model.addRow(data);
}
}
public int addBook(Book bo) {
int x = 0;
try {
con = JdbcUtil.getMysqlConnection();
ps = con.prepareStatement("insert into jlcbooks values(?,?,?,?,?,?,?)");
ps.setString(1, bo.getBid());
ps.setString(2, bo.getBname());
ps.setString(3, bo.getAuthor());
ps.setString(4, bo.getPub());
ps.setString(5, bo.getCost());
ps.setString(6, bo.getEdi());
ps.setString(7, bo.getIsbn());
x = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtil.cleanup(ps, con);
}
return x;
}
@Override
public void mouseClicked(MouseEvent e) {
// TODO Auto-generated method stub
if (e.getSource() == table) {
if (e.getClickCount() == 2) // 더블클릭
{
int row = table.getSelectedRow();
String no = model.getValueAt(row, 0).toString();
bp.setPoster(Integer.parseInt(no));
bp.repaint();
Book book = bm.bookDetail(Integer.parseInt(no));
la1.setText("번호:" + no);
la2.setText("제목:" + book.getTitle());
la3.setText("저자:" + book.getAuthor());
la4.setText("출판사:" + book.getPublisher());
la5.setText("가격:" + book.getPrice());
}
} else if (e.getSource() == b) {
getData();
}
}
@Action(
value = "grouponBook",
interceptorRefs = {@InterceptorRef(value = "userActionStack")},
results = {@Result(name = SUCCESS, type = "json")})
public String grouponBook() {
PrintWriter writer = CommonUtil.getJsonPrintWriter(ServletActionContext.getResponse());
Book book = bookService.getBookByIsbn(isbn);
BookBase base = null;
if (book != null) {
base = new BookBase();
base.setIsbn(book.getIsbn());
base.setAuthor(book.getAuthor());
base.setPrice(book.getPrice());
base.setTitle(book.getTitle());
base.setPublisher(book.getPublisher());
}
String json = JSONObject.fromObject(base).toString();
writer.write(json);
writer.flush();
writer.close();
return SUCCESS;
}
// 1 进入团购的页面
@Action(
value = "nextGrouponitemPage",
interceptorRefs = {@InterceptorRef(value = "userActionStack")},
results = {
@Result(name = SUCCESS, location = "/userPages/grouponitem.jsp"),
@Result(name = "over", location = "/userPages/cart.jsp")
})
public String nextGrouponitemPage() {
User findUser = (User) ServletActionContext.getRequest().getSession().getAttribute("user");
// if()
Groupon find = grouponService.getGroupon(groupon.getId());
Grouponitem grouponitem = new Grouponitem();
grouponitem.setId(page);
grouponitem.setGroupon(find);
Grouponitem findItem = grouponService.next(grouponitem);
// 如果没有找到,那么意味着查询已经结束
if (findItem == null) {
double fee = 0.0;
int num = 0;
List<Cart> result = new ArrayList<Cart>();
List<Cartitem> items = cartService.getGrouponitemsByUser(findUser.getId(), find.getId());
for (int i = 0; i < items.size(); i++) {
Cartitem cartitem = items.get(i);
num += cartitem.getNum();
if (cartitem.getSalesBook() == null) {
if (cartitem.getBook().getDiscount() == 0.0) {
cartitem.getBook().setDiscount(ConstantUtil.NEWBOOKDISCOUNT);
}
SalesBook newbookSalesBook =
salesBookService.getSalesBookByIsbnSeller(
cartitem.getBook().getIsbn(), ConstantUtil.NEWBOOKPRODUCT);
float discount = ConstantUtil.NEWBOOKDISCOUNT;
if (newbookSalesBook != null && newbookSalesBook.getDiscount() != null) {
discount = newbookSalesBook.getDiscount();
}
fee +=
cartitem.getNum() * Math.round(cartitem.getBook().getPrice() * discount * 10) / 10d;
} else {
fee += cartitem.getNum() * cartitem.getSalesBook().getPrice();
}
Cart cart = cartitem.getCart();
Cart findCart = getCartByList(cart.getId(), result);
if (findCart == null) {
Cart cartResult = new Cart();
cartResult.setId(cart.getId());
cartResult.setSeller(cart.getSeller());
cartResult.setCartitems(new HashSet());
cartResult.setTotalFee(cart.getTotalFee());
cartResult.setUser(cart.getUser());
cartResult.getCartitems().add(cartitem);
cartitem.setCart(cartResult);
result.add(cartResult);
} else {
findCart.getCartitems().add(cartitem);
cartitem.setCart(findCart);
}
}
System.out.println(result.size());
ActionContext.getContext().getValueStack().set("carts", result);
ActionContext.getContext().getValueStack().set("num", num);
ActionContext.getContext().getValueStack().set("fee", Math.round(fee * 10) / 10d);
return "over";
}
Book book = bookService.getBookByIsbn(findItem.getBook().getIsbn());
// 如果没有拿到数据，则返回空
ServiceArea serviceArea = findUser.getSchool().getServiceArea();
// 如果找到了，查看新书供应商有没有此数据，如果没有，那么就给新书供应商加进去
SalesBook newbookSalesBook =
salesBookService.getSalesBookByIsbnSeller(
findItem.getBook().getIsbn(), ConstantUtil.NEWBOOKPRODUCT);
Seller seller = sellerService.getSellerById(ConstantUtil.NEWBOOKPRODUCT);
SalesBook model =
salesBookService.getSalesBookByIsbnSeller(findItem.getBook().getIsbn(), seller.getId());
float bookDiscount;
if (newbookSalesBook == null) {
newbookSalesBook = new SalesBook();
newbookSalesBook.setSeller(seller);
newbookSalesBook.setBook(book);
newbookSalesBook.setTitle(book.getTitle());
newbookSalesBook.setAuthor(book.getAuthor());
newbookSalesBook.setStandardPrice(book.getPrice());
newbookSalesBook.setPublisher(book.getPublisher());
newbookSalesBook.setImage(book.getImage());
newbookSalesBook.setBigImage(book.getBigImage());
salesBookService.save(newbookSalesBook);
}
if (model == null) {
model = newbookSalesBook;
}
if (newbookSalesBook.getDiscount() == null) {
bookDiscount = ConstantUtil.NEWBOOKDISCOUNT;
} else {
bookDiscount = newbookSalesBook.getDiscount();
}
ActionContext.getContext().getValueStack().set("bookDiscount", bookDiscount);
newbookSalesBook.setDiscount(bookDiscount);
newbookSalesBook.setPrice(
Math.round(newbookSalesBook.getBook().getPrice() * bookDiscount * 10) / 10d);
newbookSalesBook.setNum(999);
SalesBook salesBook = newbookSalesBook;
School findSchool = findUser.getSchool();
List<SellerBean> sellerBeans =
salesBookService.getSellerBeans(
newbookSalesBook.getBook().getIsbn(), findSchool.getServiceArea().getId());
int totalNum = cartService.getGrouponitemsByUser(findUser.getId(), find.getId()).size();
ActionContext.getContext().getValueStack().set("sellerBeans", sellerBeans);
ActionContext.getContext().getValueStack().set("item", findItem);
Seller newBookSeller = sellerService.getSellerById(ConstantUtil.NEWBOOKPRODUCT);
ActionContext.getContext().getValueStack().set("totalNum", totalNum);
ActionContext.getContext().getValueStack().set("model", model);
ActionContext.getContext().getValueStack().set("newBookSeller", newBookSeller);
ActionContext.getContext()
.getValueStack()
.set("price", Math.round(newbookSalesBook.getBook().getPrice() * bookDiscount * 10) / 10d);
// 获得这个学校所有的团购项目
return SUCCESS;
}
// when a book is returned to the library
public void returnBook(Book book) {
int pos = findBook(book.getTitle(), book.getAuthor());
books.get(pos).setStatus(true);
}