Asp+Sql 对数据库的各种操作
时间:2007-09-22 10:38:00
一.ASP使用SQL查询数据库方法:
方法1
Set RsWorkUserInfo = Server.CreateObject("ADODB.RecordSet")
StrSql = "Select UsersId, LoginName, UserName, Password"
StrSql = StrSql & " From Users"
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
If RsWorkUserInfo.State = 1 Then
RsWorkUserInfo.Close
End If
RsWorkUserInfo.Open StrSql,Conn,1,1
If Not RsWorkUserInfo.Eof Then
LoginName = RsWorkUserInfo("LoginName")
UserName = RsWorkUserInfo("UserName")
Password = RsWorkUserInfo("Password")
End if
RsWorkUserInfo.Close
Set RsWorkUserInfo = Nothing
方法2.
StrSql = "Select UsersId, LoginName, UserName, Password"
StrSql = StrSql & " From Users"
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
Set RsFind = Conn.Execute(StrSql)
If Not RsFind.Eof Then
LoginName = RsFind("LoginName")
UserName = RsFind("UserName")
Password = RsFind("Password")
End if
RsFind.Close
Set RsFind = Nothing
二.SQL修改数据库方法
方法一.
Set RsWorkUserInfo = Server.CreateObject("ADODB.RecordSet")
StrSql = "Select UsersId, LoginName, UserName, Password"
StrSql = StrSql & " From Users"
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
If RsWorkUserInfo.State = 1 Then
RsWorkUserInfo.Close
End If
RsWorkUserInfo.Open StrSql,Conn,1,3
IF Not RsWorkUserInfo.Eof Then
RsWorkUserInfo("LoginName") = LoginName
RsWorkUserInfo("UserName") = UserName
RsWorkUserInfo("Password") = Md5(Password)
RsWorkUserInfo.Update
Update = True
Else
Update = False
End if
RsWorkUserInfo.Close
Set RsWorkUserInfo = Nothing
方法2.
StrSql = "Update Users"
StrSql = StrSql & " Set LoginName=" & SqlStr(LoginName) & ", UserName=" & SqlStr(UserName) & ", Password=" & SqlStr(Password)
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
Conn.Execute(StrSql)
三.添加数据库记录方法
方法一.
Set RsWorkUserInfo = Server.CreateObject("ADODB.RecordSet")
StrSql = "Select UsersId, LoginName, UserName, Password"
StrSql = StrSql & " From Users"
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
If RsWorkUserInfo.State = 1 Then
RsWorkUserInfo.Close
End If
RsWorkUserInfo.Open StrSql,Conn,1,3
If RsWorkUserInfo.Eof Then
RsWorkUserInfo.AddNew
RsWorkUserInfo("UsersID") = tUserId
RsWorkUserInfo("LoginName") = LoginName
RsWorkUserInfo("UserName") = UserName
RsWorkUserInfo("Password") = Md5(Password)
RsWorkUserInfo.Update
NewRecord = True
Else
NewRecord = False
End if
RsWorkUserInfo.Close
Set RsWorkUserInfo = Nothing
方法2.
StrSql = "Insert Into Users(UsersId, LoginName, UserName, Password)"
StrSql = StrSql & " Values(" & SqlStr(tUserID) & "," & SqlStr(LoginName) & "," & SqlStr(UserName) & "," & SqlStr(Password) & ")"
Conn.Execute(StrSql)
四.SQL删除数据库记录方法
方法1.
Set RsWorkUserInfo = Server.CreateObject("ADODB.RecordSet")
StrSql = "Delete From Users"
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
If RsWorkUserInfo.State = 1 Then
RsWorkUserInfo.Close
End If
RsWorkUserInfo.Open StrSql,Conn,1,3
RsWorkUserInfo.Close
Set RsWorkUserInfo = Nothing
方法2.
StrSql = "Delete From Users"
StrSql = StrSql & " Where UsersId=" & SqlStr(tUserID)
Conn.Execute(StrSql)
标签:数据库,SQL
0
投稿
猜你喜欢
解决asp中ADODB.Stream 0x800A0C93 错误
2008-01-08 19:28:00
网页代码中键盘操作相关标签教程
2010-03-18 15:56:00
如何实现固定长度的自动编号?
2010-06-03 10:08:00
隐藏修改文件时间和文件属性的ASP脚本
2011-03-17 11:15:00
两个非常规ASP木马(可躲过扫描)
2011-03-11 10:38:00
最小asp后门程序
2011-04-03 10:35:00
ASP GetRef 函数指针试探
2011-03-16 11:09:00
网页效果图设计之色彩索引
2008-03-23 13:53:00
利用Yahoo Pipes和jQuery做一个RSS挂件
2010-06-08 13:40:00
Dreamweaver2004 中文乱码解决方案
2007-01-31 10:20:00
javascript 的 in 操作符实例详解
2007-10-07 12:00:00
JavaScript文档生成工具
2007-10-26 11:59:00
使IE浏览器支持PNG格式图片的透明效果
2008-02-02 16:20:00
asp查询xml的代码 不刷新页面查询的方法
2011-04-06 11:00:00
十六则Dreamweaver使用快技法
2009-07-05 18:55:00
利用ASP输出excel文件一例
2008-06-06 13:18:00
asp ajax跨域提交数据
2011-04-11 10:56:00
考虑SQL Server安全时所应注意的几个方面
2009-01-04 13:57:00
ASP实现全站的301跳转
2010-03-27 21:45:00
SQL Server中两种修改对象所有者的方法
2009-01-15 13:10:00