easyui实现数据的增、删、改

一、前言

上次分享了easyui实现数据查询，今天分享easyui实现数据增、删、改

二、实现

1、后端代码编写

增加dao方法

package com.liubiao.dao;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.liubiao.entity.Book;
import com.liubiao.entity.Permission;
import com.liubiao.util.BaseDao;
import com.liubiao.util.BuildTree;
import com.liubiao.util.PageBean;
import com.liubiao.util.PinYinUtil;
import com.liubiao.util.StringUtils;
import com.liubiao.vo.TreeVo;

public class BookDao extends BaseDao<Book> {
   
	
	/**
	 * 是直接从数据库获取到的数据
	 * @param permission
	 * @param pageBean
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException+
	 */
	public List<Book> list(Book book,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
   
		String name = book.getName();
		String sql="select * from t_easyui_book where true ";
		if(StringUtils.isNotBlank(name)) {
   
			sql+=" and name like '%"+name+"%'";
		}
		return super.executeQuery(sql, Book.class, pageBean);
	}
	
//	增加
	public int add(Book book) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
   
		book.setPinyin(PinYinUtil.getAllPingYin(book.getName()));
		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"});
	}
	
//	修改
	public int edit(Book book) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
   
		book.setPinyin(PinYinUtil.getAllPingYin(book.getName()));
		String sql = "update t_easyui_book set name=?,pinyin=?,cid=?,author=?,price=?,image=?,publishing=?,description=?,state=?,deployTime=?,sales=? where id=? ";
		return super.executeUpdate(sql, book, new String[] {
   "name","pinyin","cid","author","price","image","publishing","description","state","deployTime","sales","id"});
	}
	
//	删除
	public int del(Book book) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
   
		String sql = "delete from t_easyui_book where id=?";
		return super.executeUpdate(sql, book, new String[] {
   "id"});
	}
	
}

数据处理的类

package com.liubiao.web