基于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
Integer userId = Integer.valueOf(attribute.toString());
address.setUserId(userId);
address.setIsUse(0);
addressService.insert(address);
return "redirect:/address/my.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Address obj = addressService.load(id);
model.addAttribute("obj",obj);
return "address/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
addressService.updateById(address);
//2.通过主键id修改
//addressService.updateById(address);
return "redirect:/car/view.action";
}
@RequestMapping(value = "/exUpdate2")
public String exUpdate2(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
addressService.updateById(address);
//2.通过主键id修改
//addressService.updateById(address);
return "redirect:/address/my.action";
}
@RequestMapping(value = "/delete1")
public String delete1(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
}
if(!isEmpty(news.getAddTime())){
params.put("addTime", news.getAddTime());
}
List<News> listAll = newsService.listByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(News news, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<News> pagers = newsService.findByEntity(news);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(News news,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
}
/**
* 分页查询 返回list json(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(OrderDetail orderDetail, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<OrderDetail> pagers = orderDetailService.findByEntity(orderDetail);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", orderDetail);
return jsonObject.toString();
}
/**
* 分页查询 返回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(!isEmpty(orderDetail.getItemId())){
params.put("itemId", orderDetail.getItemId());
}
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();
}
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntity")
public String listByEntity(Sc sc, Model model, HttpServletRequest request, HttpServletResponse response){
List<Sc> listAll = scService.listAllByEntity(sc);
model.addAttribute("list", listAll);
return "sc/sc";
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByMap
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByMap")
public String listByMap(Sc sc, Model model, 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());
}
List<Sc> listAll = scService.listByMap(params);
model.addAttribute("list", listAll);
return "sc/sc";
}
/*********************************查询列表【分页】***********************************************/
/**
* 分页查询 返回list对象(通过对象)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
@ResponseBody
public String findByObjByEntityJson(News news, HttpServletRequest request, HttpServletResponse response) {
//分页查询
Pager<News> pagers = newsService.findByEntity(news);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
* 分页查询 返回list json(通过Map)
*
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)
@ResponseBody
public String findByMapJson(News news,HttpServletRequest request, HttpServletResponse response) {
//通过map查询
Map<String,Object> params = new HashMap<String,Object>();
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());
}
//分页查询
Pager<News> pagers = newsService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", news);
return jsonObject.toString();
}
/**
}
@Controller
@RequestMapping("/orderDetail")
public class OrderDetailController extends BaseController {
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private OrderDetailService orderDetailService;
// --------------------------------------- 华丽分割线 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
return "redirect:/address/findBySql.action";
}
// --------------------------------------- 华丽分割线 ------------------------------
// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------
/*********************************查询列表【不分页】***********************************************/
/**
* 【不分页 => 查询列表 => 无条件】
* @Title: listAll
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(Address address, HttpServletRequest request, HttpServletResponse response){
List<Address> listAll = addressService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", address);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
@ResponseBody
public String listByEntityJson(Address address, HttpServletRequest request, HttpServletResponse response){
List<Address> listAll = addressService.listAllByEntity(address);
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", address);
return jsonObject.toString();
}
newsService.insert(news);
return "redirect:/news/findByObj";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
News obj = newsService.load(id);
model.addAttribute("obj",obj);
return "news/update";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/view")
public String view(Integer id,Model model) {
News obj = newsService.load(id);
model.addAttribute("obj",obj);
return "news/view";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(News news, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
newsService.updateById(news);
//2.通过主键id修改
//newsService.updateById(news);
return "redirect:/news/findByObj";
}
/**
params.put("sex", user.getSex());
}
if(!isEmpty(user.getAddress())){
params.put("address", user.getAddress());
}
if(!isEmpty(user.getEmail())){
params.put("email", user.getEmail());
}
//分页查询
Pager<User> pagers = userService.findByMap(params);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", user);
return jsonObject.toString();
}
/**
* 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", "添加成功");
return jsonObject.toString();
}
/**
* 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", "修改成功");
return jsonObject.toString();
}
/**
//分页查询
Object attribute = request.getSession().getAttribute("userId");
if (attribute == null){
return "redirect:/login/uLogin";
}
JSONObject js = new JSONObject();
Integer userId = Integer.valueOf(attribute.toString());
comment.setUserId(userId);
comment.setAddTime(new Date());
commentService.insert(comment);
return "redirect:/itemOrder/my.action";
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Comment obj = commentService.load(id);
model.addAttribute("obj",obj);
return "comment/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
commentService.updateById(comment);
//2.通过主键id修改
//commentService.updateById(comment);
return "redirect:/comment/findBySql.action";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
commentService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// commentService.deleteByEntity(comment);
Pager<OrderDetail> pagers = orderDetailService.findByEntity(orderDetail);
JSONObject jsonObject = new JSONObject();
jsonObject.put("pagers", pagers);
jsonObject.put("obj", orderDetail);
return jsonObject.toString();
}
/**
* 分页查询 返回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(!isEmpty(orderDetail.getItemId())){
params.put("itemId", orderDetail.getItemId());
}
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);
/**
* ajax 添加
* @param
* @return
*/
@RequestMapping(value = "/exAdd", method = RequestMethod.POST)
@ResponseBody
public String exAdd(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
messageService.insert(message);
JSONObject jsonObject = new JSONObject();
jsonObject.put("message", "添加成功");
return jsonObject.toString();
}
/**
* 跳至修改页面
* @return
*/
@RequestMapping(value = "/update")
public String update(Integer id,Model model) {
Message obj = messageService.load(id);
model.addAttribute("obj",obj);
return "message/update";
}
/**
* 添加修改
* @return
*/
@RequestMapping(value = "/exUpdate")
public String exUpdate(Message message, Model model, HttpServletRequest request, HttpServletResponse response) {
//1.通过实体类修改,可以多传修改条件
messageService.update(message);
//2.通过主键id修改
//messageService.updateById(message);
return "redirect:/message/findByObj";
}
/**
* 删除通过主键
* @return
*/
@RequestMapping(value = "/delete")
public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
///1.通过主键删除
messageService.deleteById(id);
/*以下是多种删除方式*/
// //2.通过实体条件删除
// messageService.deleteByEntity(message);
* @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("上传出错");
}
}
}
return "";
}
// --------------------------------------- 华丽分割线 ------------------------------
}
//
// if(!isEmpty(user.getEmail())){
// params.put("email", user.getEmail());
// }
//
// userService.deleteByMap(params);
// //4.状态删除
// User load = userService.getById(user.getId())
// 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
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
@ResponseBody
public String listAllJson(User user, HttpServletRequest request, HttpServletResponse response){
List<User> listAll = userService.listAll();
JSONObject jsonObject = new JSONObject();
jsonObject.put("list", listAll);
jsonObject.put("obj", user);
return jsonObject.toString();
}
/**
* 【不分页=》查询列表=>有条件】
* @Title: listByEntity
* @Description: TODO(这里用一句话描述这个方法的作用)
* @param @return 设定文件
* @return String 返回类型
* @throws
*/
@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
@ResponseBody
@Controller
@RequestMapping("/itemOrder")
public class ItemOrderController extends BaseController {
@Autowired
private ItemService itemService;
/**
* 依赖注入 start dao/service/===
*/
@Autowired
private UserService userService;
@Autowired
private CarService carService;
@Autowired
private ItemOrderService itemOrderService;
@Autowired
private AddressService addressService;
@Autowired
private OrderDetailService orderDetailService;
// --------------------------------------- 华丽分割线 ------------------------------
/**
* 生成二维码,返回到页面上
* @param response
*/
@RequestMapping(value="/getErWeiCode",method={RequestMethod.POST,RequestMethod.GET} )
public void getErWeiCode(HttpServletResponse response,Integer id){
ItemOrder byId = itemOrderService.getById(id);
String url=JSON.toJSONString(byId);
if(url!=null&&!"".equals(url)){
ServletOutputStream stream=null;
try {
int width=400;
int height=400;
stream=response.getOutputStream();
QRCodeWriter writer=new QRCodeWriter();
BitMatrix m=writer.encode(url, BarcodeFormat.QR_CODE, height,width);
MatrixToImageWriter.writeToStream(m, "png", stream);
} catch (Exception e) {
// TODO: handle exception
* 用户端查询列表
* @param item
* @param model
* @param request
* @param response
* @return
*/
@RequestMapping(value = "/shoplist")
public String shoplist(Item item,String condition, Model model, HttpServletRequest request, HttpServletResponse response) {
//当二级分类为空,并且condition 为空的时候,不做查询
/*if (StringUtils.isEmpty(condition) && item.getCategoryIdTwo() == null){
return "redirect:/login/uIndex.action";
}*/
//直接点击类型过来的
//直接冲数据库查询
String sql = "SELECT * FROM item WHERE 1=1 and isDelete =0 " ;
if(!isEmpty(item.getCategoryIdTwo())){
sql += " and category_id_two= "+item.getCategoryIdTwo();
}
if(!isEmpty(condition)){
sql += " and name like '%"+condition+"%'";
}
if (!StringUtils.isEmpty(item.getPrice())){
sql += " ORDER BY (price+0) DESC";
}
if (item.getGmNum() != null){
sql += " ORDER BY gmNum DESC";
}
if (StringUtils.isEmpty(item.getPrice()) && item.getGmNum() == null){
sql += " ORDER BY id DESC";
}
Pager<Item> pagers = itemService.findBySqlRerturnEntity(sql);
model.addAttribute("pagers", pagers);
model.addAttribute("obj", item);
model.addAttribute("condition", condition);
return "item/shoplist";
}
/**
* 分页查询 返回list对象(通过Map)
*
* @param request
* @param response
* @return
*/
// itemCategoryService.update(load);
//5.状态删除
ItemCategory load = itemCategoryService.load(id);
load.setIsDelete(1);
//将儿子也删除
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();
}