简单的数据库更新,为什么没有反应?
<table width="47%" border="0" align="center">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td width="16%">月份</td>
<td width="84%"> <input type="text" name="month"> </td>
</tr>
<tr>
<td>77777</td>
<td> <input type="text" name="num1"> </td>
</tr>
<tr>
<td>a</td>
<td> <input type="text" name="num2"> </td>
</tr>
<tr>
<td>b</td>
<td> <input type="text" name="num3"> </td>
</tr>
<tr>
<td>c</td>
<td> <input type="text" name="num4"> </td>
</tr>
<tr>
<td>d</td>
<td> <input type="text" name="num5"> </td>
</tr>
<tr>
<td>e</td>
<td> <input type="text" name="num6"> </td>
</tr>
<tr>
<td>f</td>
<td> <input type="text" name="num7"> </td>
</tr>
<tr>
<td>g</td>
<td> <input type="text" name="num8"> </td>
</tr>
<tr>
<td>h</td>
<td> <input type="text" name="num9"> </td>
</tr>
<tr>
<td>i</td>
<td><input type="text" name="num10"></td>
</tr>
<tr>
<td> </td>
<td><input type=submit name="OK" value="确定" onlick=Add()>
<input type="button" name="Cancle" value="重输"> </td>
</tr>
</table>
<%
sub Main()
Dim dcnDB
Dim rsMes,rsMes1
Dim strMes
Dim select_count,subject_option(11)
Dim i
select_count = 0
Set dcnDB = Server.CreateObject("ADODB.Connection")
dcnDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../jkdata/JKDATA.MDB")
dcnDB.Open
strMes = "Select * From schedule Order by schedule_ID DESC"
Set rsMes = Server.CreateObject("ADODB.RecordSet")
rsMes.Open strMes,dcnDB,3,2
end sub
%>
<%
Sub Add()
rsMes.AddNew
if Request.Form("month") = "" then
rsMes("schedule_month") = 0
else
rsMes("schedule_month") = Request.Form("month")
end if
if Request.Form("num1") = "" then
rsMes("schedule_num1") = 0
else
rsMes("schedule_num1") = Request.Form("num1")
end if
if Request.Form("num2") = "" then
rsMes("schedule_num2") = 0
else
rsMes("schedule_num2") = Request.Form("num2")
end if
if Request.Form("num3") = "" then
rsMes("schedule_num3") = 0
else
rsMes("schedule_num3") = Request.Form("num3")
end if
if Request.Form("num4") = "" then
rsMes("schedule_num4") = 0
else
rsMes("schedule_num4") = Request.Form("num4")
end if
if Request.Form("num5") = "" then
rsMes("schedule_num5") = 0
else
rsMes("schedule_num5") = Request.Form("num5")
end if
if Request.Form("num6") = "" then
rsMes("schedule_num6") = 0
else
rsMes("schedule_num6") = Request.Form("num6")
end if
if Request.Form("num7") = "" then
rsMes("schedule_num7") = 0
else
rsMes("schedule_num7") = Request.Form("num7")
end if
if Request.Form("num8") = "" then
rsMes("schedule_num8") = 0
else
rsMes("schedule_num8") = Request.Form("num8")
end if
if Request.Form("num9") = "" then
rsMes("schedule_num9") = 0
else
rsMes("schedule_num9") = Request.Form("num9")
end if
if Request.Form("num10") = "" then
rsMes("schedule_num10") = 0
else
rsMes("schedule_num10") = Request.Form("num10")
end if
if Request.Form("num11") = "" then
rsMes("schedule_num11") = 0
else
rsMes("schedule_num11") = Request.Form("num11")
end if
rsMes("schedule_date") = Date() & " " & Time()
rsMes.Update
response.write("OK")
end Sub
%>