easyui的增删改查

iuiuhhh

于 2022-04-14 20:08:41 发布

阅读量328

点赞数

分类专栏： java 文章标签： eclipse

本文链接：https://blog.youkuaiyun.com/iuiuhhh/article/details/124180375

版权

java 专栏收录该内容

14 篇文章

订阅专栏

这篇博客展示了如何使用EasyUI进行数据库的增删改查操作。通过DAO方法实现了更新和删除Book记录的功能，同时提供了一个更新Book信息的Servlet代码示例，该示例接收到请求参数，调用服务层方法执行更新操作，并返回操作结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

dao方法

   @Override
   public void updateBook(Book book) {
       String sql = "update t_book set bookname=? booktype=? where id=?";
       Connection con = null;
       PreparedStatement ps = null;
       try {
           con = DBHelper.getCon();
           ps = con.prepareStatement(sql);
           ps.setObject(1,book.getBookname());
           ps.setObject(2,book.getPrice());
           ps.setObject(3,book.getBooktype());
           ps.setObject(4,book.getId());
           ps.executeUpdate();
       } catch (Exception e) {
           e.printStackTrace();
       }finally {
           DBHelper.myClose(con, ps,null);
       }

   }


   @Override
   public void delBookById(Integer   id) {
       String sql = "delete from t_book where id=? ";
       Connection con = null;
       PreparedStatement ps = null;
       try {
           con = DBHelper.getCon();
           ps = con.prepareStatement(sql);
           ps.setObject(1,id);
           ps.executeUpdate();
       } catch (Exception e) {
           e.printStackTrace();
       }finally {
           DBHelper.myClose(con, ps,null);
       }

   }

修改代码

package com.zking.euidemo.serviet;

import java.io.IOException;
import java.io.PrintWriter;
import java.math.BigDecimal;
import java.util.HashMap;
import java.util.Map;

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

import com.alibaba.fastjson.JSON;
import com.zking.euidemo.model.Book;
import com.zking.euidemo.service.BookService;
import com.zking.euidemo.service.IBookService;

@WebServlet("/updateBookServlet")
public class UpdateBookServlet extends HttpServlet{
   private IBookService service = new BookService();
   /**
   *
   */
   private static final long serialVersionUID = 1L;

   @Override
   protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
       doPost(req, resp);
   }

   @Override
   protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
       //设置编码方式
       req.setCharacterEncoding("utf-8");
       resp.setContentType("application/json;charset=utf-8");
       String id = req.getParameter("id");
       String bookname = req.getParameter("bookname");
       String price = req.getParameter("price");
       String booktype = req.getParameter("booktype");
       //System.out.println(bookname+" "+ " "+price + " "+booktype);
       Book book = new Book();
       book.setId(Integer.parseInt(id));
       book.setBookname(bookname);
       book.setPrice(price);
       book.setBooktype(booktype);
       PrintWriter out = resp.getWriter();
       //String str = JSON.toJSONString(map);
       Map<String,Object> data = new HashMap<>();

       //接收表单过来的值
       try {
           service.updateBook(book);
           data.put("success",true);
       } catch (Exception e) {
           data.put("success",false);
       }

       out.write(JSON.toJSONString(data));
       out.flush();//刷新
       out.close();//关闭
   }
}