BookStore3（完成版）

来源：互联网发布：c语言 c 知乎编辑：程序博客网时间：2024/05/22 16:50

由于在BookStore2中又增加一些功能就直接写下了BookStore3（第三版201104221515）的项目代码。

这是javawebMVC模式下的一个项目；

需要的服务器是weblogic；

需要手动建立连接池books。

（一）BookStore3整体结构截图浏览：

（二）具体代码：

1.bean.

（1）Book.Java：

package Bean;

import java.io.Serializable;

public class Book implements Serializable {

private String id = null;
private String bookname = null;
private String publish = null;
private String author = null;
private float price = 0;

//Error(a)
public Book(String id, String bookname, String publish, String author,float price) {
this.id = id;
this.bookname = bookname;
this.publish = publish;
this.author = author;
this.price = price;
}
//Error(b)
public Book() {

}
public String getId() {
  return id;
}
public void setId(String id) {
  this.id = id;
}
public String getBookname() {
  return bookname;
}
public void setBookname(String bookname) {
  this.bookname = bookname;
}
public String getPublish() {
  return publish;
}
public void setPublish(String publish) {
  this.publish = publish;
}
public String getAuthor() {
  return author;
}
public void setAuthor(String author) {
  this.author = author;
}
public float getPrice() {
  return price;
}
public void setPrice(float price) {
  this.price = price;
}
//2011.04.18
}

（2）User.java：

package Bean;

import java.io.Serializable;

public class User implements Serializable {

private String username = null;
private String password = null;
//Error(c)
public User() {

}
public String getUsername() {
  return username;
}
public void setUsername(String username) {
  this.username = username;
}
public String getPassword() {
  return password;
}
public void setPassword(String password) {
  this.password = password;
}
//2011.04.18
}

（3）DBBean.java：

package Bean;

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

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DBBean {

private Connection con;
private PreparedStatement pstmt;
private ResultSet rs;
private static DataSource ds;
//(1)
static {
  try{
   Context ctx = new InitialContext();
   ds = (DataSource)ctx.lookup("books");
  }catch(Exception e){
   e.printStackTrace();
  }
}

//(2)
public ResultSet executeQuery(String sql,List paras) throws Exception {

  con = ds.getConnection();
  pstmt = con.prepareStatement(sql);
  int i = 1;
  if(paras!=null)
  {
   for(Object param:paras)
   {
    pstmt.setObject(i, param);
    i++;
   }
  }
  rs = pstmt.executeQuery();
  return rs;
}

//(3)
public int executeUpdate(String sql,List paras) throws Exception {

  con = ds.getConnection();
  pstmt = con.prepareStatement(sql);
  int i = 1;
  if(paras!=null)
  {
   for(Object param:paras)
   {
    pstmt.setObject(i, param);
    i++;
   }
  }
  int n = pstmt.executeUpdate();
  return n;
}

//(4)
public void close() {
  if(rs!=null)
  {
   try{
    rs.close();
   }catch(Exception e){
    e.printStackTrace();
   }
  }
  if(pstmt!=null)
  {
   try{
    pstmt.close();
   }catch(Exception e){
    e.printStackTrace();
   }
  }
  if(con!=null)
  {
   try{
    con.close();
   }catch(Exception e){
    e.printStackTrace();
   }
  }
}
//2011.04.18
}

（4）Order.java：

package Bean;

import java.io.Serializable;

public class Order implements Serializable {

private int orderid = 0;
private String username = null;
private String bookid = null;
private int amount = 0;
private boolean checked;

//big problem !!!(2011.04.22)a
public Order(int orderid, String username, String bookid, int amount) {

  this.orderid = orderid;
  this.username = username;
  this.bookid = bookid;
  this.amount = amount;
}
//big problem !!!(2011.04.22)c
public Order() {

}
public int getOrderid() {
  return orderid;
}
public void setOrderid(int orderid) {
  this.orderid = orderid;
}
public String getUsername() {
  return username;
}
public void setUsername(String username) {
  this.username = username;
}
public String getBookid() {
  return bookid;
}
public void setBookid(String bookid) {
  this.bookid = bookid;
}
public int getAmount() {
  return amount;
}
public void setAmount(int amount) {
  this.amount = amount;
}
public boolean isChecked() {
  return checked;
}
public void setChecked(boolean checked) {
  this.checked = checked;
}
//2011.04.21
}

（5）Page.java：

package Bean;

import java.io.Serializable;
import java.util.List;

public class Page implements Serializable {

private int currentPage; //当前页数
private int totalPages;   //总页数
private int totalRows;    //总行数
private int pageSize;     //每页显示的行数
private List data;        //每页显示的数据

public int getCurrentPage() {
  if(currentPage > getTotalPages())
  {
   currentPage = getTotalPages();
  }
  else if(currentPage < 1)
  {
   currentPage = 1;
  }
  return currentPage;
}
public void setCurrentPage(int currentPage) {
  this.currentPage = currentPage;
}
public int getTotalPages() {
  if(totalRows%pageSize == 0)
  {
   totalPages = totalRows/pageSize;
  }
  else
  {
   totalPages = totalRows/pageSize + 1;
  }
  return totalPages;
}
public void setTotalPages(int totalPages) {
  this.totalPages = totalPages;
}
public int getTotalRows() {
  return totalRows;
}
public void setTotalRows(int totalRows) {
  this.totalRows = totalRows;
}
public int getPageSize() {
  return pageSize;
}
public void setPageSize(int pageSize) {
  this.pageSize = pageSize;
}
public List getData() {
  return data;
}
public void setData(List data) {
  this.data = data;
}
//2011.04.20
}

2.service：

（1）BookManage.java：

package Service;

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

import Bean.Book;
import Bean.DBBean;

public class BookManage {

//(1)显示(查询)图书信息：(2011.04.18)
public List<Book> showBooks() {
  DBBean db = new DBBean();
  List<Book> bookinfo = new ArrayList<Book>();
  try{
   String sql = "select * from books";
   ResultSet rs = db.executeQuery(sql, null);
   while(rs.next())
   {
    String id = rs.getString(1);
    String bookname = rs.getString(2);
    String publish = rs.getString(3);
    String author = rs.getString(4);
    float price = rs.getFloat(5);
    Book book = new Book(id,bookname,publish,author,price);
    bookinfo.add(book);
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return bookinfo;
}

//(2)删除图书信息：(2011.04.18)
public boolean deleteBooks(String id) {

  DBBean db = new DBBean();
  try{
   String sql = "delete from books where id=?";
   List params = new ArrayList();
   params.add(id);
   if(db.executeUpdate(sql, params)>0)
   {
    return true;
   }
   else
   {
    return false;
   }
  }catch(Exception e){
   e.printStackTrace();
   return false;
  }finally{
   db.close();
  }
}

//(3)显示要修改的图书信息：(2011.04.18)
public List<Book> showUpdateBooks(String id) {
  DBBean db = new DBBean();
  List<Book> bookinfo = new ArrayList<Book>();
  try{
   String sql = "select * from books where id=?";
   List params = new ArrayList();
   params.add(id);
   ResultSet rs = db.executeQuery(sql, params);
   while(rs.next())
   {
    String bid = rs.getString(1);
    String bookname = rs.getString(2);
    String publish = rs.getString(3);
    String author = rs.getString(4);
    float price = rs.getFloat(5);
    Book book = new Book(bid,bookname,publish,author,price);//Error!!!(a)
    bookinfo.add(book);
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return bookinfo;
}

//(4)修改图书信息：(2011.04.18)
public boolean updateBooks(String bookname,String publish,String author,float price,String id) {
  DBBean db = new DBBean();
  try{
   String sql = "update books set bookname=?,publish=?,author=?,price=? where id=?";
   List params = new ArrayList();
   params.add(bookname);
   params.add(publish);
   params.add(author);
   params.add(price);
   params.add(id);
   if(db.executeUpdate(sql, params)>0)
   {
    return true;
   }
   else
   {
    return false;
   }
  }catch(Exception e){
   e.printStackTrace();
   return false;
  }finally{
   db.close();
  }
}
//(5)增加图书信息：(2011.04.18)
public boolean addBooks(String id,String bookname,String publish,String author,float price) {
  DBBean db = new DBBean();
  try{
   String sql = "insert into books values(?,?,?,?,?)";
   List params = new ArrayList();
   params.add(id);
   params.add(bookname);
   params.add(publish);
   params.add(author);
   params.add(price);
   if(db.executeUpdate(sql, params)>0)
   {
    return true;
   }
   else
   {
    return false;
   }
  }catch(Exception e){
   e.printStackTrace();
   return false;
  }finally{
   db.close();
  }
}
//2011.04.18
}

（2）UserManage.java：

package Service;

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

import Bean.DBBean;
import Bean.User;

public class UserManage {

//(1)检查用户名：(2011.04.19)
public boolean checkUser(String username) {
  DBBean db = new DBBean();
  boolean flag = false;
  try{
   String sql = "select * from users where username=?";
   //List<User> params = new ArrayList<User>();
   List params = new ArrayList();
   params.add(username);
   ResultSet rs = db.executeQuery(sql, params);
   if(rs.next())
   {
    return true;
   }
   else
   {
    return false;
   }
  }catch(Exception e){
   e.printStackTrace();
   return false;
  }finally{
   db.close();
  }
}

//(2)注册功能：(2011.04.19)
public boolean registerUser(String username,String password) {
  DBBean db = new DBBean();
  try{
   String sql = "insert into users values(null,?,?)";
   List params = new ArrayList();
   params.add(username);
   params.add(password);
   if(db.executeUpdate(sql, params)>0)
   {
    return true;
   }
   else
   {
    return false;
   }
  }catch(Exception e){
   e.printStackTrace();
   return false;
  }finally{
   db.close();
  }
}

//(3)登录功能：(2011.04.19)
public User loginUser(String username,String password) {
  DBBean db = new DBBean();
  User user = new User();//Error(c)
  boolean flag = false;
  try{
   String sql = "select * from users where username=? and password=?";
   List params = new ArrayList();
   params.add(username);
   params.add(password);
   ResultSet rs = db.executeQuery(sql, params);
   if(rs.next())
   {
    user.setUsername(rs.getString("username"));
    user.setPassword(rs.getString("password"));
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return user;
}
//2011.04.19
}

（3）PageBooksManage.java：

package Service;

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

import Bean.Book;
import Bean.DBBean;
import Bean.Page;

public class PageBooksManage {

//(1)获取books表总行数：(2011.04.20)
private int getBookRows() {
  int totalRows = 0;
  DBBean db = new DBBean();
  try{
   String sql = "select count(*) from books";
   ResultSet rs = db.executeQuery(sql, null);
   while(rs.next())
   {
       totalRows = rs.getInt(1);
   }
  }catch(Exception e){//SQLException Error!
   e.printStackTrace();
  }finally{
   db.close();
   return totalRows;
  }
}

//(2)配置Page并将页面显示的数据放到Page中返回：(2011.04.20)
public Page getBooks(int page) {
  DBBean db = new DBBean();
  List ary = new ArrayList();
  Page bean = new Page();
  bean.setPageSize(5);
  bean.setCurrentPage(page);
  bean.setTotalRows(getBookRows());
  int offset = (bean.getCurrentPage()-1)*bean.getPageSize();
  int rows = bean.getPageSize();
  try{
   String sql = "select * from books limit "+offset+","+rows+"";
   ResultSet rs = db.executeQuery(sql, null);
   while(rs.next())
   {
       Book book = new Book();
       book.setId(rs.getString("id"));
       book.setBookname(rs.getString("bookname"));
       book.setPublish(rs.getString("publish"));
       book.setAuthor(rs.getString("author"));
       book.setPrice(rs.getFloat("price"));
       ary.add(book);
   }
   bean.setData(ary);//最终将数据都写入data集合中!
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
   return bean;
  }
}
    //2011.04.20
}

（4）BuyBooksManage.java：

package Service;

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

import Bean.Book;
import Bean.DBBean;

public class BuyBooksManage {

//(1)获取购买图书id准备将图书信息插入map集合：(2011.04.21)
public Book getBooksId(String id) {
  DBBean db = new DBBean();
  Book book = new Book();
  try{
   String sql = "select * from books where id=?";
   List params = new ArrayList();
   params.add(id);
   ResultSet rs = db.executeQuery(sql, params);
   if(rs.next())
   {
    book.setId(rs.getString(1));
    book.setBookname(rs.getString(2));
    book.setPublish(rs.getString(3));
    book.setAuthor(rs.getString(4));
    book.setPrice(rs.getFloat(5));
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return book;
}
//2011.04.21
}

（5）IntoOrdersManage.java：

package Service;

import java.util.ArrayList;
import java.util.List;

import Bean.DBBean;
import Bean.Order;

public class IntoOrderManage {

//(1)插入所选图书信息到order表中：(2011.04.21)
public boolean intoOrder(List s) {
  DBBean db = new DBBean();
  boolean flag = false;
  try{
   String sql = "insert into orders2(username,bookid,amount,checked) values(?,?,?,0)";
   List params = new ArrayList();
   if(s!=null)
   {
    for(int i=0;i<s.size();i++)
    {
     Order order = (Order)s.get(i);
     params.add(order.getUsername());
     params.add(order.getBookid());
     params.add(order.getAmount());
    }
   }
   if(db.executeUpdate(sql, params)>0)
   {
    flag = true;
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return flag;
}
//2011.04.21
}

（6）OrdersManage.java：

package Service;

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

import Bean.DBBean;
import Bean.Order;

public class OrderManage {

//(1)用户查看自己的订单信息方法：(2011.04.22)
public List<Order> showOrders(String username) {

  DBBean db = new DBBean();
  List<Order> orderinfo = new ArrayList<Order>();
  try{
   String sql = "select orderid,username,bookid,amount from orders2 where username=?";
   List params = new ArrayList();
   params.add(username);
   ResultSet rs = db.executeQuery(sql, params);
   while(rs.next())
   {
    int orderid = rs.getInt(1);
    String username2 = rs.getString(2);
    String bookid = rs.getString(3);
    int amount = rs.getInt(4);
    Order order = new Order(orderid,username2,bookid,amount);
    orderinfo.add(order);
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return orderinfo;
}

//(2)管理员查看全部订单信息：(2011.04.22)
public List<Order> showAllOrders() {
  DBBean db = new DBBean();
  List<Order> orderinfo = new ArrayList<Order>();
  try{
   String sql = "select orderid,username,bookid,amount from orders2";
   ResultSet rs = db.executeQuery(sql, null);
   while(rs.next())
   {
    int orderid = rs.getInt(1);
    String username2 = rs.getString(2);
    String bookid = rs.getString(3);
    int amount = rs.getInt(4);
    Order order = new Order(orderid,username2,bookid,amount);
    orderinfo.add(order);
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   db.close();
  }
  return orderinfo;
}

//2011.04.22
}

2.Servlet：

（1）addBooksServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Book;
import Service.BookManage;

public class addBooksServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("addBooks");
  request.setCharacterEncoding("GBK");
  String id = request.getParameter("id");
  String bookname = request.getParameter("bookname");
  String publish = request.getParameter("publish");
  String author = request.getParameter("author");
  float price = Float.parseFloat(request.getParameter("price"));
  BookManage bookmanage = new BookManage();
  boolean flag = bookmanage.addBooks(id,bookname,publish,author,price);
  String msg = null;
  if(flag)
  {
   msg = "Good addBooksSuccessed";
  }
  else
  {
   msg = "Sorry addBooksFailed";
  }
  request.setAttribute("msg", msg);
  request.getRequestDispatcher("./addBooksResult.jsp").forward(request, response);
}
    //2011.04.19
}

（2）booksCarServlet.java：

package Servlet;

import java.io.IOException;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import Bean.Book;
import Service.BuyBooksManage;

public class booksCarServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("booksCar");
  String bookid = request.getParameter("id");
  if(bookid!=null)
  {
   HttpSession session = request.getSession();
   Map getBook = (Map)session.getAttribute(bookid);
   if(getBook!=null)
   {
    Integer mount = (Integer)getBook.get("mount");
    int i = mount.intValue();
    i = i+1;
    mount = new Integer(i);
    getBook.put("mount",mount);
    session.setAttribute(bookid,getBook);
   }
   else
   {
    BuyBooksManage buybooks = new BuyBooksManage();
    Book buybook = buybooks.getBooksId(bookid);
    String bookname = buybook.getBookname();
    getBook = new HashMap();
    getBook.put("bookid",bookid);
    getBook.put("bookname", bookname);
    getBook.put("mount",new Integer(1));
    session.setAttribute(bookid,getBook);
   }
   request.getRequestDispatcher("./booksCar.jsp").forward(request, response);
  }
}
    //2011.04.21
}

（3）deleteBooksServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Book;
import Service.BookManage;

public class deleteBooksServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("deleteBooks");
  String id = request.getParameter("id");
  BookManage bookmanage = new BookManage();
  boolean flag = bookmanage.deleteBooks(id);
  if(flag)
  {
   request.getRequestDispatcher("./deleteSuccessedBooks.jsp").forward(request, response);
  }
  else
  {
   request.getRequestDispatcher("./deleteFailedBooks.jsp").forward(request, response);
  }
}
    //2011.04.19
}

（4）intoOrderServlet.java：

package Servlet;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import java.util.Map;

import Bean.Book;
import Bean.Order;
import Bean.User;
import Service.IntoOrderManage;

public class intoOrderServlet extends HttpServlet {

private static final Object order = null;

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("intoOrder");
  HttpSession session = request.getSession();
  Enumeration e = session.getAttributeNames();
  User user = (User)session.getAttribute("UserInfo");
  List list = new ArrayList();
  IntoOrderManage intoorder = new IntoOrderManage();
  while(e.hasMoreElements())
  {
   String bookid = (String)e.nextElement();
   if(!bookid.equals("UserInfo"))
   {
    Map bookinfo = (Map)session.getAttribute(bookid);
    Integer mount = (Integer)bookinfo.get("mount");
                //big problem !!!(2011.04.22)
    Order order = new Order();
    order.setUsername(user.getUsername());
    order.setBookid(bookid);
    order.setAmount(mount.intValue());
    list.add(order);
    session.removeAttribute(bookid);
   }
  }
  boolean flag = false;
  flag = intoorder.intoOrder(list);
  String msg = null;
  if(flag)
  {
      msg = "Good IntoOrder Successed";
  }
  else
  {
   msg = " Sorry IntoOrder Failed";
  }
  request.setAttribute("msg", msg);
  request.setAttribute("username", user.getUsername());
  request.getRequestDispatcher("./intoOrderResult.jsp").forward(request, response);
}
    //2011.04.21
//2011.04.22
}

（5）loginServlet.java：

package Servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.User;
import Service.UserManage;

public class loginServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("loginUsers");
  request.setCharacterEncoding("GBK");
  String username = request.getParameter("username");
  String password = request.getParameter("password");
  UserManage usermanage = new UserManage();
  User user = new User();
  boolean flag = false;
  user = usermanage.loginUser(username, password);
  if(user!=null)
  {
   request.getSession().setAttribute("UserInfo",user);
   flag = true;
  }
  String msg = null;
  if(flag)
  {
   msg = "Good loginSuccessed";
  }
  else
  {
   msg = "Sorry loginFailed";
  }
  request.setAttribute("msg", msg);
  request.getRequestDispatcher("./loginUsersResult.jsp").forward(request, response);
}
    //2011.04.19
}

（6）pageBooksServlet.java：

package Servlet;

import java.io.IOException;

import Service.PageBooksManage;

import Bean.Page;
import Bean.User;

public class pageBooksServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("pageBooks");
  request.setCharacterEncoding("GBK");

  HttpSession session = request.getSession();
  User user = (User)session.getAttribute("UserInfo");
  if(user!=null)
  {
   String page = request.getParameter("page");
   int currentPage = 0;
   if(page == null||page.length()<1)
   {
    currentPage = 1;
   }
   else
   {
    currentPage = Integer.parseInt(page);
   }
   PageBooksManage pagebooks = new PageBooksManage();
   Page pageinfo = new Page();
   pageinfo = pagebooks.getBooks(currentPage);
   request.setAttribute("pageinfo", pageinfo);
   request.getRequestDispatcher("./pageBooks.jsp").forward(request, response);
  }
  else
  {
   String msg = "Please login system firstly,thank you!";
   request.setAttribute("msg", msg);
   request.getRequestDispatcher("./loginUsers.jsp").forward(request, response);
  }
}
//2011.04.20
//2011.04.21
}

（7）registerServlet.java：

package Servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.User;
import Service.BookManage;
import Service.UserManage;

public class registerServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("registerUsers");
  request.setCharacterEncoding("GBK");
  String username = request.getParameter("username");
  String password = request.getParameter("password");
  UserManage usermanage = new UserManage();
  User user = new User();
  if(usermanage.checkUser(username))
  {
   request.getRequestDispatcher("./usernameExist.jsp").forward(request, response);
  }
  else
  {
   boolean flag = usermanage.registerUser(username, password);
   String msg = null;
   if(flag)
   {
    msg = "Good registerSuccessed";
   }
   else
   {
    msg = "Sorry registerFailed";
   }
   request.setAttribute("msg", msg);
   request.getRequestDispatcher("./registerUsersResult.jsp").forward(request, response);
  }
}
    //2011.04.19
}

（8）showAllOrdersServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Order;
import Service.OrderManage;

public class showAllOrdersServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("showAllOrders");
  request.setCharacterEncoding("GBK");
  OrderManage ordermanage = new OrderManage();
  List<Order> orders = ordermanage.showAllOrders();
  request.setAttribute("orders", orders);
  request.getRequestDispatcher("./showAllOrders.jsp").forward(request, response);
}
//2011.04.22
}

（9）showBooksServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Book;
import Service.BookManage;

public class showBooksServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("showBooks");
  request.setCharacterEncoding("GBK");
  BookManage bookmanage = new BookManage();
  List<Book> books = bookmanage.showBooks();
  request.setAttribute("books", books);
  request.getRequestDispatcher("./showBooks.jsp").forward(request, response);
}
//2011.04.19
}

（10）showOrdersServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Order;
import Service.OrderManage;

public class showOrdersServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("showOrders");
  request.setCharacterEncoding("GBK");
  String username = request.getParameter("username");
  OrderManage ordermanage = new OrderManage();
  List<Order> orders = ordermanage.showOrders(username);
  //System.out.println(username);
  request.setAttribute("orders", orders);
  request.getRequestDispatcher("./showOrders.jsp").forward(request, response);
}
//2011.04.22
}

（11）showUpdateBooksServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Book;
import Service.BookManage;

public class showUpdateBooksServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("showUpdateBooks");
  request.setCharacterEncoding("GBK");
  String id = request.getParameter("id");
  BookManage bookmanage = new BookManage();
  List<Book> books = bookmanage.showUpdateBooks(id);
  request.setAttribute("books", books);
  request.getRequestDispatcher("./updateBooks.jsp").forward(request, response);
}
//2011.04.19
}

（12）updateBooksServlet.java：

package Servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import Bean.Book;
import Service.BookManage;

public class updateBooksServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {

  doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  System.out.println("updateBooks");
  request.setCharacterEncoding("GBK");
  String id = request.getParameter("id");
  String bookname = request.getParameter("bookname");
  String publish = request.getParameter("publish");
  String author = request.getParameter("author");
  float price = Float.parseFloat(request.getParameter("price"));

  BookManage bookmanage = new BookManage();
  boolean flag = bookmanage.updateBooks(bookname,publish,author,price,id);
  String msg = null;
  if(flag)
  {
   msg = "Good updateBooksSuccessed";
  }
  else
  {
   msg = "Sorry updateBooksFailed";
  }
  request.setAttribute("msg", msg);
  request.getRequestDispatcher("./updateBooksResult.jsp").forward(request, response);
}
//2011.04.19
}

3.jsp：

（1）booksCar.jsp:

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//ZN">
<html>
<head>
    <title>./booksCar.jsp(2011.04.21)</title>
</head>
<style type="text/css">
*
{
    font-family:微软雅黑;
    background:#CFC;
    font-weight:bold;
}
span
{
    color:blue;
}
</style>
<body>
<h2>购物车</h2>
<table>
    <tr>
      <td>序号</td>
      <td>图书名</td>
      <td>数量</td>
    </tr>
    <c:forEach items="${pageContext.session.attributeNames }" var="piaoqi13">
      <c:if test="${piaoqi13=='UserInfo' }">
      <span>Welcome ${sessionScope["UserInfo"].username }</span>
      </c:if>
      <c:if test="${piaoqi13!='UserInfo' }">
        <tr>
          <td>${sessionScope[piaoqi13].bookid }</td>
          <td>${sessionScope[piaoqi13].bookname }</td>
          <td>${sessionScope[piaoqi13].mount }</td>
        </tr>
      </c:if>
    </c:forEach>
</table>
<a href="./pageBooks">back</a>
  
<a href="./intoOrder">over</a>
  
<a href="./index.jsp">index</a>
</body>
</html>

（2）intoOrderResult.jsp：

（3）pageBooks.jsp：

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//ZN">
<html>
<head>
    <title>./pageBooks.jsp(2011.04.20)</title>
</head>
<style type="text/css">
*
{
    font-family:微软雅黑;
    background:#CFC;
    font-weight:bold;
}
</style>
<body>
    <h2>选购图书页面</h2>
    <form action="buyBooks" method="post">
    <table border="0" bordercolor="" cellpadding="1" cellspacing="0" width="55%">
      <tr>
        <td >图书编号</td>
        <td>书籍名称</td>
        <td>出版社</td>
        <td>作者</td>
        <td>售价</td>
        <td>购买</td>
      </tr>
      <c:forEach var="book" items="${pageinfo.data}">
        <tr>
          <td><c:out value="${book.id}"/></td>
          <td><c:out value="${book.bookname}"/></td>
          <td><c:out value="${book.publish}"/></td>
          <td><c:out value="${book.author}"/></td>
          <td><c:out value="${book.price}"/></td>
          <td><a href="buyBooks?id=${book.id}">加入购入车</a></td>
        </tr>
      </c:forEach>
    </table>
    </form>
           每页${pageinfo.pageSize}行    共${pageinfo.totalRows}行   
           第${pageinfo.currentPage}页    共${pageinfo.totalPages}页
    <br/>
    <c:choose>
      <c:when test="${pageinfo.currentPage == 1}">首页上一页</c:when>
      <c:otherwise>
        <a href="pageBooks?page=1">首页</a>
        <a href="pageBooks?page=${pageinfo.currentPage - 1}">上一页</a>
      </c:otherwise>
    </c:choose>

    <c:choose>
      <c:when test="${pageinfo.currentPage == pageinfo.totalPages}">下一页尾页</c:when>
      <c:otherwise>
        <a href="pageBooks?page=${pageinfo.currentPage + 1}">下一页</a>
        <a href="pageBooks?page=${pageinfo.totalPages}">尾页</a>
      </c:otherwise>
    </c:choose>
    <br/>
    <a href="./index.jsp">back</a>
</body>
</html>

（4）showAllOrders.jsp：

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//ZN">
<html>
<head>
    <title>./showAllOrders.jsp(2011.04.22)</title>
</head>
<style type="text/css">
*
{
    font-family:微软雅黑;
    background:#CFC;
    font-weight:bold;
}
</style>
<body>
<h2>显示全部订单信息</h2>
    <table>
      <tr>
        <th>订单流水号</th>
        <th>用户名</th>
        <th>图书号</th>
        <th>购买总数</th>
      </tr>
      <c:forEach items="${orders}" var="order">
      <tr>
        <td>${order.orderid}</td>
        <td>${order.username}</td>
        <td>${order.bookid}</td>
        <td>${order.amount}</td>
      </tr>
      </c:forEach>
    </table>
    <a href="./index.jsp">back</a>
</body>
</html>

（5）showOrders.jsp：

<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//ZN">
<html>
<head>
    <title>./showOrders.jsp(2011.04.22)</title>
</head>
<style type="text/css">
*
{
    font-family:微软雅黑;
    background:#CFC;
    font-weight:bold;
}
</style>
<body>
<h2>查看订单页面</h2>
<table border="0">
    <tr>
        <td>订单流水号</td>
        <td>用户名</td>
        <td>图书号</td>
        <td>购买总数</td>
    </tr>
    <c:forEach items="${orders}" var="order">
      <tr>
        <td>${order.orderid }</td>
        <td>${order.username }</td>
        <td>${order.bookid }</td>
        <td>${order.amount }</td>
      </tr>
    </c:forEach>
    </table>
    <a href="./pageBooks">back</a>
      
    <a href="./index.jsp">index</a>
</body>
</html>

0 0