Easyui_06_datagrid——新增and删除

 

一、新增

主页搜索旁边添加一个新增的按钮，

   <a id="btn-add" href="#" class="easyui-linkbutton" data-options="iconCls:'icon-search'">新增</a> 

给它添加点击事件

	// 新增
	$("#btn-add").click(function() {
		$('#ff').form('clear');
		$('#dd').dialog('open');
		addflag = 1;

	})
})

dao方法

//	新增
	public void add(Book book) throws Exception {
		book.setBid((int)new Date().getTime());
		super.executeUpdate("insert into t_mvc_book values(?,?,?)", book, new String[] {"bid","bname","price"});
	
		}

BookAction

	public String add(HttpServletRequest req, HttpServletResponse resp) {
		try {
			bookDao.add(book);
			ResponseUtil.writeJson(resp, 1);
		} catch (Exception e) {
			e.printStackTrace();
			try {
			ResponseUtil.writeJson(resp, 0);
			} catch (Exception e1) {
				e1.printStackTrace();
			}
		}
		return null;
	}

 二、删除

删除是用的a标签，也写在来book里面

return '<a href="javascript:void(0)" onclick="edit()">修改</a>&nbsp;&nbsp;<a href="javascript:void(0)" onclick="del()">删除</a>'

同样添加在book.js里面添加事件

// 删除
function del() {
	var row = $('#dg').datagrid("getSelected");
	if (row) {
		var id = row.bid;
		/* messager不能向后台发送请求 */
		$.messager.confirm('确认', '您确认想要删除记录吗？', function(r) {
			if (r) {
				$.ajax({
					url : $('#ctx').val() + '/book.action?methodName=del&bid='+ id,
					success : function(data) {
						if (data == 1) {
							$('#dg').datagrid('reload');
						}
					}
				})
			}
		});

	}

}

然后写dao方法

public void del(Book book) throws Exception {
		super.executeUpdate("delete from t_mvc_book where bid =? ", book, new String[] {"bid"});
	
		}

BookAction

//	删除
	public String del(HttpServletRequest req, HttpServletResponse resp) {
		try {
			bookDao.del(book);
			ResponseUtil.writeJson(resp, 1);
		} catch (Exception e) {
			e.printStackTrace();
			try {
			ResponseUtil.writeJson(resp, 0);
			} catch (Exception e1) {
				e1.printStackTrace();
			}
		}
		return null;
	}