给您一段程序参考:
<script language="javascript">
<!--
function del()
{
if (confirm("您确认删除这些记录么?")) {
document.listform.submit() ; }
}
function add()
{
if ( document.addform.password1.value != document.addform.password2.value )
{alert("两次输入口令不对!")}
else if (confirm("您确认增加这条记录么?")) {
document.addform.submit(); }
}
//-->
</script>
<%
if trim(Request.Form("decidedel")) = "decidedel" then
set conn = server.CreateObject("adodb.connection")
conn.Open session("dsn"),session("sqllogin_1"),session("sqlpassword_1")
for m=1 to session("recordcount")
if trim(Request.Form("check"&m))<> "" then
delsql= "delete tmanager where managerid='"&Request.Form("check"&m)&"'"
conn.Execute delsql,0,1
end if
next
end if
'Response.Write Request.Form("loginname")
if trim(Request.Form("decideadd")) = "decideadd" then
'Response.Write "aaaa"
set conn = server.CreateObject("adodb.connection")
conn.Open session("dsn"),session("sqllogin_1"),session("sqlpassword_1")
set conn1 = server.CreateObject("adodb.connection")
conn1.Open session("dsn"),session("sqllogin_1"),session("sqlpassword_1")
findsql1 = "select * from tmanager where login='"&replace(Request.Form("loginname"),"'","“")&"'"
' Response.Write findsql1
set findrs1 = server.CreateObject("adodb.recordset")
findrs1.Open findsql1,conn1,1
if findrs1.RecordCount = 1 then
%>
<script language='javascript'>
<!--
window.history.back();
alert("管理人员名称重复,请另输入一个!");
-->
</script>
<%
findrs1 = nothing
conn1 = nothing
else
addsql = " insert into tmanager (login,password,class)values('"&replace(trim(Request.Form("loginname")),"'","“")&"','"&replace(trim(Request.Form("password1")),"'","“")&"','"&replace(trim(Request.Form("class")),"'","“")&"') "
'Response.Write addsql
conn.Execute addsql,0,1
end if
end if
set conn = server.CreateObject("adodb.connection")
conn.Open session("dsn"),session("sqllogin_1"),session("sqlpassword_1")
sql = "select * from tmanager "
set rs=server.CreateObject("adodb.recordset")
rs.Open sql,conn,1
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY bgcolor=#F0E68C>