1.jquery取出带id属性的div里面选中的复选框的值
var levelArray=new Array();
$("#level_config input[type='checkbox']:checked").each(function(){
levelArray.push($(this).val());//向数组中添加元素
})
var levels=levelArray.join(',');//将数组元素连接起来以构建一个字符串,此处levels类型为字符串 alert(levels)得到 1,2,3,4
2. GET加json等不正常参数要进行编码encodeURIComponent()
var url = getRootPath() + "/event/exportExcel.do?params=" + encodeURIComponent(jsonParams);
location.href = url; //window.open(url);
3.bootstrap获取所有选中项
var selectContent = $("#To_Table").bootstrapTable('getSelections');
4.ajax如果传参数为数组,一般ajax里面配置属性traditional: true,
5.删除某一字段重复的 数据并且保留ROWID最小的那个
DELETE FROM TABLE_L WHERE (EVENTNUM) IN ( SELECT EVENTNUM FROM TABLE_L GROUP BY EVENTNUM HAVING COUNT(EVENTNUM) > 1) AND ROWID NOT IN (SELECT MIN(ROWID) FROM TABLE_L GROUP BY EVENTNUM HAVING COUNT(*) > 1)
6.jquery 添加name属性,给表格里所有span添加name="showText"属性
$("#table").find("span").attr("name","showText");