六月婷婷综合激情-六月婷婷综合-六月婷婷在线观看-六月婷婷在线-亚洲黄色在线网站-亚洲黄色在线观看网站

明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！

用asp程序顯示sql數據庫所有表的名稱（帶刪除技巧）

發表時間：2024-05-19 來源：明輝站整理相關軟件相關文章人氣：

[摘要]<% ' Define your sql info here strSQLDSN = "xxxx" strSQLUsername = "sa" strSQLPassword = "" ' This is where ...

<%
' Define your sql info here
strSQLDSN = "xxxx"
strSQLUsername = "sa"
strSQLPassword = ""

' This is where we connect to our sql server
Set adoConn = Server.CreateObject("ADODB.Connection")
ConnectionString = "dsn=" & strSQLDSN & ";uid=" & strSQLUsername & ";pwd=" & strSQLPassword & ""
adoConn.Open ConnectionString
Set adoRS = Server.CreateObject("ADODB.Recordset")

' now we will just difine a couple things
showblank = " "
shownull = "-null-"

If Request.QueryString("action") = "del" Then
Delete_Data
Else
If Request.QueryString("table") <> "" Then
' A table has been selected
Page_Head
Display_Table_Names
If Request.QueryString("msg") = "deleted" Then
Response.Write("<p><br></p>")
Response.Write("<font color=""#FF0000""><b>成功刪除數據</b></font>")
Else
Response.Write("<p><br></p>")
End If
Display_Table_Info
Else
' No table has been selected.
Page_Head
Display_Table_Names
End If
End If

Sub Page_Head
%>
<HTML>
<HEAD>
<TITLE>SQL Viewer</TITLE>
<BODY aLink=#0663bf leftMargin="0" link="#0663bf" topMargin="0" vLink="#0663bf" MARGINHEIGHT="0"

MARGINWIDTH="0">
</HEAD>
<p><br></p>
<%
End Sub

Sub Delete_Data
strSQL = "Delete From " & Request.QueryString("table") & " Where ID='" &

Request.QueryString("id") & "'"
Set adoRS = adoConn.Execute(strSQL)
strURL = "index.asp?table=" & Request.QueryString("table") & "&msg=deleted"
Response.Redirect(strURL)
End Sub

Sub Display_Table_Names
Response.Write("<div align=""center""><center>" & vbCrLf)
Response.Write("" & vbCrLf)
Response.Write("<table border=""1"" cellpadding=""0"" cellspacing=""0"" width=""36%""

bordercolor=""#9b9180"">" & vbCrLf)
Response.Write(" <tr bgColor=""#9b9180"">" & vbCrLf)
Response.Write(" <td width=""100%""><p align=""center""><font

color=""#FFFFFF""><strong>SQL Viewer</strong></font></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr bgColor=""#dcd8d1"">" & vbCrLf)
Response.Write(" <td width=""100%""><div align=""center""><center><table border=""0""

cellpadding=""0""" & vbCrLf)
Response.Write(" cellspacing=""0"" width=""100%"">" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td width=""100%""> </td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td width=""100%"" NOWRAP><center> <select size=""1""

name=""Table"" style=""font-family: Verdana; font-size: 8pt""

onChange=""top.location.href=this.options[this.selectedIndex].value"">" & vbCrLf)
Response.Write(" <option selected value>請選擇表名進行查看.</option>" & vbCrLf)
strSQL = "SELECT name FROM sysobjects WHERE xtype = 'U' AND (Not (id) = 133575514) ORDER

BY name"
Set adoRS = adoConn.Execute(strSQL)
Do While Not adoRS.EOF
Response.Write "<option value=""index.asp?table=" & adoRS("name") & """>" &

adoRS("name") & "</option>"
adoRS.MoveNext
Loop
Response.Write(" </select> </center></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td width=""100%""> </td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" </table>" & vbCrLf)
Response.Write(" </center></div></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write("</table>" & vbCrLf)
Response.Write("</center></div>" & vbCrLf)
End Sub

Sub Display_Table_Info
Response.Write("<div align=""center""><center>" & vbCrLf)
Response.Write("<table border=""1"" cellpadding=""0"" cellspacing=""0"" width=""36%""

bordercolor=""#9b9180"">" & vbCrLf)
Response.Write(" <tr bgColor=""#9b9180"">" & vbCrLf)
Response.Write(" <td width=""100%""><p align=""center""><font

color=""#FFFFFF""><strong>SQL 破戒</strong></font></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr bgColor=""#dcd8d1"">" & vbCrLf)
Response.Write(" <td width=""100%""><div align=""center""><center><table border=""0""

cellpadding=""0""" & vbCrLf)
Response.Write(" cellspacing=""0"" width=""100%"">" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
' This selects the table that we want to use.
strSQL="select * from " & Request.QueryString("table") & ""
set adoRS=adoConn.execute(strSQL)
' Now lets start the table
Response.Write("<table border=""1""><tr>" & vbCrLf)
' this will find all the fields in that table and write them out
FOR EACH fieldname IN adoRS.fields
Response.Write("<td><b><font size=""2"">" & fieldname.name & "</font></B></TD>")
NEXT ' fieldname
Response.Write("<td><b><font size=""2"">刪除</font></B></TD>")
Response.Write(" </tr>" & vbCrLf)
DO UNTIL adoRS.eof
Response.Write("<tr>")
FOR EACH fieldname IN adoRS.fields
strFieldValue=fieldname.value
strField=fieldname.name
IF isnull(strFieldValue) THEN
strFieldValue=shownull
END IF
IF trim(strFieldValue)="" THEN
strFieldValue=showblank
END IF
IF strField = "ID" OR strField = "id" THEN
strRecordID = strFieldValue
END IF
Response.Write("<td valign=top><font size=""2"">" & strFieldValue &

"</font></td>" & vbCrLf)
NEXT
Response.Write("<td valign=top><font size=""2""><a href=""index.asp?table=" &

Request.QueryString("table") & "&id=" & strRecordID & "&action=del"">刪除</a></font></td>" &

vbCrLf)
adoRS.movenext
LOOP
Response.Write("</table>")
adoRS.close
Response.Write(" </tr>" & vbCrLf)
Response.Write(" <tr>" & vbCrLf)
Response.Write(" <td></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write(" </table>" & vbCrLf)
Response.Write(" </center></div></td>" & vbCrLf)
Response.Write(" </tr>" & vbCrLf)
Response.Write("</table>" & vbCrLf)
Response.Write("</center></div>" & vbCrLf)
End Sub
%>



主站蜘蛛池模板： 中文字幕 一区 婷婷 在线 | 日本精品高清一区二区2021 | 四虎4hu永久免费国产精品 | 亚洲一区二区三区免费在线观看 | 亚州免费一级毛片 | 欧美中文字幕 | 又大又硬又粗又爽免费 | 婷婷综合色伊人阁 | 亚洲国产第一页 | 日韩精品一 | 亚洲人成在线观看男人自拍 | 天天操天天干天天爱 | 视频一区精品 | 午夜欧美性视频在线播放 | 中国性欧美 | 最近最新中文字幕免费的一页 | 啪啪国产视频 | 日本一区高清视频 | 伊香蕉大综综综合久久 | 四月激情网 | 亚洲国产一区二区在线 | 色综合久久综精品 | 中国女人一级做受免费视频 | 天天射日| 四虎精品视频在线永久免费观看 | 亚洲最新在线观看 | 日本乳色www| 欧美午夜免费观看福利片 | 色女人久久 | 最新国产在线 | 做受又硬又粗又免费视频 | 日本一区视频 | 天天综合网天天综合色 | 日韩在线小视频 | 青青草人人 | 欧美亚洲综合一区 | 日韩一区二三区国产好的精华液 | 青青青在线网站视频在线 | 午夜欧美精品 | 亚洲图片在线欧美专区图片 | 日本乱人伦片中文字幕三区 |