Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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....²»ÖªµÀÔõô·µ»ØÓ°ÏìÐÐÊý


Ïà¹ØÎÊ´ð£º

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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Á¬½Óoracle

ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ

oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó

ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬

ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ