DwNet(DwNet):数据就上面几条,以前的帖子连接也有,朋友们解答一条,我可以就开100分答谢,三条300都没问题。不大明白将数据生成后贴出来,什么意思?建两个表,不是很麻烦吧
解决方案 »
- 请教一个迷惑不解的问题,jssdk方面
- 同一页面两个表单的问题
- function mm(gg){return document.all ? gg.innerText : gg.textContent}
- 由document.getElementByID().value得到的值如何去掉前后空格
- 如何用js修改ContentType,或使用 js 修改ContentType=msword的 page ?
- 问一个有点难的问题,请问怎么用javascript做一个先进后出的栈??
- 如何重新加载iframe中的jsp页面?
- 页面运行后自可最大化,没有上面和下面的状态栏
- 在网页初始时不能读取层(div)的pixelLeft和pixelTop属性!
- 这个搜索框如何自适应手机
- 前辈们:偶准备学正则表达式,求一些练手的例子
- 表单提交时的问题:<form name="load" method="POST" action="test.jsp" enctype="multipart/form-data">
.text1{border:0px}
</style>
<BODY>
<script language="Javascript">
function AtoB(dm1,dm2)
{//这个函数用于给表格2添加行和元素
var oTR=tableB.insertRow(tableB.rows.length);
oTR.attachEvent("ondblclick",new Function('delB()'))
tmpNum=oTR.rowIndex;//这个是每行的编号值
oTR.bgColor="#FFFFFF";
oTD=oTR.insertCell(0); oTD.innerHTML="<input type='text' size=20 value='"+dm1+"' class='text1' name='dm1_"+tmpNum+"'>";
oTD=oTR.insertCell(1);
oTD.innerHTML="<input type='text' size=20 value='"+dm2+"' class='text1' name='dm2_"+tmpNum+"'>";
oTD=oTR.insertCell(2);
oTD.innerHTML=tmpNum;
disableA(dm2)
}
function disableA(dm2)
{
for(var i = 0; i<tableA.rows.length; i++)
{
if(tableA.rows[i].cells[1].innerText == dm2)
{
tableA.rows[i].bgColor = "#E4F2F3";
tableA.rows[i].cells[2].firstChild.disabled="true";
}
}
}
function enableA(dm2)
{
for(var i = 0; i<tableA.rows.length; i++)
{
if(tableA.rows[i].cells[1].innerText == dm2)
{
tableA.rows[i].bgColor = "#FFFFFF";
tableA.rows[i].cells[2].firstChild.disabled="";
}
}
}function delB()
{
var oTR;
for(oTR=event.srcElement;oTR.tagName!="TR";oTR=oTR.parentNode){}
var dm2 = oTR.cells[1].firstChild.value;
enableA(dm2)
tableB.deleteRow(oTR.rowIndex);
}
</script>
<table id="tableA" cellpadding="0" cellspacing="1" border="0" bgcolor="#003300">
<tr bgcolor="#FFFFFF">
<td>20040001</td>
<td>1</td>
<td align="center"><input name="button" type="button" onClick="AtoB('20040001','1')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040001</td>
<td>2</td>
<td width="100" align="center"><input name="button" type="button" onClick="AtoB('20040001','2')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040001</td>
<td>3</td>
<td align="center"><input name="button2" type="button" onClick="AtoB('20040001','3')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040002</td>
<td>1</td>
<td align="center"><input name="button22" type="button" onClick="AtoB('20040002','1')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040002</td>
<td>2</td>
<td align="center"><input name="button23" type="button" onClick="AtoB('20040002','2')" value="添加"></td>
</tr></table>
<hr>
<form action="xx.asp" method="post">
<table id="tableB" cellpadding="0" cellspacing="1" border="0" bgcolor="#003300" width="500">
<tr height="20" bgcolor="#FFFFFF">
<td align="center">Dm1</td>
<td align="center">Dm2</td>
<td align="center" width="40">编号</td>
</tr>
</table>
<input type="submit" value="提交">
</form>
==============================<%
dim dm1,dm2,sql
dm1 = request("dm1")
dm2 = request("dm2")
dm1 = split(dm1,",")
dm2 = split(dm2,",")
for i = lbound(dm1) to ubound(dm1)
sql = "insert into B(DM1,DM2) values('" & trim(dm1(i)) & "','" & trim(dm2(i)) & "')"
response.write sql & "<br>"
next
%>
请看一下
<html>
<head>
<%Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open "database","sa","password"
dim dm1,dm2,sql
dm1 = request("dm1")
dm2 = request("dm2")
dm1 = split(dm1,",")
dm2 = split(dm2,",")
for i = lbound(dm1) to ubound(dm1)
sql = "insert into B(DM1,DM2) values('" & rtrim(dm1(i)) & "','" & rtrim(dm2(i)) & "')"
set rs=conn.execute(sql)
next
%>
</head>
<body>
添加成功
</body>
</html>
oTD.innerHTML="<input type='text' size=20 value='"+dm1+"' class='text1' name='dm1'>";
oTD=oTR.insertCell(1);
oTD.innerHTML="<input type='text' size=20 value='"+dm2+"' class='text1' name='dm2'>";=======================================<style>
.text1{border:0px}
</style>
<BODY>
<script language="Javascript">
function AtoB(dm1,dm2)
{//这个函数用于给表格2添加行和元素
var oTR=tableB.insertRow(tableB.rows.length);
oTR.attachEvent("ondblclick",new Function('delB()'))
tmpNum=oTR.rowIndex;//这个是每行的编号值
oTR.bgColor="#FFFFFF";
oTD=oTR.insertCell(0); oTD.innerHTML="<input type='text' size=20 value='"+dm1+"' class='text1' name='dm1'>";
oTD=oTR.insertCell(1);
oTD.innerHTML="<input type='text' size=20 value='"+dm2+"' class='text1' name='dm2'>";
oTD=oTR.insertCell(2);
oTD.innerHTML=tmpNum;
disableA(dm1)
}
function disableA(dm1)
{
for(var i = 0; i<tableA.rows.length; i++)
{
if(tableA.rows[i].cells[0].innerText == dm1)
{
tableA.rows[i].bgColor = "#E4F2F3";
tableA.rows[i].cells[2].firstChild.disabled="true";
}
}
}
function enableA(dm1)
{
for(var i = 0; i<tableA.rows.length; i++)
{
if(tableA.rows[i].cells[0].innerText == dm1)
{
tableA.rows[i].bgColor = "#FFFFFF";
tableA.rows[i].cells[2].firstChild.disabled="";
}
}
}function delB()
{
var oTR;
for(oTR=event.srcElement;oTR.tagName!="TR";oTR=oTR.parentNode){}
var dm1 = oTR.cells[0].firstChild.value;
enableA(dm1)
tableB.deleteRow(oTR.rowIndex);
}
</script>
<table id="tableA" cellpadding="0" cellspacing="1" border="0" bgcolor="#003300">
<tr bgcolor="#FFFFFF">
<td>20040001</td>
<td>1</td>
<td align="center"><input name="button" type="button" onClick="AtoB('20040001','1')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040001</td>
<td>2</td>
<td width="100" align="center"><input name="button" type="button" onClick="AtoB('20040001','2')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040001</td>
<td>3</td>
<td align="center"><input name="button2" type="button" onClick="AtoB('20040001','3')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040002</td>
<td>1</td>
<td align="center"><input name="button22" type="button" onClick="AtoB('20040002','1')" value="添加"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td>20040002</td>
<td>2</td>
<td align="center"><input name="button23" type="button" onClick="AtoB('20040002','2')" value="添加"></td>
</tr></table>
<hr>
<form action="xx.asp" method="post">
<table id="tableB" cellpadding="0" cellspacing="1" border="0" bgcolor="#003300" width="500">
<tr height="20" bgcolor="#FFFFFF">
<td align="center">Dm1</td>
<td align="center">Dm2</td>
<td align="center" width="40">编号</td>
</tr>
</table>
<input type="submit" value="提交">
</form>
请到下列地方领奖:
http://expert.csdn.net/Expert/topic/2650/2650391.xml?temp=.3773767
http://expert.csdn.net/Expert/topic/2648/2648454.xml?temp=.2847406
谢幕。(此希望置顶)