基于javaweb和mysql的jsp+servlet嘟嘟蛋糕商城系统(java+jdbc+servlet+jsp+ajax+mysql+fileupload)
·
基于javaweb和mysql的jsp+servlet嘟嘟蛋糕商城系统(java+jdbc+servlet+jsp+ajax+mysql+fileupload)
私信源码获取及调试交流
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的JSP+Servlet嘟嘟蛋糕商城系统(java+jdbc+servlet+jsp+ajax+mysql+fileupload)
前台用户:
user1 123456
user2 123456
后台管理员:
admin 123456
一、项目运行 环境配置:
Jdk1.8 + Tomcat8.5 + mysql + Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)
项目技术:
Jdbc+ Servlert + html+ css + JavaScript + JQuery + Ajax + Fileupload等等
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式
User user =(User) req.getSession().getAttribute("user");
Orders order = new Orders();
order.setNumber(order.getRandomString(10));
order.setTime(df.format(new Date()));
order.setName(req.getParameter("recipients"));
order.setAddress(req.getParameter("address"));
order.setPhone(req.getParameter("phone"));
order.setAddress_label(req.getParameter("addressLabel"));
order.setSex(req.getParameter("sex"));
order.setUser(user.getUserName());
order.setGoods_id(Integer.parseInt(req.getParameter("id")));
order.setGoods_num(Integer.parseInt(req.getParameter("num")));
order.setGoods_status(1);
int d = service.addOrder(order);
try {
if(d>0) {
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
JSONResult error = JSONResult.errorMsg("订单提交失败!");
resp.getWriter().println(JsonUtil.javaObjectToJson(error));
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 向前端页面返回订单数据列表
*/
public void getOrdersList(HttpServletRequest req,HttpServletResponse resp) {
List<Orders> allOrders = service.getAllOrders();
req.setAttribute("ordersList",allOrders);
try {
req.getRequestDispatcher("/backstage/tgls/ordersManage/orders_list.jsp").forward(req, resp);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 根据订单名查询商品(注意!类别没改)
* @param req
* @param resp
* @throws IOException
*/
public void getOrdersListByName(HttpServletRequest req,HttpServletResponse resp) throws IOException {
//设置请求编码格式:
id = user.getId();
}
System.out.println(id+"dddddddddddddddd");
Map<String, List<Goods>> allGoods = service.getCartGoods(id+"");
try {
req.setAttribute("cart", allGoods);
req.getRequestDispatcher("/showcart.jsp").forward(req, resp);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 获取所有商品列表
* @param req
* @param resp
*/
public void findAllGoods(HttpServletRequest req, HttpServletResponse resp) {
Map<String, List<Goods>> allGoods = service.getAllGoods();
try {
req.setAttribute("allGoods", allGoods);
req.getRequestDispatcher("/main.jsp").forward(req, resp);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
*根据类型获得商品列表
* @param req
* @param resp
*/
public void findGoodsByType(HttpServletRequest req, HttpServletResponse resp) {
String type = req.getParameter("type");
String currentPage = req.getParameter("currentPage");
PageBean pageBean = null;
return fileName;
}
/**
* 获取文件后缀名, 只要jpg或者png格式
* @param item
* @return 如果是jpg,则返回jpg
* 如果png,则返回png
* 否则返回null
*/
public static String getFileSuffix(FileItem item) {
String fileFullName=item.getName();
File fileInfo=new File(fileFullName);
String suffix = fileInfo.getName().substring(fileInfo.getName().lastIndexOf(".") + 1);
if(suffix.equals("jpg") ||suffix.equals("png") ) {
return suffix;
}
return null;
}
}
/**
* 解决中文乱码问题的过滤器
/**
* 修改商品时,获取此商品的全部数据,并返回至修改页面
*/
public void toGoodsUpdatePage(HttpServletRequest req,HttpServletResponse resp) {
int id = Integer.parseInt(req.getParameter("id"));
Goods goods = service.getGoodsInfoById(id);
req.setAttribute("goods", goods);
try {
req.getRequestDispatcher("/backstage/tgls/goodsManage/goods_update.jsp").forward(req, resp);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
*修改商品信息时,如果有修改图片,先将图片进行修改
* @throws IOException
*/
public void upGoodsImage(HttpServletRequest req,HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
FileUploadUtil upFile = new FileUploadUtil();
ServletContext servletContext = req.getSession().getServletContext();
List<FileItem> items= upFile.getRequsetFileItems(req,servletContext);
String imgName = null;
try {
//遍历
for (FileItem file : items) {
if(!file.isFormField()) {
String fileSuffix = FileUploadUtil.getFileSuffix(file);
//必须是jpg或png 图片文件才能进行上传操作
if("jpg".equals(fileSuffix) || "png".equals(fileSuffix)) {
//生成新图片名
imgName = FileUploadUtil.getImgNewName(fileSuffix);
FileUploadUtil.saveFile(file, savePath, imgName);
}
}
}
int d = service.updateGoodsImgById(imgName, Integer.parseInt(req.getParameter("id")));
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 检查旧密码是否正确 ,在修改密码操作时使用
* @throws IOException
*/
public void checkOldPassword(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
User user =(User) req.getSession().getAttribute("user");
String oldPassword = service.getPasswordById(user.getId());
String password = req.getParameter("password");
try {
if(!oldPassword.equals(password)) {
JSONResult errorMsg = JSONResult.errorMsg("原始密码错误,请重新输入");
resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg));
}else {
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 修改密码
* @throws IOException
*/
public void modifyPassword(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
String password = req.getParameter("newPassword");
User user =(User) req.getSession().getAttribute("user");
User user =(User) req.getSession().getAttribute("user");
Orders order = new Orders();
order.setNumber(order.getRandomString(10));
order.setTime(df.format(new Date()));
order.setName(req.getParameter("recipients"));
order.setAddress(req.getParameter("address"));
order.setPhone(req.getParameter("phone"));
order.setAddress_label(req.getParameter("addressLabel"));
order.setSex(req.getParameter("sex"));
order.setUser(user.getUserName());
order.setGoods_id(Integer.parseInt(req.getParameter("id")));
order.setGoods_num(Integer.parseInt(req.getParameter("num")));
order.setGoods_status(1);
int d = service.addOrder(order);
try {
if(d>0) {
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
JSONResult error = JSONResult.errorMsg("订单提交失败!");
resp.getWriter().println(JsonUtil.javaObjectToJson(error));
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 向前端页面返回订单数据列表
*/
public void getOrdersList(HttpServletRequest req,HttpServletResponse resp) {
List<Orders> allOrders = service.getAllOrders();
req.setAttribute("ordersList",allOrders);
try {
req.getRequestDispatcher("/backstage/tgls/ordersManage/orders_list.jsp").forward(req, resp);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 根据订单名查询商品(注意!类别没改)
* @param req
* @param resp
* @throws IOException
*/
}
}
int d = service.updateGoodsImgById(imgName, Integer.parseInt(req.getParameter("id")));
if(d>0) {
JSONResult ok = JSONResult.ok(imgName);
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
JSONResult errorMsg = JSONResult.errorMsg("修改失败,请重试");
resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg));
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 修改商品
* @throws IOException
*/
public void updateGoods(HttpServletRequest req,HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
Goods goods = new Goods();
goods.setId(Integer.parseInt(req.getParameter("id")));
goods.setName(req.getParameter("goodsName"));
goods.setNum(Integer.parseInt(req.getParameter("num")));
goods.setPrice(Double.parseDouble(req.getParameter("price")));
goods.setType(req.getParameter("type"));
goods.setColor(req.getParameter("color"));
goods.setMemory(req.getParameter("memory"));
goods.setDescription(req.getParameter("description"));
int d = service.updateGoodsById(goods);
try {
if(d>0) {
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
JSONResult errorMsg = JSONResult.errorMsg("修改失败,请重试");
resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg));
Map<String, List<Goods>> allGoods = service.getCartGoods(ids+"");
try {
req.setAttribute("cart", allGoods);
req.getRequestDispatcher("/showcart.jsp").forward(req, resp);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
@WebServlet("/backstage_userServlet")
public class UserServlet extends HttpServlet{
UserService service = new UserService();
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String action = req.getParameter("action");
switch(action) {
case "login":login(req, resp);break;
case "modifyPassword":modifyPassword(req, resp);break;
case "checkOldPassword":checkOldPassword(req, resp);break;
case "afterModifyPassword":afterModifyPassword(req, resp);break;
case "logout":logout(req, resp);break;
}
}
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String action = req.getParameter("action");
switch(action) {
case "login":login(req, resp);break;
case "modifyPassword":modifyPassword(req, resp);break;
case "checkOldPassword":checkOldPassword(req, resp);break;
case "afterModifyPassword":afterModifyPassword(req, resp);break;
case "logout":logout(req, resp);break;
}
}
/**
* 用户登录
* @throws IOException
*/
public void login(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
//获取前端页面传来的用户名
String userName = req.getParameter("userName");
//获取前端页面传来的密码
String password = req.getParameter("password");
// 1、先验证该用户的角色是否为管理员
String userRole = service.getUserRoleByName(userName);
try {
if(!"admin".equals(userRole)) {
JSONResult errorMsg = JSONResult.errorMsg("暂无登录权限");
resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg));
}else {
//2、获取用户数据 进行用户名和密码验证
User user = service.getUserByNameAndPassword(userName, password);
if(user!=null) {
//将用户数据保存到session 作用域中,方便在后续的操作中使用用户数据
req.getSession().setAttribute("user", user);
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
// 将错误信息封装在结果集中
JSONResult result = JSONResult.errorMsg("用户名或密码错误,请重试");
//以json的形式返回给前端
resp.getWriter().println(JsonUtil.javaObjectToJson(result));
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 检查旧密码是否正确 ,在修改密码操作时使用
* @throws IOException
*/
}
/**
*根据类型获得商品列表
* @param req
* @param resp
*/
public void findGoodsByType(HttpServletRequest req, HttpServletResponse resp) {
String type = req.getParameter("type");
String currentPage = req.getParameter("currentPage");
PageBean pageBean = null;
// 如果当前第几页currentPage 值为null,说明第一次跳转到此页面或者是要跳转到首页,则设定该值currentPage默认为1
if(currentPage == null) {
pageBean = service.getGoodsByType(type, 4, 1);
}else {
pageBean = service.getGoodsByType(type, 4, Integer.parseInt(currentPage));
}
try {
req.setAttribute("pageBean", pageBean);
req.setAttribute("type", type);
req.getRequestDispatcher("/product.jsp").forward(req, resp);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 获取商品的详细信息
* @param req
* @param resp
*/
public void findGoodsById(HttpServletRequest req, HttpServletResponse resp) {
int id =Integer.parseInt(req.getParameter("id"));
Goods goodsInfo = service.getGoodsInfoById(id);
try {
req.setAttribute("pro", goodsInfo);
this.request = request;
}
@Override
public Map getParameterMap() {
// 先获得请求方式
String method = request.getMethod();
if (method.equalsIgnoreCase("post")) {
// post请求
try {
// 处理post乱码
request.setCharacterEncoding("utf-8");
return request.getParameterMap();
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
} else if (method.equalsIgnoreCase("get")) {
// get请求
Map<String, String[]> parameterMap = request.getParameterMap();
if (!hasEncode) {
for (String parameterName : parameterMap.keySet()) {
String[] values = parameterMap.get(parameterName);
if (values != null) {
for (int i = 0; i < values.length; i++) {
try {
// 处理get乱码
values[i] = new String(values[i]
.getBytes("ISO-8859-1"), "utf-8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
}
}
}
hasEncode = true;
}
return parameterMap;
}
return super.getParameterMap();
}
@Override
public String getParameter(String name) {
/**
* 解决中文乱码问题的过滤器
*/
public class EncodingFilter implements Filter {
public EncodingFilter() { }
public void destroy() {}
public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
// 处理请求乱码
HttpServletRequest httpServletRequest = (HttpServletRequest) request;
HttpServletRequest myRequest = new MyRequest(httpServletRequest);
// 处理响应乱码
response.setContentType("text/html;charset=utf-8");
chain.doFilter(myRequest, response);
}
public void init(FilterConfig fConfig) throws ServletException {
}
}
//自定义request对象
formData.put("imgUrl",imgName);
}
}else {
//非文件数据存入
formData.put(file.getFieldName(), file.getString("utf-8"));
}
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}
Goods goods = new Goods();
goods.setName(formData.get("goodsName"));
goods.setNum(Integer.parseInt(formData.get("num")));
goods.setPrice(Double.parseDouble(formData.get("price")));
goods.setImgurl(formData.get("imgUrl"));
goods.setType(formData.get("type"));
goods.setDescription(formData.get("description"));
goods.setColor(formData.get("color"));
goods.setMemory(formData.get("memory"));
goods.setCreateDate(new SimpleDateFormat("yyyy-MM-dd").format(new Date()));
int d = service.addGoods(goods);
try {
if(d>0) {
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
JSONResult errorMsg = JSONResult.errorMsg("添加失败,请重试");
resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg));
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 向前端页面返回商品数据列表
*/
@WebServlet("/backstage_userServlet")
public class UserServlet extends HttpServlet{
UserService service = new UserService();
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String action = req.getParameter("action");
switch(action) {
case "login":login(req, resp);break;
case "modifyPassword":modifyPassword(req, resp);break;
case "checkOldPassword":checkOldPassword(req, resp);break;
case "afterModifyPassword":afterModifyPassword(req, resp);break;
case "logout":logout(req, resp);break;
}
}
/**
* 用户登录
* @throws IOException
*/
public void login(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
//获取前端页面传来的用户名
String userName = req.getParameter("userName");
//获取前端页面传来的密码
String password = req.getParameter("password");
// 1、先验证该用户的角色是否为管理员
String userRole = service.getUserRoleByName(userName);
try {
if(!"admin".equals(userRole)) {
@WebServlet("/backstage_goodsServlet")
public class GoodsServlet extends HttpServlet{
GoodsService service = new GoodsService();
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String action = req.getParameter("action");
switch(action) {
case "addGoods":addGoods(req,resp);break;
case "getGoodsList":getGoodsList(req,resp);break;
case "getGoodsListByName":getGoodsListByName(req,resp);break;
case "deleteGoods":deleteGoods(req,resp);break;
case "toGoodsUpdatePage":toGoodsUpdatePage(req,resp);break;
case "updateGoods":updateGoods(req,resp);break;
case "upGoodsImage":upGoodsImage(req,resp);break;
case "fastbuy":sendOrder(req,resp);break;
}
}
/**
* 提交订单
* @throws IOException
*/
public void sendOrder(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式
Orders order = new Orders();
order.setNumber(order.getRandomString(10));
order.setTime(df.format(new Date()));
order.setName(req.getParameter("recipients"));
order.setAddress(req.getParameter("address"));
req.setAttribute("cart", allGoods);
req.getRequestDispatcher("/showcart.jsp").forward(req, resp);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}
@WebServlet("/backstage_userServlet")
public class UserServlet extends HttpServlet{
UserService service = new UserService();
@Override
protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String action = req.getParameter("action");
switch(action) {
case "login":login(req, resp);break;
case "modifyPassword":modifyPassword(req, resp);break;
case "checkOldPassword":checkOldPassword(req, resp);break;
case "afterModifyPassword":afterModifyPassword(req, resp);break;
case "logout":logout(req, resp);break;
}
}
/**
* 用户登录
* @throws IOException
*/
public void login(HttpServletRequest req, HttpServletResponse resp) throws IOException {
}
}
/*
* 删除全部订单
*/
private void deleteAllOrders(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
// TODO 自动生成的方法存根
int d = service.deleteAllOrders();
try {
if(d>0) {
JSONResult ok = JSONResult.ok();
resp.getWriter().println(JsonUtil.javaObjectToJson(ok));
}else {
JSONResult errorMsg = JSONResult.errorMsg("删除失败,请重试");
resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg));
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 提交订单
* @throws IOException
*/
public void sendOrder(HttpServletRequest req, HttpServletResponse resp) throws IOException {
//设置请求编码格式:
req.setCharacterEncoding("utf-8");
//设置响应编码格式
resp.setContentType("text/html;charset=utf-8");
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式
User user =(User) req.getSession().getAttribute("user");
Orders order = new Orders();
order.setNumber(order.getRandomString(10));
order.setTime(df.format(new Date()));
* @param resp
*/
public void findAllGoods(HttpServletRequest req, HttpServletResponse resp) {
Map<String, List<Goods>> allGoods = service.getAllGoods();
try {
req.setAttribute("allGoods", allGoods);
req.getRequestDispatcher("/main.jsp").forward(req, resp);
return;
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
/**
*根据类型获得商品列表
* @param req
* @param resp
*/
public void findGoodsByType(HttpServletRequest req, HttpServletResponse resp) {
String type = req.getParameter("type");
String currentPage = req.getParameter("currentPage");
PageBean pageBean = null;
// 如果当前第几页currentPage 值为null,说明第一次跳转到此页面或者是要跳转到首页,则设定该值currentPage默认为1
if(currentPage == null) {
pageBean = service.getGoodsByType(type, 4, 1);
}else {
pageBean = service.getGoodsByType(type, 4, Integer.parseInt(currentPage));
}
try {
req.setAttribute("pageBean", pageBean);
req.setAttribute("type", type);
req.getRequestDispatcher("/product.jsp").forward(req, resp);
} catch (Exception e) {





更多推荐

所有评论(0)