基于javaweb+mysql的ssm+maven小米交易商城系统(java+jsp+ssm+maven+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven小米交易商城系统(java+jsp+ssm+maven+mysql)
一、项目简述 环境配置:
Jdk1.8 + Tomcat8.5 + mysql + Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)
项目技术:
JSP +Spring + SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax + layui+ maven等等。
return "redirect:/community";
}
@RequestMapping("/saves")
public String saves(Comms comms){
commsMapper.intsert(comms);
return "redirect:/community";
}
}
@Controller
public class Goods_Class {
@Autowired
private GoodsClassMapper goodsClassMapper;
@RequestMapping("xm_goods_class")
public ModelAndView goodsClassAll(){
ModelAndView mv=new ModelAndView("admin/xm_adminClass");
mv.addObject("xm_goodsClass",goodsClassMapper.queryClassAll());
return mv;
}
@RequestMapping("xm_adminClasss")
public ModelAndView goodsClassAlls(){
ModelAndView mv=new ModelAndView("admin/xm_adminClass");
mv.addObject("xm_goodsClass",goodsClassMapper.queryClassAll());
return mv;
}
@RequestMapping("class_add")
public String goodsClass_add(HttpServletRequest request){
String class_name=request.getParameter("class_name");
int class_cId=Integer.parseInt(request.getParameter("class_cId"));
goodsClassMapper.classInsert(class_name,class_cId);
return "redirect:/xm_goods_class";
}
@RequestMapping("class_update")
public String goodsClass_Update(GoodsClass goodsClass){
goodsClassMapper.classUpdate(goodsClass);
return "redirect:/xm_goods_class";
}
@RequestMapping("/admin_update")
public String admin_update(HttpServletRequest req,String oldpassword, String passwoed){
String ps = req.getParameter("oldpassword");
String pas = adminMapper.query_admin_pass();
String pass = req.getParameter("password");
if (ps.equalsIgnoreCase(pas)){
adminMapper.admin_update(pass);
return "admin/update_sucess";
}
return "admin/update_fail";
}
}
@Controller
public class Tb_OrderInfo {
@Autowired
private OrderInfoMapper orderInfoMapper;
@RequestMapping("/order_info")
public ModelAndView xm_order_info(){
ModelAndView mv=new ModelAndView("/admin/order_admin");
mv.addObject("order_infoAll",orderInfoMapper.order_query());
return mv;
}
@RequestMapping("/order_save")
public String order_save(OrderInfo orderInfo){
orderInfoMapper.order_insertfo(orderInfo);
return "redirect:/order_info";
}
@RequestMapping("/order_del")
public String order_del(int order_id){
orderInfoMapper.ord_deleteById(order_id);
return "redirect:/order_info";
}
@Controller
public class UserLogin {
@Autowired
private UserDaoMapper userDaoMapper;
@Autowired
private ShoppingCarMapper shoppingCarMapper;
private ShoppingCar shoppingCar = new ShoppingCar();
@RequestMapping("/logins")
public String checckLogin(HttpServletRequest req, HttpServletResponse res,HttpSession session) throws IOException {
res.setCharacterEncoding("utf-8");
PrintWriter out = res.getWriter();
String name = req.getParameter("name");
String pass = req.getParameter("pass");
String mdpass = pass;
int count = userDaoMapper.find(name,mdpass);
if(count==1){
session.setAttribute("member",name);
session.setAttribute("face",userDaoMapper.queryface(name));
//获取Cookie
List<Integer> lis = CookieUtils.queryAllCookie(req);
for (int i : lis) {
if (shoppingCarMapper.queryUserCar(i, session.getAttribute("member").toString()) == null) {
}
mv.addObject("goods", goodsInfo);
return mv;
}
//查看购物车
@RequestMapping("/shoppingCar")
public ModelAndView ShoppingCar() {
List<GoodsInfo> li = new ArrayList<GoodsInfo>();
ModelAndView mv = new ModelAndView("shoppingCar");
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
//判断是否登录,否则查看Cookie
if (session.getAttribute("member") == null) {
//获取Cookie
List<Integer> lis = CookieUtils.queryAllCookie(request);
for (int i : lis) {
li.add(shoppingCarMapper.queryGoodsInfoID(i));
}
mv.addObject("goods", li);
} else {
mv.addObject("goods", shoppingCarMapper.queryAllShoppingCar(session.getAttribute("member").toString()));
}
return mv;
}
//登录后把Cookie的内容放在数据库 方法,
/*@RequestMapping("/cookieSave")
@ResponseBody
public void sa() {
if (session.getAttribute("user") == null) {
//获取Cookie
List<Integer> lis = CookieUtils.queryAllCookie(request);
for (int i : lis) {
if (shoppingCarMapper.queryUserCar(i, 1) == null) {
GoodsInfo goodsInfo = shoppingCarMapper.queryGoodsInfoID(i);
CookieUtils.replaceDao(shoppingCar, goodsInfo);
//用户
shoppingCar.setUserID(1);
//添加到数据库
shoppingCarMapper.addShoppingCar(shoppingCar);
}
}
}
}*/
@RequestMapping("/carNum")
@ResponseBody
public Integer Num(){
if (session.getAttribute("member") == null) {
Cookie[] cookies = request.getCookies();
return cookies.length-1;
}else{
List<ShoppingCar> li=shoppingCarMapper.queryAllShoppingCar(session.getAttribute("member").toString());
userDao.setU_address(u_address);
userDao.setU_face(u_face);
userDaoMapper.pencer_update(userDao);
session.removeAttribute("member");
return "redirect:/index";
}
@RequestMapping("/percen")
public ModelAndView orders(){
ModelAndView mv = new ModelAndView("percen");
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
return mv;
}
@RequestMapping("/percens")
public ModelAndView orderss(){
ModelAndView mv = new ModelAndView("percens");
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
return mv;
}
@RequestMapping("/order")
public ModelAndView rs(String u_name,HttpSession session,String moneys){
ModelAndView mv = new ModelAndView("order");
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
u_name = (String)session.getAttribute("member");
mv.addObject("aas",userDaoMapper.queryxmuser(u_name));
System.out.println(moneys);
mv.addObject("moneys",moneys);
//System.out.println(u_name);
//System.out.println(userDaoMapper.queryxmuser(u_name));
return mv;
}
}
orderMapper.order_upda(order);
return "redirect:/xm_detail_order";
}
@RequestMapping("/ord_query_id")
public ModelAndView updateVal(int order_id){
ModelAndView mv=new ModelAndView("admin/order_detail_update");
mv.addObject("order_qu",orderMapper.xm_querybyId(order_id));
return mv;
}
/*随机shengchen*/
@RequestMapping("/orderItem") @ResponseBody
public String add_item(){
String trandNo = String.valueOf((Math.random() * 9 + 1) * 1000000);
String sdf = new SimpleDateFormat("yyyyMMddHHMMSS").format(new Date());
String orderNo = trandNo.toString().substring(0, 4);
return orderNo + sdf;
}
@RequestMapping("/yu")
public ModelAndView orders(String moneys,HttpSession session){
ModelAndView mv = new ModelAndView("yu");
String u_name ="";
u_name = (String)session.getAttribute("member");
UserDao use = userDaoMapper.queryxmuser(u_name);
OrderInfo orderInfo = new OrderInfo();
orderInfo.setOrder_addr(use.getU_address());
orderInfo.setUser_id(use.getU_id());
orderInfo.setOrder_desc("用户"+use.getU_name()+"下单");
orderInfo.setOrder_tel(use.getU_phone());
orderInfo.setOrder_phone(use.getU_phone());
orderInfo.setOrder_price(Double.valueOf(moneys));
orderInfo.setOrder_name(use.getU_name());
orderInfo.setState(0);
orderInfoMapper.order_insertfo(orderInfo);
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
mv.addObject("as",use);
return mv;
}
}
GoodsInfo goodsInfo = shoppingCarMapper.queryGoodsInfoID(i);
CookieUtils.replaceDao(shoppingCar, goodsInfo);
//用户
shoppingCar.setUserID(session.getAttribute("member").toString());
//添加到数据库
shoppingCarMapper.addShoppingCar(shoppingCar);
}
}
//删除Cookies
Cookie[] cookies = req.getCookies();
if (cookies != null) {
for (Cookie cookie : cookies) {
try {
if(cookie.getName().length()==36) {
System.out.println(cookie.getName());
cookie.setMaxAge(0);
cookie.setPath("/");
res.addCookie(cookie);
}
} catch (Exception e) {
continue;
}
}
}
return "redirect:/index";
}else{
return "redirect:/login.jsp";
}
}
}
for(Integer i:li){
lg.add(goodsInfoMapper.queryGoods(i));
}
mv.addObject("starAll",lg);
/*查询推荐商品*/
li=goodsInfoMapper.queryAllRecommend();
lg=new ArrayList<GoodsInfo>();
for(Integer i:li){
lg.add(goodsInfoMapper.queryGoods(i));
}
mv.addObject("RecommendAll",lg);
mv.addObject("carousel",carouselMapper.querycarousel());
return mv;
}
@RequestMapping("/carNums") @ResponseBody
public String carNum(HttpServletRequest request, HttpServletResponse response){
HttpSession session=request.getSession();
String num="0";
if(session.getAttribute("member")!=null){
List<ShoppingCar> li=shoppingCarMapper.queryAllShoppingCar(session.getAttribute("member").toString());
num=li.size()+"";
}else{
List<Integer> ll=CookieUtils.queryAllCookie(request);
num=ll.size()+"";
}
return num;
}
@RequestMapping("/carIndexShow") @ResponseBody
public List<GoodsInfo> carIndexShow(HttpServletRequest request, HttpServletResponse response){
HttpSession session=request.getSession();
List<GoodsInfo> li=new ArrayList<GoodsInfo>();
if(session.getAttribute("member")!=null){
List<ShoppingCar> ls=shoppingCarMapper.queryAllShoppingCar(session.getAttribute("member").toString());
for(ShoppingCar sc:ls){
li.add(goodsInfoMapper.queryGoods(sc.getGoodsID()));
}
}else{
List<Integer> ll=CookieUtils.queryAllCookie(request);
for(int goodsID:ll){
li.add(goodsInfoMapper.queryGoods(goodsID));
}
}
return li;
}
}
@Controller
public class UserLogin {
@Autowired
private UserDaoMapper userDaoMapper;
@Autowired
private ShoppingCarMapper shoppingCarMapper;
private ShoppingCar shoppingCar = new ShoppingCar();
@RequestMapping("/logins")
public String checckLogin(HttpServletRequest req, HttpServletResponse res,HttpSession session) throws IOException {
res.setCharacterEncoding("utf-8");
PrintWriter out = res.getWriter();
String name = req.getParameter("name");
String pass = req.getParameter("pass");
String mdpass = pass;
int count = userDaoMapper.find(name,mdpass);
if(count==1){
session.setAttribute("member",name);
session.setAttribute("face",userDaoMapper.queryface(name));
//获取Cookie
List<Integer> lis = CookieUtils.queryAllCookie(req);
for (int i : lis) {
if (shoppingCarMapper.queryUserCar(i, session.getAttribute("member").toString()) == null) {
GoodsInfo goodsInfo = shoppingCarMapper.queryGoodsInfoID(i);
CookieUtils.replaceDao(shoppingCar, goodsInfo);
//用户
shoppingCar.setUserID(session.getAttribute("member").toString());
//添加到数据库
//判断是否登录,否则查看Cookie
if (session.getAttribute("member") == null) {
//获取Cookie
List<Integer> lis = CookieUtils.queryAllCookie(request);
for (int i : lis) {
li.add(shoppingCarMapper.queryGoodsInfoID(i));
}
mv.addObject("goods", li);
} else {
mv.addObject("goods", shoppingCarMapper.queryAllShoppingCar(session.getAttribute("member").toString()));
}
return mv;
}
//登录后把Cookie的内容放在数据库 方法,
/*@RequestMapping("/cookieSave")
@ResponseBody
public void sa() {
if (session.getAttribute("user") == null) {
//获取Cookie
List<Integer> lis = CookieUtils.queryAllCookie(request);
for (int i : lis) {
if (shoppingCarMapper.queryUserCar(i, 1) == null) {
GoodsInfo goodsInfo = shoppingCarMapper.queryGoodsInfoID(i);
CookieUtils.replaceDao(shoppingCar, goodsInfo);
//用户
shoppingCar.setUserID(1);
//添加到数据库
shoppingCarMapper.addShoppingCar(shoppingCar);
}
}
}
}*/
@RequestMapping("/carNum")
@ResponseBody
public Integer Num(){
if (session.getAttribute("member") == null) {
Cookie[] cookies = request.getCookies();
return cookies.length-1;
}else{
List<ShoppingCar> li=shoppingCarMapper.queryAllShoppingCar(session.getAttribute("member").toString());
return li.size();
}
}
@RequestMapping("/dropShoppingCar") @ResponseBody
public String dropShoppingCar(int goodsID) {
List<Integer> lis = CookieUtils.queryAllCookie(request);
@Autowired
private OrderMapper orderMapper;
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@Autowired
private UserDaoMapper userDaoMapper;
@Autowired
private OrderInfoMapper orderInfoMapper;
@RequestMapping("/xm_detail_order")
public ModelAndView xm_adm(){
ModelAndView mv=new ModelAndView("/admin/order_detail_admin");
mv.addObject("show_order",orderMapper.xm_order_query());
return mv;
}
@RequestMapping("/xm_order_insert")
public String xm_order_insertInfo(Order order){
orderMapper.xm_order_insertfo(order);
return "redirect:/xm_detail_order";
}
@RequestMapping("/xm_order_del")
public String xm_order_del(int order_id){
orderMapper.order_deleteById(order_id);
return "redirect:/xm_detail_order";
}
@RequestMapping("/xm_order_update")
public String xm_order_update(Order order){
System.out.println(order);
orderMapper.order_upda(order);
return "redirect:/xm_detail_order";
}
@RequestMapping("/ord_query_id")
public ModelAndView updateVal(int order_id){
ModelAndView mv=new ModelAndView("admin/order_detail_update");
mv.addObject("order_qu",orderMapper.xm_querybyId(order_id));
return mv;
}
/*随机shengchen*/
@RequestMapping("/orderItem") @ResponseBody
public String add_item(){
String trandNo = String.valueOf((Math.random() * 9 + 1) * 1000000);
}else{
List<Integer> ll=CookieUtils.queryAllCookie(request);
for(int goodsID:ll){
li.add(goodsInfoMapper.queryGoods(goodsID));
}
}
return li;
}
}
@Controller
public class Con_Carousel {
@Autowired
private CarouselMapper carouselMapper;
@RequestMapping("/carouselAdmin")
public ModelAndView xm_admin() {
ModelAndView mv = new ModelAndView("/admin/carousel_admin");
mv.addObject("carouselshow", carouselMapper.carousel_show());
return mv;
}
@RequestMapping("/carousel_save")
public String insert(@RequestParam("img") CommonsMultipartFile f, HttpServletResponse resp, HttpServletRequest req) throws IOException {
orderInfo.setOrder_tel(use.getU_phone());
orderInfo.setOrder_phone(use.getU_phone());
orderInfo.setOrder_price(Double.valueOf(moneys));
orderInfo.setOrder_name(use.getU_name());
orderInfo.setState(0);
orderInfoMapper.order_insertfo(orderInfo);
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
mv.addObject("as",use);
return mv;
}
}
@Data
@Controller("goods")
public class Goods {
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@Autowired
private ShoppingCarMapper shoppingCarMapper;
@Autowired
public ModelAndView querylx(int goodsID){
ModelAndView mv = new ModelAndView("dtop");
mv.addObject("lx",goodsInfoMapper.querylx(1));
return mv;
}*/
}
@Controller
/*@RequestMapping("/xm_user")*/
public class AdminLogin {
@Autowired
private UserDaoMapper userDaoMapper;
@RequestMapping("/xm_admin_login")
public String checckLogin(HttpServletRequest req, HttpServletResponse res) throws IOException {
res.setCharacterEncoding("utf-8");
PrintWriter out = res.getWriter();
String name = req.getParameter("username");
String pass = req.getParameter("password");
if(name.equalsIgnoreCase("admins") && pass.equalsIgnoreCase("password")){
return "redirect:/admin/admin_index.jsp";
}else{
return "redirect:/admin/admin_login.jsp";
}
}
}
public class UpFile {
public static String upFileImg(CommonsMultipartFile url, HttpServletRequest req) {
String path = "img/goodsInfo/";
String p = req.getServletContext().getRealPath(path);
}
public class CookieUtils {
/**
* 设置cookie
* @param response
* @param name cookie名字
* @param value cookie值
* @param maxAge cookie生命周期 以秒为单位
*/
public static void addCookie(HttpServletResponse response, String name, String value, int maxAge){
Cookie cookie = new Cookie(name,value);
cookie.setPath("/");
if(maxAge>0) cookie.setMaxAge(maxAge);
response.addCookie(cookie);
}
/**
* 获取Cookie的内容--商品编号
* @param request
* @return 商品编号List集合
*/
public static List<Integer> queryAllCookie(HttpServletRequest request){
List<Integer> li = new ArrayList<Integer>();
Cookie[] cookies = request.getCookies();
if (cookies != null) {
for (Cookie cookie : cookies) {
try {
if(cookie.getName().length()==36) {
int goodsID = Integer.valueOf(cookie.getValue());
li.add(goodsID);
}
} catch (Exception e) {
continue;
}
}
}
Set set = new HashSet();
List<Integer> newList = new ArrayList<Integer>();
for (Integer cd:li) {
@Controller
public class Tb_OrderInfo {
@Autowired
private OrderInfoMapper orderInfoMapper;
@RequestMapping("/order_info")
public ModelAndView xm_order_info(){
ModelAndView mv=new ModelAndView("/admin/order_admin");
mv.addObject("order_infoAll",orderInfoMapper.order_query());
return mv;
}
@RequestMapping("/order_save")
public String order_save(OrderInfo orderInfo){
orderInfoMapper.order_insertfo(orderInfo);
return "redirect:/order_info";
}
@RequestMapping("/order_del")
public String order_del(int order_id){
orderInfoMapper.ord_deleteById(order_id);
return "redirect:/order_info";
}
@RequestMapping("/ord_update")
public String ord_update(OrderInfo orderInfo){
System.out.println(orderInfo);
orderInfoMapper.or_update(orderInfo);
return "redirect:/order_info";
}
@RequestMapping("/ord_update_id")
public ModelAndView updateVal(int order_id){
ModelAndView mv=new ModelAndView("admin/order_update");
mv.addObject("order_update",orderInfoMapper.ord_queryById(order_id));
return mv;
}
}
@Controller
public class Commes {
@Autowired
private CommunityMapper communityMapper;
@Autowired
private CommsMapper commsMapper;
@RequestMapping("/community")
public ModelAndView test(@RequestParam(required=true,defaultValue="1") Integer page,
@RequestParam(required=false,defaultValue="5") Integer pageSize) {
ModelAndView ma = new ModelAndView("community");
PageHelper.startPage(page,pageSize);
List<Community> list = communityMapper.queryalls();
PageInfo<Community> p = new PageInfo<Community>(list);
ma.addObject("commall",list);
ma.addObject("page",p);
ma.setViewName("community");
return ma;
}
@RequestMapping("/comms1")
public ModelAndView testes(int c_id){
ModelAndView ma = new ModelAndView("comms1");
ma.addObject("comm_show",communityMapper.queryById(c_id));
ma.addObject("comm_shows",commsMapper.queall());
/*ma.addObject("yu",commsMapper.queall());*/
/* List<Comms> ls = commsMapper.queall();
mv.addObject("cao",ls);*/
return ma;
}
@RequestMapping("/xm_save")
public String save(Community community){
System.out.println(community.toString());
communityMapper.intsert(community);
return "redirect:/community";
}
@RequestMapping("/dels")
public String dels(int c_id){
communityMapper.delById(c_id);
return "redirect:/community";
}