$(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){
}
}
]],
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();
%>