基于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等等。
@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);
File ff = new File(p);
if(!ff.exists()){
ff.mkdirs();
}
String name = url.getOriginalFilename();
@Controller
public class Goods_Info {
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@RequestMapping("/admin")
public ModelAndView xm_admin(ModelAndView mv, @RequestParam(required=true,defaultValue="1") Integer page,
@RequestParam(required=false,defaultValue="5") Integer pageSize){
// ModelAndView mv = new ModelAndView("/admin/xm_admin");
PageHelper.startPage(page,pageSize);
List<GoodsInfo> list = goodsInfoMapper.query();
PageInfo<GoodsInfo> p = new PageInfo<GoodsInfo>(list);
mv.addObject("commall",list);
mv.addObject("page",p);
mv.setViewName("/admin/xm_admin");
mv.addObject("showall",list);
return mv;
}
@RequestMapping("/save")
public String insert(@RequestParam("goodsImg") CommonsMultipartFile f,HttpServletRequest req) throws IOException {
String path = "img/goodsInfo/";
String p = req.getServletContext().getRealPath(path);
File ff = new File(p);
if(!ff.exists()){
@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());
//添加到数据库
shoppingCarMapper.addShoppingCar(shoppingCar);
}
}
//删除Cookies
Cookie[] cookies = req.getCookies();
if (cookies != null) {
for (Cookie cookie : cookies) {
try {
if (shoppingCarMapper.queryUserCar(i, session.getAttribute("member").toString()) == null) {
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";
}
}
}
@Controller
public class Userpercen {
@Autowired
private UserDaoMapper userDaoMapper;
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@RequestMapping("/up_user")
public ModelAndView up_user(String u_name) {
ModelAndView ma = new ModelAndView("up_user");
ma.addObject("showusers",userDaoMapper.queryxmuser(u_name));
return ma;
}
@RequestMapping("/per_update")
public String ord_update(UserDao userDao, HttpSession session,HttpServletRequest request){
String u_name = request.getParameter("u_name");
String u_pass = request.getParameter("u_pass");
//u_pass = MD5Utils.MD5For32(u_pass);
String u_email = request.getParameter("u_email");
String u_phone = request.getParameter("u_phone");
String u_tname = request.getParameter("u_tname");
String u_sex = request.getParameter("u_sex");
String u_address = request.getParameter("u_address");
String u_face = request.getParameter("u_face");
userDao.setU_name(u_name);
userDao.setU_pass(u_pass);
userDao.setU_email(u_email);
userDao.setU_phone(u_phone);
userDao.setU_tname(u_tname);
userDao.setU_sex(u_sex);
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(){
}
@Controller
public class Userpercen {
@Autowired
private UserDaoMapper userDaoMapper;
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@RequestMapping("/up_user")
public ModelAndView up_user(String u_name) {
ModelAndView ma = new ModelAndView("up_user");
ma.addObject("showusers",userDaoMapper.queryxmuser(u_name));
return ma;
}
@RequestMapping("/per_update")
public String ord_update(UserDao userDao, HttpSession session,HttpServletRequest request){
String u_name = request.getParameter("u_name");
String u_pass = request.getParameter("u_pass");
//u_pass = MD5Utils.MD5For32(u_pass);
String u_email = request.getParameter("u_email");
String u_phone = request.getParameter("u_phone");
String u_tname = request.getParameter("u_tname");
String u_sex = request.getParameter("u_sex");
String u_address = request.getParameter("u_address");
String u_face = request.getParameter("u_face");
userDao.setU_name(u_name);
@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 {
String path = "img/carousel/";
String p = req.getServletContext().getRealPath(path);
File ff = new File(p);
if(!ff.exists()){
ff.mkdirs();
}
//上传文件到指定目录中
long size = f.getSize();
String name = f.getOriginalFilename();
String ext = name.substring(name.lastIndexOf(".")).toLowerCase();
String nn = new SimpleDateFormat("yyyyMMddHHmmssS").format(new Date());
if(ext.equalsIgnoreCase(".jpg") || ext.equalsIgnoreCase(".png")){
f.transferTo(new File(p,nn+ext));
}
String title=req.getParameter("title");
String img=nn+ext;
String url=req.getParameter("url");
String flag=req.getParameter("flag");
carouselMapper.carousel_insert(title,img,url,flag);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_del")
public String del(int id) {
// System.out.println();
carouselMapper.carousel_del(id);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_update")
public String update(Carousel carousel) {
System.out.println(carousel.toString());
carouselMapper.carousel_update(carousel);
return "redirect:/carouselAdmin";
}
//System.out.println(userDaoMapper.queryxmuser(u_name));
return mv;
}
}
@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) {
@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());
//添加到数据库
shoppingCarMapper.addShoppingCar(shoppingCar);
}
}
//删除Cookies
Cookie[] cookies = req.getCookies();
@Controller
public class Goods_Info {
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@RequestMapping("/admin")
public ModelAndView xm_admin(ModelAndView mv, @RequestParam(required=true,defaultValue="1") Integer page,
@RequestParam(required=false,defaultValue="5") Integer pageSize){
// ModelAndView mv = new ModelAndView("/admin/xm_admin");
PageHelper.startPage(page,pageSize);
List<GoodsInfo> list = goodsInfoMapper.query();
PageInfo<GoodsInfo> p = new PageInfo<GoodsInfo>(list);
mv.addObject("commall",list);
mv.addObject("page",p);
mv.setViewName("/admin/xm_admin");
mv.addObject("showall",list);
return mv;
}
@RequestMapping("/save")
public String insert(@RequestParam("goodsImg") CommonsMultipartFile f,HttpServletRequest req) throws IOException {
String path = "img/goodsInfo/";
String p = req.getServletContext().getRealPath(path);
File ff = new File(p);
if(!ff.exists()){
ff.mkdirs();
}
//上传文件到指定目录中
//long size = f.getSize();
String name = f.getOriginalFilename();
String ext = name.substring(name.lastIndexOf(".")).toLowerCase();
String nn = new SimpleDateFormat("yyyyMMddHHmmssS").format(new Date());
if(ext.equalsIgnoreCase(".jpg") || ext.equalsIgnoreCase(".png")){
f.transferTo(new File(p,nn+ext));
}
int c_ID=Integer.parseInt(req.getParameter("c_ID"));
String goodsName=req.getParameter("goodsName");
String goodsIntroduce=req.getParameter("goodsIntroduce");
String service=req.getParameter("service");
String goodsImg=nn+ext;
String goodsUrl=req.getParameter("goodsUrl");
@Controller
public class Details {
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@RequestMapping("/details")
public ModelAndView querydetails(int goodsID){
ModelAndView mv = new ModelAndView("details");
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
mv.addObject("edition",goodsInfoMapper.queryedition(goodsID));
mv.addObject("color",goodsInfoMapper.querycolor(goodsID));
mv.addObject("img",goodsInfoMapper.queryimg(goodsID));
mv.addObject("moImg",goodsInfoMapper.queryMoimg(goodsID));
mv.addObject("lx",goodsInfoMapper.querylx(goodsID));
System.out.println(goodsInfoMapper.querylx(goodsID));
return mv;
}
/*@RequestMapping("/dtop")
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")
@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;
}
}
@Data
@Controller("goods")
public class Goods {
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@Autowired
private ShoppingCarMapper shoppingCarMapper;
@Autowired
}
//删除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";
}
}
}
ModelAndView ma = new ModelAndView("up_user");
ma.addObject("showusers",userDaoMapper.queryxmuser(u_name));
return ma;
}
@RequestMapping("/per_update")
public String ord_update(UserDao userDao, HttpSession session,HttpServletRequest request){
String u_name = request.getParameter("u_name");
String u_pass = request.getParameter("u_pass");
//u_pass = MD5Utils.MD5For32(u_pass);
String u_email = request.getParameter("u_email");
String u_phone = request.getParameter("u_phone");
String u_tname = request.getParameter("u_tname");
String u_sex = request.getParameter("u_sex");
String u_address = request.getParameter("u_address");
String u_face = request.getParameter("u_face");
userDao.setU_name(u_name);
userDao.setU_pass(u_pass);
userDao.setU_email(u_email);
userDao.setU_phone(u_phone);
userDao.setU_tname(u_tname);
userDao.setU_sex(u_sex);
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");
@Data
@Controller
@RequestMapping("xm_user")
public class UserReg {
@Autowired
private UserDaoMapper userDaoMapper;
@RequestMapping(value = "/u_save",method = RequestMethod.POST)
public String u_save(UserDao userDao, HttpServletRequest request, HttpServletResponse res) throws IOException {
PrintWriter out = res.getWriter();
request.setCharacterEncoding("utf-8");
res.setCharacterEncoding("utf-8");
res.setContentType("text/html;charset=utf8");
String name = request.getParameter("u_name");
String pass = request.getParameter("u_pass");
String mdpass = pass;
String email = request.getParameter("u_email");
String phone = request.getParameter("u_phone");
String tname = request.getParameter("u_tname");
String sex = request.getParameter("u_sex");
String address = request.getParameter("u_address");
String face = request.getParameter("u_face");
userDao.setU_name(name);
userDao.setU_pass(mdpass);
userDao.setU_email(email);
userDao.setU_phone(phone);
userDao.setU_tname(tname);
userDao.setU_sex(sex);
userDao.setU_address(address);
userDao.setU_face(face);
userDaoMapper.u_insert(userDao);
return "redirect:/index";
}
}
@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 {
String path = "img/carousel/";
String p = req.getServletContext().getRealPath(path);
File ff = new File(p);
if(!ff.exists()){
ff.mkdirs();
}
//上传文件到指定目录中
long size = f.getSize();
String name = f.getOriginalFilename();
String ext = name.substring(name.lastIndexOf(".")).toLowerCase();
String nn = new SimpleDateFormat("yyyyMMddHHmmssS").format(new Date());
if(ext.equalsIgnoreCase(".jpg") || ext.equalsIgnoreCase(".png")){
f.transferTo(new File(p,nn+ext));
}
String title=req.getParameter("title");
String img=nn+ext;
String url=req.getParameter("url");
String flag=req.getParameter("flag");
carouselMapper.carousel_insert(title,img,url,flag);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_del")
public String del(int id) {
// System.out.println();
carouselMapper.carousel_del(id);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_update")
public String update(Carousel carousel) {
System.out.println(carousel.toString());
carouselMapper.carousel_update(carousel);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_updateVal")
}
@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 Details {
@Autowired
private GoodsInfoMapper goodsInfoMapper;
@RequestMapping("/details")
public ModelAndView querydetails(int goodsID){
ModelAndView mv = new ModelAndView("details");
mv.addObject("goodsAll",goodsInfoMapper.queryAllGoods());
mv.addObject("edition",goodsInfoMapper.queryedition(goodsID));
mv.addObject("color",goodsInfoMapper.querycolor(goodsID));
mv.addObject("img",goodsInfoMapper.queryimg(goodsID));
mv.addObject("moImg",goodsInfoMapper.queryMoimg(goodsID));
mv.addObject("lx",goodsInfoMapper.querylx(goodsID));
System.out.println(goodsInfoMapper.querylx(goodsID));
return mv;
}
/*@RequestMapping("/dtop")
public ModelAndView querylx(int goodsID){
ModelAndView mv = new ModelAndView("dtop");
mv.addObject("lx",goodsInfoMapper.querylx(1));
return mv;
}*/
}
String p = req.getServletContext().getRealPath(path);
File ff = new File(p);
if(!ff.exists()){
ff.mkdirs();
}
//上传文件到指定目录中
long size = f.getSize();
String name = f.getOriginalFilename();
String ext = name.substring(name.lastIndexOf(".")).toLowerCase();
String nn = new SimpleDateFormat("yyyyMMddHHmmssS").format(new Date());
if(ext.equalsIgnoreCase(".jpg") || ext.equalsIgnoreCase(".png")){
f.transferTo(new File(p,nn+ext));
}
String title=req.getParameter("title");
String img=nn+ext;
String url=req.getParameter("url");
String flag=req.getParameter("flag");
carouselMapper.carousel_insert(title,img,url,flag);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_del")
public String del(int id) {
// System.out.println();
carouselMapper.carousel_del(id);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_update")
public String update(Carousel carousel) {
System.out.println(carousel.toString());
carouselMapper.carousel_update(carousel);
return "redirect:/carouselAdmin";
}
@RequestMapping("/carousel_updateVal")
public ModelAndView updateVal(int id){
ModelAndView mv=new ModelAndView("admin/carousel_update");
mv.addObject("updateVal",carouselMapper.carousel_selectID(id));
return mv;
}
@RequestMapping("/carousel_updateFlag")
public String updateFlag(int id,String flag,HttpServletRequest req){
id=Integer.valueOf(req.getParameter("id"));
flag=req.getParameter("flag");
carouselMapper.carousel_updateFlag(id,flag);
return "redirect:/carouselAdmin";
}