springmvc_mybatis1208的基本注释(editsubmit)

最新推荐文章于 2022-11-18 06:13:30 发布

weiyuanzhuo

最新推荐文章于 2022-11-18 06:13:30 发布

阅读量444

点赞数

分类专栏： SSM框架

本文链接：https://blog.csdn.net/weiyuanzhuo/article/details/52806660

版权

SSM框架专栏收录该内容

28 篇文章 0 订阅

订阅专栏

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>成功提示</title>
</head>
<body>
操作成功！
</body>
</html>

	//编辑商品提交（更新）
	@RequestMapping("/editItemsSubmit")
	public String editItemsSubmit(HttpServletRequest request,Integer id,ItemsCustom itemsCustom)
			throws Exception {
		
		//调用service更新商品信息，页面需要将商品信息传到此方法
		itemsService.updateItems(id, itemsCustom);
		
		return "success";
	}

public void updateItems(Integer id,ItemsCustom itemsCustom) throws Exception;

	@Override
	public void updateItems(Integer id, ItemsCustom itemsCustom) throws Exception {

		itemsCustom.setId(id);
		itemsMapper.updateByPrimaryKeyWithBLOBs(itemsCustom);

	}

int updateByPrimaryKeyWithBLOBs(Items record);

  <update id="updateByPrimaryKeyWithBLOBs" parameterType="cn.itcast.ssm.po.Items" >
    update items
    set name = #{name,jdbcType=VARCHAR},
      price = #{price,jdbcType=REAL},
      pic = #{pic,jdbcType=VARCHAR},
      createtime = #{createtime,jdbcType=TIMESTAMP},
      detail = #{detail,jdbcType=LONGVARCHAR}
    where id = #{id,jdbcType=INTEGER}
  </update>