web_day42_练习JDBC增删改查

最新推荐文章于 2021-12-25 21:53:16 发布
最新推荐文章于 2021-12-25 21:53:16 发布
阅读量217 收藏
点赞数
分类专栏： web
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_35537301/article/details/86982445
版权

一、web阶段通用流程【同步操作】

  1. 创建数据库表结构，并创建数据库表（初始化数据）
  2. 根据创建的数据库表结构创建对应的JavaBean
  3. 导入相关的jar包，工具类和配置文件（）
  4. 寻找程序的入口（一般在jsp页面，他会指向一个servlet，需要注意一个问题：携带参数的问题）
  5. 编写对应的servlet
    1. 如果携带了请求参数，需要获取请求参数，并封装到对应的JavaBean
    2. 调用service层方法
  6. 编写service层方法
    1. web阶段，除了分页和事务操作，这个类中仅仅知识调用DAO层的方法
  7. 编写dao层方法
    1. 对数据库的CRUD操作

二、功能模块

1.查询所有商品信息

web层

package com.itheima.web.servlet;

import java.io.IOException;
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.itheima.domain.Product;
import com.itheima.service.ProductService;
import com.itheima.service.impl.ProductServiceImpl;

/**
 * 查询所有商品信息
 *
 */
public class FindAllProductServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public FindAllProductServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		ProductService service = new ProductServiceImpl();
		try {
			// 1.调用service层方法
			List<Product> products = service.findAllProduct();
			// 2.将查询结果返回域对象
			request.setAttribute("products", products);
			// 3.转发到jsp页面
			request.getRequestDispatcher("/product_list.jsp").forward(request, response);

		} catch (Exception e) {
			throw new RuntimeException(e);
		}

	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

service层

package com.itheima.service.impl;

import java.util.List;

import com.itheima.dao.ProductDao;
import com.itheima.dao.impl.ProductDaoImpl;
import com.itheima.domain.Product;
import com.itheima.service.ProductService;

public class ProductServiceImpl implements ProductService {

	private ProductDao dao = new ProductDaoImpl();
	@Override
	public List<Product> findAllProduct()throws Exception {
		return dao.findAllProduct();
	}

}

 dao层

package com.itheima.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.itheima.dao.ProductDao;
import com.itheima.domain.Product;
import com.itheima.utils.C3P0Utils;

public class ProductDaoImpl implements ProductDao {

	@Override
	public List<Product> findAllProduct() throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pflag=?";
		// 3.设置实际参数
		Object[] params = {0};
		// 4.执行查询操作
		return qr.query(sql, new BeanListHandler<>(Product.class),params);
	}

}

 JSP页面

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/imagetable.css">

</head>
<body>
	<table border="1" width="40%" class="imagetable" align="center">
		<tr>
			<th>商品列表</th>
		</tr>
	</table>
	<hr/>
	<table border="1" width="100%" class="imagetable">
		<tr>
			<th colspan="5" align="right">
				<input type="button" value="添加商品"/>
			</th>
		</tr>
		<tr>
			<th style="width:110px">商品序号</th>
			<th>商品名称</th>
			<th style="width:110px">商品图片</th>
			<th style="width:110px">商品价格</th>
			<th>商品描述</th>
		</tr>
		<!-- 遍历商品信息 -->
		<c:if test="${not empty products }">
			<c:forEach items="${products }" var="product" varStatus="vs">
				<tr>
					<td align="center">${vs.count }</td>
					<td>${product.pname }</td>
					<td align="center">
						<img  src="${pageContext.request.contextPath }/${product.pimage }" width="45px" height="45px">
					</td>
					<td align="center">${product.shop_price }</td>
					<td>${product.pdesc }</td>
				</tr>
			</c:forEach>
		</c:if>
	</table>
</body>
</html>

 2.添加商品信息

2.1 回显下拉框的数据

product_list.jsp 

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/imagetable.css">
<style type="text/css">
	a{
		text-decoration: none;
		color: gray;
	}
</style>

<script type="text/javascript">
	function addProductUI(){
		location.href="${pageContext.request.contextPath }/AddProductUIServlet";
	}
</script>
</head>
<body>
	<table border="1" width="40%" class="imagetable" align="center">
		<tr>
			<th>商品列表</th>
		</tr>
	</table>
	<hr/>
	<table border="1" width="100%" class="imagetable">
		<tr>
			<th colspan="5" align="right">
				<!-- javascript:void(0):禁用插连接 -->
				<a href="javascript:void(0);" onclick="addProductUI()">添加商品</a>
			</th>
		</tr>
		<tr>
			<th style="width:110px">商品序号</th>
			<th>商品名称</th>
			<th style="width:110px">商品图片</th>
			<th style="width:110px">商品价格</th>
			<th>商品描述</th>
		</tr>
		<!-- 遍历商品信息 -->
		<c:if test="${not empty products }">
			<c:forEach items="${products }" var="product" varStatus="vs">
				<tr>
					<td align="center">${vs.count }</td>
					<td>${product.pname }</td>
					<td align="center">
						<img  src="${pageContext.request.contextPath }/${product.pimage }" width="45px" height="45px">
					</td>
					<td align="center">${product.shop_price }</td>
					<td>${product.pdesc }</td>
				</tr>
			</c:forEach>
		</c:if>
	</table>
</body>
</html>

web层

package com.itheima.web.servlet;

import java.io.IOException;
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.itheima.domain.Category;
import com.itheima.service.CategoryService;
import com.itheima.service.impl.CategoryServiceImpl;

/**
 * 回显添加商品界面的下拉框
 *
 */
public class AddProductUIServlet extends HttpServlet {

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		
		CategoryService service = new CategoryServiceImpl();
		try {
			List<Category> categorys = service.findAllCategory();
			request.setAttribute("categorys", categorys);
			request.getRequestDispatcher("/addProduct.jsp").forward(request, response);
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

service层

package com.itheima.service.impl;

import java.util.List;

import com.itheima.dao.CategoryDao;
import com.itheima.dao.impl.CategoryDaoImpl;
import com.itheima.domain.Category;
import com.itheima.service.CategoryService;

public class CategoryServiceImpl implements CategoryService {

	private CategoryDao dao = new CategoryDaoImpl();
	@Override
	public List<Category> findAllCategory() throws Exception{
		return dao.findAllCategory();
	}
	@Override
	public Category findCategoryById(String cid) throws Exception{
		return dao.findCategoryById(cid);
	}

}

dao层

package com.itheima.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.itheima.dao.CategoryDao;
import com.itheima.domain.Category;
import com.itheima.utils.C3P0Utils;

public class CategoryDaoImpl implements CategoryDao {

	@Override
	public List<Category> findAllCategory() throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from category";
		
		// 3.执行查询操作
		return qr.query(sql, new BeanListHandler<>(Category.class));
	}

	@Override
	public Category findCategoryById(String cid) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from category where cid =?";
		// 3.设置实际参数
		Object[] params = {cid};
		// 4.执行查询操作
		return qr.query(sql, new BeanHandler<>(Category.class), params);
	}

}

2.2 添加商品信息

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/imagetable.css">

</head>
<body>
	<table border="1" width="40%" class="imagetable" align="center">
		<tr>
			<th>添加商品</th>
		</tr>
	</table>
	<hr/>
	<form action="${pageContext.request.contextPath}/AddProductServlet" method="post">
		<table border="1" width="65%" class="imagetable" align="center">
			<tr>
				<td>商品名称</td>
				<td><input type="text" name="pname"/></td>
			</tr>
			<tr>
				<td>商品价格</td>
				<td><input type="text" name="shop_price"/></td>
			</tr>
			<tr>
				<td>市场价格</td>
				<td><input type="text" name="market_price"/></td>
			</tr>
			<tr>
				<td>商品图片路径</td>
				<td><input type="text" name="pimage"/></td>
			</tr>
			<tr>
				<td>是否热门</td>
				<td><input type="radio" name="is_hot" value="0" checked="checked"/>不热门
				<input type="radio" name="is_hot" value="1"/>热门</td>
			</tr>
			<tr>
				<td>商品描述</td>
				<td>
					<textarea name="pdesc"></textarea>
				</td>
			</tr>
			<tr>
				<td>商品分类</td>
				<td>
					<select name="cid">
						<c:if test="${not empty categorys }">
							<c:forEach items="${categorys}" var="category">
								<option value="${category.cid}">${category.cname }</option>
							</c:forEach>
						</c:if>
					</select>
				</td>
			</tr>
			<tr>
				<td></td>
				<td>
					<input type="submit" value="添加商品"/>
				</td>
			</tr>
		</table>
	</form>
</body>
</html>

web层

package com.itheima.web.servlet;

import java.io.IOException;
import java.util.Date;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;

import com.itheima.domain.Category;
import com.itheima.domain.Product;
import com.itheima.service.CategoryService;
import com.itheima.service.ProductService;
import com.itheima.service.impl.CategoryServiceImpl;
import com.itheima.service.impl.ProductServiceImpl;
import com.itheima.utils.UUIDUtils;

/**
 * 添加商品信息
 *
 */
public class AddProductServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public AddProductServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");

		// 1.获取用户请求参数
		Map<String, String[]> parameterMap = request.getParameterMap();
		// 2.使用BeanUtils工具类封装请求参数
		Product product = new Product();
		try {
			// 2.使用BeanUtils封装用户提交的数据
			BeanUtils.populate(product, request.getParameterMap());
			// 3.单独封装pid,pdate,pflag,catgegory
			product.setPid(UUIDUtils.getUUID());
			product.setPdate(new Date());
			product.setPflag(0);// 添加商品默认为上架状态
			// 获得cid
			String cid = request.getParameter("cid");
			// 调用service层根据cid查询分类信息
			CategoryService categoryService = new CategoryServiceImpl();
			Category category = categoryService.findCategoryById(cid);
			product.setCategory(category);

			ProductService service = new ProductServiceImpl();
			// 调用service层查询所有商品信息的方法
			service.addProduct(product);
			// 重定向到查询所有商品信息的页面
			response.sendRedirect(request.getContextPath() + "/FindAllProductServlet");

		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

service层

package com.itheima.service.impl;

import java.util.List;

import com.itheima.dao.ProductDao;
import com.itheima.dao.impl.ProductDaoImpl;
import com.itheima.domain.Product;
import com.itheima.service.ProductService;

public class ProductServiceImpl implements ProductService {

	private ProductDao dao = new ProductDaoImpl();

	@Override
	public List<Product> findAllProduct() throws Exception {
		return dao.findAllProduct();
	}

	@Override
	public void addProduct(Product product) throws Exception {
		dao.addProduct(product);
	}

}

dao层

package com.itheima.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.itheima.dao.ProductDao;
import com.itheima.domain.Product;
import com.itheima.utils.C3P0Utils;

public class ProductDaoImpl implements ProductDao {

	@Override
	public List<Product> findAllProduct() throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pflag=?";
		// 3.设置实际参数
		Object[] params = {0};
		// 4.执行查询操作
		return qr.query(sql, new BeanListHandler<>(Product.class),params);
	}

	@Override
	public void addProduct(Product product) throws Exception {
		 // 1.获得QueryRunner核心对象
        QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
        // 2.编写SQL语句
        String sql = "insert into product values(?,?,?,?,?,?,?,?,?,?)";
        // 3.设置实际参数
        Object[] params = { product.getPid(), product.getPname(), product.getMarket_price(),
                product.getShop_price(), product.getPimage(), product.getPdate(), product.getIs_hot(),
                product.getPdesc(), product.getPflag(), product.getCategory().getCid() };
        // 4.执行插入操作
        qr.update(sql, params);
	}

}

 3.删除商品信息

页面

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/imagetable.css">
<style type="text/css">
	a{
		text-decoration: none;
		color: gray;
	}
</style>

<script type="text/javascript">
	//添加商品信息
	function addProductUI(){
		location.href="${pageContext.request.contextPath }/AddProductUIServlet";
	}
	
	//删除单个商品信息
	function delProduct(pid){
		//alert(pid);
		location.href="${pageContext.request.contextPath }/DelProductServlet?pid="+pid;
	}
</script>
</head>
<body>
	<table border="1" width="40%" class="imagetable" align="center">
		<tr>
			<th>商品列表</th>
		</tr>
	</table>
	<hr/>
	<table border="1" width="100%" class="imagetable">
		<tr>
			<th colspan="6" align="right">
				<!-- javascript:void(0):禁用插连接 -->
				<a href="javascript:void(0);" onclick="addProductUI()">添加商品</a>
			</th>
		</tr>
		<tr>
			<th style="width:110px">商品序号</th>
			<th>商品名称</th>
			<th style="width:110px">商品图片</th>
			<th style="width:110px">商品价格</th>
			<th>商品描述</th>
			<th style="width:110px">操作</th>
		</tr>
		<!-- 遍历商品信息 -->
		<c:if test="${not empty products }">
			<c:forEach items="${products }" var="product" varStatus="vs">
				<tr>
					<td align="center">${vs.count }</td>
					<td>${product.pname }</td>
					<td align="center">
						<img  src="${pageContext.request.contextPath }/${product.pimage }" width="45px" height="45px">
					</td>
					<td align="center">${product.shop_price }</td>
					<td>${product.pdesc }</td>
					<td align="center">
						<a href="javascript:void(0);" onclick="delProduct('${product.pid}')">删除</a>
						<a href="javascript:void(0);" onclick="">修改</a>
					</td>
				</tr>
			</c:forEach>
		</c:if>
	</table>
</body>
</html>

web层

package com.itheima.web.servlet;

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.itheima.service.ProductService;
import com.itheima.service.impl.ProductServiceImpl;

public class DelProductByIdServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public DelProductByIdServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		//1.获取请求参数
		String pid = request.getParameter("pid");
		// 2.调用service层根据pid删除商品信息的方法
		ProductService service = new ProductServiceImpl();
		try {
			service.delProductById(pid);
			// 3.重定向到查询所有商品信息的Servlet
            response.sendRedirect(request.getContextPath() + "/FindAllProductServlet");
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

service层

package com.itheima.service.impl;

import java.util.List;

import com.itheima.dao.ProductDao;
import com.itheima.dao.impl.ProductDaoImpl;
import com.itheima.domain.Product;
import com.itheima.service.ProductService;

public class ProductServiceImpl implements ProductService {

	private ProductDao dao = new ProductDaoImpl();

	@Override
	public List<Product> findAllProduct() throws Exception {
		return dao.findAllProduct();
	}

	@Override
	public void addProduct(Product product) throws Exception {
		dao.addProduct(product);
	}

	@Override
	public void delProductById(String pid) throws Exception {
		dao.delProductById(pid);
	}

}

dao层

package com.itheima.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.itheima.dao.ProductDao;
import com.itheima.domain.Product;
import com.itheima.utils.C3P0Utils;

public class ProductDaoImpl implements ProductDao {

	@Override
	public List<Product> findAllProduct() throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pflag=?";
		// 3.设置实际参数
		Object[] params = { 0 };
		// 4.执行查询操作
		return qr.query(sql, new BeanListHandler<>(Product.class), params);
	}

	@Override
	public void addProduct(Product product) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "insert into product values(?,?,?,?,?,?,?,?,?,?)";
		// 3.设置实际参数
		Object[] params = { product.getPid(), product.getPname(), product.getMarket_price(), product.getShop_price(),
				product.getPimage(), product.getPdate(), product.getIs_hot(), product.getPdesc(), product.getPflag(),
				product.getCategory().getCid() };
		// 4.执行插入操作
		qr.update(sql, params);
	}

	@Override
	public void delProductById(String pid) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "delete from product where pid = ?";
		// 3.设置实际参数
		Object[] params = { pid };
		// 4.执行插入操作
		qr.update(sql, params);
	}

}

4.修改商品信息

3.1 回显数据

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/imagetable.css">
<style type="text/css">
	a{
		text-decoration: none;
		color: gray;
	}
</style>

<script type="text/javascript">
	//添加商品信息
	function addProductUI(){
		location.href="${pageContext.request.contextPath }/AddProductUIServlet";
	}
	
	//删除单个商品信息
	function delProductByPid(pid){
		//alert(pid);
		location.href="${pageContext.request.contextPath }/DelProductByIdServlet?pid="+pid;
	}
	
	function modifyProductByPid(pid){
		//alert(pid);
		location.href="${pageContext.request.contextPath }/ModifyUIProductServlet?pid="+pid;
	}
</script>
</head>
<body>
	<table border="1" width="40%" class="imagetable" align="center">
		<tr>
			<th>商品列表</th>
		</tr>
	</table>
	<hr/>
	<table border="1" width="100%" class="imagetable">
		<tr>
			<th colspan="6" align="right">
				<!-- javascript:void(0):禁用插连接 -->
				<a href="javascript:void(0);" onclick="addProductUI()">添加商品</a>
			</th>
		</tr>
		<tr>
			<th style="width:110px">商品序号</th>
			<th>商品名称</th>
			<th style="width:110px">商品图片</th>
			<th style="width:110px">商品价格</th>
			<th>商品描述</th>
			<th style="width:110px">操作</th>
		</tr>
		<!-- 遍历商品信息 -->
		<c:if test="${not empty products }">
			<c:forEach items="${products }" var="product" varStatus="vs">
				<tr>
					<td align="center">${vs.count }</td>
					<td>${product.pname }</td>
					<td align="center">
						<img  src="${pageContext.request.contextPath }/${product.pimage }" width="45px" height="45px">
					</td>
					<td align="center">${product.shop_price }</td>
					<td>${product.pdesc }</td>
					<td align="center">
						<a href="javascript:void(0);" onclick="delProductByPid('${product.pid}')">删除</a>
						<a href="javascript:void(0);" onclick="modifyProductByPid('${product.pid}')">修改</a>
					</td>
				</tr>
			</c:forEach>
		</c:if>
	</table>
</body>
</html>
package com.itheima.web.servlet;

import java.io.IOException;
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.itheima.domain.Category;
import com.itheima.domain.Product;
import com.itheima.service.CategoryService;
import com.itheima.service.ProductService;
import com.itheima.service.impl.CategoryServiceImpl;
import com.itheima.service.impl.ProductServiceImpl;

public class ModifyUIProductServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public ModifyUIProductServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		//1.获取请求参数
		String pid = request.getParameter("pid");
		//2.调用service层,根据ID查询商品信息的方法
		ProductService service = new ProductServiceImpl();
		try {
			Product product = service.findProductByPid(pid);
			//3.查询所有商品的分类信息
			CategoryService categoryService = new CategoryServiceImpl();
			List<Category> categorys = categoryService.findAllCategory();
			//4.将查询结果保存域对象
			request.setAttribute("product", product);
			request.setAttribute("categorys", categorys);
			//5.跳转到修改页面
			request.getRequestDispatcher("/modify.jsp").forward(request, response);
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}

 

package com.itheima.service.impl;

import java.util.List;

import com.itheima.dao.ProductDao;
import com.itheima.dao.impl.ProductDaoImpl;
import com.itheima.domain.Product;
import com.itheima.service.ProductService;

public class ProductServiceImpl implements ProductService {

	private ProductDao dao = new ProductDaoImpl();

	@Override
	public List<Product> findAllProduct() throws Exception {
		return dao.findAllProduct();
	}

	@Override
	public void addProduct(Product product) throws Exception {
		dao.addProduct(product);
	}

	@Override
	public void delProductById(String pid) throws Exception {
		dao.delProductById(pid);
	}

	@Override
	public Product findProductByPid(String pid) throws Exception {
		return dao.findProductByPid(pid);
	}

}

package com.itheima.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.itheima.dao.ProductDao;
import com.itheima.domain.Product;
import com.itheima.utils.C3P0Utils;

public class ProductDaoImpl implements ProductDao {

	@Override
	public List<Product> findAllProduct() throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pflag=?";
		// 3.设置实际参数
		Object[] params = { 0 };
		// 4.执行查询操作
		return qr.query(sql, new BeanListHandler<>(Product.class), params);
	}

	@Override
	public void addProduct(Product product) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "insert into product values(?,?,?,?,?,?,?,?,?,?)";
		// 3.设置实际参数
		Object[] params = { product.getPid(), product.getPname(), product.getMarket_price(), product.getShop_price(),
				product.getPimage(), product.getPdate(), product.getIs_hot(), product.getPdesc(), product.getPflag(),
				product.getCategory().getCid() };
		// 4.执行插入操作
		qr.update(sql, params);
	}

	@Override
	public void delProductById(String pid) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "delete from product where pid = ?";
		// 3.设置实际参数
		Object[] params = { pid };
		// 4.执行插入操作
		qr.update(sql, params);
	}

	@Override
	public Product findProductByPid(String pid) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pid=?";
		// 3.设置实际参数
		Object[] params = {pid};
		// 4.执行查询操作
		return qr.query(sql, new BeanHandler<>(Product.class), params);
	}

}

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>Insert title here</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/imagetable.css">

</head>
<body>
	<table border="1" width="40%" class="imagetable" align="center">
		<tr>
			<th>修改商品</th>
		</tr>
	</table>
	<hr/>
	<form action="${pageContext.request.contextPath}/ModifyServlet" method="post">
		<table border="1" width="65%" class="imagetable" align="center">
			<tr>
				<td>商品名称</td>
				<td><input type="text" name="pname" value="${product.pname }"/></td>
			</tr>
			<tr>
				<td>商品价格</td>
				<td><input type="text" name="shop_price" value="${product.shop_price }"/></td>
			</tr>
			<tr>
				<td>市场价格</td>
				<td><input type="text" name="market_price" value="${product.market_price }"/></td>
			</tr>
			<tr>
				<td>商品图片路径</td>
				<td><input type="text" name="pimage" value="${product.pimage }"/></td>
			</tr>
			<tr>
				<td>是否热门</td>
				<td><input type="radio" name="is_hot" value="0"   <c:if test="${product.is_hot==0}">checked="checkded"</c:if>  />不热门
				<input type="radio" name="is_hot" value="1" <c:if test="${product.is_hot==1}">checked="checkded"</c:if>/>热门</td>
			</tr>
			<tr>
				<td>商品描述</td>
				<td>
					<textarea name="pdesc">${product.pdesc }</textarea>
				</td>
			</tr>
			<tr>
				<td>商品分类</td>
				<td>
					<select name="cid">
						<c:if test="${not empty categorys }">
							<c:forEach items="${categorys }" var="category">
								<option value="${category.cid }" <c:if test="${category.cid==product.cid }">selected="selected"</c:if>>${category.cname }</option>
							</c:forEach>
						</c:if>
					</select>
				</td>
			</tr>
			<tr>
				<td></td>
				<td>
					<input type="submit" value="修改商品"/>
				</td>
			</tr>
		</table>
	</form>
</body>
</html>

3.2 修改数据

package com.itheima.web.servlet;

import java.io.IOException;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.beanutils.BeanUtils;

import com.itheima.domain.Category;
import com.itheima.domain.Product;
import com.itheima.service.CategoryService;
import com.itheima.service.ProductService;
import com.itheima.service.impl.CategoryServiceImpl;
import com.itheima.service.impl.ProductServiceImpl;

public class ModifyServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	public ModifyServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		//1.获取请求参数
		Map<String, String[]> parameterMap = request.getParameterMap();
		Product product = new Product();
		try {
			//2.封装数据
			BeanUtils.populate(product, parameterMap);
			
			//3.调用service层根据商品ID修改商品信息的代码
			ProductService service = new ProductServiceImpl();
			
			//获得cid
            String cid = request.getParameter("cid");
            CategoryService categoryService = new CategoryServiceImpl();
            Category category = categoryService.findCategoryById(cid);
            product.setCategory(category);
            
			service.modifyProductByPid(product);
			
			//4.重定向到查询所有商品信息的Servlet
            response.sendRedirect(request.getContextPath()+"/FindAllProductServlet");
		} catch (Exception e) {
			throw new RuntimeException(e);
		}
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request, response);
	}

}
package com.itheima.service.impl;

import java.util.List;

import com.itheima.dao.ProductDao;
import com.itheima.dao.impl.ProductDaoImpl;
import com.itheima.domain.Product;
import com.itheima.service.ProductService;

public class ProductServiceImpl implements ProductService {

	private ProductDao dao = new ProductDaoImpl();

	@Override
	public List<Product> findAllProduct() throws Exception {
		return dao.findAllProduct();
	}

	@Override
	public void addProduct(Product product) throws Exception {
		dao.addProduct(product);
	}

	@Override
	public void delProductById(String pid) throws Exception {
		dao.delProductById(pid);
	}

	@Override
	public Product findProductByPid(String pid) throws Exception {
		return dao.findProductByPid(pid);
	}

	@Override
	public void modifyProductByPid(Product product) throws Exception {
		dao.modifyProductByPid(product);
	}

}

package com.itheima.dao.impl;

import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.itheima.dao.ProductDao;
import com.itheima.domain.Product;
import com.itheima.utils.C3P0Utils;

public class ProductDaoImpl implements ProductDao {

	@Override
	public List<Product> findAllProduct() throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pflag=?";
		// 3.设置实际参数
		Object[] params = { 0 };
		// 4.执行查询操作
		return qr.query(sql, new BeanListHandler<>(Product.class), params);
	}

	@Override
	public void addProduct(Product product) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "insert into product values(?,?,?,?,?,?,?,?,?,?)";
		// 3.设置实际参数
		Object[] params = { product.getPid(), product.getPname(), product.getMarket_price(), product.getShop_price(),
				product.getPimage(), product.getPdate(), product.getIs_hot(), product.getPdesc(), product.getPflag(),
				product.getCategory().getCid() };
		// 4.执行插入操作
		qr.update(sql, params);
	}

	@Override
	public void delProductById(String pid) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "delete from product where pid = ?";
		// 3.设置实际参数
		Object[] params = { pid };
		// 4.执行插入操作
		qr.update(sql, params);
	}

	@Override
	public Product findProductByPid(String pid) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "select * from product where pid=?";
		// 3.设置实际参数
		Object[] params = { pid };
		// 4.执行查询操作
		return qr.query(sql, new BeanHandler<>(Product.class), params);
	}

	@Override
	public void modifyProductByPid(Product product) throws Exception {
		// 1.获得QueryRunner核心对象
		QueryRunner qr = new QueryRunner(C3P0Utils.getDataSource());
		// 2.编写SQL语句
		String sql = "update product set pname=?,shop_price=?,market_price=?,pimage=?,is_hot=?,pdesc=?,cid=? where pid=?";
		// 3.设置实际参数
		Object[] params = { product.getPname(), product.getShop_price(), product.getMarket_price(), product.getPimage(),
				product.getIs_hot(), product.getPdesc(), product.getCid(), product.getPid() };
		// 4.执行更新操作
		qr.update(sql, params);
	}

}

 

冰蓝心灵
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
${pageContext.request.contextPath}
No body But u
01-07 1452
`${pageContext.request.contextPath}`的意思是取出部署的应用程序名称或当前项目的名称。例如我的部署文件的名称是shopend_war_expload，${pageContext.request.contextPath}/css/common.css等价于/shopend_war_expload/css/common.css。
src标签中${pageContext.request.contextPath }无效问题解决方案
zhoucheng05_13的博客
12-05 1万+
问题描述<img src="${pageContext.request.contextPath}/static/images/dog.jpg"/>该链接中的图片显示不出来。原因分析在Chrome下用开发者工具查看图片请求链接会发现请求的链接变成了：//static/images/dog.jpg原因是${pageContext.request.contextPath}相当于http://localho
link标签的href=与 rel=stylesheet是什么意思？
cx-young的博客
03-30 2万+
link标签的href与 rel=stylesheet是什么意思？ 此处是设置CSS样式的，叫做外部格式链接。 rel=“stylesheet” type=“text/css” 是固定写法，不可修改。 href是URL rel是relationship的英文缩写，意思是“关系”； stylesheet中style是“样式”的意思,sheet是”表格“，加起来是样式表的意思； href连接的文档是一...
关于src中${pageContext.request.contextPath}不能识别的问题
cyikns的博客
05-14 1202
如果运行这一段代码的时候报错，请检查项目web.xmlwen文件的开头是这样的 Archetype Created Web Application 改完记得重启 作者：iXiongYu 来源：CSDN 原文：https://blog.csdn.net/u012527870/article/details/71330754 版权声明：本文为博主原创文章，转载请...
img动态改变src的参数，图片不及时更新
雨中漫步
09-30 1万+
在js中 window.setInterval(getPic, 100);         function getPic(){                             $("#img1").attr('src',"${pageContext.request.contextPath}/image/iframe.jpg?time="+(new Date()).getTime(
jdbc_day01.rar_JDBC增删改查_MySQL与数据库连接及增删改查操作
09-21
在JDBC中，增删改查（CRUD）操作是核心功能。以下是每种操作的简要说明： - **创建（Create）**：使用INSERT语句向数据库添加新记录。例如，插入一个用户： ```java String sql = "INSERT INTO users (username, ...
基于java对数据库增删改查
01-11
在Java编程语言中，对数据库进行增删改查（CRUD）操作是常见的任务，尤其在开发企业级应用时。本教程将围绕“基于Java对数据库进行增删改查”这一主题，详细介绍如何使用Java、MySQL数据库、MyBatis框架以及...
Jdbc_Day01.zip_jdbc
09-24
在"Jdbc_Day01.zip_jdbc"这个压缩包中，我们可以预期找到一些关于JDBC基础使用和数据库连接的教程资料。 JDBC的核心组件包括以下几个部分： 1. **Driver Manager**：这是JDBC的入口点，负责管理所有已注册的数据库...
day2_jdbc.zip_jdbc ut_jdbc util_jdbcUtil_jdbc封装
09-23
在Java编程领域，JDBC（Java Database Connectivity）是Java应用程序连接和操作数据库的标准接口。`JdbcUtil`类是开发者为了简化JDBC操作而自定义的一个工具类，它封装了JDBC的一些常用功能，以便更方便、高效地进行...
javaweb基础班day19_3客户关系管理系统（带分页的增删改查）
04-11
在本项目"javaweb基础班day19_3客户关系管理系统（带分页的增删改查）"中，我们将探讨几个核心的Java Web开发技术。这个系统旨在帮助新手理解如何实现一个实用的客户关系管理系统，其中包括了基础的数据操作功能如增...
绝对路径${pageContext.request.contextPath}用法及其与web.xml中Servlet的url-pattern匹配过程
热门推荐
Sun9528的博客
06-08 9万+
绝对路径${pageContext.request.contextPath}用法及其与web.xml中Servlet的url-pattern匹配过程
SpringBoot图片下载
qq_41373328的博客
11-07 6116
jsp页面： &lt;img src="${pageContext.request.contextPath}/showImg?imgID=1" /&gt; 后台： @RequestMapping("/showImg") public void showImg(HttpServletRequest request, HttpServletResponse response){ String i...
IDEA中使用${pageContext.request.contextPath}相对路径问题
weixin_42815846的博客
07-06 1345
${pageContext.request.contextPath}的路径是webapp 如下图 因此我们通常把静态资源放到webapp的resources下 可以在JSP使用如下语句来定位静态资源 <img src="${pageContext.request.contextPath }/resources/images/clown.jpeg"> <link rel="icon" href="${pageContext.request.contextPath }/resources/i
pageContext.request.contextPath写可迁移的项目
05-11 2064
${pageContext.request.contextPath }这是个EL表达式，可以用来得到工程的名字，比如 我要定义路径 按道理来说得到的应该是 。但是将工程发布后却无法解释${pageContext.request.contextPath }这个EL表达式，在Windows上发布后是正常的，可以正确解释EL表达式。但是当我把工程发布到linux服务器的时候路径 竟然是${pageC
JSP 页面中插入图片
weixin_30772261的博客
04-02 1956
第一步 在 JSP 页面中插入图片 EL 表达式 ${pageContext.request.contextPath } 的值为当前的项目名称 <html> ... <body> ... <img src="${pageContext.request.contextPath }/image/样本类型示意图.png" alt = "样本类...
2021-10-12
Sugar_Harmonious的博客
10-12 559
思路： 1、商家： 查看订单 发货-->“订单状态”：1=未发货、2=已发货、3=已签收、4=已撤单 （默认值1） 订单项的查看 实现思路： 分析功能： 订单表的查询 、 将订单表的订单状态由1改成2 、通过订单的id到订单项表查询出对应的订单项 2、买家： 功能： 查看订单、 撤单、 签收 实现思路： 订单表的查询 将订单表的订单状态由1改成4 将订单表的订单状态...
使用IDEA写JAVAWEB项目引入外部CSS文件无效解决方法
言语肤浅的博客
12-25 7288
今天在用IDEA写Java Web项目的时候，发现引入的外部CSS文件不起效果。 在网上查了别人的解决方法，有人说是因为文件路径名不对 ** {pageContext.request.contextPath} **使用这个语句可以查找到文件根目录。 但是我将代码改成<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/css/public.css"/>仍然没有效果 还有人说是因为编码问题，要
ssm项目路径问题和EL ${pageContext.request.contextPath}解析问题
YaQiSun的博客
11-28 1378
在page directive中的isELIgnored属性用来指定是否忽略。格式为： ＜%@ page isELIgnored＝"true|false"%＞ 如果设定为真，那么JSP中的表达式被当成字符串处理。比如下面这个表达式${2000 % 20}, 在isELIgnored＝"true"时输出为${2000 % 20}，而isELIgnored＝"false"时输出为100。Web容器默认isELIgnored＝"false&qu
mysql增删改查语句练习题
最新发布
08-19
- *1* *2* *3* [MySQL-day6-条件语句与增删改查练习题](https://blog.csdn.net/qq_23995091/article/details/114271955)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值