Datagrid数据表格---增删改

前言

本章给大家分享的是datagrid增删改实现步骤。

效果图展示

增加页面效果展示

修改页面效果展示

增删改实现步骤

实现增加

1.dao方法

public int add(Book book) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
   
  //拼音的属性值不是从jsp传递过来的
  book.setPinyin(PinYinUtil.getAllPingYin(book.getName()));
  //从前端把jsp传到后端的depioyTime属性是String类型，而数据库需要的是timestamp
  //SimpleDateFormat sdt=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  String sql="insert into t_easyui_book values(null,?,?,?,?,?,?,?,?,?,?,?)";
  return super.executeUpdate(sql, book, new String[] {
   "name","pinyin","cid","author","price","image","publishing","description","state","deployTime","sales"});
 }

2.Action代码

public String add(HttpServletRequest req,HttpServletResponse resp) {
   
  try {
   
   int n = this.bookdao.add(book);
      ResponseUtil.writeJson(resp,DataGridResult.SUCCESS);
   
  } catch (NoSuchFieldException e) {
   
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SecurityException e) {
   
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalArgumentException e) {
   
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (Exception e) {
   
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
   return null; 
 }

3.js代码

//给新增按钮绑定点击事件
 $("#btn-add").click(function(){
   
  $("#bookEdit").dialog('open');
 });
 
 
 
 $("#btn-save").click(function(){
   
  $('#ff').form('submit', {
       
    url:ctx