hibernate mysql ÈÕÎÄ
±í½á¹¹
mysqlÊý¾Ý
ÍøÒ³ÏÔʾµÄÊý¾Ý
ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£
ÕâÀïºÍÈÕÎÄÓйØÏµ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»
ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎÊÌ⣬һʱ¿ÉÒÔ£¬Ò»Ê±²»ÐС£
ÕâÊÇ´úÂë
½á¹¹ÊÇstruts2+hibernate
²»¿ÉÏÔʾ²»³öÀ´°É£¬×îÉÙÒ²ÄÜÓм¸¸öÂÒÂë°É¡£
ллÄãµÄ»Ø´ð
¡£ÎÒÔÚmyeclipse µ÷ʽµÄ
´ÓÉÏÃæÕâ¸öͼ¿ÉÒÔ¿´µ½£¬ÓÐ2ÌõÊý¾Ý£¬µ«ÊÇÕâÀïÃæµÄÊýֵȴÊÇûÓеġ£ÎÒ²»ÖªµÀÎÊÌâ³öÏÖÔÚÄÄÀï¡£
³¤¶ÈÊÇÓÃhibernate°´Êý¾Ý¿âÉú³ÉµÄ£¬Ö»ÒªÊý¾Ý¿âÄÜ´æ´¢£¬javaÀïÃæµÄlistÒ²ÊÇ¿ÉÒԵġ£¡£Ð»Ð»Äã¡£
ҲллÄã¸æËßÎÒÕâ¸ö¡£¶¥Ò»Ï¡£
лл8Â¥£¬
<property name="current_session_context_class">thread </property> ÕâÒ»¶ÎÇëÎÊÊÇ·ÅÔÚstruts.xml
»¹ÊÇhibernate.cfg.xml
°ÑÊý¾Ý¿âµÄ±í ¸ÄÒ»¸ö×Ö¶Î ²»¿ÉÒÔΪ¿Õ ÊÔÊÔ
Ö»ÒªÎÒ»»Ò»ÕÅ±í£¬¾ÍʲôÎÊÌⶼûÓÐÁË¡£
ллÁË¡£ÒѾŪºÃÁË¡£Ö÷ÒªÎÊÌâÊÇ£¬ÎÒÓиöÈÕÆÚÁС£ÊÇmysql·ÅµÄÊÇ0000-00-00
ËùÒÔÔÚhibernate¶ÔÏñת»»µÄʱºò³ö´íÁË¡£Ð»Ð»´ó¼Ò£¡£¡
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
C#ÔõôÁ¬½ÓMySql£¿
sqlÓï¾ä·ÅÄÄ?
½á¹û¼¯ÔõôÓã¿
Çó½â´ð
Â¥Ö÷£¬ÓÐʱºòѧ»á×Ô¼ºÕҴ𰸣¬×Ô¼ºÄܽâ¾öµÄ¾¡Á¿×Ô¼º½â¾ö¡£
ÎÒÒ²ÊǰٶȵĴð°¸Ï£Íû¶ÔÄãÓаïÖú
MySQLConnection DBConn;
&nb ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
SQL code:
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369
ÒÔÉ ......
select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡
Èç¹ ......