Asp.net ·ÀֹģÄâHttpÇëÇó
ǰһ¶Îʱ¼ä×öÁËÄ£ÄâHttpÇëÇó£¬ÄÇôÎÒÃÇÓ¦¸ÃÔõô×ö¿ÉÒÔ×èÖ¹Óû§Ä£ÄâHttpÇëÇóÁË£¬ÔÚÕâÀïÍÆ¼öÒ»¸ö·½·¨£º¾ÍÊÇ·ÃÎÊʱ¼ä²îºÍ·ÃÎÊ´ÎÊý¡£ÎÒÃǰÑÊý¾Ý·ÃÎʵÄIP´æ·Åµ½Êý¾Ý¿â£¬ÒÔ±ãÎÒÃÇÒÔºó²é¿´¡£
Ê×ÏȽ¨Á¢Êý¾Ý±íºÍ´æ´¢¹ý³Ì
CREATE TABLE [dbo].[IPAccess](
[IP] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Times] [bigint] NULL,
[State] [bit] NULL,
[LastDataTime] [datetime] NULL,
CONSTRAINT [PK_IPAccess] PRIMARY KEY CLUSTERED
(
[IP] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE PROC GetIpState
(
@IP VARCHAR(50) ,
@TimeCount INT ,
@State BIT OUTPUT
)
AS
BEGIN
DECLARE @count BIGINT
SELECT @count = COUNT(0)
from dbo.IPAccess
WHERE IP = @IP
IF ( @count IS NULL
OR @count = 0
)
BEGIN
SET @State = 1 ;
INSERT dbo.IPAccess
( IP, Times, State, LastDataTime )
VALUES ( @IP, 1, -- Times - bigint
Ïà¹ØÎĵµ£º
±¾ÏµÁÐÎÄÕÂͨ¹ýÒ»¸öÐéÄâµÄ°¸Àý——¡¶MVC¹«¸æ·¢²¼ÏµÍ³¡·µÄ¿ª·¢¹ý³Ì£¬È«ÃæÕ¹Ê¾ÁËASP.NET MVCµÄ»ù±¾Ê¹Ó÷½·¨£¬Í¬Ê±ÔÚÌÖÂÛÁËÕâ¸ö¿ò¼ÜµÄ»ù±¾ÔÀí¡£
Õâ¸öÎÄÕÂϵÁеÄÄ¿µÄ¾ÍÊÇʹÅóÓÑÃǸüÇáËɵÄÈëÃÅASP.NET MVC¡£
Õâ¸öϵÁлá°üº¬µÄÄÚÈÝÓУºASP.NET ......
WebÒ³ÃæÊÇÎÞ״̬µÄ£¬ ·þÎñÆ÷¶Ôÿһ´ÎÇëÇó¶¼ÈÏΪÀ´×Ô²»Í¬Óû§£¬Òò´Ë£¬±äÁ¿µÄ״̬ÔÚÁ¬Ðø¶ÔÍ¬Ò»Ò³ÃæµÄ¶à´ÎÇëÇóÖ®¼ä»òÔÚÒ³ÃæÌø×ªÊ±²»»á±»±£Áô¡£ÔÚÓÃASP.NET Éè¼Æ¿ª·¢Ò»¸öWebϵͳʱ£¬ Óöµ½Ò»¸öÖØÒªµÄÎÊÌâÊÇÈçºÎ±£Ö¤Êý¾ÝÔÚÒ³Ãæ¼ä½øÐÐÕýÈ·¡¢°²È«ºÍ¸ßЧµØ´«ËÍ£¬Asp.net ÌṩÁË״̬¹ÜÀíµÈ¶àÖÖ¼¼ÊõÀ´½â¾ö±£´æºÍ´« ......
²¿ÃÅÒª×öÒ»¸öÍøÕ¾£¬ÎÒÒÔǰÓõÄÊÇphp»òasp×öµÄ£¬Õâ»ØÏë¸ÄÓÃasp.net×ö£¬Ö÷Òª»ùÓÚÁ½µã¿¼ÂÇ£¬µÚÒ»£ºÏëͨ¹ýasp.netѧϰc#¼°Æä.net¿ò¼Ü¡£µÚ¶þ£º×Ô¼ºÓÖÏë͵ÀÁ£¬²»Ïë´ÓÍ·¿ªÊ¼×öÍøÕ¾£¬ÓÚÊǾÍÏëÓÿªÔ´µÄnetcmsÀ´¸Ä¸Ä¡£ÓÚÊÇÓÐÁËÎÒµÄϵÁÐÎÄÕ¡£¸ù¾ÝÎÒµÄѧϰ½ø¶ÈÎÒ»áÿÌì¸üУ¬ÇëÅóÓÑÃǹØ×¢¡£ ......
[תÌùÒ»]
ʹÓÃASP.NET MVC¿ò¼Ü£¬´´½¨Ä¬ÈÏÏîÄ¿£¬µÚÒ»Ö±¹Û¸Ð¾õ¾ÍÊǵØÖ·¶¼ÊÇRewrite¹ýµÄ¡£¶ÔÔ´ÂëºÍÅäÖÃÎļþÉÔ¼Ó·ÖÎö²»ÄÑ¿´³ö£¬MVCʹÓÃÁËhttpModulesÀ´À¹½ØµØÖ·ÇëÇ󣬾ßÌåÓõ½ÁËSystem.Web.RoutingÀà¿â£¨MVC2ÖУ¬MVC1ÔõôÓõÄÍü¼ÇÁË¡££©¶øÕⲿ·ÖÀà¿â±»°ü×°ÔÚ.NET Framework3.5 SP1ÖУ¬MVC2ÐèÒªSP1Ö§³ÖÒ²¾ÍÀíËùµ±È»ÁË¡£SP1Ìṩµ ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb; //µ¼ÈëÃüÃû¿Õ¼ä
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflection;
using System.Data;
usi ......