📄 database_setup_creater.asp
字号:
<!--#include file="config.asp"-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>数据库初始化数据</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK rel="stylesheet" type="text/css" href="../style.css">
</head>
<body>
/**************************************/<br>
/* 请建立数据库结构后导入以下初始数据 */<br>
/**************************************/<br>
/* 用户表 */<br>
insert into Employee(LoginName,Password,Employee_Name) values('Admin','123','系统管理员')<br>
<%
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.open connstr
sql = "select * from System_Application order by Application_ID"
set rs = conn.execute(sql)
'权限表
response.write "/* 权限表 */<br>"
while not rs.eof
response.write "insert into System_Application(Application_ID,Application_Name,Father_ID) values(" & rs(0) & ",'" & rs(1) & "'," & rs(2) & ")<br>"
rs.movenext
wend
rs.close
set rs = nothing
conn.close
set conn = nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -