idea Springboot 数码商城系统LayUI框架开发mysql数据库web结构java编程计算机网页源码

package com.main.controller; import com.main.dao.glyDao; import com.main.model.gly; import com.main.util.DBO; import java.sql.ResultSet; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView; @Controller @RequestMapping({"/gly"}) public class glyController { @Autowired glyDao glydao; @Autowired private JdbcTemplate jdbcTemplate; public glyController() { } @RequestMapping({"listpage"}) public ModelAndView listpage(HttpServletRequest request, HttpServletResponse response) { try { request.setCharacterEncoding("gb2312"); } catch (Exception var10) { var10.printStackTrace(); } Map<String, Object> map = new HashMap(); ModelAndView mav = new ModelAndView(); mav.setViewName("gly/glylist"); String glyid = request.getParameter("glyid"); if (glyid != null && !glyid.equals("")) { map.put("glyid", glyid); } String yhm = request.getParameter("yhm"); if (yhm != null && !yhm.equals("")) { map.put("yhm", yhm); } String mm = request.getParameter("mm"); if (mm != null && !mm.equals("")) { map.put("mm", mm); } String xm = request.getParameter("xm"); if (xm != null && !xm.equals("")) { map.put("xm", xm); } List<gly> list = this.glydao.getAll(map); mav.addObject("list", list); return mav; } @RequestMapping({"add"}) public ModelAndView add(HttpServletRequest request, HttpServletResponse response) { try { request.setCharacterEncoding("gb2312"); } catch (Exception var20) { var20.printStackTrace(); } ModelAndView mav = new ModelAndView(); mav.setViewName("gly/glyadd"); gly bean = new gly(); String glyid = request.getParameter("glyid"); bean.setGlyid(glyid); String yhm = request.getParameter("yhm"); bean.setYhm(yhm); String mm = request.getParameter("mm"); bean.setMm(mm); String xm = request.getParameter("xm"); bean.setXm(xm); DBO db = new DBO(); ResultSet rs = null; String sql = ""; int num = 0; try { sql = "select count(1) as num from gly where yhm='" + yhm + "'"; rs = db.query(sql); if (rs.next()) { num = rs.getInt("num"); } if (num > 0) { request.setAttribute("msg", "<script>alert('添加失败、用户名重复');</script>"); } else { this.glydao.add(bean); request.setAttribute("msg", "<script>alert('添加成功');</script>"); } } catch (Exception var18) { var18.printStackTrace(); } finally { db.close(); } return this.addpage(request, response); } @RequestMapping({"addpage"}) public ModelAndView addpage(HttpServletRequest request, HttpServletResponse response) { try { request.setCharacterEncoding("gb2312"); } catch (Exception var4) { var4.printStackTrace(); } ModelAndView mav = new ModelAndView(); mav.setViewName("gly/glyadd"); return mav; } @RequestMapping({"del"}) public ModelAndView del(HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("keyid"); new ModelAndView(); try { this.glydao.delete(Integer.parseInt(id)); } catch (Exception var6) { var6.printStackTrace(); } request.setAttribute("msg", "<script>alert('删除成功');</script>"); return this.listpage(request, response); } @RequestMapping({"detail"}) public ModelAndView detail(HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("keyid"); try { request.setCharacterEncoding("gb2312"); } catch (Exception var8) { var8.printStackTrace(); } new gly(); ModelAndView mav = new ModelAndView(); mav.setViewName("gly/glydetail"); try { gly bean = this.glydao.getglyByID(Integer.parseInt(id)); request.setAttribute("glyid", bean.getGlyid()); request.setAttribute("yhm", bean.getYhm()); request.setAttribute("mm", bean.getMm()); request.setAttribute("xm", bean.getXm()); } catch (Exception var7) { var7.printStackTrace(); } return mav; } @RequestMapping({"modifypage"}) public ModelAndView modifypage(HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("keyid"); new gly(); ModelAndView mav = new ModelAndView(); mav.setViewName("gly/glymodify"); try { gly bean = this.glydao.getglyByID(Integer.parseInt(id)); request.setAttribute("glyid", bean.getGlyid()); request.setAttribute("yhm", bean.getYhm()); request.setAttribute("mm", bean.getMm()); request.setAttribute("xm", bean.getXm()); } catch (Exception var7) { var7.printStackTrace(); } return mav; } @RequestMapping({"mod"}) public ModelAndView mod(HttpServletRequest request, HttpServletResponse response) { String id = (String)request.getSession().getAttribute("id"); new gly(); ModelAndView mav = new ModelAndView(); mav.setViewName("gly/modify"); try { gly bean = this.glydao.getglyByID(Integer.parseInt(id)); request.setAttribute("glyid", bean.getGlyid()); request.setAttribute("yhm", bean.getYhm()); request.setAttribute("mm", bean.getMm()); request.setAttribute("xm", bean.getXm()); } catch (Exception var7) { var7.printStackTrace(); } return mav; } @RequestMapping({"upd"}) public ModelAndView upd(HttpServletRequest request, HttpServletResponse response) { try { request.setCharacterEncoding("gb2312"); } catch (Exception var9) { var9.printStackTrace(); } new ModelAndView(); gly bean = new gly(); String glyid = request.getParameter("glyid"); bean.setGlyid(glyid); String yhm = request.getParameter("yhm"); bean.setYhm(yhm); String mm = request.getParameter("mm"); bean.setMm(mm); String xm = request.getParameter("xm"); bean.setXm(xm); this.glydao.update(bean); request.setAttribute("msg", "<script>alert('修改成功');</script>"); return this.mod(request, response); } @RequestMapping({"update"}) public ModelAndView update(HttpServletRequest request, HttpServletResponse response) { try { request.setCharacterEncoding("gb2312"); } catch (Exception var9) { var9.printStackTrace(); } new ModelAndView(); gly bean = new gly(); String glyid = request.getParameter("glyid"); bean.setGlyid(glyid); String yhm = request.getParameter("yhm"); bean.setYhm(yhm);