tools_updatedb-11-6.asp

来自「zheng fu wang zhan gong neng qi quan」· ASP 代码 · 共 32 行

<!--#include file=conn.asp -->
<!--#include file="ConnUser.asp"-->
<!--#include file="config.asp"-->
<!--#include file="char.inc"-->
<!--#include file="chkuser.asp" -->
<!--#include file="md5.asp"-->
<!--#include file="ChkURL.asp"-->
<!--#include file="ChkManage.asp"-->
<%
if not(request.cookies(eChuang)("ManageKEY")="super" or request.cookies(eChuang)("ManageKEY")="typemaster" or request.cookies(eChuang)("ManageKEY")="bigmaster") then
	Show_Err("对不起，您的后台管理权限不够操作！")
	response.end
else
	action=request("action")


		'更新表结构
         conn.execute("alter table dep add depnumber int")
         response.write "<DIV align=center>增加[dep]表[depnumber]字段完毕！</DIV><BR>"
                                       

        '更新表数据	

		conn.execute("update "& db_Dep_Table &" Set depnumber=0 where (depnumber is null) ")	
		response.write "<DIV align=center>[dep]表[depnumber]字段修正成功！</DIV><BR>"

		response.write "<DIV align=center>2004-11-6全部更新完成！</DIV><BR>"
		response.end
		conn.close
		set conn=nothing

end if%>