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¶ÔÏñת»»µÄʱºò³ö´íÁË¡£Ð»Ð»´ó¼Ò£¡£¡
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
-> ;
+--------------------------+----------------------------------- ......
select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡
Èç¹ ......