1.全选简单操作:
οnclick="$('[name=ids]').attr('checked',this.checked)";
2.删除所选中的数据行
-先将复选框的ID作为字符串传个后台:
<input type="checkbox" name="chk" value="${id}"/>这是框
//删除
function del() {
//这里要验证和获取选择删除的行
DelChk();
if (flag == false) {
return false;
} else {
if (confirm("确认删除吗?")) {
var ids="";
var chk1 = document.getElementsByName("chk");
for(var i=0;i<chk1.length;i++){
if (chk1[i].checked) {
ids=ids+chk1[i].value+",";
}
}
$.ajax({
url : "CarAction_delect.action",
type : "POST",
//data:{}如果没有就不传当有值的时候是比如:
data:{"ids":ids},
dataType : "json",
complete : function() {
window.location.href = "/LIS/TSP/CarAction_list.action";
}
});
}
}
}
function DelChk() {
var count = 0;
var chk = document.getElementsByName("chk");
for (var i = 0; i < chk.length; i++) {
if (chk[i].checked) {
count++;
}
}
if (count == 0) {
alert("请选择要删除的车辆信息");
flag = false;
return false;
}
flag = true;
}
---后台action:String s=ServletActionContext.getRequest().getParameter("ids");
String[] s1=s.split(",");
for(int i=0;i<s1.length;i++){
carService.delect(carService.get(Long.parseLong(s1[i])));
}
PrintWriter out=ServletActionContext.getResponse().getWriter();
out.println(s1);
out.flush();
return "list";
----------------------------------------------多条件查询
String hql="from Car c where 1=1 ";
if(car.getCarNumber()!=null&&!car.getCarNumber().equals("")){
hql=hql+"and c.carNumber='"+car.getCarNumber()+"'";
}
if(car.getCarChePai()!=null&&!car.getCarChePai().equals("")){
hql=hql+"and c.carChePai='"+car.getCarChePai()+"'";
}
if(car.getCarType()!=null&&!car.getCarType().equals("")){
hql=hql+"and c.carType='"+car.getCarType()+"'";
}
if(car.getCarPlace()!=null&&!car.getCarPlace().equals("")){
hql=hql+"and c.carPlace='"+car.getCarPlace()+"'";
}
if(car.getCarState()!=null&&!car.getCarState().equals("")){
hql=hql+"and c.carState='"+car.getCarState()+"'";
}
if(carBuyingTimeStart!=null){
hql=hql+"and c.carBuyingTime>='"+carBuyingTimeStart+"'";
}
if(carBuyingTimeEnd!=null){
hql=hql+"and c.carBuyingTime<='"+carBuyingTimeEnd+"'";
}
οnclick="$('[name=ids]').attr('checked',this.checked)";
2.删除所选中的数据行
-先将复选框的ID作为字符串传个后台:
<input type="checkbox" name="chk" value="${id}"/>这是框
//删除
function del() {
//这里要验证和获取选择删除的行
DelChk();
if (flag == false) {
return false;
} else {
if (confirm("确认删除吗?")) {
var ids="";
var chk1 = document.getElementsByName("chk");
for(var i=0;i<chk1.length;i++){
if (chk1[i].checked) {
ids=ids+chk1[i].value+",";
}
}
$.ajax({
url : "CarAction_delect.action",
type : "POST",
//data:{}如果没有就不传当有值的时候是比如:
data:{"ids":ids},
dataType : "json",
complete : function() {
window.location.href = "/LIS/TSP/CarAction_list.action";
}
});
}
}
}
function DelChk() {
var count = 0;
var chk = document.getElementsByName("chk");
for (var i = 0; i < chk.length; i++) {
if (chk[i].checked) {
count++;
}
}
if (count == 0) {
alert("请选择要删除的车辆信息");
flag = false;
return false;
}
flag = true;
}
---后台action:String s=ServletActionContext.getRequest().getParameter("ids");
String[] s1=s.split(",");
for(int i=0;i<s1.length;i++){
carService.delect(carService.get(Long.parseLong(s1[i])));
}
PrintWriter out=ServletActionContext.getResponse().getWriter();
out.println(s1);
out.flush();
return "list";
----------------------------------------------多条件查询
String hql="from Car c where 1=1 ";
if(car.getCarNumber()!=null&&!car.getCarNumber().equals("")){
hql=hql+"and c.carNumber='"+car.getCarNumber()+"'";
}
if(car.getCarChePai()!=null&&!car.getCarChePai().equals("")){
hql=hql+"and c.carChePai='"+car.getCarChePai()+"'";
}
if(car.getCarType()!=null&&!car.getCarType().equals("")){
hql=hql+"and c.carType='"+car.getCarType()+"'";
}
if(car.getCarPlace()!=null&&!car.getCarPlace().equals("")){
hql=hql+"and c.carPlace='"+car.getCarPlace()+"'";
}
if(car.getCarState()!=null&&!car.getCarState().equals("")){
hql=hql+"and c.carState='"+car.getCarState()+"'";
}
if(carBuyingTimeStart!=null){
hql=hql+"and c.carBuyingTime>='"+carBuyingTimeStart+"'";
}
if(carBuyingTimeEnd!=null){
hql=hql+"and c.carBuyingTime<='"+carBuyingTimeEnd+"'";
}