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

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¶ÔÏñת»»µÄʱºò³ö´íÁË¡£Ð»Ð»´ó¼Ò£¡£¡


Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

MySqlÎÊÌâ

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

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

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

mysqlÖÐÎÄÂÒÂë

ÀûÓÃload data infileÃüÁîµ¼ÈëuserDesc.txtÊý¾Ý£¬Êý¾Ýµ¼ÈëºóËùÓеÄÖÐÎľÓȻȫÊÇÂÒÂ룬
mysql×Ö·û¼¯ÉèÖÃÈçÏ£º
    -> ;
+--------------------------+----------------------------------- ......

mysql ²éѯÓï¾ä

select id,dtime,zt,optype( Èç¹ûoptype=0½«±¾ÌõÊý¾Ý²åÈëµ½table1±íÖУ¬Èç¹ûoptype=1ÒÔdtimeºÍztΪÌõ¼þÖ´ÐÐÒ»Ìõ²éѯÓï¾ä ) from table
ʵÏÖÕâ¸öÒªÇóµÄÓï·¨Ôõôд
Ò»ÌõSQLÓï¾ä¹À¼Æ¸ã²»¶¨¡£µÈ¥Ϻ÷½·¨£¡

Èç¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ