基于javaweb+mysql的ssm网上果蔬商城水果蔬菜商城系统(java+ssm+mysql+tomcat+jsp)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM网上果蔬商城水果蔬菜商城系统(java+ssm+mysql+tomcat+jsp)
一、项目简述
功能: 功能:系统分管理员界面与用户界面 管理员:用户管理,商品类别管理,商品管理,订单管理,公 告管理留言里筲等 向户:房总主册功能,用户登录功能,商品浏览,商品留言评 论,商品购买,商品支付,订单查询等等
二、项目运行
环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术: JSP +Spring + SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax + Fileupload + maven等等。
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(News news, Model model, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAll();
model.addAttribute("list", listAll);
return "news/news";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(News news, Model model, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAllByEntity(news);
model.addAttribute("list", listAll);
return "news/news";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(News news, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(news.getName())){
List<CategoryDto> parseArray = JSONArray.parseArray(string, CategoryDto.class);
System.out.println(JSONObject.toJSONString(parseArray));
model.addAttribute("lbs",parseArray);*/
// 1-500
//热销
List<Item> listBySqlReturnEntity = itemService.listBySqlReturnEntity("SELECT * FROM item WHERE 1=1 and isDelete =0 order by gmNum desc limit 0,10");
model.addAttribute("rxs",listBySqlReturnEntity);
//折扣
List<Item> zks = itemService.listBySqlReturnEntity("SELECT * FROM item WHERE 1=1 and isDelete =0 and zk is not null order by zk desc limit 0,10");
model.addAttribute("zks",zks);
//做推荐
Object attribute = request.getSession().getAttribute("userId");
if (attribute != null){
Integer userId = Integer.valueOf(attribute.toString());
//协同过滤
List<Item> tjs = getListByUCF(userId);
model.addAttribute("tjs",tjs);
}
model.addAttribute("obj",item);
model.addAttribute("prices",prices);
model.addAttribute("xl",xl);
return "login/uIndex";
}
private List<Item> getListByUCF(Integer userId) {
List<Item> returnList = new ArrayList<Item> ();
List<User> listAll = userService.listAll();
List<Integer> userIds = new ArrayList<Integer>();
List<ItemDto> res = new ArrayList<ItemDto>();
@Controller
@RequestMapping("/news")
public class NewsController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private NewsService newsService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(News news, Model model, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAll();
model.addAttribute("list", listAll);
return "news/news";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(News news, Model model, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAllByEntity(news);
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(ItemCategory itemCategory,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(itemCategory.getName())){
params.put("name", itemCategory.getName());
}
if(!isEmpty(itemCategory.getPid())){
params.put("pid", itemCategory.getPid());
}
if(!isEmpty(itemCategory.getIsDelete())){
params.put("isDelete", itemCategory.getIsDelete());
}
//分页查询
Pager<ItemCategory> pagers = itemCategoryService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", itemCategory);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response) {
itemCategoryService.insert(itemCategory);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
// if(!isEmpty(news.getName())){
// params.put("name", news.getName());
// }
//
// if(!isEmpty(news.getContent())){
// params.put("content", news.getContent());
// }
//
// if(!isEmpty(news.getAddTime())){
// params.put("addTime", news.getAddTime());
// }
//
// newsService.deleteByMap(params);
// //4.状态删除
// News load = newsService.getById(news.getId())
// load.setIsDelete(1);
// newsService.update(load);
//5.状态删除
//News load = newsService.load(id);
//load.setIsDelete(1);
//newsService.update(load);
return "redirect:/news/findByObj";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(News news, HttpServletRequest request, HttpServletResponse response){
List<News> listAll = newsService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
}
if(!isEmpty(item.getUrl5())){
params.put("url5", item.getUrl5());
}
if(!isEmpty(item.getMs())){
params.put("ms", item.getMs());
}
if(!isEmpty(item.getPam1())){
params.put("pam1", item.getPam1());
}
if(!isEmpty(item.getPam2())){
params.put("pam2", item.getPam2());
}
if(!isEmpty(item.getPam3())){
params.put("pam3", item.getPam3());
}
if(!isEmpty(item.getType())){
params.put("type", item.getType());
}
if(!isEmpty(item.getIsDelete())){
params.put("isDelete", item.getIsDelete());
}
List<Item> listAll = itemService.listByMap(params);
model.addAttribute("list", listAll);
return "item/item";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Item item, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Item> pagers = itemService.findByEntity(item);
model.addAttribute("pagers", pagers);
// }
//
// if(!isEmpty(item.getUrl4())){
// params.put("url4", item.getUrl4());
// }
//
// if(!isEmpty(item.getUrl5())){
// params.put("url5", item.getUrl5());
// }
//
// if(!isEmpty(item.getMs())){
// params.put("ms", item.getMs());
// }
//
// if(!isEmpty(item.getPam1())){
// params.put("pam1", item.getPam1());
// }
//
// if(!isEmpty(item.getPam2())){
// params.put("pam2", item.getPam2());
// }
//
// if(!isEmpty(item.getPam3())){
// params.put("pam3", item.getPam3());
// }
//
// if(!isEmpty(item.getType())){
// params.put("type", item.getType());
// }
//
// if(!isEmpty(item.getIsDelete())){
// params.put("isDelete", item.getIsDelete());
// }
//
// itemService.deleteByMap(params);
// //4.状态删除
// Item load = itemService.getById(item.getId())
// load.setIsDelete(1);
// itemService.updateById(load);
//5.状态删除
//Item load = itemService.load(id);
//load.setIsDelete(1);
//itemService.updateById(load);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "删除成功");
}
if(!isEmpty(orderDetail.getOrderId())){
params.put("orderId", orderDetail.getOrderId());
}
if(!isEmpty(orderDetail.getStatus())){
params.put("status", orderDetail.getStatus());
}
//分页查询
Pager<OrderDetail> pagers = orderDetailService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", orderDetail);
return jsonObject.toString();
}
/**
* 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", "添加成功");
return jsonObject.toString();
}
/**
* 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();
*/
@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", "添加成功");
return jsonObject.toString();
}
/**
* 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", "修改成功");
return jsonObject.toString();
}
/**
* 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);
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(itemCategory.getName())){
params.put("name", itemCategory.getName());
}
if(!isEmpty(itemCategory.getPid())){
params.put("pid", itemCategory.getPid());
}
if(!isEmpty(itemCategory.getIsDelete())){
params.put("isDelete", itemCategory.getIsDelete());
}
List<ItemCategory> listAll = itemCategoryService.listByMap(params);
model.addAttribute("list", listAll);
return "itemCategory/itemCategory";
}
/*********************************查询列表【分页】***********************************************/
@Autowired
private ItemService itemService;
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<ItemCategory> pagers = itemCategoryService.findByEntity(itemCategory);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", itemCategory);
return "itemCategory/itemCategory";
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Comment> pagers = commentService.findByEntity(comment);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", comment);
return "comment/comment";
}
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM comment WHERE 1=1 ";
if(!isEmpty(comment.getUserId())){
sql += " and userId like '%"+comment.getUserId()+"%'";
}
if(!isEmpty(comment.getItemId())){
sql += " and itemId like '%"+comment.getItemId()+"%'";
}
if(!isEmpty(comment.getContent())){
sql += " and content like '%"+comment.getContent()+"%'";
}
if(!isEmpty(comment.getAddTime())){
sql += " and addTime like '%"+comment.getAddTime()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<Comment> pagers = commentService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", comment);
return "comment/comment";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(Comment comment,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(comment.getUserId())){
params.put("userId", comment.getUserId());
}
if(!isEmpty(comment.getItemId())){
params.put("itemId", comment.getItemId());
}
if(!isEmpty(comment.getContent())){
params.put("content", comment.getContent());
}
if(!isEmpty(comment.getAddTime())){
params.put("addTime", comment.getAddTime());
}
List<Comment> listAll = commentService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", comment);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Comment comment, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Comment> pagers = commentService.findByEntity(comment);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", comment);
return jsonObject.toString();
}
sql += " and phone like '%"+user.getPhone()+"%'";
}
if(!isEmpty(user.getRealName())){
sql += " and realName like '%"+user.getRealName()+"%'";
}
if(!isEmpty(user.getSex())){
sql += " and sex like '%"+user.getSex()+"%'";
}
if(!isEmpty(user.getAddress())){
sql += " and address like '%"+user.getAddress()+"%'";
}
if(!isEmpty(user.getEmail())){
sql += " and email like '%"+user.getEmail()+"%'";
}
sql += " ORDER BY ID DESC ";
Pager<User> 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(!isEmpty(user.getUserName())){
params.put("userName", user.getUserName());
}
if(!isEmpty(user.getPassWord())){
params.put("passWord", user.getPassWord());
}
if(!isEmpty(user.getPhone())){
params.put("phone", user.getPhone());
}
@RequestMapping(value = "/pay")
public String pay(Integer id,Model model) {
ItemOrder obj = itemOrderService.load(id);
// Integer addressId = obj.getAddressId();
// Address load = addressService.load(addressId);
// model.addAttribute("obj",obj);
// model.addAttribute("address", load);
return "itemOrder/pay";
}
//查询物流信息
@RequestMapping(value="/wl",produces="text/html;charset=UTF-8")
@ResponseBody
public String upass(Integer id,HttpServletRequest request,String password) throws UnsupportedEncodingException{
JSONObject j = new JSONObject();
ItemOrder obj = itemOrderService.load(id);
KD100Service service = new KD100Service();
LogisticsResponse queryLogistics = service.queryLogistics(obj.getWlgs(), obj.getWlcode());
j.put("res", 1);
j.put("data", queryLogistics);
return j.toString();
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(ItemOrder itemOrder, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
itemOrderService.updateById(itemOrder);
//2.通过主键id修改
//itemOrderService.updateById(itemOrder);
return "redirect:/itemOrder/findBySql.action";
}
/**
items.add(user_item[j]);
itemUserCollection.put(user_item[j], new HashSet<String>());//创建物品--用户倒排关系
itemUserCollection.get(user_item[j]).add(user_item[0]);
}
}
a++;
}
System.out.println(itemUserCollection.toString());
//计算相似度矩阵【稀疏】
Set<Entry<String, Set<String>>> entrySet = itemUserCollection.entrySet();
Iterator<Entry<String, Set<String>>> iterator = entrySet.iterator();
while(iterator.hasNext()){
Set<String> commonUsers = iterator.next().getValue();
for (String user_u : commonUsers) {
for (String user_v : commonUsers) {
if(user_u.equals(user_v)){
continue;
}
sparseMatrix[userID.get(user_u)][userID.get(user_v)] += 1;//计算用户u与用户v都有正反馈的物品总数
}
}
}
System.out.println(userItemLength.toString());
String recommendUser = String.valueOf(userId);
System.out.println(userID.get(recommendUser));
//计算用户之间的相似度【余弦相似性】
Integer s = userID.get(recommendUser);
int recommendUserId = 0;
if (s != null){
recommendUserId = s;
}else{
}
//判断当前用户的index
Integer index = 0;
for(int j = 0; j < userIds.size(); j ++){
if (userIds.get(j).equals(recommendUserId)){
index = j;
}
}
recommendUserId = index;
for (int j = 0;j < sparseMatrix.length; j++) {
if(j != recommendUserId){
// System.out.println(idUser.get(recommendUserId)+"--"+idUser.get(j)+"相似度:"+sparseMatrix[recommendUserId][j]/Math.sqrt(userItemLength.get(idUser.get(recommendUserId))*userItemLength.get(idUser.get(j))));
}
}
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 = request.getRealPath("/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(!file.exists()){
file.createNewFile();
}
files[i].transferTo(file);
} catch (Exception e) {
e.printStackTrace();
System.out.println("上传出错");
}
}
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
//
// if(!isEmpty(item.getPam1())){
// params.put("pam1", item.getPam1());
// }
//
// if(!isEmpty(item.getPam2())){
// params.put("pam2", item.getPam2());
// }
//
// if(!isEmpty(item.getPam3())){
// params.put("pam3", item.getPam3());
// }
//
// if(!isEmpty(item.getType())){
// params.put("type", item.getType());
// }
//
// if(!isEmpty(item.getIsDelete())){
// params.put("isDelete", item.getIsDelete());
// }
//
// itemService.deleteByMap(params);
// //4.状态删除
// Item load = itemService.getById(item.getId())
// load.setIsDelete(1);
// itemService.updateById(load);
//5.状态删除
//Item load = itemService.load(id);
//load.setIsDelete(1);
//itemService.updateById(load);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "删除成功");
return jsonObject.toString();
}
/**
* 单文件上传
* @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 = request.getSession().getServletContext().getRealPath("/upload");
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(Message message, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Message> pagers = messageService.findByEntity(message);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", message);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(Message message,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(message.getName())){
params.put("name", message.getName());
}
if(!isEmpty(message.getPhone())){
params.put("phone", message.getPhone());
}
if(!isEmpty(message.getContent())){
params.put("content", message.getContent());
}
//分页查询
Pager<Message> pagers = messageService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", message);
return jsonObject.toString();
}
/**