日期:2014-05-16  浏览次数:20450 次

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