商品系统（源代码）.doc

《商品系统（源代码）.doc》由会员分享，可在线阅读，更多相关《商品系统（源代码）.doc（21页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、Config:Mapper.xmlselect*from product where 1=1and product_no=#product_noand product_name =#product_nameand Status =#Statusinsert into product(product_no,product_name,product_type,Status) values(#product_no,#product_name,#product_type,#Status)delete from productwhere product_no=#product_noupdate prod

2、uct setproduct_no=#product_no,product_name=#product_name,product_type=#product_type,Status =#StatusMyBatis.xmlDao:package com.ry.Dao;import java.util.List;import com.ry.model.Product;public interface ProductDao List selectByNameAndIDAndStatus(Product product);int insertProduct(Product product);int d

3、eleteProduct(Integer product_no);int updataProduct(Product product);Service:package com.ry.service;import java.util.List;import com.ry.model.Product;public interface ProductService List queryByIdAndNameAndStatus(Product product);boolean addProduct(Product product);boolean deleteProduct(Integer produ

4、ct_no);boolean updata(Product product);boolean doesExist(Product product);ServiceImpl:package com.ry.serviceImpl;import java.io.IOException;import java.io.InputStream;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.sess

5、ion.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import com.ry.Dao.ProductDao;import com.ry.model.Product;import com.ry.service.ProductService;public class ProductServiceImpl implements ProductService private ProductDao productDao;private SqlSession session;public Prod

6、uctServiceImpl() try InputStream config = Resources.getResourceAsStream(com/ry/config/product-mybatis.xml);SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory factory = builder.build(config);session = factory.openSession();productDao = session.getMapper(ProductDao.cla

7、ss); catch (IOException e) e.printStackTrace();Overridepublic List queryByIdAndNameAndStatus(Product product) List products = productDao.selectByNameAndIDAndStatus(product);mit(true);return products;Overridepublic boolean addProduct(Product product) int result = -1;result = productDao.insertProduct(

8、product);mit(true);return result = 1;Overridepublic boolean deleteProduct(Integer product_no) int result1 = -1;result1 = productDao.deleteProduct(product_no);mit(true);return result1 0;Overridepublic boolean updata(Product product) int result1 = -1;result1 = productDao.updataProduct(product);mit(tru

9、e);return result1 0;Overridepublic boolean doesExist(Product product) List products = null;products = productDao.selectByNameAndIDAndStatus(product);if (products = null) return false; else if (products.size() = 0) return false; else return true;QueryServlet:package com.ry.web;import java.io.IOExcept

10、ion;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.ry.model.Product;import com.ry.service.ProductService;import com.ry.serviceImpl.ProductServiceIm

11、pl;/* * Servlet implementation class QueryServlet */public class QueryServlet extends HttpServlet private ProductService productService = new ProductServiceImpl();protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, respon

12、se);protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException List results = null;Integer product_no = null;String product_name = null;Integer Status = null;Product product = new Product();request.setCharacterEncoding(UTF-8);String parm1 = re

13、quest.getParameter(product_num);String parm2 = request.getParameter(product_name);String status = request.getParameter(status);if (parm1 != null & !(parm1.equals() product_no = Integer.parseInt(parm1);if (parm2 != null & !(parm2.equals() product_name = parm2.trim();Status = Integer.parseInt(status);

14、product.setProduct_no(product_no);product.setProduct_name(product_name);product.setStatus(Status);results = productService.queryByIdAndNameAndStatus(product);request.setAttribute(results, results);request.getRequestDispatcher(index.jsp).forward(request, response);AddServlet:package com.ry.web;import

15、 java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.ry.model.Product;import com.ry.service.ProductService;import com.ry.serviceImpl.ProductServiceImpl;pu

16、blic class AddServlet extends HttpServlet private ProductService productService = new ProductServiceImpl();protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);protected void doPost(HttpServletRequest request, Ht

17、tpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8);Product product = new Product();Integer product_no = null;String product_name = null;String product_type = null;Integer Status = null;String parm1 = request.getParameter(product_num);String parm2 = re

18、quest.getParameter(product_name);String parm3 = request.getParameter(product_type);String parm4 = request.getParameter(status);if (parm1 != null & !(parm1.equals() product_no = Integer.parseInt(parm1);if (parm2 != null & !(parm2.equals() product_name = parm2.trim();if (parm3 != null & !(parm3.equals

19、() product_type = parm3.trim();Status = Integer.parseInt(parm4);product.setProduct_no(product_no);product.setProduct_name(product_name);product.setProduct_type(product_type);product.setStatus(Status);System.out.println(product);/ 判断用户是否存在boolean doesExist = productService.doesExist(product);if (does

20、Exist) System.out.println(用户名已存在);request.setAttribute(msg, 2);request.getRequestDispatcher(add.jsp).forward(request, response);return;boolean isSuccessful = productService.addProduct(product);request.setAttribute(msg, isSuccessful ? 0 : 1);request.getRequestDispatcher(add.jsp).forward(request, resp

21、onse);DeleteServlet:package com.ry.web;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.ry.service.ProductService;import com.ry.serviceImpl.Prod

22、uctServiceImpl;public class DeleteServlet extends HttpServlet private ProductService productService = new ProductServiceImpl();protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);protected void doPost(HttpServle

23、tRequest request, HttpServletResponse response)throws ServletException, IOException Integer product_no = null;String param1 = request.getParameter(product_no);if (param1 = null) System.out.println(参数operatorId获取失败);response.sendRedirect(index.jsp);return; else product_no = Integer.parseInt(param1.tr

24、im();System.out.println(product_no);productService.deleteProduct(product_no);UpdataServlet:import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.ry.m

25、odel.Product;import com.ry.service.ProductService;import com.ry.serviceImpl.ProductServiceImpl;public class UpdataServlet extends HttpServlet private ProductService productService = new ProductServiceImpl();protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletE

26、xception, IOException doPost(request, response);protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8);Product product = new Product();Integer product_no = null;String product_name = null;String product_

27、type = null;Integer Status = null;String parm1 = request.getParameter(product_num);String parm2 = request.getParameter(product_name);String parm3 = request.getParameter(product_type);String parm4 = request.getParameter(status);if (parm1 != null & !(parm1.equals() product_no = Integer.parseInt(parm1)

28、;if (parm2 != null & !(parm2.equals() product_name = parm2.trim();if (parm3 != null & !(parm3.equals() product_type = parm3.trim();Status = Integer.parseInt(parm4);product.setProduct_no(product_no);product.setProduct_name(product_name);product.setProduct_type(product_type);product.setStatus(Status);

29、productService.updata(product);response.sendRedirect(index.jsp);Index.jsp:% taglib prefix=c uri=Insert title herefunction open_add() window.open(add.jsp, 增加, width=900px,height=500px);function open_delete(a) window.open(delete.jsp?product_no=+a,删除,width=450px,height=200px);function open_updata(a,b,c

30、,d) window.open(updata.jsp?product_no=+a+&product_name=+b+&product_type=+c+&status=+d,修改,width=900px,height=500px); .main_index position: absolute;left: 15%;top: 5%;width: 70%;height: 80%;background-color: #66ccff;产品信息管理系统产品编号： 产品名称： -有效无效产品编号产品名称产品类型产品状态删除修改$product.product_no$product.product_name$product.product_type$product.status=1?有效:无效Add.jsp% page lan