📄 createnewtable.asp
字号:
<html>
<head>
<title>SmartCity 远程数据库管理系统</title>
<link rel="stylesheet" type="text/css" href="data/css.css">
</head>
<body background="data/background.gif" bgproperties=fixed>
<table width="100%" align="center">
<tr>
<td align="center">
<b><font size="5">SmartCity 远程数据库管理系统</font><br><font size="4">Version 1.0 beta</font><br><br></b>
</td>
</tr>
<tr>
<td align="center">
<div style="width: 740;">
<table width="100%">
<tr>
<td align="center" width="80"><a href="index.asp">重选数据库</a></td>
<td align="center" width="70"><a href="tablelist.asp">数据库列表</a></td>
<td align="center" width="70"><a href="creatnewtable.asp">新建表格</a></td>
<td></td>
<td align="center" width="50"><a href="changepsw.asp">修改密码</a></td>
<td align="center" width="45"><a href="tablelist.asp">返回</a></td>
</tr>
</table>
</div>
<br>
</td>
</tr>
<tr>
<td>
请按照步骤进行设置，如果表格含有多个字段，可重复设置<font color="red">Step2</font>
<br><br>
</td>
</tr>
<tr>
<td>
<table class="line" width="100%">
<tr>
<td class="line" width="60" valign="top"><font color="red">Step1</font></td>
<td class="line">
<form action="gettablename.asp" method="post">
表名 <input type="text" name="tablename" class="txt" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'" value=<%=session("tablename")%>>
<input type="submit" value="保存" class="btn" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'">
</form>
</td>
</tr>
<tr>
<td class="line" width="60" valign="top"><font color="red">Step2</font></td>
<td class="line">
<form action="getfield.asp" method="post">
字段名 <input type="text" name="fieldname" class="txt" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'" value=<%=session("fieldname")%>>
类型 <select name="fieldtype">
<option value="text" selected>文本</option>
<option value="int">整数</option>
<option value="bit">逻辑</option>
<option value="date">日期/时间</option>
<option value="memo">备注</option>
</select><br><br>
如果是<font color="red">文本</font>类型请输入字符个数 <input type="text" name="charnum" size="6" class="txt" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'" value=<%=session("charnum")%>>
<input type="submit" value="保存" class="btn" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'"> （此步骤可重复设置）
</form>
</td>
</tr>
<tr>
<td class="line" width="60" valign="top"><font color="red">Step3</font></td>
<td class="line">
<form action="getprimarykey.asp" method="post">
主键字段名 <input type="text" name="primarykey" class="txt" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'" value=<%=session("primarykey")%>>
<input type="submit" value="保存" class="btn" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'">
</form>
</td>
</tr>
<tr>
<td><br><br></td>
<td>
<input type="button" value="开始创建" class="btn" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'" onclick="javascript:location.href='createtable.asp'">
<input type="button" value="清除" class="btn" onmouseover="this.style.color='FF9966'" onmouseout="this.style.color='#4B69D8'" onclick="javascript:location.href='clear.asp'">
</td>
</tr>
</table>
<%
if request("error") = 1 then
response.write "创建错误：表名不能为空！<br>"
end if
if request("error") = 2 then
response.write "创建错误：字段名不能为空！<br>"
end if
if request("error") = 3 then
response.write "创建错误：文本类型字符个数不能为空！<br>"
end if
if request("error") = 4 then
response.write "创建错误：主键不能为空！<br>"
end if
%>
<br><br><br>
</td>
</tr>
<tr>
<td align="center">
小城工作室作品 2003.9<br>
欢迎访问<a href="http://218.4.50.118/smartcity">『SmartCity 小城在线』</a>
</td>
</tr>
</talbe>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -