MySqlÊÂÎñÎÊÌâ
MySQLĬÈÏÊÂÎñÊǹرյġ£¡£ÎÊһϴó¼Ò¡£¡£ÈçºÎ´ò¿ª°¡¡£¡£ÎÒÓÃset autoCommit=0ºÃÏñÖ»¶ÔÒ»¸öÁ¬½Ó×÷Ó㬣¬ÎÒÏëÓÃspringÀ´¿ØÖÆ£¬£¬µ«ÊDz»Ðа¡¡£¡£¸ßÊÖ°ïæ£¬£¬Õâ¸öÎÊÌâÎÊÁË3¸öÔÂÁË¡£¡£¡£¡£
°ÑÊý¾ÝÔ´Åäµ½springµÄÅäÖÃÎļþÖС£¾ÍÄÜÈ«¾Ö¿ØÖÆÊÂÎñÁË
µÚÒ» £º ͨ¹ýÐÞ¸ÄÅäÖÃÎļþ¿ªÆôÊÂÎñ
µÚ¶þ£º Â¥Éϵġ£
Äܲ»ÄܸøÎÒ¸öÀý×Ó¡£¡£
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
SQL code:
create table t2 (aa int ,bb varchar(50),cc varchar(50),dd varchar(50),ee varchar(50))
insert into t2 (aa ,bb,cc,dd,ee) values (1,'string',ÆäÓàµÄ3¸ö×Ö¶ÎÊÇ select c,d,e from t1 ²é³öÀ´µÄ)
......