database_setup_creater.asp

来自「=== ==ASP销售管理系统」· ASP 代码 · 共 34 行

ASP
34
字号
<!--#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 + =
减小字号Ctrl + -
显示快捷键?