商品服务_商品，服务-优快云博客

本文链接：https://blog.youkuaiyun.com/weixin_42345170/article/details/86560525
本文详细介绍了基于Spring MVC的商品管理系统的设计与实现过程，包括商品的添加、修改、删除及分页模糊查询等功能，通过Java、MyBatis和JSP实现了完整的CRUD操作。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
id pid name url target list toaddlist toupdatelist dellist
登录
controller
@Autowired
	UserMapper mapper;
	
	@RequestMapping("login")
	public String login(HttpServletRequest request,DengLu dl,Model model) {
		if (dl.getDname()==null) {
			model.addAttribute("error", "请输入账号或密码");
			return "login";
		} else {
			DengLu dd=mapper.login(dl);
			if (dd.getDpass().equals(dl.getDpass())) {
				request.getSession().setAttribute("dd", dd);
				return "redirect:/main";
			} else {
				model.addAttribute("error", "密码错误");
				return "login";
			}
		}
	}

@Select("select * from denglu where dname=#{dname} and dpass=#{dpass}")
	DengLu login(DengLu dl);

login.jsp
<form action="login" method="post">

   ${error}
   <table>
     <tr>
       <td>
                                      用户:<input type="text" name="dname">
       </td>
     </tr>
     <tr>
       <td>
                                      密码:<input type="text" name="dpass">
       </td>
     </tr>
     <tr>
       <td>
          <input type="submit" value="登录">
       </td>
     </tr>
   </table>
 </form>

权限
@RequestMapping("quanxian")
	@ResponseBody
	public List<QuanXian> qx(HttpServletRequest request){
		ShangPin user=(ShangPin) request.getSession().getAttribute("us");
		List<QuanXian> list=mapper.qx(user);
		return list;
		
	}
@RequestMapping("main")
	public String main(HttpServletRequest request){
		return "main";
	}
	@RequestMapping("left")
	public String left(HttpServletRequest request){
		return "left";
	}
	@RequestMapping("right")
	public String right(HttpServletRequest request){
		return "right";
	}
	@RequestMapping("top")
	public String top(HttpServletRequest request){
		return "top";
	}
@Select("select * from quanxian")
	List<QuanXian> qx(ShangPin user);

列表
@RequestMapping("list")
	public String list(HttpServletRequest request){
		List<ShangPin> list=mapper.list();
		request.setAttribute("list", list);
		return "list";
		
	}
@Select("select * from shangpin")
	List<ShangPin> list(PageUtil pg);

<tr>
    		<td>编号</td>
    		<td>商品名称</td>
    		<td>商品价格</td>
    		<td>一级分类</td>
    		<td>二级分类</td>
    		<td>三级分类</td>
    		<td>状态</td>
    	</tr>
    	<c:forEach items="${list}" var="s" >
	    	<tr>
	    		<td>${s.sid}</td>
	    		<td>${s.sname}</td>
	    		<td>${s.sjg}</td>
	    		<td>${s.yiji}</td>
	    		<td>${s.erji}</td>
	    		<td>${s.sanji}</td>
	    		<td>${s.zhuangtai}</td>
	    	</tr>
    	</c:forEach>
添加
@RequestMapping("toaddlist")
	public String toaddlist(HttpServletRequest request){
		List<ShangPin> list=mapper.list1();
		request.setAttribute("list", list);
		return "list1";
		
	}
	@RequestMapping("toadd")
	public String toadd() {
		return "add";
	}
	@RequestMapping("add")
	public String add(ShangPin sp) {
		mapper.add(sp);
		return "redirect:toaddlist";
	}
@Select("select * from shangpin")
	List<ShangPin> list1();

	@Insert("insert into shangpin(sid,sname,sjg,yiji,erji,sanji,zhuangtai) values(#{sid},#{sname},#{sjg},#{yiji},#{erji},#{sanji},#{zhuangtai})")
	void add(ShangPin sp);
建立list1.jsp
<td>
    		  <input type="button" value="添加" onclick="toadd()">
    		</td>

  function toadd(){
	  location="toadd";
  }

add.jsp
<form action="add" method="post">
      <table>
        <tr>
           <td>
                编号:<input type="text" name="sid">
           </td>
        </tr>
        <tr>
           <td>
                商品名称:<input type="text" name="sname">
           </td>
        </tr>
        <tr>
           <td>
                商品价格:<input type="text" name="sjg">
           </td>
        </tr>
        <tr>
           <td>
                一级分类:
                <select name="yiji">
                  <option>数码</option>
                  <option>电器</option>
                </select>
           </td>
        </tr>
        <tr>
           <td>
                二级分类:
               <select name="erji">
                  <option>手机</option>
                  <option>空调</option>
                  <option>平板电脑</option>
                  <option>冰箱</option>
                  <option>电脑</option>
                </select>
           </td>
        </tr>
        <tr>
           <td>
                三级分类:
                <select name="sanji">
                  <option>国产</option>
                  <option>国外产</option>
                </select>
           </td>
        </tr>
        <tr>
           <td>
                状态:<input type="text" name="zhuangtai">
           </td>
        </tr>
        <tr>
				<td colspan="11">
					<input type="submit" value="提交">
				</td>
			</tr>
      </table>
    </form>
删除
@RequestMapping("dellist")
	public String dellist(HttpServletRequest request){
		List<ShangPin> list=mapper.list2();
		request.setAttribute("list", list);
		return "list2";
	}
	@RequestMapping("delete")
	public String delete(ShangPin sp) {
		mapper.del(sp);
		return "redirect:dellist";
	}


	@Select("select * from shangpin")
	List<ShangPin> list2();

	@Delete("delete from shangpin where sid=#{sid}")
	void del(ShangPin sp);

建立list2.jsp
<td>
	    		  <input type="button" value="删除" onclick="del(${s.sid})">
	    		</td>

function del(sid){
	location="delete?sid="+sid;
}
修改
@RequestMapping("toupdatelist")
	public String toupdatelist(HttpServletRequest request){
		List<ShangPin> list=mapper.list3();
		request.setAttribute("list", list);
		return "list3";
		
	}
	@RequestMapping("toupdate")
	public String toupdate(HttpServletRequest request,int sid) {
		ShangPin sp=mapper.toupdate(sid);
		request.setAttribute("sp", sp);
		return "update";
	}
	@RequestMapping("update")
	public String update(ShangPin sp) {
		mapper.update(sp);
		return "redirect:toupdatelist";
	}

@Select("select * from shangpin")
	List<ShangPin> list3();

	@Update("update shangpin set sname = #{sname},sjg = #{sjg},yiji = #{yiji},erji = #{erji},sanji = #{sanji},zhuangtai = #{zhuangtai} where sid=#{sid}")
	void update(ShangPin sp);

	@Select("select * from shangpin where sid=#{sid}")
	ShangPin toupdate(int sid);

建立list3.jsp


<td>
	    		 <input type="button" value="修改" onclick="update(${s.sid})">
	    		</td>
function update(sid){
	location="toupdate?sid="+sid;
}
建立update.jsp
<form action="update" method="post">
      <table>
        <tr>
           <td>
                编号:<input type="text" name="sid" value="${sp.sid }">
           </td>
        </tr>
        <tr>
           <td>
                商品名称:<input type="text" name="sname" value="${sp.sname }">
           </td>
        </tr>
        <tr>
           <td>
                商品价格:<input type="text" name="sjg" value="${sp.sjg }">
           </td>
        </tr>
        <tr>
           <td>
                一级分类:
                <input type="text" name="yiji" value="${sp.yiji }">
           </td>
        </tr>
        <tr>
           <td>
                二级分类:
               <input type="text" name="erji" value="${sp.erji }">
           </td>
        </tr>
        <tr>
           <td>
                三级分类:
                <input type="text" name="sanji" value="${sp.sanji }">
           </td>
        </tr>
        <tr>
           <td>
                状态:<input type="text" name="zhuangtai" value="${sp.zhuangtai }">
           </td>
        </tr>
        <tr>
				<td colspan="11">
					<input type="submit" value="提交">
				</td>
			</tr>
      </table>
    </form>
分页模糊
@RequestMapping("list")
	public String list(HttpServletRequest request,String page,String mohu){
		mohu=mohu==null?"":mohu;
		int count = mapper.count(mohu);
		PageUtil pg = new PageUtil(page, 3, count);
		pg.setMohu(mohu);
		pg.setPagesize(pg.getDangqianye()*3);
		List<ShangPin> list=mapper.list(pg);
		request.setAttribute("list", list);
		request.setAttribute("mohu", mohu);
		request.setAttribute("pg", pg);
		return "list";
		
	}
@Select("select count(*) from shangpin where sname like concat('%',#{mohu},'%')")
	int count(String mohu);
@Select("select * from shangpin where sname like concat('%',#{mohu},'%') limit #{shoucanshu},#{pagesize}")
	List<ShangPin> list(PageUtil pg);

<tr>
			<td colspan="11">
				<form action="list" method="post">
					<input type="hidden" name="page" id="page">
					<input type="text" name="mohu"> 
					<input type="submit" value="模糊查询">
				</form>
			</td>
		</tr>

<tr>
			<td colspan="11">
				<input type="button" value="首页" onclick="fenye(1)">
				<input type="button" value="上一页" onclick="fenye(${pg.prevpage})">
				<input type="button" value="下一页" onclick="fenye(${pg.nextpage})">
				<input type="button" value="末页" onclick="fenye(${pg.countpage})">
			</td>
		</tr>

function fenye(page){
	document.getElementById("page").value=page;
	document.forms[0].submit();
}