、三层架构

业务逻辑层业务层:对业务逻辑进行封装组合数据访问层层中基本功能形成复杂的业务逻辑功能。

一般命名为反转公司网址/service

给上次的数据添加一个状态字段0禁用1启用2预售设个默认值1即可

使用三层架构思想开发

SqlSessionFactoryUtils.getSqlSessionFactory();public

ListProduct

sqlSessionFactory.openSession();final

ProductMapper

sqlSession.getMapper(ProductMapper.class);final

ListProduct

mapper.selectAll();sqlSession.close();return

products;};

ProductService();Overrideprotected

void

productService.selectAll();request.setAttribute(product,products);request.getRequestDispatcher(/jsp/product.jsp).forward(request,response);}

​Overrideprotected

urihttp://java.sun.com/jsp/jstl/core

%--Created

contentTypetext/html;charsetUTF-8

languagejava

request.getAttribute(product);%--%

html

blacktrth商品序号/thth商品id/thth商品名/thth商品图片/thth商品价格/thth商品评论数/thth商品分类/thth商品状态/thth商品发布时间/thth商品更新时间/th/trc:forEach

items${product}

index从0开始count从1开始--%td${status.count}/td%--

${user.id}

getId()--%td${product.id}/tdtd${product.title}/tdtdimg

src${product.imgUrl}

height75px/tdtd${product.price}/tdtd${product.comment}/tdtd${product.category}/tdtd${product.status}/tdtd${product.gmtCreate}/tdtd${product.gmtModified}/td/tr/c:forEach

​/table

sqlSessionFactory.openSession();final

ProductMapper

sqlSession.getMapper(ProductMapper.class);mapper.add(product);sqlSession.commit();sqlSession.close();

web

request.getParameter(title);final

String

request.getParameter(price);final

Integer

Integer.parseInt(request.getParameter(status));final

Integer

Integer.parseInt(request.getParameter(category));Product

product

Product(title,price,category,status);productService.add(product);request.getRequestDispatcher(/selectAll).forward(request,response);}

​Overrideprotected

sqlSessionFactory.openSession();final

ProductMapper

sqlSession.getMapper(ProductMapper.class);final

Product

mapper.selectById(id);sqlSession.close();return

product;

request.getParameter(id);ProductService

productService

productService.selectById(Long.parseLong(id));request.setAttribute(product,product);System.out.println(id);request.getRequestDispatcher(/jsp/productUpdate.jsp).forward(request,response);}

​Overrideprotected

urihttp://java.sun.com/jsp/jstl/core

page

contentTypetext/html;charsetUTF-8

languagejava

action/product_demo_war/updateById

methodpostinput

sqlSessionFactory.openSession();final

ProductMapper

sqlSession.getMapper(ProductMapper.class);mapper.updateById(product);sqlSession.commit();

servlet

Long.parseLong(request.getParameter(id));final

String

request.getParameter(title);final

String

request.getParameter(price);final

Integer

Integer.parseInt(request.getParameter(category));final

Integer

Integer.parseInt(request.getParameter(status));Date

gmtModified

Product(id,title,price,category,status,gmtModified);ProductService

productService

ProductService();productService.UpdateById(product);

​request.getRequestDispatcher(/selectAll).forward(request,response);

​Overrideprotected