基于javaweb+mysql的ssm+maven农资采购商城系统(java+ssm+jsp+javascript+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven农资采购商城系统(java+ssm+jsp+javascript+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项目:是;
技术栈
- 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+CSS+JavaScript+jQuery
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven;若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中jdbc.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,前台地址:http://localhost:8080/snack/shop/index 注:tomcat中配置的路径必须为snack 用户账号/密码:wangzixiao/123456 后台地址:http://localhost:8080/snack/admin/login/adminLogin 管理员账号/密码:admin/123456
@Controller
@RequestMapping("/sorder")
public class SorderController {
@Autowired
private sorderService sorderService=null;
@Autowired
private userService userService;
@RequestMapping(value="/add",method=RequestMethod.POST)
public String addSorder(Snackinfo snackinfo,HttpSession session) {
System.out.println("-------addCar()------"+snackinfo.getsNumber());
Snackinfo findSnackinfo = sorderService.snackfindById(snackinfo.getsId());
findSnackinfo.setsNumber(snackinfo.getsNumber());
//2:判断当前session是否有购物车,如果没有则创建
if (session.getAttribute("receiptinfo")==null) {
//创建购物车,存到session中
session.setAttribute("receiptinfo", new Receiptinfo(new HashSet<Orderdetail>()));
}
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
//3:把农资信息转化为sorder,并且添加到购物车中(判断购物车是否重复)
receiptinfo = sorderService.addSorder(receiptinfo, findSnackinfo);
receiptinfo.setoPhone(cluTotal(receiptinfo));
return "redirect:gotocar";
}
@RequestMapping("gotocar")
public String gotocar() {
return "product/car";
}
//计算总金额
public String cluTotal(Receiptinfo receiptinfo) {
//查登陆的用户
@RequestMapping("readUserinfo")
@ResponseBody
public AjaxResult readUserinfo(Userinfo userinfo,HttpServletRequest request){
AjaxResult aj=new AjaxResult();
Userinfo usr= userService.selectUserinfoById(userinfo);
if(usr!=null){
aj.setTag(usr);
}
return aj;
}
//修改个人信息
@RequestMapping("editUserinfo")
@ResponseBody
public int editUserinfo(Userinfo userinfo){
int rs= userService.updateUserinfoById(userinfo);
return rs;
}
//跳转注册
@RequestMapping("userPersonalInfo")
public String gotoPersonalInfo(){
return "user/personalInfo";
}
//加载个人信息界面
@RequestMapping("userInfo")
public String gotoUserInfo(){
return "user/userInfo";
}
//跳转个人积分页面
@RequestMapping("userIntegral")
public String userIntegral(){
return "user/integral";
}
//跳转个人图片
@RequestMapping("userGerenImg")
public String userGerenImg(){
return "user/gerenImg";
}
//加载个人积分
@RequestMapping("userIntegralLimit")
@ResponseBody
public DataTables userIntegralLimit(HttpServletRequest request,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("uId",request.getSession().getAttribute("frontuserId"));
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
adminSnackInfoService.updateAdminSnackinfo(snackinfo);
return ResponseUtil.successToClient();
}
}
}
@Controller
@RequestMapping("/shop/")
public class ShopControll {
@Autowired
public shopService shopService=null;
//主页
@RequestMapping("index")
public String gotoIndex(HttpServletRequest request){
String path = request.getSession().getServletContext().getRealPath("/image/trimImg/");
//上传文件名
String filename = fileName;
File filepath = new File(path,filename);
//判断路径是否存在,如果不存在就创建一个
//filepath.delete();
if (!filepath.getParentFile().exists()) {
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
return ResponseUtil.errorToClient();
}
}
}
public class MyHandlerInterceptor implements HandlerInterceptor{
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
int k=0;
int p=0;
String uri=request.getRequestURI();
if(uri.indexOf("login")!=-1){
return true;
}
HttpSession session = request.getSession();
List<Permission> list = (List<Permission>)session.getAttribute("allPer");
List<Permission> list2 = (List<Permission>)session.getAttribute("userPer");
for (int i = 0; i < list.size(); i++) {
if(uri.equals((list.get(i).getUrl()))){
for (int j = 0; j < list2.size(); j++) {
k++;
if(uri.contains(list2.get(j).getUrl())){
@Controller
@RequestMapping("/user/")
public class UserControll {
@Autowired
private userService userService;
@Autowired
private sorderService sorderService;
@Autowired
private adminOrderService adminOrderService;
//跳转注册
@RequestMapping("userRegisterGet")
public String gotoRegister(){
return "user/register";
}
//注册判断用户名存在
@RequestMapping("selectUserOne")
@ResponseBody
public AjaxResult getUserOne(Userinfo userinfo){
AjaxResult aj=new AjaxResult();
Userinfo rs = userService.selectUserOne(userinfo);
aj.setTag(rs);
public String mainToAdminImg(){
return "admin/snackinfo/adminSnackinfo";
}
//
@RequestMapping("adminSnackinfoLimit")
@ResponseBody
public DataTables adminOrderLimit(int start,int length,
String sName,String sType,String startDate,String endDate){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
map.put("sType",sType);
map.put("sName",sName);
map.put("startDate",startDate);
map.put("endDate",endDate);
PageHelp<Snackinfo> pageHelp = adminSnackInfoService.selectAdminSnackinfoLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//删除用户
@RequestMapping("delAdminUserinfo")
@ResponseBody
public String delUserinfoById(int sId){
return ResponseUtil.successToClient(adminSnackInfoService.delAdminSnackinfo(sId));
}
//加载用户
@RequestMapping("selectAdminUserinfoBysId")
@ResponseBody
public String selectAdminUserinfoBysId(int sId){
return ResponseUtil.successToClient(adminSnackInfoService.selectAdminUserinfoBysId(sId));
}
@RequestMapping(value="updateAdminSnack")
@ResponseBody
public String updateAdminSnack(HttpServletRequest request,MultipartFile file,String fileName,Snackinfo snackinfo) throws Exception {
//如果文件不为空,写入上传路径
if(file !=null) {
@ResponseBody
public String updateSelectAdminOrderDetial(int dId){
return ResponseUtil.successToClient(adminOrderService.updateSelectAdminOrderDetial(dId));
}
//updateOrderDetial订单
@RequestMapping("updateOrderdetail")
@ResponseBody
public String updateOrderdetail(Orderdetail orderdetail){
return ResponseUtil.successToClient(adminOrderService.updateOrderdetail(orderdetail));
}
//删除OrderDetial
@RequestMapping("deleteOrderdetail")
@ResponseBody
public String deleteOrderdetail(int dId,String oId){
List<Orderdetail> orderdetailList = adminOrderService.selectOrderdetailByoId(oId);
if(orderdetailList.size()>=2){
adminOrderService.deleteOrderdetailBydId(dId);
return ResponseUtil.successToClient(1);
}else{
adminOrderService.deleteAdminOrder(oId);
return ResponseUtil.successToClient(2);
}
}
//导出订单详情
@RequestMapping("outExcelOrder")
@ResponseBody
public void outExcelOrder(HttpServletResponse response,String oId){
SXSSFWorkbook workbook = new SXSSFWorkbook();
reportSheet(workbook,oId);
outputExcel(response, workbook, "订单详情");
}
private void reportSheet(SXSSFWorkbook workbook,String oId) {
List<DoExcelOrder> outExcelOrderDetail = adminOrderService.outExcelOrderDetail(oId);
for (int i = 0; i < outExcelOrderDetail.size(); i++) {
if(i!=0){
outExcelOrderDetail.get(i).setOId("");
public class MyHandlerInterceptor implements HandlerInterceptor{
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
int k=0;
int p=0;
String uri=request.getRequestURI();
if(uri.indexOf("login")!=-1){
return true;
}
HttpSession session = request.getSession();
List<Permission> list = (List<Permission>)session.getAttribute("allPer");
List<Permission> list2 = (List<Permission>)session.getAttribute("userPer");
for (int i = 0; i < list.size(); i++) {
if(uri.equals((list.get(i).getUrl()))){
for (int j = 0; j < list2.size(); j++) {
k++;
if(uri.contains(list2.get(j).getUrl())){
return true;
}
}
}
p++;
}
if(p>0 && k==list2.size()){
response.getWriter().write("Sorry");
return false;
}
if(list.size()==p){
return true;
}
return false;
}
@Override
private userService userService;
@RequestMapping(value="/add",method=RequestMethod.POST)
public String addSorder(Snackinfo snackinfo,HttpSession session) {
System.out.println("-------addCar()------"+snackinfo.getsNumber());
Snackinfo findSnackinfo = sorderService.snackfindById(snackinfo.getsId());
findSnackinfo.setsNumber(snackinfo.getsNumber());
//2:判断当前session是否有购物车,如果没有则创建
if (session.getAttribute("receiptinfo")==null) {
//创建购物车,存到session中
session.setAttribute("receiptinfo", new Receiptinfo(new HashSet<Orderdetail>()));
}
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
//3:把农资信息转化为sorder,并且添加到购物车中(判断购物车是否重复)
receiptinfo = sorderService.addSorder(receiptinfo, findSnackinfo);
receiptinfo.setoPhone(cluTotal(receiptinfo));
return "redirect:gotocar";
}
@RequestMapping("gotocar")
public String gotocar() {
return "product/car";
}
//计算总金额
public String cluTotal(Receiptinfo receiptinfo) {
double tal=0.0;
for(Orderdetail temp : receiptinfo.getOrderdetailSet()){
tal+=temp.getoMoney()*temp.getoNum();
}
return String.valueOf(tal);
}
@RequestMapping(value="/delete",method=RequestMethod.GET)
public String deleteSorder(Snackinfo snackinfo,HttpSession session) {
@RequestMapping("userOrderLimit")
@ResponseBody
public DataTables userOrderLimit(HttpServletRequest request,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("uId",request.getSession().getAttribute("frontuserId"));
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<DoMyOrder> pageHelp= userService.selectOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//跳转订单页面
@RequestMapping("userGoOrder")
public String userGoOrder(HttpSession session){
return "user/myOrder";
}
//跳转历史订单
@RequestMapping("userGoSuccessOrder")
public String userGoSuccessOrder(){
return "user/myOrderSuccess";
}
//查看当前订单
@RequestMapping("userSucOrderLimit")
@ResponseBody
public DataTables userSucOrderLimit(HttpServletRequest request,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("uId",request.getSession().getAttribute("frontuserId"));
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<DoMyOrder> pageHelp= userService.selectMySuccessOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
} else {
return ResponseUtil.errorToClient();
}
}
}
public class MyHandlerInterceptor implements HandlerInterceptor{
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
int k=0;
int p=0;
String uri=request.getRequestURI();
if(uri.indexOf("login")!=-1){
return true;
}
HttpSession session = request.getSession();
List<Permission> list = (List<Permission>)session.getAttribute("allPer");
List<Permission> list2 = (List<Permission>)session.getAttribute("userPer");
for (int i = 0; i < list.size(); i++) {
if(uri.equals((list.get(i).getUrl()))){
for (int j = 0; j < list2.size(); j++) {
k++;
if(uri.contains(list2.get(j).getUrl())){
return true;
}
}
}
p++;
}
if(p>0 && k==list2.size()){
response.getWriter().write("Sorry");
return false;
}
@RequestMapping("gotocar")
public String gotocar() {
return "product/car";
}
//计算总金额
public String cluTotal(Receiptinfo receiptinfo) {
double tal=0.0;
for(Orderdetail temp : receiptinfo.getOrderdetailSet()){
tal+=temp.getoMoney()*temp.getoNum();
}
return String.valueOf(tal);
}
@RequestMapping(value="/delete",method=RequestMethod.GET)
public String deleteSorder(Snackinfo snackinfo,HttpSession session) {
Receiptinfo receiptinfo = (Receiptinfo)session.getAttribute("receiptinfo");
Set<Orderdetail> set = receiptinfo.getOrderdetailSet();
Iterator<Orderdetail> iterator = set.iterator();
while(iterator.hasNext()){
Orderdetail orderdetail = iterator.next();
if(orderdetail.getSnackinfo().getsId()==snackinfo.getsId()){
iterator.remove();
receiptinfo.setoPhone(String.valueOf((Double.parseDouble(receiptinfo.getoPhone())-orderdetail.getoMoney()*orderdetail.getoNum())));
}
}
if( set.size() <= 0){
session.removeAttribute("receiptinfo");
}
return "redirect:gotocar";
@RequestMapping("adminUserinfoLimit")
@ResponseBody
public DataTables adminUserinfoLimit(HttpServletRequest request,int start,int length,Userinfo userinfo){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<Userinfo> pageHelp= adminUserService.selectAdminUserinfoLimit(map,userinfo);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//删除用户
@RequestMapping("delUserinfoById")
@ResponseBody
public String delUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.delUserinfoById(uId));
}
//更新加载用户
@RequestMapping("updateGoUserinfoById")
@ResponseBody
public String updateGoUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.updateGoUserinfoById(uId));
}
//更新用户
@RequestMapping("updateUserinfoById")
@ResponseBody
public String updateUserinfoById(Userinfo userinfo){
return ResponseUtil.successToClient(adminUserService.updateUserinfoById(userinfo));
}
@RequestMapping("mainToAdmin")
public String mainToAdmin(){
return "admin/user/adminAdmin";
}
//加载用户
@RequestMapping("adminAdminLimit")
@ResponseBody
public DataTables adminAdminLimit(HttpServletRequest request,int start,int length,DoAdmin doAdmin){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<Admin> pageHelp= adminUserService.selectAdminLimit(map,doAdmin);
DataTables datatable=new DataTables();
k++;
if(uri.contains(list2.get(j).getUrl())){
return true;
}
}
}
p++;
}
if(p>0 && k==list2.size()){
response.getWriter().write("Sorry");
return false;
}
if(list.size()==p){
return true;
}
return false;
}
@Override
public void postHandle(HttpServletRequest request,
HttpServletResponse response, Object handler,
ModelAndView modelAndView) throws Exception {
// TODO Auto-generated method stub
}
@Override
public void afterCompletion(HttpServletRequest request,
HttpServletResponse response, Object handler, Exception ex)
throws Exception {
// TODO Auto-generated method stub
}
}
return "user/myOrder";
}
//跳转历史订单
@RequestMapping("userGoSuccessOrder")
public String userGoSuccessOrder(){
return "user/myOrderSuccess";
}
//查看当前订单
@RequestMapping("userSucOrderLimit")
@ResponseBody
public DataTables userSucOrderLimit(HttpServletRequest request,int start,int length){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("uId",request.getSession().getAttribute("frontuserId"));
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<DoMyOrder> pageHelp= userService.selectMySuccessOrderLimit(map);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//请确认收货
@RequestMapping("userOrderConfirm")
@ResponseBody
public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
int eId;
if(typeNum==0){
eId = (int)request.getSession().getAttribute("adminId");
}else{
eId=0;
}
return ResponseUtil.successToClient(userService.upDateByorderConfirm(id,typeNum,eId));
}
//去付款
@RequestMapping("userOrderPayMoney")
@ResponseBody
public String userOrderPayMoney(HttpServletRequest request,String oId){
DoPayMoney dpm=new DoPayMoney();
Userinfo selectUserinfoMoney = userService.selectUserinfoMoney((int)request.getSession().getAttribute("frontuserId"));
Double selectOrderdetailPayMoney = sorderService.selectOrderdetailPayMoney(oId);
dpm.setPayMoney(selectOrderdetailPayMoney.toString());
dpm.setuMoney(selectUserinfoMoney.getuMoney());
return ResponseUtil.successToClient(dpm);
}
//删除用户
@RequestMapping("delUserinfoById")
@ResponseBody
public String delUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.delUserinfoById(uId));
}
//更新加载用户
@RequestMapping("updateGoUserinfoById")
@ResponseBody
public String updateGoUserinfoById(int uId){
return ResponseUtil.successToClient(adminUserService.updateGoUserinfoById(uId));
}
//更新用户
@RequestMapping("updateUserinfoById")
@ResponseBody
public String updateUserinfoById(Userinfo userinfo){
return ResponseUtil.successToClient(adminUserService.updateUserinfoById(userinfo));
}
@RequestMapping("mainToAdmin")
public String mainToAdmin(){
return "admin/user/adminAdmin";
}
//加载用户
@RequestMapping("adminAdminLimit")
@ResponseBody
public DataTables adminAdminLimit(HttpServletRequest request,int start,int length,DoAdmin doAdmin){
Map<Object,Object> map=new HashMap<Object, Object>();
map.put("pageStart",start);
map.put("pageSize",length);
PageHelp<Admin> pageHelp= adminUserService.selectAdminLimit(map,doAdmin);
DataTables datatable=new DataTables();
datatable.setData(pageHelp.getList());
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//新建
@RequestMapping("addNewAdmin")
@ResponseBody
public String upload(HttpServletRequest request,
@RequestParam("file") MultipartFile file,String fileName) throws Exception {
//如果文件不为空,写入上传路径
if(!file.isEmpty()) {
//上传文件路径
String path = request.getSession().getServletContext().getRealPath("/image/trimImg/");
//上传文件名
String filename = fileName;
File filepath = new File(path,filename);
//判断路径是否存在,如果不存在就创建一个
//filepath.delete();
if (!filepath.getParentFile().exists()) {
filepath.getParentFile().mkdirs();
}
//将上传文件保存到一个目标文件当中
file.transferTo(new File(path + File.separator + filename));
return ResponseUtil.successToClient();
} else {
return ResponseUtil.errorToClient();
}
}
}
public class MyHandlerInterceptor implements HandlerInterceptor{
@Override
public boolean preHandle(HttpServletRequest request,
HttpServletResponse response, Object handler) throws Exception {
int k=0;
int p=0;
String uri=request.getRequestURI();
if(uri.indexOf("login")!=-1){
return true;
}
HttpSession session = request.getSession();
List<Permission> list = (List<Permission>)session.getAttribute("allPer");
datatable.setRecordsFiltered(pageHelp.getRecord());
datatable.setRecordsTotal(pageHelp.getRecord());
return datatable;
}
//请确认收货
@RequestMapping("userOrderConfirm")
@ResponseBody
public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){
int eId;
if(typeNum==0){
eId = (int)request.getSession().getAttribute("adminId");
}else{
eId=0;
}
return ResponseUtil.successToClient(userService.upDateByorderConfirm(id,typeNum,eId));
}
//去付款
@RequestMapping("userOrderPayMoney")
@ResponseBody
public String userOrderPayMoney(HttpServletRequest request,String oId){
DoPayMoney dpm=new DoPayMoney();
Userinfo selectUserinfoMoney = userService.selectUserinfoMoney((int)request.getSession().getAttribute("frontuserId"));
Double selectOrderdetailPayMoney = sorderService.selectOrderdetailPayMoney(oId);
dpm.setPayMoney(selectOrderdetailPayMoney.toString());
dpm.setuMoney(selectUserinfoMoney.getuMoney());
return ResponseUtil.successToClient(dpm);
}
//确认付款
@RequestMapping("userOrderPayMoneyConfirm")
@ResponseBody
public String userOrderPayMoneyConfirm(HttpServletRequest request,Float payNumber,Float uMoney,String uPasword,String oId){
Userinfo userinfo = (Userinfo)request.getSession().getAttribute("exituser");
if(userinfo.getuPassword().equals(uPasword)){
sorderService.updateOrderByoId(oId);
userService.updateUserinfoBypay(userinfo.getuId(), uMoney-payNumber);
}else{
return ResponseUtil.errorToClient();
}
return ResponseUtil.successToClient();
}