怎样判断表格的某一列是否存在相同数据 如题,先谢谢了 列1 列2 列3 A B c D b e A c d 怎样怎样判断列1有重复的数据A呢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <html><body> <table width="90%" border="1" cellspacing="1" cellpadding="1" id="datatable"> <tr> <td>ID </td> <td>Type</td> <td>Title</td> </tr> <tr> <td>1</td> <td>a</td> <td>title1</td> </tr> <tr> <td>2</td> <td>b</td> <td>title2</td> </tr> <tr> <td>3</td> <td>a</td> <td>title3</td> </tr> <tr> <td>4</td> <td>b</td> <td>title4</td> </tr> <tr> <td>5</td> <td>a</td> <td>title5</td> </tr></table><script language="javascript" type="text/javascript"> //在这里,现获取表格,再getElementsByTagName; var tbl = document.getElementById('datatable'); var trs = tbl.getElementsByTagName('tr'); for(var i=1; i<trs.length; i++){ trs[i].onmouseover = function(){ this.style.backgroundColor = "#eee"; var _type = this.childNodes[1].childNodes[0].data; for(var j=1; j<trs.length; j++){ if(trs[j].childNodes[1].childNodes[0].data==_type){ trs[j].style.backgroundColor = "#eee"; } } } trs[i].onmouseout = function(){ for(var j=1; j<trs.length; j++){ trs[j].style.backgroundColor = "#fff"; } } }</script></body></html>以前在网上摘的,你拿去改改就ok了,这些代码是将type那一列相同的数据都变色. SELECT 列1, COUNT(列1) FROM tbl GROUP BY 列1 HAVING COUNT(列1)>1 <script language="javascript" type="text/javascript">function check(n){ var tb = document.getElementById("tb"); var b = false; for(var i=1;i<tb.rows.length-1;i++){ b = false; for(var j=i+1;j<tb.rows.length;j++){ if(tb.rows[i].cells[n].innerHTML == tb.rows[j].cells[n].innerHTML){ b = true; break; } } if(b) break; } if(b) alert("重复"); else alert("无重复");} </script><input type="button" value="检查1" onclick="check(0);"><input type="button" value="检查2" onclick="check(1);"><input type="button" value="检查3" onclick="check(2);"><table id="tb"> <tr><td>列1</td><td>列2</td><td>列3</td></tr> <tr><td>A</td><td>B</td><td>c</td></tr> <tr><td>D</td><td>b</td><td>e</td></tr> <tr><td>A</td><td>c</td><td>d</td></tr></table> 求解 jquery写的焦点图 点击快了会乱 Javascript两日期相减 周末除外 IE7.0提示不支持其方法!! 用复选框(checkbox)来控制文本框(textfield)的属性 關於在createPopup窗體中加入JS函數的問題? 把excel贴在网页上,为什么输入18位身份证号码时候,最后三位被自动置0??? iframe在ie5.0中不显示? 把字符窜当一条命令来执行怎么做? 在javascript中怎么把字符串变成url编码? 将一个纪录集存放到Hashtable中,怎么处理呢? 帮忙写个正则吧 怎样判断表格的某一列是否存在相同数据
<body>
<table width="90%" border="1" cellspacing="1" cellpadding="1" id="datatable">
<tr>
<td>ID </td>
<td>Type</td>
<td>Title</td>
</tr>
<tr>
<td>1</td>
<td>a</td>
<td>title1</td>
</tr>
<tr>
<td>2</td>
<td>b</td>
<td>title2</td>
</tr>
<tr>
<td>3</td>
<td>a</td>
<td>title3</td>
</tr>
<tr>
<td>4</td>
<td>b</td>
<td>title4</td>
</tr>
<tr>
<td>5</td>
<td>a</td>
<td>title5</td>
</tr>
</table>
<script language="javascript" type="text/javascript">
//在这里,现获取表格,再getElementsByTagName;
var tbl = document.getElementById('datatable');
var trs = tbl.getElementsByTagName('tr');
for(var i=1; i<trs.length; i++){
trs[i].onmouseover = function(){
this.style.backgroundColor = "#eee";
var _type = this.childNodes[1].childNodes[0].data;
for(var j=1; j<trs.length; j++){
if(trs[j].childNodes[1].childNodes[0].data==_type){
trs[j].style.backgroundColor = "#eee";
}
}
}
trs[i].onmouseout = function(){
for(var j=1; j<trs.length; j++){
trs[j].style.backgroundColor = "#fff";
}
}
}
</script>
</body>
</html>
以前在网上摘的,你拿去改改就ok了,这些代码是将type那一列相同的数据都变色.
<script language="javascript" type="text/javascript">
function check(n){
var tb = document.getElementById("tb");
var b = false;
for(var i=1;i<tb.rows.length-1;i++){
b = false;
for(var j=i+1;j<tb.rows.length;j++){
if(tb.rows[i].cells[n].innerHTML == tb.rows[j].cells[n].innerHTML){
b = true; break;
}
}
if(b) break;
}
if(b) alert("重复");
else alert("无重复");
}
</script>
<input type="button" value="检查1" onclick="check(0);">
<input type="button" value="检查2" onclick="check(1);">
<input type="button" value="检查3" onclick="check(2);">
<table id="tb">
<tr><td>列1</td><td>列2</td><td>列3</td></tr>
<tr><td>A</td><td>B</td><td>c</td></tr>
<tr><td>D</td><td>b</td><td>e</td></tr>
<tr><td>A</td><td>c</td><td>d</td></tr>
</table>