87,997
社区成员




<input type="text" id="<%=ID%>" name="<%=ID%>name" value="<%=zhi%>" style="width:60px" readonly/>
//ID是不一样的,从数据库中取,数据库中有几个ID,就有几个文本框。
//如果数据库中ID有2个为1和2,则:
//<input type="text" id="1" name="1name" value="<%=zhi%>" style="width:60px" readonly/>
//<input type="text" id="2" name="2name" value="<%=zhi%>" style="width:60px" readonly/>
总和:<input type="text" style="width:60px" readonly/>
<html>
<SCRIPT language="javascript">
function getSum(sName){
var f = document.forms[0];
var sum = 0;
for(var i=0;i<f.elements.length;i++){
if(f.elements[i].type=="text"){
s = f.elements[i].name;
if(s.substr(s.length-sName.length,sName.length)==sName) sum += parseFloat(f.elements[i].value);
}
}
f.sum.value = sum;
}
window.onload = function(){
getSum("name");
}
</SCRIPT>
</head>
<body>
<form>
<input type="text" id="1" name="1name" value="10" style="width:60px" readonly/>
<input type="text" id="2" name="2name" value="20" style="width:60px" readonly/>
总和:<input type="text" name="sum" style="width:60px" readonly/>
</form>
</body>
</html>
<script>
var sum = 0
//j为循环读出的数据条数
for(var i=1;i<=<%=j%>;i++)
{
sum+=parseInt(document.getElementById(i).value)
}
document.getElementById("sum").value = sum;
</script>
select sum(字段名) from 表名
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
<title>Insert title here</title>
<script>
<!--
window.onload = function()
{
var str="";
var arr = document.getElementsByTagName("input");
for (var i = 0; i < arr.length; i++)
{
if (arr[i].type == "text")
{
str=arr[i].value*1+str*1;
}
}
document.all.aaname.value=str;
}
-->
</script>
</head>
<body>
值:<br/>
<input type="text" value="1" name="1"><br/>
<input type="text" value="2" name=2><br/>
<input type="text" value="3" name=3><br/>
<input type="text" value="4" name=4><br/>
<input type="text" value="5" name=5><br/>
和:<br/>
<input type="text" name="aaname" style="width:60px" readonly/><br/>
</body>
</html>