asp conndb
来源:互联网 发布:docker pull centos 编辑:程序博客网 时间:2024/06/05 01:09
<%
Dim DBpath,ConnStr,Conn
DBpath =DBpath & "xxxxxxx.mdb" '数据库
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath(DBPath)
On Error Resume Next 'ニテエ﨔ヲタ昕フミ・
set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConnStr
'=====================
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "<p> </p><p align='center'>ハセンソ簔ャスモウ惞ャヌ・・鮹エスモツキセカコヘハセンソ篥﨤ニ」。</p>"
Response.End
End If
'======================
On Error GoTo 0
sub CloseConnDB()
Conn.Close
set conn=nothing '关闭连接
end sub
%>
<%
'=================================================
'ケウフテ訒コShowUserLogin
'权限制限简单思路设计
'イホ ハ」コボ call ShowUserLogin()
'=================================================
sub ShowUserLogin()
dim strLogin
If Session("UserName")="" Then
strLogin= "<table width='100%' border='0' cellspacing='0' cellpadding='0'>"
strLogin=strLogin & "<form action='UserLogin.asp' method='post' name='UserLogin' onSubmit='return CheckForm();'>"
strLogin=strLogin & "<tr><td height='25' align='right'>モテサァテ訒コ</td><td height='25'><input name='UserName' type='text' id='UserName' size='10' maxlength='20'></td></tr>"
strLogin=strLogin & "<tr><td height='25' align='right'>テワ ツ・コ</td><td height='25'><input name='Password' type='password' id='Password' size='10' maxlength='20'></td></tr>"
strLogin=strLogin & "<tr align='center'><td height='25' colspan='2'><input name='Login' type='submit' id='Login' value=' オヌツシ '> <input name='Reset' type='reset' id='Reset' value=' ヌ蟲 '>"
strLogin=strLogin & "</td></tr>"
strLogin=strLogin & "<tr><td height='20' align='center' colspan='2'><a href='UserReg.asp' target='_blank'>ミツモテサァラ「イ・/a> <a href='GetPassword.asp' target='_blank'>ヘ・ヌテワツ・ソ</a></td></tr>"
strLogin=strLogin & "<tr><td height='20' align='center' colspan='2'><a href='zy.asp?id=7' target='_blank'>サ瞞アマ桄ワネィタ・/a></td></tr>"
strLogin=strLogin & "</form></table>"
response.write strLogin
%>
<script language=javascript>
function CheckForm()
{
if(document.UserLogin.UserName.value=="")
{
alert("ヌ・菠・テサァテ訒。");
document.UserLogin.UserName.focus();
return false;
}
if(document.UserLogin.Password.value == "")
{
alert("ヌ・菠・ワツ・。");
document.UserLogin.Password.focus();
return false;
}
}
</script>
<%
Else
'===========================================Hardhearted Gunner=============================================================================
set rq=server.createobject("adodb.recordset")
sqlaa="select * from [user] where UserName='"&session("UserName")&"'"
rq.open sqlaa,conn,1,1
if not rq.eof then
uid=rq("LockUser")
set rq=nothing
select case uid
case "1"
info="サカモュミツラ「イ盻瞞ア!"
case "2"
info="サカモュニユヘィサ瞞ア!"
end select
end if
'===============================================End============================================================================
response.write"<br><center><strong>" &info & "</strong></center><br><center><font color=red size=4>"&Session("UserName") & "</font></center><br><br>"
response.write "<center><a href='UserLogout.asp'><b>ヘヒウヌツシ</b></a></center><br><br>"
end if
end sub
'=================================================
'ケウフテ訒コShowUserLogina
'ラ・ モテ」コマヤハセモテサァオヌツシア昉・
'イホ ハ」コボ
'=================================================
%>
<style type="text/css">
<!--CSS-->
</style>
- asp conndb
- connDB
- ConnDB小例子
- JDBC-数据库连接类ConnDB
- 数据库连接及操作类 ConnDB
- ASP
- asp
- ASP
- asp
- asp
- asp
- asp
- ASP
- asp
- asp
- asp
- asp
- asp
- 한국어테스트
- Google和百度搜索引擎的网页收录习惯
- 如何使用SetTimer
- Java中的构造器(构造方法)的调用
- EJB 最佳实践: 工业强度的 JNDI 优化
- asp conndb
- 有关 int main(int argc, char* argv[])
- 使用Dom4j构造XML入门实例
- c++笔试题汇总 (转)
- 一次小小的上传文件测试
- 很搞,但是我笑不出来
- Java关键字final、static使用总结(2)
- wxPython的事件处理过程详解
- ORA-12560: TNS: 协议适配器错误解决