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

java mysql ºº×Ö´æÈëʱÂÒÂë


´ÓÍøÂçÕª³­µ½µÄ½â¾ö·½·¨——
½â¾ö·½·¨¶þ£º
      Á¬½Ómysqlʱ(ÎÞÂÛÔÚ´Ómysql¶Á»¹ÊÇÈ¡Êý¾ÝµÄÇé¿ö)£¬Ö¸¶¨Ê¹ÓõıàÂ뷽ʽΪutf-8£¬¾ßÌå´úÂëÈçÏÂ
      //×°ÔØmysql-jdbcÇý¶¯
       Class.forName("com.mysql.jdbc.Driver").newInstance();
      //Á¬½ÓÊý¾Ý¿â
      Connection sqlCon = DriverManager.getConnection( "jdbc:mysql://localhost:3306/javatest?user=root&password=admin&useUnicode=true&characterEncoding=utf-8 " );
      ÎÒÊÇÓÃÕâ¸ö·½·¨½â¾öµÄ¡£
ÔÚÅäÖÃÎļþÖиÄΪ
url="jdbc:mysql://127.0.0.1/elearning?useUnicode=true&characterEncoding=utf-8"
³ö´í£¬ºó¸ÄΪurl="jdbc:mysql://127.0.0.1/elearning?useUnicode=true&characterEncoding=utf-8"
³É¹¦


Ïà¹ØÎĵµ£º

mysql×Ó²éѯ exists,not exists


(1)ʵÏÖÈýá¹û¼¯A-½á¹û¼¯B£º--ÀûÓÃnot
exists£¬ºÏ²¢Ôò¿ÉÓÃunion
exists,not
exists£ºÓÃÓÚÅжÏÇÒ»ñÈ¡½á¹û¼¯AÊÇ·ñ´æÔڵؽá¹û¼¯BÖÐ!
==========½á¹û¼¯A£º
SELECT
d.Device_ID,d.Device_Name,a.App_ID,a.App_Name
               from
T_ ......

windows°²×°apache+php+mysqlµÄһЩ¼Ç¼

apache°²×°£¬mysql°²×°£¬php5Ö±½Ó½âѹ£¬¾ù·ÅÔÚD:\wwwÏ¡£
Ŀ¼½á¹¹Îª£º
D:\www\apache2
D:\www\mysql
D:\www\php5
½«php5\php.ini-dist¸´ÖÆÎªphp.ini£¬°ÑÐèÒªÓõ½µÄ×é¼þ½«Ç°ÃæµÄ;È¥µô¡£
Èç
extension=php_mysql.dll
extension=php_gd2.dll
ÔÚapache2µÄconf/httpd.confÎļþÖмÓ
LoadFile D:/www/php5/php5ts.dll
......

mysqlÂÒÂëÎÊÌâ

´´½¨µÄһЩ±í»á³öÏÖÕâÑùµÄÎÊÌ⣺ӢÎIJåÈëµ½±íÖÐûÓÐÈκÎÎÊÌâ¡£µ«ÊDzåÈëÖÐÎĵÄʱºò¾Í³öÏÖ Data truncation: Data too long for column 'name' at row 1 ÀàËÆµÄÎÊÌâ¡£
mysqlÄܰÑÓ¢ÎÄ×ֶβåÈçÊý¾Ý¿âÁË¡¡µ±ÎÒÊäÈëÖÐÎÄʱËû¾Í³öÏÖ×Ö¶ÎData truncation: Data too long for column 'name' at row 1
ÎÒʹÓÃÅóÓѵÄÕâ¸ö·½·¨£º(1)ÐÞ¸ ......

ÔÚjavaÖÐʵÏÖaccessÊý¾Ý¿âµÄÔ¶³Ì·ÃÎÊ

ÁκéÁÁ 2010/4/13
¸ÅÊö
ÔÚʵ¼ÊµÄÏîÄ¿ÖУ¬¿ÉÄÜ»áÓöµ½ÕâÑùµÄÎÊÌ⣺A·þÎñÆ÷ÉϵÄÓ¦ÓóÌÐòÐèÒª·ÃÎÊB·þÎñÆ÷ÉϵÄaccessÊý¾Ý¿â(¿ÉÒÔʹÓÃÐéÄâ»úÄ£ÄâA¡¢B·þÎñÆ÷½øÐвâÊÔ)¡£¶øaccessÊý¾Ý¿âÊÇÎļþÀàÐ͵쬲»Í¬¼ÆËã»ú¼äÐèÒªÖ¸¶¨Îļþ·ÃÎÊȨÏÞ£¬Ôö¼ÓÁ˳ÌÐòµÄ¸´ÔÓ¶È¡£±¾ÎĽ«´ÓÒ»¸öʵÀýÀ´½éÉÜÒ»ÖÖ¼òµ¥ÊµÓõķ½·¨¡£¸ÃʵÀýʹÓõķ½·¨À´×ÔInte ......

Java Ï̵߳Ĵ´½¨·½·¨

Ò»¶àÏ̵߳ĸÅÄî
¼òµ¥ËµÏ߳̾ÍÊdzÌÐòÖ´ÐеIJ»Í¬Â·¾¶¡£¶ø½ø³ÌÊÇÒ»¸ö¾²Ì¬µÄ¸ÅÄîͨ³£ËµµÄÆô¶¯Ò»¸ö½ø³ÌÊÇÆô¶¯Ò»¸ö½ø³ÌÀïÃæµÄÖ÷Ï̡߳£
¶àÏß³ÌÔòÊÇÒ»¸ö½ø³ÌÀïÃæµÄ²»Í¬µÄ³ÌÐòµÄÖ´Ðз¾¶¡£¶øÊÂʵÉÏÔÚijһ¸öʱ¿ÌcpuÖ´ÐÐÁËijһ¸ö³ÌÐò ÓÉÓÚËٶȺܿìËùÒÔ
ÎÒÃǸоõ²»³öÀ´
¶þÏ̵߳Ĵ´½¨
1  ʵÏÖ½Ó¿Ú´´½¨
 
public void c ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ