<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>動態新增移除表格</title>
</head>
<script language="javascript" src="jquery-1.8.0.js" ></script>
<script language="javascript">
$(document).ready(function()
{
var table=document.getElementById("tb1");
var i=0;
$("#bt1").click(function()
{
$.post("jdata1.jsp",{id:$("#t1").val()},function(data,s)
{
//$("#dv1").html(data);
var tdata=data.split(" ");
var tr=table.insertRow(i);
for(var u=0;u<tdata.length-1;u++)
{
var td=tr.insertCell(u);
td.innerHTML=tdata[u];
}
var ttd=tr.insertCell(5);
ttd.innerHTML="<a herf='javascript:;' onclick='fun(this)'>移除</a>";
i++;
});
});
$("#bt2").click(function()
{
$("#t1").val("");
$("#t1").focus();
});
});
function fun(x)
{
var i=x.parentNode.parentNode.rowIndex;即table
document.getElementById("tb1").deleteRow(i);
}
</script>
<body>
<form id="f1" name="f1" method="post" >
<table width="300" border="2">
<tr>
<td>
輸入編號；
</td>
<td>
<input type="text" id="t1" name="t1" size="20" />
</td>
</tr>
<tr>
<td>
<input type="button" name="bt1" id="bt1" value="確認" />
</td>
<td>
<input type="reset" name="bt2" id="bt2" value="清除" />
</td>
</tr>
</table>
</form>
<p>
<p>
<div id="dv1" style="background-color:#9CF; width:300px; height:100px; overflow:scroll">
<table id="tb1" border="0" width="300">
</table>
</div>
</body>
</html>
jdata1.jsp
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@include file="querydata.jsp"%>
<%
String[][] data=null;
String id=request.getParameter("id");
//String id="p1002";
String databasename="persondata";
String strsql="select * from person where 編號='"+id+"'";
data=querydatafun(databasename,strsql);
String str="";
if(data.length==0)
{
str="查無此資料";
}
else
{
for(int i=0;i<data.length;i++)
{
for(int j=0;j<data[0].length;j++)
{
str+=data[i][j]+" ";//加一空格方便split
}
}
}
out.print(str);
%>
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@include file="querydata.jsp"%>
<%
String[][] data=null;
String id=request.getParameter("id");
//String id="p1002";
String databasename="persondata";
String strsql="select * from person where 編號='"+id+"'";
data=querydatafun(databasename,strsql);
String str="";
if(data.length==0)
{
str="查無此資料";
}
else
{
for(int i=0;i<data.length;i++)
{
for(int j=0;j<data[0].length;j++)
{
str+=data[i][j]+" ";//加一空格方便split
}
}
}
out.print(str);
%>
沒有留言:
張貼留言