saveprovince.asp

非常好用的asp网页,有需要的同学可以下载学习,提供完整的代码.

<!--#include file="conn.asp"-->
<!--#include file="session2.asp"-->
<%
dim shengid,shengorder,shengname,shengno,i
if request("action")="update" then
    for i=1 to request.form("shengid").count
	shengid=replace(request.form("shengid")(i),"'","")
	shengorder=replace(request.form("shengorder")(i),"'","")
	shengname=replace(request.form("shengname")(i),"'","")
	shengno=replace(request.form("shengno")(i),"'","")
	if replace(request.form("shengorder")(i),"'","")="" then
%>
<script language=javascript>
history.back()
alert("请填写省的显示排序！")
</script>
<%
		Response.End
	end if
	conn.execute("update province set shengorder="&shengorder&",shengname='"&shengname&"',shengno='"&shengno&"' where id="&shengid)

    next
conn.close
set conn=nothing
response.Write "<script language='javascript'>alert('省设置成功!')</script>"
response.write "<meta http-equiv=""refresh"" content=""0;url=ManageProvince.asp"">"
end if


if request("action")="add" then
	shengno=request.form("shengno")
	shengname=trim(request("shengname"))
	shengorder=request.form("shengorder")
	If shengname="" Then
		response.Write "<script language='javascript'>alert('省名称不能为空！');javascript:history.go(-1);</script>"
		response.end
	end if
	If shengno="" Then
		response.Write "<script language='javascript'>alert('省编号名称不能为空！');javascript:history.go(-1);</script>"
		response.end
	end if
	If shengorder="" Then
		response.Write "<script language='javascript'>alert('排序不能为空!');javascript:history.go(-1);</script>"
		response.end
	end if
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "select * from sh_province",conn,1,3
rs.addnew
rs("shengname")=shengname
rs("shengno")=shengno
rs("shengorder")=shengorder
rs.update
rs.close
set rs=nothing

conn.close
set conn=nothing
response.Write "<script language='javascript'>alert('省添加成功!')</script>"
response.write "<meta http-equiv=""refresh"" content=""0;url=ManageProvince.asp"">"
end if
%>