MYSQLÁ¬½ÓµÄÎÊÌâ - Java / Java SE
Java code:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was51093 seconds ago.The last packet sent successfully to the server was 51093 seconds ago, which is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3246)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1917)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.StatementImpl.executeUpdate(
Ïà¹ØÎÊ´ð£º
¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£
´Ê¿âÔõôÉú³ÉÄØ£¿
²»»á¡£
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä
ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ
ÓÃmap ¼üÖµ¶ÔÓ¦
Èç¹ûÓÃÊý¾Ý¿ ......
ÌâÄ¿£º
ÓÐ1,2,3£¬4,5,6Áù¸öÊý×ÖÅÅÐò£¬ÓÃjava³ÌÐò¼ÆËã³öÅÅÐòµÄÖÖÀà¡£
ÒªÇó£ºÒ»£¬ÒÔ4¿ªÍ·
¶þ£¬2,3²»ÄÜÏàÁÚ
Èý£¬²»ÄÜÒÔ5¿ªÍ·
Ï£Íû´ó¼ÒÄܼ´ ......
JSPÖÐÒª´ÓÊý¾Ý¿âÀïÃæ¶ÁÈ¡Êý¾Ý ÿҳÏÔʾ5ÌõÊý¾Ý£¬Òª½øÐзҳ£¬»¹Òª·µ»ØÇ°Ò»Ò³ ¸ÃÔõôʵÏÖ°¡
ÓõÄʲôÊý¾Ý¿âÄØ£¿£¿£¿
MYSQL
....лл ÎÒÏÈ¿´¿´´úÂë
http://my.donews.com/benz/2006/10/21/YnmQXKsKWNgKiTJ ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
Òò¹«Ë¾ÒµÎñ·¢Õ¹£¬ÏÖÕÐÆ¸java¿ª·¢¹¤³Ìʦ2ÈË
ÓÐJAVAÏîÄ¿¿ª·¢¾Ñé
¶Ô·ÖÅɵÄÈÎÎñÄܹ»¶ÀÁ¢½øÐпª·¢
ÊìϤ2ÖÖÒÔÉÏÊý¾Ý¿â
¶Ô¼ÆËã»úÍøÂçÓÐÒ»¶¨Á˽â
ѧÀú²»ÏÞ
ѧϰÄÜÁ¦Ç¿
Äܹ»³ÐÊܹ¤×÷ѹÁ¦
¹¤×÷µØµã£º±±¾©
Çë·¢¼òÀúÖÂ ......