Asp與Sql構(gòu)建網(wǎng)站系統(tǒng)中對數(shù)據(jù)庫的各種操作的函數(shù)代碼分享

  StrSql = "Insert Into Users(UsersId, LoginName, UserName, Password)"
   StrSql = StrSql & " Values(" & SqlStr(tUserID) & "," & SqlStr(LoginName) & "," & SqlStr(UserName) & "," & SqlStr(Password) & ")"
   Conn.Execute(StrSql)
  
  
  '//刪除方法
  '//----------------------------(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)
  
  %>