基于javaweb+mysql的ssm农产品特产商城系统(java+ssm+jsp+jquery+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
基于javaweb+mysql的SSM农产品特产商城系统(java+ssm+jsp+jquery+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.是否Maven项目: 是；
6.数据库：MySql 5.7/8.0等版本均可；
技术栈
-
后端：Spring+springmvc+mybatis
-
前端：JSP+css+javascript+jQuery
使用说明
- 使用Navicat或者其它工具，在mysql中创建对应sql文件名称的数据库，并导入项目的sql文件；
2.使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
若为maven项目，导入成功后请执行maven clean;maven install命令，配置tomcat
-
将项目中db.properties配置文件中的数据库配置改为自己的配置;
-
运行项目，在浏览器中输入http://localhost:8080/ssm_yunnanncp_shop/ 登录;
用户账号/密码： user/123456
管理员账号/密码：admin/admin
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 "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
@Controller
@RequestMapping("/sc")
public class ScController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private ScService scService;
@Autowired
private ItemService itemService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(Sc sc, Model model, HttpServletRequest request, HttpServletResponse response){
List<Sc> listAll = scService.listAll();
model.addAttribute("list", listAll);
return "sc/sc";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
@ResponseBody
public String listByEntityJson(Comment comment, HttpServletRequest request, HttpServletResponse response){
List<Comment> listAll = commentService.listAllByEntity(comment);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", comment);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @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
*/
jsonObject.put("pagers", pagers);
jsonObject.put("obj", sc);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(Sc sc,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(sc.getItemId())){
params.put("itemId", sc.getItemId());
}
if(!isEmpty(sc.getUserId())){
params.put("userId", sc.getUserId());
}
//分页查询
Pager<Sc> pagers = scService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", sc);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
@ResponseBody
public String exAddJson(Sc sc, Model model, HttpServletRequest request, HttpServletResponse response) {
scService.insert(sc);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
// }
//
// if(!isEmpty(message.getPhone())){
// params.put("phone", message.getPhone());
// }
//
// if(!isEmpty(message.getContent())){
// params.put("content", message.getContent());
// }
//
// messageService.deleteByMap(params);
// //4.状态删除
// Message load = messageService.getById(message.getId())
// load.setIsDelete(1);
// messageService.update(load);
//5.状态删除
//Message load = messageService.load(id);
//load.setIsDelete(1);
//messageService.update(load);
return "redirect:/message/findByObj";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(Message message, HttpServletRequest request, HttpServletResponse response){
List<Message> listAll = messageService.listAll();
JSONObject jsonObject = new JSONObject();
}
List<Address> listAll = addressService.listByMap(params);
model.addAttribute("list", listAll);
return "address/address";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObj")
public String findByObj(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<Address> pagers = addressService.findByEntity(address);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", address);
return "address/address";
}
/**
* 分页查询 返回list对象(通过对By Sql)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findBySql")
public String findBySql(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
//分页查询
String sql = "SELECT * FROM address WHERE 1=1 ";
if(!isEmpty(address.getName())){
sql += " and name like '%"+address.getName()+"%'";
}
if(!isEmpty(address.getPhone())){
String path = request.getSession().getServletContext().getRealPath("/upload");
String fileName = file.getOriginalFilename();
System.out.println(path);
File targetFile = new File(path, fileName);
if(!targetFile.exists()){
targetFile.mkdirs();
}
//保存
try {
file.transferTo(targetFile);
} 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 = 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("上传出错");
}
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
@ResponseBody
public String listByMapJson(Item item,HttpServletRequest request, HttpServletResponse response){
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(item.getName())){
params.put("name", item.getName());
}
if(!isEmpty(item.getPrice())){
params.put("price", item.getPrice());
}
if(!isEmpty(item.getScNum())){
params.put("scNum", item.getScNum());
}
if(!isEmpty(item.getGmNum())){
params.put("gmNum", item.getGmNum());
}
if(!isEmpty(item.getUrl1())){
params.put("url1", item.getUrl1());
}
if(!isEmpty(item.getUrl2())){
params.put("url2", item.getUrl2());
}
if(!isEmpty(item.getUrl3())){
params.put("url3", item.getUrl3());
}
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())){
* @return
*/
@RequestMapping(value = "/findByMap")
public String findByMap(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(manage.getUserName())){
params.put("userName", manage.getUserName());
}
if(!isEmpty(manage.getPassWord())){
params.put("passWord", manage.getPassWord());
}
if(!isEmpty(manage.getRealName())){
params.put("realName", manage.getRealName());
}
//分页查询
Pager<Manage> pagers = manageService.findByMap(params);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", manage);
return "manage/manage";
}
/**********************************【增删改】******************************************************/
/**
* 跳至添加页面
* @return
*/
@RequestMapping(value = "/add")
public String add() {
return "manage/add";
}
/**
* 跳至详情页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
Manage obj = manageService.load(id);
model.addAttribute("obj",obj);
return "manage/view";
}
/**
* 添加执行
* @return
*/
@RequestMapping(value = "/exAdd")
public String exAdd(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {
manageService.insert(manage);
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(ItemOrder itemOrder,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
if(!isEmpty(itemOrder.getItemId())){
params.put("itemId", itemOrder.getItemId());
}
if(!isEmpty(itemOrder.getUserId())){
params.put("userId", itemOrder.getUserId());
}
if(!isEmpty(itemOrder.getCode())){
params.put("code", itemOrder.getCode());
}
if(!isEmpty(itemOrder.getAddTime())){
params.put("addTime", itemOrder.getAddTime());
}
if(!isEmpty(itemOrder.getTotal())){
params.put("total", itemOrder.getTotal());
}
if(!isEmpty(itemOrder.getIsDelete())){
params.put("isDelete", itemOrder.getIsDelete());
}
if(!isEmpty(itemOrder.getStatus())){
params.put("status", itemOrder.getStatus());
}
//分页查询
Pager<ItemOrder> pagers = itemOrderService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", itemOrder);
return jsonObject.toString();
}
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)
if(!isEmpty(car.getTotal())){
params.put("total", car.getTotal());
}
//分页查询
Pager<Car> 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 = request.getSession().getAttribute("userId");
if (attribute == null){
return "redirect:/login/uLogin";
}
Integer userId = Integer.valueOf(attribute.toString());
model.addAttribute("code", code);
return "car/view";
}
/**
* 添加执行
* @return
*/
String sql2 = "SELECT * FROM item_category WHERE isDelete = 0 and pid = "+load.getId();
List<ItemCategory> childrens = itemCategoryService.listBySqlReturnEntity(sql2);
if (!CollectionUtils.isEmpty(childrens)){
for (ItemCategory i : childrens){
i.setIsDelete(1);
itemCategoryService.updateById(i);
}
}
itemCategoryService.updateById(load);
return "redirect:/itemCategory/findBySql.action";
}
@RequestMapping(value = "/delete2")
public String delete2(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
ItemCategory load = itemCategoryService.load(id);
load.setIsDelete(1);
itemCategoryService.updateById(load);
//将儿子也删除
String sql2 = "SELECT * FROM item_category WHERE isDelete = 0 and pid = "+load.getId();
List<ItemCategory> childrens = itemCategoryService.listBySqlReturnEntity(sql2);
if (!CollectionUtils.isEmpty(childrens)){
for (ItemCategory i : childrens){
i.setIsDelete(1);
itemCategoryService.updateById(i);
}
}
return "redirect:/itemCategory/findBySql2.action?pid="+load.getPid();
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
return js.toJSONString();
}
Integer userId = Integer.valueOf(attribute.toString());
User byId = userService.getById(userId);
if (StringUtils.isEmpty(byId.getAddress())){
js.put("res", 2);
return js.toJSONString();
}
List<Integer> ids = new ArrayList<Integer>();
double to = 0.0;
for (CarDto c : list){
ids.add(c.getId());
Car load = carService.load(c.getId());
to += load.getPrice()*c.getNum();
}
ItemOrder order= new ItemOrder();
order.setStatus(0);
order.setCode(getOrderNo());
order.setIsDelete(0);
order.setTotal(String.valueOf(to));
order.setUserId(userId);
order.setAddTime(new Date());
itemOrderService.insert(order);
//删除购车
if (!CollectionUtils.isEmpty(ids)){
for (CarDto c : list){
Car load = carService.load(c.getId());
OrderDetail de = new OrderDetail();
de.setItemId(load.getItemId());
de.setOrderId(order.getId());
de.setStatus(0);
de.setNum(c.getNum());
de.setTotal(String.valueOf(c.getNum()*c.getNum()));
orderDetailService.insert(de);
//修改成交数
Item load2 = itemService.load(load.getItemId());
load2.setGmNum(load2.getGmNum()+c.getNum());
itemService.updateById(load2);
carService.deleteById(c.getId());
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAll")
public String listAll(Message message, Model model, HttpServletRequest request, HttpServletResponse response){
List<Message> listAll = messageService.listAll();
model.addAttribute("list", listAll);
return "message/message";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(Message message, Model model, HttpServletRequest request, HttpServletResponse response){
List<Message> listAll = messageService.listAllByEntity(message);
model.addAttribute("list", listAll);
return "message/message";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(Message message, Model model, 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());
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
@Controller
@RequestMapping("/message")
public class MessageController extends BaseController {
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(car.getItemId())){
// params.put("itemId", car.getItemId());
// }
//
// if(!isEmpty(car.getUserId())){
// params.put("userId", car.getUserId());
// }
//
// if(!isEmpty(car.getNum())){
// params.put("num", car.getNum());
// }
//
// if(!isEmpty(car.getTotal())){
// params.put("total", car.getTotal());
// }
//
// carService.deleteByMap(params);
// //4.状态删除
// Car load = carService.getById(car.getId())
// 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", "删除成功");
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");
String fileName = file.getOriginalFilename();
System.out.println(path);
@Controller
@RequestMapping("/message")
public class MessageController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private MessageService messageService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @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(!isEmpty(car.getItemId())){
params.put("itemId", car.getItemId());
}
if(!isEmpty(car.getUserId())){
params.put("userId", car.getUserId());
}
if(!isEmpty(car.getNum())){
params.put("num", car.getNum());
}
if(!isEmpty(car.getTotal())){
params.put("total", car.getTotal());
}
List<Car> 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<Car> pagers = carService.findByEntity(car);
model.addAttribute("pagers", pagers);
//存储查询条件
model.addAttribute("obj", car);
return "car/car";
}
/**
* 分页查询 返回list对象(通过对By Sql)
扫一扫
2461
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
