运用layui实现增删改查

package com.chen.dao;

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

import com.chen.util.JsonBaseDao;
import com.chen.util.JsonUtils;
import com.chen.util.PageBean;
import com.chen.util.StringUtils;

public class BooktypeDao extends JsonBaseDao{

/**
 * 书籍类别查询
 * @param paMap
 * @param pageBean
 * @return
 * @throws SQLException 
 * @throws IllegalAccessException 
 * @throws InstantiationException 
 */
public List<Map<String, Object>> list(Map<String, String[]> paMap,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
    String sql=" select * from t_type where true";
    String tid=JsonUtils.getParamVal(paMap, "tid");
    String tname=JsonUtils.getParamVal(paMap, "tname");
    if(StringUtils.isNotBlank(tid)) {
        sql+=" and tid ="+tid+" ";
    }
    if(StringUtils.isNotBlank(tname)) {
        sql+=" and tname like '%"+tname+"%'";
    }
    sql += "  order by tid desc ";
    return executeQuery(sql, pageBean);
}





/**
 * 增加
 * @param paMap
 * @return
 * @throws NoSuchFieldException
 * @throws SecurityException
 * @throws IllegalArgumentException
 * @throws IllegalAccessException
 * @throws SQLException
 */
public int addType(Map<String, String[]> paMap) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
    String sql="insert into t_type(tname)  values(?) ";
    
    return super.executeUpdate(sql, new String[] {"tname"}, paMap);
}


/**
 * 修改
 * @param paMap
 * @return
 * @throws NoSuchFieldException
 * @throws SecurityException
 * @throws IllegalArgumentException
 * @throws IllegalAccessException
 * @throws SQLException
 */
public int editType(Map<String, String[]> paMap) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
    String sql="update t_type set tname=? where tid=?";
    
    return super.executeUpdate(sql, new String[] {"tname","tid"}, paMap);
}

/**
 * 删除
 * @param paMap
 * @return
 * @throws NoSuchFieldException
 * @throws SecurityException
 * @throws IllegalArgumentException
 * @throws IllegalAccessException
 * @throws SQLException
 */

public int removeType(Map<String, String[]> paMap) throws NoSuchFieldException, SecurityException, IllegalArgumentException, IllegalAccessException, SQLException {
    String sql="delete from t_type where tid=? ";
    
    return super.executeUpdate(sql, new String[] {"tid"}, paMap);
}

}