tools_updatedb-11-9.asp

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

<!--#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 "& db_system_Table &" alter COLUMN L_BG int") 
         'response.write "<DIV align=center>修改字段[E_system]表[L_BG]字段属性为数字！</DIV><BR>"

		 conn.execute("alter table "& db_system_Table &" drop L_BG ")
         conn.execute("alter table "& db_system_Table &" add L_BG int")
         response.write "<DIV align=center>修改字段[E_system]表[L_BG]字段属性为数字！</DIV><BR>"
                                       

        '更新表数据	

		conn.execute("update "& db_system_Table &" Set L_BG=1 where (L_BG is null) ")	
		response.write "<DIV align=center>[L_BG]字段修正成功！</DIV><BR>"

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

end if%>