mysql²éѯÎÊÌ⣬¼± - Java / Java EE
ʹÓÃmysqlµÄjdbc driverÁ¬½ÓmysqlÊý¾Ý¿â¡£¾³£³öÏÖÏÂÃæµÄ²éѯ£¬ÇëÎÊÊǸÉɶµÄ£¿
/* mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) */SHOW
VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR
Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name
= 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name =
'character_set' OR Variable_name = 'character_set_server' OR Variable_name =
'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name =
'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR
Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR
Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR
Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name =
'query_cache_size' OR Variable_name = 'init_connect'
¹À¼ÆÇý¶¯°ü°æ±¾ÓÐÎÊÌâ°É
²»Á˽⣬ȥϸö×îеÄÇý¶¯°ü¿´¿´°É
¸Ð¾õÊÇ·ñÊÇconnectorÔÚά»¤Á¬½Ó³ØÀïµÄÁ¬½Ó£¿»òÕß˵ÊDzâÊÔÁ¬½Ó³ØÀïµÄÁ´½ÓÊÇ·ñ¿ÉÓ㿸ßÈË¿ì³öÏÖ°É
ÖØ×°......................
²¹³äÒ»µã£¬²¢Ã»Óе¼Ö³ÌÐò³ö´í»òÕß²»ÄÜÔËÐУ¬Ö»ÊÇ´ÓmysqlµÄshow full processlistÖп´µ½´óÁ¿ÕâÖÖ²éѯ£¬²»Ã÷°×ÊÇÕ¦»ØÊ£¬Òò´ËÇë½Ì¸÷λ¸ßÈË£¬ÕâЩ¶«¶«ÊÇÔõôÀ´µÄ
Ïà¹ØÎÊ´ð£º
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һÏ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëÄ¿Ç°×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......