前言
本章给大家分享的是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+'/book.action?methodName=add',
onSubmit: