update.asp

来自「用ASP开发的网络考试系统」· ASP 代码 · 共 28 行

<!--#include file="conn.asp"-->
<%
conn.execute("alter table config add locked bit")
conn.execute("alter table config add gonggao text")
conn.execute("alter table config add todaydate datetime")
conn.execute("alter table config add todaytimes int")
conn.execute("alter table config add times int")
conn.execute("update config set locked=false,todaydate=2003/5/1,todaytimes=0,times=0 where true")
conn.execute("alter table main add title char(50)")
conn.execute("alter table main add type char(10)")
conn.execute("update main set title='无',type='课件' where true")
conn.execute("alter table teacher add email char(30)")
conn.execute("alter table teacher add address char(50)")
conn.execute("alter table teacher add photourl char(50)")
conn.execute("alter table teacher add homepage char(50)")
conn.execute("alter table teacher add qq char(10)")
conn.execute("alter table teacher add intro text")
conn.execute("create table type (id int IDENTITY (1, 1) NOT NULL PRIMARY KEY,type char(10))")
conn.execute("insert into type (type) values('课件')")
conn.execute("drop table fenlei1")
conn.execute("drop table fenlei2")
conn.close
set conn = nothing
%>
<script language="javascript">
alert('升级成功，请立即删除本升级文件');
location.replace('index.asp');
</script>