基于javaweb+mysql的jsp+servlet网上书店图书商城(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
前台:登录注册、管理个人信息、修改密码、收藏图书、下单购买
后台:管理个人信息、书籍管理、分类管理、图书管理、订单管理、用户管理、添加管理员,销售统计信息
前台
后台
技术框架
JSP Servlet MySQL JDBC Tomcat CSS JavaScript bootstrap jquery
基于javaweb+mysql的JSP+Servlet网上书店图书商城(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)
private void editCategoryUI(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
Category category = service.findCategoryById(req.getParameter("category_id"));
req.setAttribute("category", category);
req.getRequestDispatcher("/admin/editCategory.jsp").forward(req, resp);
}
private void editCategory(HttpServletRequest req, HttpServletResponse resp) throws IOException {
Category category = new Category(req.getParameter("category_id"), req.getParameter("category_name"),
req.getParameter("category_desc"));
String categoryName = category.getCategory_name();
if (categoryName == null || categoryName.trim().equals("")) {
return;
}
service.editCategory(category);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
private void delCategory(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String category_id = req.getParameter("category_id");
service.delCategory(category_id);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>删除成功!</div>");
}
// 通过书籍id找到书籍信息
private Book findBookById(String book_id) {
return service.findBookById(book_id);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.web.controller;
HttpSession session = req.getSession();
session.removeAttribute("user");// 获取session对象,从session中移除登陆信息
resp.sendRedirect("../client/ClientServlet?op=category");
} catch (Exception e) {
e.printStackTrace();
}
}
private void register(HttpServletRequest req, HttpServletResponse resp) {
try {
String username = req.getParameter("username");
String password = req.getParameter("password");
String name = req.getParameter("name");
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
String address = req.getParameter("address");
boolean isExist = false;// 判断是否存在该用户
if (!username.equals("") && !password.equals("")) {
isExist = service.register(username, password, name, sex, tel, address);
if (isExist == true) {
} else {
resp.getWriter().write("注册成功!");
}
}else {
}
} catch (Exception e) {
e.printStackTrace();
}
}
private void getCategoryBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<Book> books = service.getCategoryBook(req.getParameter("cid"));// 文学艺术类书籍
req.setAttribute("books", books);
List<Category> categoryList= managerService.findAllCategory();
req.setAttribute("categoryList", categoryList);
req.getRequestDispatcher("/showBook.jsp").forward(req, resp);
}
HttpSession session = req.getSession();
session.setAttribute("orders", orders);
req.getRequestDispatcher("/admin/managerOrder.jsp").forward(req, resp);
}
private void findAllOrders(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
HttpSession session = req.getSession();
User user = (User) session.getAttribute("user");
List<Order> orders = service.findUserOrders(user);
req.setAttribute("orders", orders);
req.getRequestDispatcher("/person/personOrder.jsp").forward(req, resp);
}
private void genOrder(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
// 取出购物车信息
// 取出购物项信息
HttpSession session = req.getSession();
Cart cart = (Cart) session.getAttribute("cart");
User user = (User) session.getAttribute("user");
if (cart == null) {
session.setAttribute("message", "会话已经结束!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
//先判断库存够不够!
Book book = cart.getBook();
String book_id = book.getBook_id();
Book findBookById = clientService.findBookById(book_id);
if(findBookById.getBook_kunumber()-cart.getTotalQuantity()<0) {
session.setAttribute("message", "库存不足,无法购买!");
session.removeAttribute("cart");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
Order order = new Order();
order.setTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
String ordernum = genOrdernum();
order.setOrdernum(ordernum);
order.setQuantity(cart.getTotalQuantity());
order.setMoney(cart.getTotalMoney());
order.setUser(user);
// 订单项
List<Orderitem> oItems = new ArrayList<Orderitem>();
for (Map.Entry<String, CartItem> me : cart.getItmes().entrySet()) {
e.printStackTrace();
}
}
private void register(HttpServletRequest req, HttpServletResponse resp) {
try {
String username = req.getParameter("username");
String password = req.getParameter("password");
String name = req.getParameter("name");
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
String address = req.getParameter("address");
boolean isExist = false;// 判断是否存在该用户
if (!username.equals("") && !password.equals("")) {
isExist = service.register(username, password, name, sex, tel, address);
if (isExist == true) {
} else {
resp.getWriter().write("注册成功!");
}
}else {
}
} catch (Exception e) {
e.printStackTrace();
}
}
private void getCategoryBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<Book> books = service.getCategoryBook(req.getParameter("cid"));// 文学艺术类书籍
req.setAttribute("books", books);
List<Category> categoryList= managerService.findAllCategory();
req.setAttribute("categoryList", categoryList);
req.getRequestDispatcher("/showBook.jsp").forward(req, resp);
}
private void personInformation(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
String username = req.getParameter("username");
String name = req.getParameter("name");
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
String address = req.getParameter("address");
service.personInformation(username, name, sex, tel, address);
String op = req.getParameter("op");// 得到传过来的请求
if (op != null && !op.equals("")) {
// 登录
if (op.equals("login")) {
login(req, resp);
}
// 注销
if (op.equals("layout")) {
layout(req, resp);
}
// 注册
if (op.equals("register")) {
register(req, resp);
}
// 文学艺术类书籍列表
if (op.equals("category")) {
getCategoryBook(req, resp);
}
// 个人信息修改
if (op.equals("personInformation")) {
personInformation(req, resp);
}
// 修改密码
if (op.equals("personPassword")) {
personPassword(req, resp);
}
// 搜索框
if (op.equals("search")) {
search(req, resp);
}
// 详情页面
if (op.equals("particulars")) {
particulars(req, resp);
}
// 添加购物车
if (op.equals("addCart")) {
addCart(req, resp);
}
// 删除购物车中的购物项
if (op.equals("delItem")) {
parentDir.mkdirs();
}
book.setFilename(filename);
book.setPath(path);
InputStream inputStream = item.getInputStream();
FileOutputStream fos = new FileOutputStream(fileDir);
int len = 0;
while ((len = inputStream.read()) != -1) {
fos.write(len);
}
} catch (IOException e) {
e.printStackTrace();
}
}
// 把Fielditem中的数据封装到book中
private void processFormField(FileItem item, HttpServletRequest req, Book book) {
try {
// item每一个item对象代表一个输入框
// 01. 获取input输入框的 name 的值 根据规范 输入框 的name的取值, 与 javabean 中的 属性名一致
String inputName = item.getFieldName();
String inputValue = item.getString("UTF-8");
if (inputName.equals("categoryid")) {// 分类单独处理
// 获取到选择的分类的id,根据这个id取到分类的信息
String categoryid = item.getString();
System.out.println("categoryid=" + categoryid);
Category category = service.findCategoryById(categoryid);
System.out.println(category);
book.setCategory(category);
} else {
BeanUtils.setProperty(book, inputName, inputValue);
}
} catch (Exception e) {
e.printStackTrace();
}
}
// 添加书籍分类
private void addCategory(HttpServletRequest req, HttpServletResponse resp) {
}else {
req.getSession().setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.web.controller;
Date time = new Date();
SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
String strTime = simpleDateFormat.format(time);
// path属性filename
String path = strTime + File.separator + "books";// 存放到book对象中的路径
// String path = "books";// 存放到book对象中
String filename = fileName + "." + fileType;
// fileDir:图片最终存在于fileDir
File fileDir = new File(dirImages, path + File.separator + filename);
// InputStream inputStream = item.getInputStream(); 从请求 对象中 通过流的方式
// 把 上传的文件加载到 内存中 构建输出流
File parentDir = new File(dirImages, path);// 父目录
if (!parentDir.exists()) {
parentDir.mkdirs();
}
book.setFilename(filename);
book.setPath(path);
InputStream inputStream = item.getInputStream();
FileOutputStream fos = new FileOutputStream(fileDir);
int len = 0;
while ((len = inputStream.read()) != -1) {
fos.write(len);
}
} catch (IOException e) {
e.printStackTrace();
}
}
// 把Fielditem中的数据封装到book中
private void processFormField(FileItem item, HttpServletRequest req, Book book) {
try {
// item每一个item对象代表一个输入框
// 01. 获取input输入框的 name 的值 根据规范 输入框 的name的取值, 与 javabean 中的 属性名一致
String inputName = item.getFieldName();
String inputValue = item.getString("UTF-8");
if (inputName.equals("categoryid")) {// 分类单独处理
// 获取到选择的分类的id,根据这个id取到分类的信息
String categoryid = item.getString();
System.out.println("categoryid=" + categoryid);
Category category = service.findCategoryById(categoryid);
System.out.println(category);
book.setCategory(category);
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
service.managerInformation(username, name, sex, tel);
HttpSession session = req.getSession();
Administrator admin = (Administrator) session.getAttribute("admin");
admin.setName(name);
admin.setSex(sex);
admin.setTel(tel);
session.setAttribute("admin", admin);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
//修改管理员密码
private void managerPassword(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
String repassword = req.getParameter("repassword");
String oldPassword = req.getParameter("oldPassword");
if (!password.equals(repassword)) {
return;
}
Administrator admin = service.findAdminByUsername(username);
if (!admin.getPassword().equals(oldPassword)) {
return;
}
service.managerPassword(username, password);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
private void layout(HttpServletRequest req, HttpServletResponse resp) {
try {
HttpSession session = req.getSession();
session.removeAttribute("admin");
resp.sendRedirect("../admin/managerLogin.jsp");
} catch (Exception e) {
e.printStackTrace();
String password = req.getParameter("password");
String repassword = req.getParameter("repassword");
String oldPassword = req.getParameter("oldPassword");
if(!repassword.equals(password)) {
}
User user = service.findUserByUserName(username);
if(user==null) {
return;
}
if(!user.getPassword().equals(oldPassword)) {
return;
}
service.personPassword(password, username);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
private void search(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String search = req.getParameter("search");
List<Book> searchmessage = service.search(search);
req.setAttribute("books", searchmessage);
req.setAttribute("name", search==null?"":search);
req.getRequestDispatcher("/showBook.jsp").forward(req, resp);
}
private void particulars(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
req.setAttribute("book", book);
req.getRequestDispatcher("/particulars.jsp").forward(req, resp);
}
// 通过书籍id找到书籍信息
private Book findBookById(String book_id) {
Book book = service.findBookById(book_id);
return book;
}
private void addCart(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
HttpSession session = req.getSession();
Cart cart = (Cart) session.getAttribute("cart");
if (cart == null) {
cart = new Cart();
cart.addBook(book);
cart.setBook(book);
session.setAttribute("cart", cart);
}else {
session.setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
private void delItem(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String book_id = req.getParameter("book_id");
Cart cart = (Cart) req.getSession().getAttribute("cart");
cart.getItmes().remove(book_id);
req.getSession().removeAttribute("cart");
resp.sendRedirect(req.getContextPath() + "/showCart.jsp");
}
private void buNow(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
Cart cart1 = (Cart) req.getSession().getAttribute("cart");
if(cart1==null) {
Cart cart = new Cart();
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
cart.addBook(book);
cart.setBook(book);
req.getSession().setAttribute("cart", cart);
}else {
req.getSession().setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.web.controller;
public class ClientServlet extends HttpServlet {
private ClientService service = new ClientServiceImpl();
private ManagerService managerService = new ManagerServiceImpl();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=UTF-8");
String op = req.getParameter("op");// 得到传过来的请求
if (op != null && !op.equals("")) {
// 登录
if (op.equals("login")) {
login(req, resp);
}
// 注销
if (op.equals("layout")) {
layout(req, resp);
}
// 注册
if (op.equals("register")) {
register(req, resp);
}
// 文学艺术类书籍列表
if (op.equals("category")) {
getCategoryBook(req, resp);
}
// 个人信息修改
if (op.equals("personInformation")) {
personInformation(req, resp);
}
// 修改密码
if (op.equals("personPassword")) {
personPassword(req, resp);
}
// 搜索框
if (op.equals("search")) {
search(req, resp);
}
// 详情页面
if (op.equals("particulars")) {
particulars(req, resp);
}
// 添加购物车
if (op.equals("addCart")) {
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
req.setAttribute("book", book);
req.getRequestDispatcher("/particulars.jsp").forward(req, resp);
}
// 通过书籍id找到书籍信息
private Book findBookById(String book_id) {
Book book = service.findBookById(book_id);
return book;
}
private void addCart(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
HttpSession session = req.getSession();
Cart cart = (Cart) session.getAttribute("cart");
if (cart == null) {
cart = new Cart();
cart.addBook(book);
cart.setBook(book);
session.setAttribute("cart", cart);
}else {
session.setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
private void delItem(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String book_id = req.getParameter("book_id");
Cart cart = (Cart) req.getSession().getAttribute("cart");
cart.getItmes().remove(book_id);
req.getSession().removeAttribute("cart");
resp.sendRedirect(req.getContextPath() + "/showCart.jsp");
}
private void buNow(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
Cart cart1 = (Cart) req.getSession().getAttribute("cart");
if(cart1==null) {
Cart cart = new Cart();
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
cart.addBook(book);
}
}
// 把Fielditem中的数据封装到book中
private void processFormField(FileItem item, HttpServletRequest req, Book book) {
try {
// item每一个item对象代表一个输入框
// 01. 获取input输入框的 name 的值 根据规范 输入框 的name的取值, 与 javabean 中的 属性名一致
String inputName = item.getFieldName();
String inputValue = item.getString("UTF-8");
if (inputName.equals("categoryid")) {// 分类单独处理
// 获取到选择的分类的id,根据这个id取到分类的信息
String categoryid = item.getString();
System.out.println("categoryid=" + categoryid);
Category category = service.findCategoryById(categoryid);
System.out.println(category);
book.setCategory(category);
} else {
BeanUtils.setProperty(book, inputName, inputValue);
}
} catch (Exception e) {
e.printStackTrace();
}
}
// 添加书籍分类
private void addCategory(HttpServletRequest req, HttpServletResponse resp) {
try {
Category category = new Category();
BeanUtils.populate(category, req.getParameterMap());
String categoryName = category.getCategory_name();
if (categoryName == null || categoryName.trim().equals("")) {
return;
}
service.addCategory(category);// 调用添加方法
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>添加成功!</div>");
} catch (Exception e) {
e.printStackTrace();
}
return;
}
service.editCategory(category);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
private void delCategory(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String category_id = req.getParameter("category_id");
service.delCategory(category_id);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>删除成功!</div>");
}
// 通过书籍id找到书籍信息
private Book findBookById(String book_id) {
return service.findBookById(book_id);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.web.controller;
order.setQuantity(cart.getTotalQuantity());
order.setMoney(cart.getTotalMoney());
order.setUser(user);
// 订单项
List<Orderitem> oItems = new ArrayList<Orderitem>();
for (Map.Entry<String, CartItem> me : cart.getItmes().entrySet()) {
CartItem cItem = me.getValue();
Orderitem oItem = new Orderitem();
oItem.setId(genOrdernum());
oItem.setBook(cItem.getBook());
oItem.setPrice(cItem.getMoney());
oItem.setQuantity(cItem.getQuantity());
oItem.setOrdernum(ordernum);
oItems.add(oItem);
}
// 建立订单项和订单的关系
order.setItems(oItems);
service.genOrder(order);
req.setAttribute("order", order);
req.getSession().removeAttribute("cart");
req.removeAttribute("cart");
req.getRequestDispatcher("/order.jsp").forward(req, resp);
}
// 生成订单号
private String genOrdernum() {
Date now = new Date();
DateFormat df = new SimpleDateFormat("yyyyMMdd");
String s1 = df.format(now);
return s1 + System.nanoTime();
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.util;
/**
* 这是过滤器
* 主要负责过滤编码为utf-8及登录拦截,禁止未登录就访问
*/
public class MyFilter implements Filter {
@Override
private void addfavorite(HttpServletRequest req, HttpServletResponse resp) throws IOException {
HttpSession session = req.getSession();
User user = (User) session.getAttribute("user");
String user_id = user.getId();
String book_id = req.getParameter("book_id");
boolean isExit = service.findFavorite(user_id, book_id);
if (isExit == false) {
service.addfavorite(user_id, book_id);
}
}
private void changeNum(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String num = req.getParameter("num");
String book_id = req.getParameter("book_id");
// 取出购物车
Cart cart = (Cart) req.getSession().getAttribute("cart");
CartItem item = cart.getItmes().get(book_id);
item.setQuantity(Integer.parseInt(num));
resp.sendRedirect(req.getContextPath() + "/showCart.jsp");
}
private void login(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
HttpSession session = req.getSession();
User user = service.login(username, password);
if (user.getUsername() != null && user.getUsername() != "") {
req.setAttribute("message", "登陆成功");
session.setAttribute("user", user);
req.getRequestDispatcher("/message.jsp").forward(req, resp);
} else {
req.setAttribute("message", "用户名或密码错误,请重新登录");
req.getRequestDispatcher("/message.jsp").forward(req, resp);
}
}
private void layout(HttpServletRequest req, HttpServletResponse resp) {
try {
HttpSession session = req.getSession();
session.removeAttribute("user");// 获取session对象,从session中移除登陆信息
resp.sendRedirect("../client/ClientServlet?op=category");
} catch (Exception e) {
e.printStackTrace();
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
req.setAttribute("book", book);
req.getRequestDispatcher("/particulars.jsp").forward(req, resp);
}
// 通过书籍id找到书籍信息
private Book findBookById(String book_id) {
Book book = service.findBookById(book_id);
return book;
}
private void addCart(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
HttpSession session = req.getSession();
Cart cart = (Cart) session.getAttribute("cart");
if (cart == null) {
cart = new Cart();
cart.addBook(book);
cart.setBook(book);
session.setAttribute("cart", cart);
}else {
session.setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
private void delItem(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String book_id = req.getParameter("book_id");
Cart cart = (Cart) req.getSession().getAttribute("cart");
cart.getItmes().remove(book_id);
req.getSession().removeAttribute("cart");
resp.sendRedirect(req.getContextPath() + "/showCart.jsp");
}
private void buNow(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
Cart cart1 = (Cart) req.getSession().getAttribute("cart");
if(cart1==null) {
Cart cart = new Cart();
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
cart.addBook(book);
cart.setBook(book);
req.getSession().setAttribute("cart", cart);
}else {
req.getSession().setAttribute("message", "购物车里有商品,请支付之后再来添加!");
User user = (User) session.getAttribute("user");
List<Order> orders = service.findUserOrders(user);
req.setAttribute("orders", orders);
req.getRequestDispatcher("/person/personOrder.jsp").forward(req, resp);
}
private void genOrder(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
// 取出购物车信息
// 取出购物项信息
HttpSession session = req.getSession();
Cart cart = (Cart) session.getAttribute("cart");
User user = (User) session.getAttribute("user");
if (cart == null) {
session.setAttribute("message", "会话已经结束!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
//先判断库存够不够!
Book book = cart.getBook();
String book_id = book.getBook_id();
Book findBookById = clientService.findBookById(book_id);
if(findBookById.getBook_kunumber()-cart.getTotalQuantity()<0) {
session.setAttribute("message", "库存不足,无法购买!");
session.removeAttribute("cart");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
Order order = new Order();
order.setTime(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
String ordernum = genOrdernum();
order.setOrdernum(ordernum);
order.setQuantity(cart.getTotalQuantity());
order.setMoney(cart.getTotalMoney());
order.setUser(user);
// 订单项
List<Orderitem> oItems = new ArrayList<Orderitem>();
for (Map.Entry<String, CartItem> me : cart.getItmes().entrySet()) {
CartItem cItem = me.getValue();
Orderitem oItem = new Orderitem();
oItem.setId(genOrdernum());
cart.addBook(book);
cart.setBook(book);
session.setAttribute("cart", cart);
}else {
session.setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
private void delItem(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String book_id = req.getParameter("book_id");
Cart cart = (Cart) req.getSession().getAttribute("cart");
cart.getItmes().remove(book_id);
req.getSession().removeAttribute("cart");
resp.sendRedirect(req.getContextPath() + "/showCart.jsp");
}
private void buNow(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
Cart cart1 = (Cart) req.getSession().getAttribute("cart");
if(cart1==null) {
Cart cart = new Cart();
String book_id = req.getParameter("book_id");
Book book = findBookById(book_id);
cart.addBook(book);
cart.setBook(book);
req.getSession().setAttribute("cart", cart);
}else {
req.getSession().setAttribute("message", "购物车里有商品,请支付之后再来添加!");
req.getRequestDispatcher("../message.jsp").forward(req, resp);
return;
}
req.getRequestDispatcher("../showCart.jsp").forward(req, resp);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.web.controller;
private void addAdmin(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
String name = req.getParameter("name");
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
Administrator admin = new Administrator(username, password, name, sex, tel);
service.addAdmin(admin);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>添加成功!</div>");
}
private void findUsers(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<User> list = service.findUsers();
HttpSession session = req.getSession();
session.setAttribute("users", list);
req.getRequestDispatcher("/admin/managerUsers.jsp").forward(req, resp);
}
private void login(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
if (username == null || username == "") {
req.setAttribute("message", "请填写用户名");
req.getRequestDispatcher("/admin/404.jsp").forward(req, resp);
return;
}
if (password == null || password == "") {
req.setAttribute("message", "请填写密码");
req.getRequestDispatcher("/admin/404.jsp").forward(req, resp);
return;
}
HttpSession session = req.getSession();
Administrator admin = service.login(username, password);
if (admin.getUsername() != null && admin.getUsername() != "") {
req.setAttribute("message", "登陆成功");
session.setAttribute("admin", admin);
req.getRequestDispatcher("/admin/message.jsp").forward(req, resp);
} else {
req.setAttribute("message", "账号或密码错误!");
req.getRequestDispatcher("/admin/404.jsp").forward(req, resp);
}
}
private void managerInformation(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String username = req.getParameter("username");
String name = req.getParameter("name");
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
service.managerInformation(username, name, sex, tel);
HttpSession session = req.getSession();
Administrator admin = (Administrator) session.getAttribute("admin");
admin.setName(name);
return service.findBookById(book_id);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req, resp);
}
}
package com.demo.web.controller;
@WebServlet("/client/ClientServlet")
public class ClientServlet extends HttpServlet {
private ClientService service = new ClientServiceImpl();
private ManagerService managerService = new ManagerServiceImpl();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("UTF-8");
resp.setContentType("text/html;charset=UTF-8");
String op = req.getParameter("op");// 得到传过来的请求
if (op != null && !op.equals("")) {
// 登录
if (op.equals("login")) {
login(req, resp);
}
String address = req.getParameter("address");
boolean isExist = false;// 判断是否存在该用户
if (!username.equals("") && !password.equals("")) {
isExist = service.register(username, password, name, sex, tel, address);
if (isExist == true) {
} else {
resp.getWriter().write("注册成功!");
}
}else {
}
} catch (Exception e) {
e.printStackTrace();
}
}
private void getCategoryBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<Book> books = service.getCategoryBook(req.getParameter("cid"));// 文学艺术类书籍
req.setAttribute("books", books);
List<Category> categoryList= managerService.findAllCategory();
req.setAttribute("categoryList", categoryList);
req.getRequestDispatcher("/showBook.jsp").forward(req, resp);
}
private void personInformation(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
String username = req.getParameter("username");
String name = req.getParameter("name");
String sex = req.getParameter("sex");
String tel = req.getParameter("tel");
String address = req.getParameter("address");
service.personInformation(username, name, sex, tel, address);
User user = (User) req.getSession().getAttribute("user");
user.setUsername(username);
user.setName(name);
user.setSex(sex);
user.setTel(tel);
user.setAddress(address);
req.getSession().setAttribute("user", user);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
private void personPassword(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
}
// 注销
if (op.equals("layout")) {
layout(req, resp);
}
// 添加书籍前先获取所有分类
if (op.equals("addBookUI")) {
addBookUI(req, resp);
}
// 添加书籍
if (op.equals("addBook")) {
try {
addBook(req, resp);
} catch (FileUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// 添加书籍分类
if (op.equals("addCategory")) {
addCategory(req, resp);
}
// 文学艺术类书籍列表
if (op.equals("category")) {
getCategoryBook(req, resp);
}
// 编辑书籍信息前获取书籍的信息回显
if (op.equals("editBookUI")) {
editBookUI(req, resp);
}
// 编辑书籍
if (op.equals("editBook")) {
try {
editBook(req, resp);
} catch (FileUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
// 删除书籍
if (op.equals("delBook")) {
delBook(req, resp);
}
// 获取书籍分类列表
if (op.equals("categoryList")) {
//修改管理员密码
private void managerPassword(HttpServletRequest req, HttpServletResponse resp) throws IOException {
String username = req.getParameter("username");
String password = req.getParameter("password");
String repassword = req.getParameter("repassword");
String oldPassword = req.getParameter("oldPassword");
if (!password.equals(repassword)) {
return;
}
Administrator admin = service.findAdminByUsername(username);
if (!admin.getPassword().equals(oldPassword)) {
return;
}
service.managerPassword(username, password);
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>修改成功!</div>");
}
private void layout(HttpServletRequest req, HttpServletResponse resp) {
try {
HttpSession session = req.getSession();
session.removeAttribute("admin");
resp.sendRedirect("../admin/managerLogin.jsp");
} catch (Exception e) {
e.printStackTrace();
}
}
private void addBookUI(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<Category> categorys = service.findAllCategory();
req.setAttribute("cs", categorys);
req.getRequestDispatcher("/admin/addBook.jsp").forward(req, resp);
}
private void addBook(HttpServletRequest req, HttpServletResponse resp) throws FileUploadException, IOException {
// 判断表单是不是multipart/form-data类型
boolean isMultipart = ServletFileUpload.isMultipartContent(req);
if (!isMultipart) {
throw new RuntimeException("表单上传类型有误!!");
}
// 创建工厂用来 解析请求内容
DiskFileItemFactory factory = new DiskFileItemFactory();
// 构建核心类对象
ServletFileUpload sfu = new ServletFileUpload(factory);
List<FileItem> items = new ArrayList<FileItem>();
items = sfu.parseRequest(req);
Book book = new Book();
for (FileItem item : items) {
}
} catch (IOException e) {
e.printStackTrace();
}
}
// 把Fielditem中的数据封装到book中
private void processFormField(FileItem item, HttpServletRequest req, Book book) {
try {
// item每一个item对象代表一个输入框
// 01. 获取input输入框的 name 的值 根据规范 输入框 的name的取值, 与 javabean 中的 属性名一致
String inputName = item.getFieldName();
String inputValue = item.getString("UTF-8");
if (inputName.equals("categoryid")) {// 分类单独处理
// 获取到选择的分类的id,根据这个id取到分类的信息
String categoryid = item.getString();
System.out.println("categoryid=" + categoryid);
Category category = service.findCategoryById(categoryid);
System.out.println(category);
book.setCategory(category);
} else {
BeanUtils.setProperty(book, inputName, inputValue);
}
} catch (Exception e) {
e.printStackTrace();
}
}
// 添加书籍分类
private void addCategory(HttpServletRequest req, HttpServletResponse resp) {
try {
Category category = new Category();
BeanUtils.populate(category, req.getParameterMap());
String categoryName = category.getCategory_name();
if (categoryName == null || categoryName.trim().equals("")) {
return;
}
service.addCategory(category);// 调用添加方法
resp.getWriter().write("<div style='text-align: center;margin-top: 260px'><img src='" + req.getContextPath()
+ "/img/duigou.png'/>添加成功!</div>");
} catch (Exception e) {
e.printStackTrace();
}
}
private void getCategoryBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
List<Book> books = service.getCategoryBook(req.getParameter("cid"));// 文学艺术类书籍
List<Category> categoryList = service.findAllCategory();// 分类
req.setAttribute("books", books);
req.setAttribute("categoryList", categoryList);
changeNum(req, resp);
}
// 添加收藏夹
if (op.equals("addfavorite")) {
addfavorite(req, resp);
}
// 显示收藏夹
if (op.equals("showfavorite")) {
showfavorite(req, resp);
}
// 删除收藏夹
if (op.equals("delFavorite")) {
delFavorite(req, resp);
}
// 删除收藏夹
if (op.equals("buyNow")) {
buNow(req, resp);
}
}
}
private void delFavorite(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
String book_id = req.getParameter("book_id");
service.delFavorite(book_id);
HttpSession session = req.getSession();
List<Favorite> lists = (List<Favorite>) session.getAttribute("favorite");
Iterator<Favorite> iterator = lists.iterator();
while (iterator.hasNext()) {
Favorite favorite = iterator.next();
if (book_id.equals(favorite.getBook().getBook_id())) {
iterator.remove();// 使用迭代器的删除方法删除
}
}
resp.sendRedirect(req.getContextPath() + "/favorite.jsp");
}
private void showfavorite(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
HttpSession session = req.getSession();
User user = (User) session.getAttribute("user");
List<Favorite> favorites = service.findFavoriteByUserId(user);
session.setAttribute("favorite", favorites);
req.getRequestDispatcher("/favorite.jsp").forward(req, resp);
}