1,动态加载table的行列
function testLoad(){
var table = document.getElementById("mytable");
for(var i=0;i<this.opener.unFoundFieldTaskIdList.length;i++){
var row = table.insertRow(table.rows.length);
row.insertCell(0).innerHTML = i+1;
row.insertCell(1).innerHTML = this.opener.unFoundFieldTaskIdList[i];
}
}
2,JS正则表达式
// 按正则过滤输入文本,只允许输入数字
function checkNumber(tar){
var reg = /^[0-9]+$/;
if(!reg.test(tar.value)){
tar.value = '';
}
}
3,通过父元素来查找子元素
ParentElement.childNodes[]
Var p = a.parentNode;
4,父子页面传值
父页面:var obj = window;
obj.unFoundFieldTaskIdList;
子页面:this.opener.unFoundFieldTaskIdList这样就能取到值
5,case when then when then else end用法:
SELECT (CASE WHEN T.NUMID = 2 THEN T.MATCHID ELSE NULL END) FROM TASK_INFO T
6,批量更新
Update table t1 set (t1.c1,t1.c2) = (select t2.c1,t2.c2 from table t2 where t1.id = t2.id)
7, substr截取字符串:
Substr(msg,startindex,endindex)
8,Instr(msg,targetmsg,1,1)->msg是需要判断的字符串,targetmsg目标字符串,1是从第一位开始,1出现的第几次。
9,like 模糊匹配,通配符
%代表任意个字符,_代表任意一个字符
10,原生js创建异步请求:
function createXMLHttp() {
var XmlHttp;
if (window.ActiveXObject)
{
var arr=["MSXML2.XMLHttp.6.0","MSXML2.XMLHttp.5.0", "MSXML2.XMLHttp.4.0","MSXML2.XMLHttp.3.0","MSXML2.XMLHttp","Microsoft.XMLHttp"];
for(var i=0;i<arr.length;i++) {
try {
XmlHttp = new ActiveXObject(arr[i]);
return XmlHttp;
} catch(error) {
}
}
} else {
try {
XmlHttp=new XMLHttpRequest();
return XmlHttp;
}
catch(otherError) {
}
}
}
// 发送post请求
function xmlPost(method,url,param,syncFlg,timerName) {
var result;
var xmlHttp = createXMLHttp();
xmlHttp.open(method,url,syncFlg);
xmlHttp.onreadystatechange = function() {
if(xmlHttp.readyState == 4 && xmlHttp.status == 200) {
result = xmlHttp.responseText;
var json = eval("("+result+")");
if(json.taskSmeltTimerStop == true){
window.clearInterval(timerName);
} else {
var resultMsg = '<div id="successdiv" class="successmsg">'+json.taskSmeltMsg+'</div>';
document.getElementById('printMassage').innerHTML = resultMsg;
}
}
}
xmlHttp.send(param);
}