SQLServer IP¿â ²éѯIP²»Í¬ ËÙ¶ÈÏà²î¾Þ´ó ÇóÓÅ»¯Òâ¼û
ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â
°´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal
±ÈÈç
IP±í
IPStart IPEnd Address
-------------------------------------
994304000 994310143 ±±¾©
... ... ...
... ... ...
¼Ç¼Êý30Íò
°´ÕÕIPStart IPEnd ½¨¾Û¼¯Ë÷Òý ²éѯ·½Ê½Îª SELECT Address from [IP] IPStart <=@IP And IPEnd>=@IP
¸ù¾Ý²éѯIP²»Í¬ ²éѯËÙ¶ÈÏà²î¿É´ïµ½10±¶ÒÔÉÏ (IPÕý³£ÖµµÄÇé¿öÏÂ)
Çë½Ì¸÷λÓÐʲôºÃµÄÓÅ»¯Òâ¼û?
Êý¾Ý¿â½á¹¹¿É¸ü¸Ä Ö»Çó×î¸ßЧÂÊ
Up
ÔÚ´æ儲µÄ時ºòŪ個計ËãÁÐ
Ïà¹ØÎÊ´ð£º
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÓÐÈËÊÔ¹ýÔÚwin7ÉÏ°²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÓÐһ̨Êý¾Ý¿â·þÎñÆ÷£¬¿Í»§¶ËʹÓÃADO.NETÁ¬½Ósql£¬Ê¹ÓÃExecuteScalarÖ´ÐÐSQL INSERTÓï¾ä£¬È»ºó¿Í»§¶Ëˢв»Äܲéѯµ½ÐÂINSERTµÄÊý¾Ý£¬¹ý10Ãë×óÓÒ²ÅÄܲ鵽ÐÂÊý¾Ý
ʲôÔÒò
Äã×öÁË»º´æÂð£¿
û×ö»º´æ
Ôõô»áÄØ£¡ ......
ÐèÇó˵Ã÷£º
ÔÚJSPǰִ̨ÐÐÒ»¸ö²Ù×÷£¬±¸·ÝºÃºǫ́SQLSERVERÊý¾Ý¿â±¸·Ý¡£
Çë¸÷λ´óϺ¸ø½éÉÜһϽâ¾ö·½°¸¡£
ǰ̨µ÷Óúǫ́µÄÒ»¸ö´æ´¢¹ý³Ì¾Í¿ÉÒÔÁË¡£
²»ÖªµÀ´æ´¢¹ý³ÌÔõôдÄØ£¿»¹ÇëÏ£ÍûÌṩһ¸ö·¶Àý¡£¸Ðл£¡
......