SQLÖеÄlikeÓï¾äÏê½â
ÔÚÎÒÃÇƽʱд³ÌÐòµÄʱºò£¬ÓÐЩ²ÎÊýÊǾ³£¸Ä±äµÄ£¬¶øÕâÖָı䲻ÊÇÎÒÃÇÔ¤ÖªµÄ¡£±ÈÈç˵ÎÒÃÇ¿ª·¢ÁËÒ»¸ö²Ù×÷Êý¾Ý¿âµÄÄ£¿é£¬ÔÚ¿ª·¢µÄʱºòÎÒÃÇÁ¬½Ó±¾µØµÄÊý¾Ý¿âÄÇô IP £¬Êý¾Ý¿âÃû³Æ£¬±íÃû³Æ£¬Êý¾Ý¿âÖ÷»úµÈÐÅÏ¢ÊÇÎÒÃDZ¾µØµÄ£¬ÒªÊ¹µÃÕâ¸ö²Ù×÷Êý¾ÝµÄÄ£¿é¾ßÓÐͨÓÃÐÔ£¬ÄÇôÒÔÉÏÐÅÏ¢¾Í²»ÄÜдËÀÔÚ³ÌÐòÀͨ³£ÎÒÃǵÄ×ö·¨ÊÇÓÃÅäÖÃÎļþÀ´½â¾ö¡£
¸÷ÖÖÓïÑÔ¶¼ÓÐ×Ô¼ºËùÖ§³ÖµÄÅäÖÃÎļþÀàÐÍ¡£±ÈÈç Python £¬ËûÖ§³Ö .ini Îļþ¡£ÒòΪËûÄÚ²¿ÓÐÒ»¸ö ConfigParser ÀàÀ´Ö§³Ö .ini ÎļþµÄ¶Áд£¬¸ù¾Ý¸ÃÀàÌṩµÄ·½·¨³ÌÐòÔ±¿ÉÒÔ×ÔÓɵÄÀ´²Ù×÷ .ini Îļþ¡£¶øÔÚ Java ÖУ¬ Java Ö§³ÖµÄÊÇ .properties ÎļþµÄ¶Áд¡£ JDK ÄÚÖÃµÄ java.util.Properties ÀàΪÎÒÃDzÙ×÷ .properties ÎļþÌṩÁ˱ãÀû¡£
Ò»£® .properties ÎļþµÄÐÎʽ ==========================================================
# ÒÔÏÂΪ·þÎñÆ÷¡¢Êý¾Ý¿âÐÅÏ¢
dbPort = localhost
databaseName = mydb
dbUserName = root
dbPassword = root
# ÒÔÏÂΪÊý¾Ý¿â±íÐÅÏ¢
dbTable = mytable
# ÒÔÏÂΪ·þÎñÆ÷ÐÅÏ¢
ip = 192.168.0.9
······
ÔÚÉÏÃæµÄÎļþÖÐÎÒÃǼÙÉè¸ÃÎļþÃûΪ£º test.properties Îļþ¡£ÆäÖÐ # ¿ªÊ¼µÄÒ»ÐÐΪעÊÍÐÅÏ¢£»ÔڵȺœ = ”×ó±ßµÄÎÒÃdzÆ֮Ϊ key £»µÈºÅ“ = ”ÓұߵÄÎÒÃdzÆ֮Ϊ value ¡££¨Æäʵ¾ÍÊÇÎÒÃdz£ËµµÄ¼ü - Öµ¶Ô£© key Ó¦¸ÃÊÇÎÒÃdzÌÐòÖеıäÁ¿¡£¶ø value ÊÇÎÒÃǸù¾Ýʵ¼ÊÇé¿öÅäÖõġ£
¶þ£® JDK ÖÐµÄ Properties Àà Properties Àà´æÔÚÓÚ°û Java.util ÖУ¬¸ÃÀà¼Ì³Ð×Ô Hashtable £¬ËüÌṩÁ˼¸¸öÖ÷ÒªµÄ·½·¨£º 1£® getProperty ( String key) £¬ ÓÃÖ¸¶¨µÄ¼üÔÚ´ËÊôÐÔÁбíÖÐËÑË÷ÊôÐÔ¡£Ò²¾ÍÊÇͨ¹ý²ÎÊý key £¬µÃµ½ key Ëù¶ÔÓ¦µÄ value ¡£
2£® load ( InputStream inStream) £¬´ÓÊäÈëÁ÷ÖжÁÈ¡ÊôÐÔÁÐ±í£¨¼üºÍÔªËضԣ©¡£Í¨¹ý¶ÔÖ¸¶¨µÄÎļþ£¨±ÈÈç˵ÉÏÃæµÄ test.properties Îļþ£©½øÐÐ×°ÔØÀ´»ñÈ¡¸ÃÎļþÖеÄËùÓмü - Öµ¶Ô¡£ÒÔ¹© getProperty ( String key) À´ËÑË÷¡£ 3£® setProperty ( String key, String value) £¬µ÷Óà Hashtable µÄ·½·¨ put ¡£Ëûͨ¹ýµ÷ÓûùÀàµÄput·½·¨À´ÉèÖà ¼ü - Öµ¶Ô¡£
4£® store ( OutputStream out, String comments) £¬ ÒÔÊʺÏʹÓà load ·½·¨¼ÓÔص½ Properties ±íÖеĸñʽ£¬½«´Ë Properties ±íÖÐ
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¶þ¡¢¸ÄÉÆSQLÓï¾ä
Èý¡¢ÊµÏÖСÊý¾ÝÁ¿ºÍº£Á¿Êý¾ÝµÄͨÓ÷ÖÒ³ÏÔʾ´æ´¢¹ý³Ì
¾Û¼¯Ë÷ÒýµÄÖØÒªÐÔºÍÈçºÎÑ¡Ôñ¾Û¼¯Ë÷Òý
¡¡¡¡ÔÚÉÏÒ»½ÚµÄ±êÌâÖУ¬±ÊÕßдµÄÊÇ£ºÊµÏÖСÊý¾ÝÁ¿ºÍº£Á¿Êý¾ÝµÄͨÓ÷ÖÒ³ÏÔʾ´æ´¢¹ý³Ì¡£ÕâÊÇÒòΪÔÚ½«±¾´æ´¢¹ý³ÌÓ¦ÓÃÓÚ“°ì¹«×Ô¶¯»¯”ϵͳµÄʵ¼ùÖÐʱ£¬±ÊÕß·¢ÏÖÕ ......
ÔÚJAVAÖеÄSQL Óï¾äµÄ±àд·½Ã棬ûÓÐʹÓÃORACLE °ó¶¨±äÁ¿£¬ºÜ´ó³Ì¶ÈÉϽµµÍÁËÊý¾Ý¿âµÄÐÔÄÜ£¬±íÏÖÔÚÁ½¸ö·½Ã棺
1¡¢SQLÓï¾äÓ²·ÖÎö(Hard Parse)Ì«¶à£¬ÑÏÖØÏûºÄCPU×ÊÔ´£¬ÑÓ³¤ÁËSQLÓï¾ä×ܵÄÖ´ÐÐʱ¼ä
SQLÓï¾äµÄÖ´Ðйý³Ì·Ö¼¸¸ö²½Ö裺Óï·¨¼ì²é¡¢·ÖÎö¡¢Ö´ÐС¢·µ»Ø½á¹û¡£ÆäÖзÖÎöÓÖ·ÖΪӲ·ÖÎö(Hard Parse)ºÍÈí·ÖÎö(Soft Pars ......
ÏÖÔÚ·ÖÒ³·½·¨´ó¶à¼¯ÖÐÔÚselect top/not in/Óαê/row_number£¬¶øselect top·ÖÒ³(ÔÚÕâ»ù´¡ÉÏ»¹Óжþ·Ö·¨)·½·¨Ëƺõ¸üÊÜ´ó¼Ò»¶Ó£¬ÕâƪÎÄÕ²¢²»´òËãÈ¥ÌÖÂÛÊÇ·ñͨÓõÄÎÊÌ⣬±¾×ÅʵÓõÄÔÔò£¬»¨ÁËһЩʱ¼äÈ¥²âÊÔrow_number()·ÖÒ³µÄÐÔÄÜ£¬¸Ð¾õ²¢²»ÏñÒ»²¿·ÖÈËËù˵µÄÄÇô¼¦Àߣ¬ÓÉÓÚ½Ó´¥Èí¼þ¿ª·¢²ÅÊ®¸öÔ£¬·½·½ÃæÃæµÄ¶«Î÷¶¼ÒªÑ§ ......