HTML页面提交的值,JAVASCRIPT如何取得,我需要实现JAVASC RIPT操作数据库,表单中提交的内容,插入数据库,现在我不能取到提交后的值,没有后台程序,谢谢
代码如下:
<html>
<head>
<title>表格?示数据表??</title>
</head>
<body>
<h2>表格?示数据表??</h2>
<form name="myform" method="post">
<p>id:
<input id="myname" type="text" name="id">
</p>
<p>comment:
<input id="mycomment" type="text" name="comment">
<input type="submit" onClick="openwindow();" name="Submit" value="Submit">
</p>
</form>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<script language="JavaScript">
var id = document.getElementById("myname").value;
var comment = document.getElementById("mycomment").value;
if(id=null|| id==""){
id="9999999999999999";
comment="gseg99999999999999999999wewew";
}
// ?建数据??象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:/femes.mdb";
// 打?数据源
objdbConn.Open(strdsn);
var sql = "insert into plan (id,comment) values ('"+id+"','"+comment+"') ";
try{
objdbConn.Execute(sql);
}catch(e){
alert(e);
}
// ?行SQL的数据???
var objrs = objdbConn.Execute("SELECT * FROM plan");
// ?取字段数目
var fdCount = objrs.Fields.Count - 1;
// ??是否有??
if (!objrs.EOF){
document.write("<table border=1><tr>");
// ?示数据?的字段名称
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// ?示数据?内容
while (!objrs.EOF){
document.write("<tr>");
// ?示????的字段
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext();
}
document.write("</table>");
}
else
document.write("数据?内没有??!<br>");
objrs.Close();
objdbConn.Close();
</script>
</td>
</tr>
</table>
</body>
</html>
代码如下:
<html>
<head>
<title>表格?示数据表??</title>
</head>
<body>
<h2>表格?示数据表??</h2>
<form name="myform" method="post">
<p>id:
<input id="myname" type="text" name="id">
</p>
<p>comment:
<input id="mycomment" type="text" name="comment">
<input type="submit" onClick="openwindow();" name="Submit" value="Submit">
</p>
</form>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<script language="JavaScript">
var id = document.getElementById("myname").value;
var comment = document.getElementById("mycomment").value;
if(id=null|| id==""){
id="9999999999999999";
comment="gseg99999999999999999999wewew";
}
// ?建数据??象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:/femes.mdb";
// 打?数据源
objdbConn.Open(strdsn);
var sql = "insert into plan (id,comment) values ('"+id+"','"+comment+"') ";
try{
objdbConn.Execute(sql);
}catch(e){
alert(e);
}
// ?行SQL的数据???
var objrs = objdbConn.Execute("SELECT * FROM plan");
// ?取字段数目
var fdCount = objrs.Fields.Count - 1;
// ??是否有??
if (!objrs.EOF){
document.write("<table border=1><tr>");
// ?示数据?的字段名称
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// ?示数据?内容
while (!objrs.EOF){
document.write("<tr>");
// ?示????的字段
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext();
}
document.write("</table>");
}
else
document.write("数据?内没有??!<br>");
objrs.Close();
objdbConn.Close();
</script>
</td>
</tr>
</table>
</body>
</html>
<html>
<head>
<title>表格?示数据表??</title>
</head>
<body>
<table>
<tr>
<td height="100">
<form name="myform" method="post">
your id :<input id="myname" type="text" name="myname"><br>
your message:<input id="comment" type="text" name="comment">
<input type="button" onClick="diplay();" name="Submit" value="Submit">
</form>
</td>
<td>
<script language="JavaScript">
function diplay()
{
var id = document.getElementById("myname").value;
var comment = document.getElementById("comment").value;
// ?建数据??象
var objdbConn = new ActiveXObject("ADODB.Connection");
// DSN字符串
var strdsn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:/femes.mdb";
// 打?数据源
objdbConn.Open(strdsn);
alert(id);alert(comment);
var sql = "insert into plan (id,comment) values ('"+id+"','"+comment+"') ";
try{
objdbConn.Execute(sql);
}catch(e){
alert(e);
}
// ?行SQL的数据???
var objrs = objdbConn.Execute("SELECT * FROM plan");
// ?取字段数目
var fdCount = objrs.Fields.Count - 1;
// ??是否有??
if (!objrs.EOF){
document.write("<p><p><p><p><p><p><p>");
document.write("<table border=1><tr>");
// ?示数据?的字段名称
for (var i=0; i <= fdCount; i++)
document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");
document.write("</tr>");
// ?示数据?内容
while (!objrs.EOF){
document.write("<tr>");
// ?示????的字段
for (i=0; i <= fdCount; i++)
document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");
document.write("</tr>");
objrs.moveNext();
}
document.write("</table>");
}
else
document.write("数据?内没有??!<br>");
objrs.Close();
objdbConn.Close();
}
</script>
</td>
</tr>
</table></body>
</html>