基于javaweb的酒水商城管理系统(java+jsp+bootstrap+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的酒水商城管理系统(java+JSP+bootstrap+servlet+Mysql)
项目介绍
本项目分为前后台，分为管理员与普通用户两种角色，管理员登录后台，普通用户登录前台；
管理员角色：
查看客户信息,酒水管理,查看类目,订单管理等功能。
用户角色包含以下功能：
用户登录与注册,修改个人信息,查看首页,查看酒水分类,查看热销酒水,查看酒水详情,查看购物车,确认收货信息,查看用户订单等功能。
环境需要
1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可 4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 5.数据库：MySql 5.7版本； 6.是否Maven项目：否；
技术栈
JSP+CSS+jQuery+bootstrap+mysql+servlet
使用说明
用户管理控制层：
@Controller
@RequestMapping(“/user”)
public class UserController extends BaseController {
/**
*/
@Autowired
private UserService userService;
// --------------------------------------- 华丽分割线 ------------------------------
/查询列表【不分页】**************/
/**
【不分页 => 查询列表 => 无条件】
@Title: listAll
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listAll”)
public String listAll(User user, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = userService.listAll();
model.addAttribute(“list”, listAll);
return “user/user”;
/**
【不分页=》查询列表=>有条件】
@Title: listByEntity
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByEntity”)
public String listByEntity(User user, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = userService.listAllByEntity(user);
model.addAttribute(“list”, listAll);
return “user/user”;
/**
【不分页=》查询列表=>有条件】
@Title: listByMap
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByMap”)
public String listByMap(User user, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!UserName())){
params.put(“userName”, UserName());
if(!PassWord())){
params.put(“passWord”, PassWord());
if(!Phone())){
params.put(“phone”, Phone());
if(!RealName())){
params.put(“realName”, RealName());
if(!Sex())){
params.put(“sex”, Sex());
if(!Address())){
params.put(“address”, Address());
if(!Email())){
params.put(“email”, Email());
List listAll = userService.listByMap(params);
model.addAttribute(“list”, listAll);
return “user/user”;
/查询列表【分页】**************/
/**
分页查询 返回list对象(通过对象)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByObj”)
public String findByObj(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = userService.findByEntity(user);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, user);
return “user/user”;
/**
分页查询 返回list对象(通过对By Sql)
@param request
@param response
@return
*/
@RequestMapping(value = “/findBySql”)
public String findBySql(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM user WHERE 1=1 ";
if(!UserName())){
sql += " and userName like ‘%“&#UserName()+”%’";
if(!PassWord())){
sql += " and passWord like ‘%“&#PassWord()+”%’";
if(!Phone())){
sql += " and phone like ‘%“&#Phone()+”%’";
if(!RealName())){
sql += " and realName like ‘%“&#RealName()+”%’";
if(!Sex())){
sql += " and sex like ‘%“&#Sex()+”%’";
if(!Address())){
sql += " and address like ‘%“&#Address()+”%’";
if(!Email())){
sql += " and email like ‘%“&#Email()+”%’";
sql += " ORDER BY ID DESC ";
Pager pagers = userService.findBySqlRerturnEntity(sql);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, user);
return “user/user”;
/**
分页查询 返回list对象(通过Map)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByMap”)
public String findByMap(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!UserName())){
params.put(“userName”, UserName());
if(!PassWord())){
params.put(“passWord”, PassWord());
if(!Phone())){
params.put(“phone”, Phone());
if(!RealName())){
params.put(“realName”, RealName());
if(!Sex())){
params.put(“sex”, Sex());
if(!Address())){
params.put(“address”, Address());
if(!Email())){
params.put(“email”, Email());
//分页查询
Pager pagers = userService.findByMap(params);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, user);
return “user/user”;
/【增删改】********************/
/**
跳至添加页面
@return
*/
@RequestMapping(value = “/add”)
public String add() {
return “user/add”;
/**
跳至详情页面
@return
*/
@RequestMapping(value = “/view”)
public String view(Model model,HttpServletRequest request) {
Object attribute = Session().getAttribute(“userId”);
if (attribute == null){
return “redirect:/login/uLogin”;
JSONObject js = new JSONObject();
Integer userId = Integer.String());
User obj = userService.load(userId);
model.addAttribute(“obj”,obj);
return “user/view”;
/**
添加执行
@return
*/
@RequestMapping(value = “/exAdd”)
public String exAdd(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
userService.insert(user);
return “redirect:/user/findBySql.action”;
/**
跳至修改页面
@return
*/
@RequestMapping(value = “/update”)
public String update(Integer id,Model model) {
User obj = userService.load(id);
model.addAttribute(“obj”,obj);
return “user/update”;
/**
添加修改
@return
*/
@RequestMapping(value = “/exUpdate”)
public String exUpdate(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
Object attribute = Session().getAttribute(“userId”);
if (attribute == null){
return “redirect:/login/uLogin”;
JSONObject js = new JSONObject();
user.setId(Integer.String()));
userService.updateById(user);
//2.通过主键id修改
//userService.updateById(user);
return “redirect:/user/view.action”;
/**
删除通过主键
@return
*/
@RequestMapping(value = “/delete”)
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
userService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// userService.deleteByEntity(user);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!UserName())){
// params.put(“userName”, UserName());
// }
//
// if(!PassWord())){
// params.put(“passWord”, PassWord());
// }
//
// if(!Phone())){
// params.put(“phone”, Phone());
// }
//
// if(!RealName())){
// params.put(“realName”, RealName());
// }
//
// if(!Sex())){
// params.put(“sex”, Sex());
// }
//
// if(!Address())){
// params.put(“address”, Address());
// }
//
// if(!Email())){
// params.put(“email”, Email());
// }
//
// userService.deleteByMap(params);
// //4.状态删除
// User load = Id())
// load.setIsDelete(1);
// userService.update(load);
//5.状态删除
//User load = userService.load(id);
//load.setIsDelete(1);
//userService.update(load);
return “redirect:/user/findBySql.action”;
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/查询列表【不分页】**************/
/**
【不分页 => 查询列表 => 无条件】
@Title: listAll
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listAllJson”, method = RequestMethod.POST)
@ResponseBody
public String listAllJson(User user, HttpServletRequest request, HttpServletResponse response){
List listAll = userService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, user);
String();
/**
【不分页=》查询列表=>有条件】
@Title: listByEntity
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByEntityJson”, method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(User user, HttpServletRequest request, HttpServletResponse response){
List listAll = userService.listAllByEntity(user);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, user);
String();
/**
【不分页=》查询列表=>有条件】
@Title: listByMap
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByMapJson”, method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(User user,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!UserName())){
params.put(“userName”, UserName());
if(!PassWord())){
params.put(“passWord”, PassWord());
if(!Phone())){
params.put(“phone”, Phone());
if(!RealName())){
params.put(“realName”, RealName());
if(!Sex())){
params.put(“sex”, Sex());
if(!Address())){
params.put(“address”, Address());
if(!Email())){
params.put(“email”, Email());
List listAll = userService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, user);
String();
/**
分页查询 返回list json(通过对象)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByObjJson”, method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(User user, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = userService.findByEntity(user);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“pagers”, pagers);
jsonObject.put(“obj”, user);
String();
/**
分页查询 返回list json(通过Map)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByMapJson”, method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(User user,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!UserName())){
params.put(“userName”, UserName());
if(!PassWord())){
params.put(“passWord”, PassWord());
if(!Phone())){
params.put(“phone”, Phone());
if(!RealName())){
params.put(“realName”, RealName());
if(!Sex())){
params.put(“sex”, Sex());
if(!Address())){
params.put(“address”, Address());
if(!Email())){
params.put(“email”, Email());
//分页查询
Pager pagers = userService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“pagers”, pagers);
jsonObject.put(“obj”, user);
String();
/**
ajax 添加
@param
@return
*/
@RequestMapping(value = “/exAddJson”, method = RequestMethod.POST)
@ResponseBody
public String exAddJson(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
userService.insert(user);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “添加成功”);
String();
/**
ajax 修改
@param
@return
*/
@RequestMapping(value = “/exUpdate.json”, method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(User user, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
userService.updateById(user);
//2.通过主键id修改
//userService.updateById(user);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “修改成功”);
String();
/**
ajax 删除
@return
*/
@RequestMapping(value = “/delete.json”, method = RequestMethod.POST)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
userService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// userService.deleteByEntity(user);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!UserName())){
// params.put(“userName”, UserName());
// }
//
// if(!PassWord())){
// params.put(“passWord”, PassWord());
// }
//
// if(!Phone())){
// params.put(“phone”, Phone());
// }
//
// if(!RealName())){
// params.put(“realName”, RealName());
// }
//
// if(!Sex())){
// params.put(“sex”, Sex());
// }
//
// if(!Address())){
// params.put(“address”, Address());
// }
//
// if(!Email())){
// params.put(“email”, Email());
// }
//
// userService.deleteByMap(params);
// //4.状态删除
// User load = Id())
// load.setIsDelete(1);
// userService.updateById(load);
//5.状态删除
//User load = userService.load(id);
//load.setIsDelete(1);
//userService.updateById(load);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “删除成功”);
String();
/**
单文件上传
@param file
@param request
@param model
@return
*/
@RequestMapping(value = “/saveFile”)
public String saveFile(@RequestParam(value = “file”, required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println(“开始”);
String path = Session().getServletContext().getRealPath(“/upload”);
String fileName = OriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!ists()){
targetFile.mkdirs();
//保存
try {
} catch (Exception e) {
e.printStackTrace();
return “”;
/**
springMvc多文件上传
@param files
@param id
@return
*/
@RequestMapping(value = “/saveFiles”)
public String saveFiles(@RequestParam(“file”) CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println(“fileName---------->” + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流，同时重命名上传的文件
String filePath = RealPath(“/upload”);
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
File file=new File(filePath+“/”+pre + files[i].getOriginalFilename());
if(!ists()){
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println(“上传出错”);
return “”;
// --------------------------------------- 华丽分割线 ------------------------------
订单管理控制层：
@Controller
@RequestMapping(“/orderDetail”)
public class OrderDetailController extends BaseController {
/**
*/
@Autowired
private OrderDetailService orderDetailService;
// --------------------------------------- 华丽分割线 ------------------------------
/查询列表【不分页】**************/
/**
【不分页 => 查询列表 => 无条件】
@Title: listAll
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listAll”)
public String listAll(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = orderDetailService.listAll();
model.addAttribute(“list”, listAll);
return “orderDetail/orderDetail”;
/**
【不分页=》查询列表=>有条件】
@Title: listByEntity
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByEntity”)
public String listByEntity(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = orderDetailService.listAllByEntity(orderDetail);
model.addAttribute(“list”, listAll);
return “orderDetail/orderDetail”;
/**
【不分页=》查询列表=>有条件】
@Title: listByMap
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByMap”)
public String listByMap(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!OrderId())){
params.put(“orderId”, OrderId());
if(!Status())){
params.put(“status”, Status());
List listAll = orderDetailService.listByMap(params);
model.addAttribute(“list”, listAll);
return “orderDetail/orderDetail”;
/查询列表【分页】**************/
/**
分页查询 返回list对象(通过对象)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByObj”)
public String findByObj(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = orderDetailService.findByEntity(orderDetail);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, orderDetail);
return “orderDetail/orderDetail”;
/**
分页查询 返回list对象(通过对By Sql)
@param request
@param response
@return
*/
@RequestMapping(value = “/findBySql”)
public String findBySql(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM orderDetail WHERE 1=1 ";
if(!ItemId())){
sql += " and itemId like ‘%“&#ItemId()+”%’";
if(!OrderId())){
sql += " and orderId like ‘%“&#OrderId()+”%’";
if(!Status())){
sql += " and status like ‘%“&#Status()+”%’";
sql += " ORDER BY ID DESC ";
Pager pagers = orderDetailService.findBySqlRerturnEntity(sql);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, orderDetail);
return “orderDetail/orderDetail”;
@RequestMapping(value = “/ulist”)
public String ulist(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = “SELECT * FROM order_detail WHERE 1=1 and order_id=”&#OrderId();
if(!ItemId())){
sql += " and itemId like ‘%“&#ItemId()+”%’";
/* if(!OrderId())){
sql += " and orderId like ‘%“&#OrderId()+”%’";
}*/
if(!Status())){
sql += " and status like ‘%“&#Status()+”%’";
sql += " ORDER BY ID DESC ";
Pager pagers = orderDetailService.findBySqlRerturnEntity(sql);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, orderDetail);
return “orderDetail/ulist”;
/**
分页查询 返回list对象(通过Map)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByMap”)
public String findByMap(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!OrderId())){
params.put(“orderId”, OrderId());
if(!Status())){
params.put(“status”, Status());
//分页查询
Pager pagers = orderDetailService.findByMap(params);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, orderDetail);
return “orderDetail/orderDetail”;
/【增删改】********************/
/**
跳至添加页面
@return
*/
@RequestMapping(value = “/add”)
public String add() {
return “orderDetail/add”;
@RequestMapping(value = “/th”)
public String th(Integer id,Model model) {
OrderDetail obj = orderDetailService.load(id);
obj.setStatus(1);
orderDetailService.updateById(obj);
model.addAttribute(“obj”,obj);
return “redirect:/itemOrder/my”;
/**
跳至详情页面
@return
*/
@RequestMapping(value = “/view”)
public String view(Integer id,Model model) {
OrderDetail obj = orderDetailService.load(id);
model.addAttribute(“obj”,obj);
return “orderDetail/view”;
/**
添加执行
@return
*/
@RequestMapping(value = “/exAdd”)
public String exAdd(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
orderDetailService.insert(orderDetail);
return “redirect:/orderDetail/findBySql.action”;
/**
跳至修改页面
@return
*/
@RequestMapping(value = “/update”)
public String update(Integer id,Model model) {
OrderDetail obj = orderDetailService.load(id);
model.addAttribute(“obj”,obj);
return “orderDetail/update”;
/**
添加修改
@return
*/
@RequestMapping(value = “/exUpdate”)
public String exUpdate(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
orderDetailService.updateById(orderDetail);
//2.通过主键id修改
//orderDetailService.updateById(orderDetail);
return “redirect:/orderDetail/findBySql.action”;
/**
删除通过主键
@return
*/
@RequestMapping(value = “/delete”)
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
orderDetailService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// orderDetailService.deleteByEntity(orderDetail);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!ItemId())){
// params.put(“itemId”, ItemId());
// }
//
// if(!OrderId())){
// params.put(“orderId”, OrderId());
// }
//
// if(!Status())){
// params.put(“status”, Status());
// }
//
// orderDetailService.deleteByMap(params);
// //4.状态删除
// OrderDetail load = Id())
// load.setIsDelete(1);
// orderDetailService.update(load);
//5.状态删除
//OrderDetail load = orderDetailService.load(id);
//load.setIsDelete(1);
//orderDetailService.update(load);
return “redirect:/orderDetail/findBySql.action”;
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/查询列表【不分页】**************/
/**
【不分页 => 查询列表 => 无条件】
@Title: listAll
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listAllJson”, method = RequestMethod.POST)
@ResponseBody
public String listAllJson(OrderDetail orderDetail, HttpServletRequest request, HttpServletResponse response){
List listAll = orderDetailService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, orderDetail);
String();
/**
【不分页=》查询列表=>有条件】
@Title: listByEntity
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByEntityJson”, method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(OrderDetail orderDetail, HttpServletRequest request, HttpServletResponse response){
List listAll = orderDetailService.listAllByEntity(orderDetail);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, orderDetail);
String();
/**
【不分页=》查询列表=>有条件】
@Title: listByMap
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByMapJson”, method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(OrderDetail orderDetail,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!OrderId())){
params.put(“orderId”, OrderId());
if(!Status())){
params.put(“status”, Status());
List listAll = orderDetailService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, orderDetail);
String();
/**
分页查询 返回list json(通过对象)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByObjJson”, method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(OrderDetail orderDetail, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = orderDetailService.findByEntity(orderDetail);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“pagers”, pagers);
jsonObject.put(“obj”, orderDetail);
String();
/**
分页查询 返回list json(通过Map)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByMapJson”, method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(OrderDetail orderDetail,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!OrderId())){
params.put(“orderId”, OrderId());
if(!Status())){
params.put(“status”, Status());
//分页查询
Pager pagers = orderDetailService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“pagers”, pagers);
jsonObject.put(“obj”, orderDetail);
String();
/**
ajax 添加
@param
@return
*/
@RequestMapping(value = “/exAddJson”, method = RequestMethod.POST)
@ResponseBody
public String exAddJson(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
orderDetailService.insert(orderDetail);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “添加成功”);
String();
/**
ajax 修改
@param
@return
*/
@RequestMapping(value = “/exUpdate.json”, method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
orderDetailService.updateById(orderDetail);
//2.通过主键id修改
//orderDetailService.updateById(orderDetail);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “修改成功”);
String();
/**
ajax 删除
@return
*/
@RequestMapping(value = “/delete.json”, method = RequestMethod.POST)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
orderDetailService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// orderDetailService.deleteByEntity(orderDetail);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!ItemId())){
// params.put(“itemId”, ItemId());
// }
//
// if(!OrderId())){
// params.put(“orderId”, OrderId());
// }
//
// if(!Status())){
// params.put(“status”, Status());
// }
//
// orderDetailService.deleteByMap(params);
// //4.状态删除
// OrderDetail load = Id())
// load.setIsDelete(1);
// orderDetailService.updateById(load);
//5.状态删除
//OrderDetail load = orderDetailService.load(id);
//load.setIsDelete(1);
//orderDetailService.updateById(load);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “删除成功”);
String();
/**
单文件上传
@param file
@param request
@param model
@return
*/
@RequestMapping(value = “/saveFile”)
public String saveFile(@RequestParam(value = “file”, required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println(“开始”);
String path = Session().getServletContext().getRealPath(“/upload”);
String fileName = OriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!ists()){
targetFile.mkdirs();
//保存
try {
} catch (Exception e) {
e.printStackTrace();
return “”;
/**
springMvc多文件上传
@param files
@param id
@return
*/
@RequestMapping(value = “/saveFiles”)
public String saveFiles(@RequestParam(“file”) CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println(“fileName---------->” + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流，同时重命名上传的文件
String filePath = RealPath(“/upload”);
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
File file=new File(filePath+“/”+pre + files[i].getOriginalFilename());
if(!ists()){
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println(“上传出错”);
return “”;
// --------------------------------------- 华丽分割线 ------------------------------
购物车管理控制层：
@Controller
@RequestMapping(“/car”)
public class CarController extends BaseController {
@Autowired
private ItemService itemService;
@Autowired
private AddressService addressService;
/**
*/
@Autowired
private CarService carService;
// --------------------------------------- 华丽分割线 ------------------------------
/查询列表【不分页】**************/
/**
【不分页 => 查询列表 => 无条件】
@Title: listAll
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listAll”)
public String listAll(Car car, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = carService.listAll();
model.addAttribute(“list”, listAll);
return “car/car”;
/**
【不分页=》查询列表=>有条件】
@Title: listByEntity
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByEntity”)
public String listByEntity(Car car, Model model, HttpServletRequest request, HttpServletResponse response){
List listAll = carService.listAllByEntity(car);
model.addAttribute(“list”, listAll);
return “car/car”;
/**
【不分页=》查询列表=>有条件】
@Title: listByMap
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByMap”)
public String listByMap(Car car, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!UserId())){
params.put(“userId”, UserId());
if(!Num())){
params.put(“num”, Num());
if(!Total())){
params.put(“total”, Total());
List listAll = carService.listByMap(params);
model.addAttribute(“list”, listAll);
return “car/car”;
/查询列表【分页】**************/
/**
分页查询 返回list对象(通过对象)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByObj”)
public String findByObj(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = carService.findByEntity(car);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, car);
return “car/car”;
/**
分页查询 返回list对象(通过对By Sql)
@param request
@param response
@return
*/
@RequestMapping(value = “/findBySql”)
public String findBySql(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = Session().getAttribute(“userId”);
if (attribute == null){
return “redirect:/login/uLogin”;
JSONObject js = new JSONObject();
Integer userId = Integer.String());
//分页查询
String sql = "SELECT * FROM car WHERE 1=1 and user_id = "+userId;
if(!ItemId())){
sql += " and itemId like ‘%“&#ItemId()+”%’";
if(!UserId())){
sql += " and userId like ‘%“&#UserId()+”%’";
if(!Num())){
sql += " and num like ‘%“&#Num()+”%’";
if(!Total())){
sql += " and total like ‘%“&#Total()+”%’";
sql += " ORDER BY ID DESC ";
List listBySqlReturnEntity = carService.listBySqlReturnEntity(sql);
model.addAttribute(“list”, listBySqlReturnEntity);
//存储查询条件
model.addAttribute(“obj”, car);
return “car/car”;
/**
分页查询 返回list对象(通过Map)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByMap”)
public String findByMap(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!UserId())){
params.put(“userId”, UserId());
if(!Num())){
params.put(“num”, Num());
if(!Total())){
params.put(“total”, Total());
//分页查询
Pager pagers = carService.findByMap(params);
model.addAttribute(“pagers”, pagers);
//存储查询条件
model.addAttribute(“obj”, car);
return “car/car”;
/【增删改】********************/
/**
跳至添加页面
@return
*/
@RequestMapping(value = “/add”)
public String add() {
return “car/add”;
/**
跳至详情页面
@return
*/
@RequestMapping(value = “/view”)
public String view(Model model,HttpServletRequest request,String code) {
Object attribute = Session().getAttribute(“userId”);
if (attribute == null){
return “redirect:/login/uLogin”;
Integer userId = Integer.String());
model.addAttribute(“code”, code);
return “car/view”;
/**
添加执行
@return
*/
@RequestMapping(value = “/exAdd”)
@ResponseBody
public String exAdd(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = Session().getAttribute(“userId”);
JSONObject js = new JSONObject();
if (attribute == null){
js.put(“res”, 0);
JSONString();
Integer userId = Integer.String());
car.setUserId(userId);
Item load = itemService.ItemId());
String price = Price();
Double valueOf = Double.valueOf(price);
car.setPrice(valueOf);
if (Zk() != null){
valueOf = (Zk())/10;
BigDecimal bg = new BigDecimal(valueOf).setScale(2, RoundingMode.UP);
car.setPrice(bg.doubleValue());
valueOf= bg.doubleValue();
Integer num = Num();
Double t = valueOf*num;
BigDecimal bg = new BigDecimal(t).setScale(2, RoundingMode.UP);
double doubleValue = bg.doubleValue();
car.setTotal(doubleValue+“”);
carService.insert(car);
js.put(“res”, 1);
JSONString();
/**
跳至修改页面
@return
*/
@RequestMapping(value = “/update”)
public String update(Integer id,Model model) {
Car obj = carService.load(id);
model.addAttribute(“obj”,obj);
return “car/update”;
@RequestMapping(value = “/js”)
@ResponseBody
public String js(@RequestBody List list,Model model,HttpServletRequest request) {
Object attribute = Session().getAttribute(“userId”);
JSONObject js = new JSONObject();
if (attribute == null){
js.put(“res”, 0);
JSONString();
Integer userId = Integer.String());
String key = “car_”+userId;
js.put(“res”, 1);
JSONString();
@RequestMapping(value = “/js2”)
@ResponseBody
public String js2(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
Object attribute = Session().getAttribute(“userId”);
JSONObject js = new JSONObject();
if (attribute == null){
js.put(“res”, 0);
JSONString();
Integer userId = Integer.String());
car.setUserId(userId);
Item load = itemService.ItemId());
String price = Price();
Long valueOf = Long.valueOf(price);
Integer num = Num();
Long t = valueOf*num;
car.String());
carService.insert(car);
String key = “car_”+userId;
List list = new ArrayList();
CarDto d = new CarDto();
d.Id());
d.Num());
list.add(d);
js.put(“res”, 1);
JSONString();
/**
添加修改
@return
*/
@RequestMapping(value = “/exUpdate”)
public String exUpdate(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
carService.updateById(car);
//2.通过主键id修改
//carService.updateById(car);
return “redirect:/car/findBySql.action”;
/**
删除通过主键
@return
*/
@RequestMapping(value = “/delete”)
@ResponseBody
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
carService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// carService.deleteByEntity(car);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!ItemId())){
// params.put(“itemId”, ItemId());
// }
//
// if(!UserId())){
// params.put(“userId”, UserId());
// }
//
// if(!Num())){
// params.put(“num”, Num());
// }
//
// if(!Total())){
// params.put(“total”, Total());
// }
//
// carService.deleteByMap(params);
// //4.状态删除
// Car load = Id())
// load.setIsDelete(1);
// carService.update(load);
//5.状态删除
//Car load = carService.load(id);
//load.setIsDelete(1);
//carService.update(load);
return “redirect:/car/findBySql.action”;
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/查询列表【不分页】**************/
/**
【不分页 => 查询列表 => 无条件】
@Title: listAll
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listAllJson”, method = RequestMethod.POST)
@ResponseBody
public String listAllJson(Car car, HttpServletRequest request, HttpServletResponse response){
List listAll = carService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, car);
String();
/**
【不分页=》查询列表=>有条件】
@Title: listByEntity
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByEntityJson”, method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(Car car, HttpServletRequest request, HttpServletResponse response){
List listAll = carService.listAllByEntity(car);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, car);
String();
/**
【不分页=》查询列表=>有条件】
@Title: listByMap
@Descriiption: TODO(这里用一句话描述这个方法的作用)
@param @return 设定文件
@author
@return String 返回类型
@throws
*/
@RequestMapping(value = “/listByMapJson”, method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(Car car,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!UserId())){
params.put(“userId”, UserId());
if(!Num())){
params.put(“num”, Num());
if(!Total())){
params.put(“total”, Total());
List listAll = carService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“list”, listAll);
jsonObject.put(“obj”, car);
String();
/**
分页查询 返回list json(通过对象)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByObjJson”, method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Car car, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager pagers = carService.findByEntity(car);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“pagers”, pagers);
jsonObject.put(“obj”, car);
String();
/**
分页查询 返回list json(通过Map)
@param request
@param response
@return
*/
@RequestMapping(value = “/findByMapJson”, method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(Car car,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!ItemId())){
params.put(“itemId”, ItemId());
if(!UserId())){
params.put(“userId”, UserId());
if(!Num())){
params.put(“num”, Num());
if(!Total())){
params.put(“total”, Total());
//分页查询
Pager pagers = carService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“pagers”, pagers);
jsonObject.put(“obj”, car);
String();
/**
ajax 添加
@param
@return
*/
@RequestMapping(value = “/exAddJson”, method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
carService.insert(car);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “添加成功”);
String();
/**
ajax 修改
@param
@return
*/
@RequestMapping(value = “/exUpdate.json”, method = RequestMethod.POST)
@ResponseBody
public String exUpdateJson(Car car, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改，可以多传修改条件
carService.updateById(car);
//2.通过主键id修改
//carService.updateById(car);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “修改成功”);
String();
/**
ajax 删除
@return
*/
@RequestMapping(value = “/delete.json”, method = RequestMethod.POST)
@ResponseBody
public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
carService.deleteById(id);
/以下是多种删除方式/
// //2.通过实体条件删除
// carService.deleteByEntity(car);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!ItemId())){
// params.put(“itemId”, ItemId());
// }
//
// if(!UserId())){
// params.put(“userId”, UserId());
// }
//
// if(!Num())){
// params.put(“num”, Num());
// }
//
// if(!Total())){
// params.put(“total”, Total());
// }
//
// carService.deleteByMap(params);
// //4.状态删除
// Car load = Id())
// load.setIsDelete(1);
// carService.updateById(load);
//5.状态删除
//Car load = carService.load(id);
//load.setIsDelete(1);
//carService.updateById(load);
JSONObject jsonObject = new JSONObject();
jsonObject.put(“message”, “删除成功”);
String();
/**
单文件上传
@param file
@param request
@param model
@return
*/
@RequestMapping(value = “/saveFile”)
public String saveFile(@RequestParam(value = “file”, required = false) MultipartFile file, HttpServletRequest request, Model model) {
System.out.println(“开始”);
String path = Session().getServletContext().getRealPath(“/upload”);
String fileName = OriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!ists()){
targetFile.mkdirs();
//保存
try {
} catch (Exception e) {
e.printStackTrace();
return “”;
/**
springMvc多文件上传
@param files
@param id
@return
*/
@RequestMapping(value = “/saveFiles”)
public String saveFiles(@RequestParam(“file”) CommonsMultipartFile[] files,Integer id,HttpServletRequest request){
for(int i = 0;i<files.length;i++){
System.out.println(“fileName---------->” + files[i].getOriginalFilename());
if(!files[i].isEmpty()){
int pre = (int) System.currentTimeMillis();
try {
//拿到输出流，同时重命名上传的文件
String filePath = RealPath(“/upload”);
File f=new File(filePath);
if(!f.exists()){
f.mkdirs();
String fileNmae=new Date().getTime() + files[i].getOriginalFilename();
File file=new File(filePath+“/”+pre + files[i].getOriginalFilename());
if(!ists()){
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println(“上传出错”);
return “”;
// --------------------------------------- 华丽分割线 ------------------------------
本文发布于:2024-02-01 18:41:45，感谢您对本站的认可！
本文链接：https://www.4u4v.net/it/170678410538674.html
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系，我们将在24小时内删除。
| 留言与评论（共有 0 条评论） |
