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¶ÔÏñת»»µÄʱºò³ö´íÁË¡£Ð»Ð»´ó¼Ò£¡£¡
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
´ÓÆô¶¯µ½ÄÜÕý³£ÔËÐÐ,´ó¸ÅÒª15µ½20·ÖÖÓ×óÓÒ
ÏÖÏóÊÇ,Æô¶¯ÒÔºómysql½ø³ÌÔÚÈÎÎñ¹ÜÀíÆ÷ÀïÒѾ¿ÉÒÔ¿´µ½ÁË,µ«ÊÇnetstat -anoûÓп´µ½Óнø³ÌÔÚ¼àÌý3306¶Ë¿Ú,ÉÏÃæÊý¾Ý¿â¶¼²»ÄÜ·ÃÎÊ
Ö±µ½15-20·ÖÖÓºó,ÄÜ¿´µ½mysqlÔÚ¼à ......
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
ÒÔÉ ......
ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
-> ;
+--------------------------+----------------------------------- ......