js获取复选框的值、根据值查询数据库信息
//js获取复选框的值
function zhuzhuangtu(obj){
var websiteID = document.getElementsByName('websiteID');
var value="";
var tag = 0;
for(i=0;i<websiteID.length;i++){
if(websiteID[i].checked){
if(tag==1){
value+=",";
}
tag = 1;
value+=websiteID[i].value;
}
}
alert(value);
winopen700("fun.getSession('PATH')/bike/websiteZhuZhuangTu.do?areaID="+obj+"&valuseee="+value);
}
// 查询出选中值的信息(sql)
//oracle in查询
select website_id,
website_no,
website_name,
IS_SUFF,
area_id,
expressions,
website_status
from sm_t_website
where 1=1 and website_id in(valueseee)
order by website_no