SQLSERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿
SQL SERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿
Ö÷ÒªÏëʵÏÖÒÔÏ£º
Ò»¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬°ÑÓû§µÄÓû§ÃûÓëIP¶¼±£´æÔÚÊý¾Ý¿âÖУ¬À´ÊµÏÖÓû§µÇ¼µÄ¹¦ÄÜ¡£
×îºÃÊÇÓû§µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬°ÑÓû§Ãû×÷²ÎÊý£¬´æ´¢¹ý³Ì¾ÍÄܰÑÓû§µÄÓû§ÃûÓëIP±£´æÏÂÀ´¡£
ÇëÖ¸½Ì£¨Ö»ÓÐ16·ÖÁË£©
SQL code:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_getlinkinfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_getlinkinfo]
GO
/*--»ñÈ¡Á¬½ÓSQL·þÎñÆ÷µÄÐÅÏ¢
ËùÓÐÁ¬½Ó±¾»úµÄ:²Ù×÷µÄÊý¾Ý¿âÃû,¼ÆËã»úÃû,Óû§Ãû,Íø¿¨ÎïÀíµØÖ·,IPµØÖ·,³ÌÐòÃû
--×Þ½¨ 2003.11--*/
/*--µ÷ÓÃʾÀý
--ÏÔʾËùÓб¾»úµÄÁ¬½ÓÐÅÏ¢
exec p_getlinkinfo
--ÏÔʾËùÓб¾»úµÄÁ¬½ÓÐÅÏ¢,°üº¬ipµØÖ·
exec p_getlinkinfo @includeip=1
--ÏÔʾÁ¬½ÓÖ¸¶¨Êý¾Ý¿âµÄÐÅÏ¢
exec p_getlinkinfo '¿Í»§×ÊÁÏ'
--*/
create proc p_getlinkinfo
@dbname sysname=null, --Òª²éѯµÄÊý¾Ý¿âÃû,ĬÈϲéѯËùÓÐÊý¾Ý¿âµÄÁ¬½ÓÐÅÏ¢
@includeip bit=0 --ÊÇ·ñÏÔʾIPµØÖ·,ÒòΪ²éѯIPµØÖ·±È½Ï·Ñʱ,ËùÒÔÔö¼Ó´Ë¿ØÖÆ
as
declare @dbid int
set @dbid=db_id(@dbname)
create table #tb(id int identity(1,1),dbname sysname,hostname nchar(128),loginname nchar(128),net_address nchar(12),net_ip nvarchar(15),prog_name nchar(128))
Ïà¹ØÎÊ´ð£º
´úÂ룺
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost: ......
ÔõôÔÚvfpµÄ±íµ¥ÖÐÏÔÏÖ´ÓsqlserverÖÐ×¥¹ýÀ´µÄͼƬ£¿
ÎÒÓõÄÊÇvfp6.0
Ìý˵¿ÉÒÔµ÷ÓÃÆäËûÓïÑÔдµÄdllÀ´ÊµÏÖ£¬
ÎÒ¿ÉÒÔÓÃdelphiдdll³öÀ´£¬
µ«ÊÇÎÒ²»»áÓÃʹÓÃvfpÀ´µ÷ÓÃdll°¡
Õâ¶Î´úÂëÊÇ´ÓSQLSEREVR¡¡I ......
sqlserver¡¡µÄ¹æÔòruleÈçºÎÀí½â£¬¡¡ÏÂÃæÊÇÒ»¸öʵÀý£¬Çë½áºÏ¸ÃÀý×Ó½âÊÍ£º
ΪĿ±êÊý¾Ý¿â¹ÜÀíϵͳÉè¼ÆÒµÎñ¹æÔò£º
4.2.1 ¹æÔò£º
Ø rule[Sex]
create rule [Sex] as @ in ('ÄÐ','Å®')
......
ÎÒ´Ó΢Èí¹ÙÍøÏÂÔØµÄdriverÔõôÊǸöhtmlÎļþ˸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè
Ò»°ã¹ÜÍøÏÂÔØ¶¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æÎªµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£
ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļ ......
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......