Building an In-Text Advertising System Under ASP.NET 3.5 - Procedures
(Page 5 of 5 )
Finally, let's take a quick look at the stored procedures used in this system.
Stored Procedure Definitions
In the ad.mdf database in our system, we've only defined one stored procedure nameduserlogin. For simplicity, we've merged the website owner related registration and login into one module. In detail, when the website owners enter their accounts and passwords, then their accounts will be checked out. If the account already exists in the database, then the user will be allowed to log in; otherwise, this account will be registered.
So, as you've seen, the above functions mainly rest upon the userlogin stored procedure. The following gives its related script code:
/*return 1, if register successfully; return 2, if login successfully;return 3, if the password is invalid*/
ALTER PROCEDURE userLogin
(
@username nvarchar(50),
@userpass nvarchar(100)
)
AS
declare @pass nvarchar(100)
set @pass='0'
select @pass=userpass from siteuser where username=@username/*query the password*/
if @@rowCount=0 begin/*not found the account, then add it*/
insert into siteuser(username,userpass)values(@username,@userpass)
return 1
end
else if @pass=@userpass /* the password is correct, and login successfully*/
begin
return 2
end
else return 3/*the password is invalid*/
Since we've provided detailed explanations between the lines, it's unnecessary to waste any more words here.
-DOWNLOAD SOURCE-
Summary
In this installment, we first explained the concept of in-text advertising, and then learned the general requirements of the sample system we will develop. Next, we introduced the architecture of the whole sample system. Lastly, we gave detailed explanations for each of the tables defined in the sample database ad.mdf.
As you've probably figured out, the in-text advertising system is surely an interesting and useful application. In the next installment, we'll start to delve into core code programming.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 2 
