MySQL update ÑÏÖØÎÊÌâ
ÏÖÔÚÎÒÏëʵÏÖÒÔÏ·½·¨£º »·¾³struts2+ibatis2.3+mysql5 ´ÓjspµÃµ½Êý¾ÝºóÏÈupdate £¬Èç¹ûÊý¾Ý¿âÀïûÓиÃÐÅÏ¢ÔÙ insert £¬ÎÒÓÃÁËtry catch Òì³£²¶×½£¬±¾Ïëtry{ update} catch£¨£©{insert} µÄ£¬½á¹ûupdateÔÚÊý¾Ý¿âûÓÐÕÒµ½ÐÅÏ¢ºó²¢Ã»ÓÐÅ׳öÒì³£¡£¡£¡£ÇëÎʸ÷λ¸ßÊÖ£¬ÓÐûÓÐʲô½â¾ö°ì·¨£¬ÔÚ Ïߵȡ£¡£¡£
×Ô¼º¶¥Ò»¸ö update¿ÉÒÔ·µ»ØÓ°ÏìÐÐÊý£¬²»ÖªÕâÑùÐв»ÐÐ try { if(update <1) insert; }catch(Exception mye){} Çë½Ì£¡£¡Çë½Ì£¡£¡ if(update ==0) insert; ×îºÃÖ±½ÓÓÃsaveOrUpdate·½·¨°É£¨²»ÄܸüÐµĻ°¾Í²åÈ룩¡£hibernateÀïÃæÓУ¬²»ÖªµÀibatisÓÐûÓУ¬ update ·µ»ØÓ°ÏìµÄÐÐÊý£¬sqlÔõôд°¡£¿ÒýÓà update ·µ»ØÓ°ÏìµÄÐÐÊý£¬sqlÔõôд°¡£¿ service·½·¨ÀïÒ²¾ÍÊÇÄãµÄtry--catch·½·¨À·µ»ØÖµ¾ÍÊÇupdateÓ°ÏìµÄÐÐÊýÒýÓà ÒýÓà 4 Â¥ yingtaoxiaonizi µÄ»Ø¸´: update ·µ»ØÓ°ÏìµÄÐÐÊý£¬sqlÔõôд°¡£¿ service·½·¨ÀïÒ²¾ÍÊÇÄãµÄtry--catch·½·¨À·µ»ØÖµ¾ÍÊÇupdateÓ°ÏìµÄÐÐÊý ¿ÉÊÇÎÒµÄupdateÓï¾äûÓÐд·µ»ØÖµ°¡... ÎÒÓõÄÊÇibatis£¬²»ÊÇjdbc....²»ÖªµÀÔõô·µ»ØÓ°ÏìÐÐÊý
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿ ÄãÊÇÈçºÎɾ³ýµÄ£¿ ÓÐʲôÌáʾ£¿ ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡ Çë¸÷λ¸øÒÔÌáʾ¡£ ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É 1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. ¿ ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï. ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî SQL code: update ±í set introtxt=left(`fulltext`,300); ¶¥£¬Ñ§Ï° SQL code: ......