dao;
// 查询单个product对象
public Product findProductByPid(String pid) throws SQLException {
String sql = "select * from product where pid=?";
QueryRunner qr = new QueryRunner(DataSourceUtils.getDataSource());
Product product = qr.query(sql,
new BeanHandler<Product>(Product.class), pid);
product.setCategory(qr.query("select * from category where cid = ?", new BeanHandler<Category>(Category.class),product.getCid()));
return product;
}
// 修改
public int updateProduct(Product product) throws SQLException {
{
QueryRunner runner = new QueryRunner(
DataSourceUtils.getDataSource());
if (product.getPimage() == null) {
String sql = "update product set pname=?,market_price=?,shop_price=?,"
+ "is_hot=?,pdesc=?,pflag=?,cid=? where pid=?";
return runner.update(sql, product.getPname(),
product.getMarket_price(), product.getShop_price(),
product.getIs_hot(), product.getPdesc(),
product.getPflag(), product.getCid(), product.getPid());
} else {
String sql = "update product set pname=?,market_price=?,shop_price=?,"
+ "pimage=?,is_hot=?,pdesc=?,pflag=?,cid=? where pid=?";
return runner.update(sql, product.getPname(),
product.getMarket_price(), product.getShop_price(),
product.getPimage(), product.getIs_hot(),
product.getPdesc(), product.getPflag(),
product.getCid(), product.getPid());
}
}
}
service:
// 跳转到修改页面
public Product findProductByPid(String pid) {
try {
return pd.findProductByPid(pid);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
//修改
public boolean updateProduct(Product product) {
try {
return pd.updateProduct(product) > 0 ? true : false;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}
servlet:
// 跳转到编辑页面
public void toUpdate(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
String pid = request.getParameter("pid");
Product pro = ps.findProductByPid(pid);
request.setAttribute("product", pro);
request.getRequestDispatcher("/admin/product/edit.jsp").forward(
request, response);
}
// 编辑
public void update(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, IllegalAccessException,
InvocationTargetException, FileUploadException {
FileItemFactory fileItemFactory = new DiskFileItemFactory();
ServletFileUpload sf = new ServletFileUpload(fileItemFactory);
if (sf.isMultipartContent(request))// 判断表单enctype为否为mutipart-data
{
// 如果表单含有上传标签,那么getParamMap方法失效,
// 因为前台input太多,所以我们要使用beanUtils快速封装,那么我们就需要自己封装Map了
Map<String, String> paramsMap = new HashMap<String, String>();
List<FileItem> itemList = sf.parseRequest(request);
// 1.上传
for (FileItem fileItem : itemList) {
if (!fileItem.isFormField())// 判断是否为上传组件
{
if (fileItem.getSize() > 0) {// 判断前台选择文件没有
// 1.1执行上传
// 1.1.1获取服务器上传目录路径
String path = getServletContext().getRealPath(
"/products");
// 1.1.2上传
InputStream is = fileItem.getInputStream();
// getFieldName()获取表单标签name属性值
// getName()获取文件名
// getString()获取表单标签value值
FileOutputStream fos = new FileOutputStream(new File(
path, fileItem.getName()));
IOUtils.copy(is, fos);
// 清除临时文件
fileItem.delete();
is.close();
fos.close();
// 将pimage属性存入map
paramsMap.put(fileItem.getFieldName(), "products/"
+ fileItem.getName());
}
} else// 普通组件
{
paramsMap.put(fileItem.getFieldName(),
fileItem.getString("UTF-8"));
}
}
// 2.封装product对象 保存到数据库里
Product product = new Product();
BeanUtils.populate(product, paramsMap);
// 保存欲修改的对象 供删除
Product delete_product = ps.findProductByPid(product.getPid());
boolean result = ps.updateProduct(product);
// 修改成功后删除
if (delete_product.getPimage() != null) {
if (result) {
String path = getServletContext().getRealPath("");
File file = new File(path, delete_product.getPimage());
if (file.exists()) {
file.delete();
}
}
}
if (result) {
response.getWriter()
.println(
"<script>confirm('修改成功');location.href='/ShopStore/product?method=list';</script>");
} else {
response.getWriter()
.println(
"<script>confirm('修改失败');location.href='/ShopStore/admin/product/edit.jsp;</script>");
}
}
}
Thank you for reading
jsp+Javabean+servlet实现修改
最新推荐文章于 2021-02-17 04:57:31 发布