jquery修改java_java jsp jquery中的删除和修改

$(function(){

$('#custom').datagrid({

nowrap: false,

striped: true,

collapsible:true,

url:'../json/getcustomerInfo.jsp',

sortName: 'khbh',

sortOrder: 'desc',

fit:'true',

fitColumns:'true',

remoteSort: false,

frozenColumns:[[

{title:'客户编号',field:'khbh',width:'100',align:'center',sortable:true},

{title:'客户名称',field:'khmc',width:'200',align:'center',sortable:true},

{title:'部门名称',field:'bmmc',width:'150',align:'center',sortable:true},

{title:'部门职能',field:'bmzn',width:'100',align:'center',sortable:true},

{title:'客户基本信息',field:'khjbxx',width:'200',align:'center',sortable:true},

{title:'备注',field:'bz',width:'100',align:'center',sortable:true}

]],

columns:[[

{field:'cz',title:'操作',width:'100',align:'center', rowspan:2,

formatter:function(value,rec){

return '修改|删除';

}

}

]],

pagination:true,

rownumbers:true,

toolbar:[{

id:'btnadd',

text:'新增客户',

iconCls:'icon-add',

handler:function(){

$('#btnsave').linkbutton('enable');

window.location.href='../jsp/newCustomer.jsp?id=12'

}

}]

});

var p = $('#custom').datagrid('getPager');

$(p).pagination({

onBeforeRefresh:function(){

alert('正在刷新');

}

});

});

请问一下上面的红色的代码应该怎么写才能修改和删除页面的数据后,数据库的数据也修改和删除了啊?

我的updateCustomerInfo.jsp如下:

request.setCharacterEncoding("utf-8");//处理乱码

String id = request.getParameter("idcustomer");

int aid = Integer.parseInt(id);

String khmc = request.getParameter("khmc");

String bmmc = request.getParameter("bmmc");

String bmzn = request.getParameter("bmzn");

String bmfzr = request.getParameter("bmfzr");

String khjbxx = request.getParameter("khjbxx");

String bz = request.getParameter("bz");

String sql = "update customer set khmc='"+khmc+"',bmmc='"+bmmc+"',bmzn='"+bmzn+"',bmfzr='"+bmfzr+"',khjbxx='"+khjbxx+"',bz='"+bz+"' where idcustomer="+aid;

boolean bol = dbConn.Sql(sql);

//out.println(sql);

if(bol){

out.println("{\"success\":\"true\",\"msg\":\"添加成功!\"}");

}else{

out.println("{\"failure\":\"failure\",\"msg\":\"出错了,请重新操作!\"}");

}

//out.println("1秒后自动跳转...");

dbConn.releaseConn();//释放链接

response.setHeader("Refresh","1; URL=customerInfo.jsp");//1秒后自动跳转页面

%>

我的deleteCustomerInfo.jsp如下:

String id = request.getParameter("id");

int aid = Integer.parseInt(id);

boolean bol = customer.deleteCustomerInfo(aid);

response.setHeader("Refresh","1; URL=customerInfo.jsp");//1秒后自动跳转页面

dbConn.releaseConn();

%>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值