📄 admin_db.asp
字号:
sSqlString = "CREATE TABLE ["+sObjName+"] ( \n"
+ "ID int IDENTITY(1,1) PRIMARY KEY CLUSTERED \n"
+ ")"
oFormSql.sTblName.value = sObjName;
oFormSql.sTblType.value = "TABLE";
oFormSql.sSqlString.value = sSqlString;
if(!confirm("你确认要新建 "+sObjName+' 表吗？')) break;
oFormSql.submit();
}
break;
case "设计":
if(!sObjName){alert("请选择对象"); return false;}
sSqlString = "SELECT * FROM [" + sObjName + "]";
oFormSql.sTblName.value = sObjName;
oFormSql.sTblType.value = sObjType;
//oFormSql.sSqlString.value = sSqlString;
oFormSql.sSqlString.value = "";
oFormSql.sOper.value = "Design";
oFormSql.submit();
break;
case "显示所有对象" :
oFormSql.sOper.value = "";
oFormSql.sSqlString.value = "";
oFormSql.sTblName.value = "";
oFormSql.sTblType.value = "";
oFormSql.submit();
break;
case "清空" :
if(sObjType!="TABLE"){alert("你不能清空该对象。");break;}
oFormSql.sOper.value = "";
oFormSql.sSqlString.value = "DELETE * FROM ["+sObjName+"]";
oFormSql.sTblName.value = sObjName;
oFormSql.sTblType.value = sObjType;
if(!confirm("你确认要清空 "+sObjName+' 表吗？')) break;
oFormSql.submit();
break;
case "新建查询" :
sTblName = prompt("请输入查询名称：","")
while(!checkInput(sTblName)){alert('名称中包含非法字符，请重新输入');sTblName = prompt("请输入表名",'');}
if(!sTblName) return false;
sSqlString = "CREATE VIEW ["+sTblName+"] \nAS \n"
oFormSql.sSqlString.value = sSqlString;
alert("请在SQL框里将语句填写完整。");
oFormSql.sSqlString.focus();
}
}
function showFieldType(o){
var oDivType = getObjByID("divFieldType");
var oFieldType = getObjByID("selFieldType");
if(!o){if(oDivType) oDivType.style.display='none'; return;}
if(!oFieldType) return;
window.currElement = o;
oFieldType.value = o.value;
oDivType.style.top = event.y + document.body.scrollTop - event.offsetY -4 ;
oDivType.style.left = event.x + document.body.scrollLeft - event.offsetX -4 ;
oDivType.style.display="";
oFieldType.focus();
}
function checkFieldType(s,i){
if(window.currElement){
window.currElement.value = s;
if(i) window.currElement.form.fieldSize.value = "";
}
}
function showDetial(o){
if(!o) return;
var iSW = parseInt(screen.AvailWidth);
var iSH = parseInt(screen.AvailHeight);
iW = 300;
iH = 100;
var newWin = open('about:blank','','width='+iW+',height='+iH+',top='+((iSH/2)-(iH/2))+',left='+((iSW/2)-(iW/2)));
newWin.document.title = CCNS_program + " - Detial Page ";
newWin.document.body.innerHTML = o.title;
}
function doOper(o,sTblName){
var iSW = parseInt(screen.AvailWidth);
var iSH = parseInt(screen.AvailHeight);
iW = 520;
iH = 260;
var oFormSql = getObjByID("formSQL");
var sSqlString = "";
switch(o.value){
case "新增" :
var newWin = open('about:blank','','width='+iW+',height='+iH+',top='+((iSH/2)-(iH/2))+',left='+((iSW/2)-(iW/2)));
newWin.document.write(sNewFieldString.replace(/\[table name\]/g,sTblName));
newWin.document.title = CCNS_program + " - New Field ";
break;
case "删除" :
sSqlString = "ALTER TABLE [" + sTblName + "] \n"
+ " DROP COLUMN [" + o.form.fieldName.value + "]";
oFormSql.sSqlString.value = sSqlString;
if(!confirm("确认要删除“"+o.form.fieldName.value+"”列吗？")) return false;
oFormSql.sOper.value = "Design";
oFormSql.submit();
break;
case "修改" :
sSqlString = "ALTER TABLE [" + sTblName + "] \n"
+ " ALTER COLUMN [" + o.form.fieldName.value + "] "
+ o.form.fieldType.value + " "
+ (o.form.fieldSize.value.length?"("+o.form.fieldSize.value+")":"") + " "
+ (o.form.fieldNull.checked?"NULL":"NOT NULL");
oFormSql.sSqlString.value = sSqlString;
if(!confirm("确认要修改“"+o.form.fieldName.value+"”列吗？")) return false;
oFormSql.sOper.value = "Design";
oFormSql.submit();
break;
case "新记录" :
iW = 600;
iH = 480;
var newWin = open('about:blank','','scrollbars=yes,width='+iW+',height='+iH+',top='+((iSH/2)-(iH/2))+',left='+((iSW/2)-(iW/2)));
newWin.document.write(sNewRecString);
newWin.document.title = CCNS_program + " - New Record ";
break;
case "删" :
if(o.tblName.length<1||o.sCondition.length<1){alert("条件不正确，不能删除。");return false;}
sSqlString = "DELETE * FROM ["+o.tblName+"] WHERE "+o.sCondition;
oFormSql.sSqlString.value = sSqlString;
if(!confirm("确认要删除吗？")) return false;
oFormSql.submit();
break;
}
}
function changePage(o,i){
var oFormSql = getObjByID("formSQL");
switch(i){
case 0 :
oFormSql.PageNo.value = o.form.gotoPage.value;
break;
case 1 :
oFormSql.PageNo.value = 1;
break;
case 2 :
oFormSql.PageNo.value = parseInt(o.form.PageNo.value)-1;
break;
case 3 :
oFormSql.PageNo.value = parseInt(o.form.PageNo.value)+1;
break;
case 4 :
oFormSql.PageNo.value = 9999;
break;
}
oFormSql.submit();
}
function doNewRec(o){
var sSqlString = "INSERT INTO ["+o.tblName.value+"] ("
for(var i=0;i<o.length;i++){
if(o[i].type!="hidden"&&o[i].type!="submit"){
sSqlString += "[" + o[i].name + "], "
}
}
sSqlString = sSqlString.substr(0,sSqlString.length-2) + ") VALUES("
for(var i=0;i<o.length;i++){
if(o[i].type!="hidden"&&o[i].type!="submit"){
sSqlString += "'" + o[i].value + "', ";
}
}
sSqlString = sSqlString.substr(0,sSqlString.length-2) + ") "
var oFormSQL = window.opener.getObjByID("formSQL");
oFormSQL.sSqlString.value = sSqlString;
if(!confirm("确认提交吗？")) return false;
oFormSQL.submit();
}
function clearSubmitForm(o){
var oFormSQL = getObjByID("formSQL");
oFormSQL.sTblName.value = "";
oFormSQL.sTblType.value = "";
oFormSQL.sOper.value = "";
}
function doSelField(o){
var bSelect = false;
var oFormSQL = getObjByID("formSQL");
var oForm = o;
var sSqlString = "SELECT "
for(var i=0;i<oForm.fieldName.length;i++){
if(oForm.fieldName[i].checked){
sSqlString += "[" + oForm.fieldName[i].value + "],";
bSelect = true;
}
}
sSqlString = sSqlString.substr(0,sSqlString.length-1);
if(!bSelect) sSqlString += " *";
sSqlString += (" FROM " + "[" + oForm.sTblName.value + "] ");
if(oForm.orderField.selectedIndex>0){
sSqlString += "ORDER BY [" + oForm.orderField[oForm.orderField.selectedIndex].value + "]";
sSqlString += " " + oForm.orderBy[oForm.orderBy.selectedIndex].value;
}
oFormSQL.sSqlString.value = sSqlString;
oFormSQL.submit();
}
function checkInput(s){
if(s.indexOf('"')>=0||s.indexOf(' ')>=0)
return false;
return true;
}
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<div id="divFieldType" style="position:absolute; left:6px; top:10px; z-index:99;display:none">
<select id="selFieldType" onChange="checkFieldType(this.value,this[this.selectedIndex].sLength)" onBlur='showFieldType(0)' style="width:130">
<OPTION value=TinyInt sLength=1>TinyInt
<OPTION value=SmallInt sLength=1>SmallInt
<OPTION value=Int sLength=1>Int
<OPTION value=BigInt sLength=1>BigInt
<OPTION value=Real sLength=1>Real / Single
<OPTION value=Float sLength=1>Float / Double
<OPTION value=Money sLength=1>Money
<OPTION value=Decimal sLength=1>Decimal
<OPTION value=Numeric sLength=1>Numeric
<OPTION value=Bit sLength=1>Bit
<OPTION value=Variant>Variant
<OPTION value=UniqueIdentifier sLength=1>UniqueIdentifier
<OPTION value=DateTime sLength=1>DateTime
<OPTION value=Char>Char
<OPTION value=VarChar>VarChar
<OPTION value=Text sLength=1>Text
<OPTION value=nChar>nChar
<OPTION value=nVarChar>nVarChar
<OPTION value=nText sLength=1>nText
<OPTION value=TimeStamp sLength=1>TimeStamp
<OPTION value=VarBinary sLength=1>VarBinary
<OPTION value=Image sLength=1>Image
<!--
<OPTION value=DBDate>DBDate
<OPTION value=DBTime>DBTime
<OPTION value=BSTR>BSTR
<OPTION value=Chapter>Chapter
<OPTION value=FileTime>FileTime
<OPTION value=PropVariant>PropVariant
<OPTION value=VarNumeric>VarNumeric
<OPTION value=Array>Array
<OPTION value=UnsignedTinyInt sLength=>UnsignedTinyInt
<OPTION value=UnsignedSmallInt sLength=>UnsignedSmallInt
<OPTION value=UnsignedInt sLength=>UnsignedInt
<OPTION value=UnsignedBigInt sLength=>UnsignedBigInt
<OPTION value=IDispatch>IDispatch
<OPTION value=IUnknown>IUnknown
<OPTION value=Error>Error
<OPTION value=UserDefined>UserDefined
<OPTION value=Empty>Empty
-->
</select>
</div>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor=E9E7EB class=3d height=30>
<form method="post" name="formLink" id="formLink">
<tr>
<td>
<div id="divLink">
连接数据库类型
<select name="sDbType" size="1" id="sDbType">
<option value="ACCESS" selected>ACCESS</option>
<option value="MSSQL">SQLServer</option>
</select>
<div style="display:none">
连接类型
<select name="sConnType" size="1" id="sConnType">
<option value="ODBC">ODBC</option>
<option value="OLEDB" selected>OLEDB</option>
</select>
</div>
位置
<input name="sDbPath" type="text" id="sDbPath" size="12" class=jinzhe>
<span title="输入SQLSERVER的库，Access不需填写">
SQL库
<input name="sDbName" type="text" id="sDbName" size="10" class=jinzhe>
</span>
用户名
<input name="sUID" type="text" id="sUID" size="8" class=jinzhe>
密码
<input name="sPWD" type="password" id="sPWD" size="8" class=jinzhe>
<input type="submit" name="Submit" value="连 接" class=button>
</div>
<div id="divLinked" style="display:none">
<input type="text" name="sConnString" style="width:600" readonly="true">
<input type="button" name="Reset" value="重新连接" onClick="location.href='<%=Request.ServerVariables("URL")%>'" class=button>
</div>
</td>
</tr>
</form>
</table>
<script language="JavaScript">
var oFormLink = getObjByID("formLink");
<% If Request.ServerVariables("REQUEST_METHOD")="POST" Then %>
oFormLink.sDbType.value = "<%=String4Js(Request("sDbType"))%>";
oFormLink.sConnType.value = "<%=String4Js(Request("sConnType"))%>";
oFormLink.sDbPath.value = "<%=String4Js(Request("sDbPath"))%>";
oFormLink.sDbName.value = "<%=String4Js(Request("sDbName"))%>";
oFormLink.sUID.value = "<%=String4Js(Request("sUID"))%>";
oFormLink.sPWD.value = "<%=String4Js(Request("sPWD"))%>";
var oDivLink = getObjByID("divLink");
var oDivLinked = getObjByID("divLinked");
<% If Len(CCDbT.GetLastError)>0 Or CCDbT.isActive=true Then %>
oDivLink.style.display = "none";
oDivLinked.style.display = "";
<% Else %>
oDivLink.style.display = "";
oDivLinked.style.display = "none";
<% End If %>
oFormLink.sConnString.value = "<%=String4Js(IIf(Len(CCDbT.GetLastError)<1,CCDbT.ConnString,CCDbT.GetLastError))%>";
<% End If %>
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -