Mysql ʹÓÃÎÊÌâ - Java / Web ¿ª·¢
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ:SHOW VARIABLES LIKE '%charac%'
¿´¿´ÄãµÄÊý¾Ý¿â±àÂë
Òª¸Ä±äÆäÖÐÒ»¸ö, ¾ÍʹÓÃ
set character_set_client = UTF8;
ÆäÖÐ
character_set_client | utf8 ¿Í»§¶Ë, Ò²¾ÍÄ㵱ǰÃüÁîÐÐϵıàÂë, Ò²¿ÉÒÔʹÓÃset names gbkÕâÑùÉèÖÃ
character_set_connection | utf8 Á¬½Ó±àÂë
character_set_database | utf8 Êý¾Ý¿â±àÂë
character_set_filesystem | binary Êý¾Ý¿âµ×²ãÎļþϵͳ±àÂë
character_set_results | utf8
character_set_server | utf8
character_set_system | utf8
È«²¿×ªÎªutf-8ÊÔÊÔ°É.
±àÂëÎÊÌ⣬ËùÓеĵط½ÒªÊ¹ÓÃÏàͬµÄ±àÂ룻CMDºÚ´°¿ÚÀïÊÇÓõÄGBK±àÂ룬Äã³ÌÐòÀïÆäËûµÄµØ·½ÄØ£¿
×Ö·û¼¯µÄÎÊÌâ
°²×°µÄʱºò£¬ÈÃÄãÑ¡±àÂëµÄ£¬¿ÉÄÜÄãûÓÐ×¢Ò⣡
ÎÒÓõıàÂëÊÇgb2313£¡£¡ È»ºóÔÚMysql µÄ¿ÉÊÓ½çÃæÖиü¸ÄÊý¾Ýʱ Ëü²»Èøü¸Ä 1406 - data too long for column £¡£¡
ÎÒÓõıàÂëÊÇgb2312£¡£¡ È»ºóÔÚMysql µÄ¿ÉÊÓ½çÃæÖиü¸ÄÊý¾Ýʱ Ëü²»Èøü¸Ä 1406 - data too long for column £¡£¡
Èç¹û¿ØÖÆÌ¨´òÓ¡µÄÊÇÖÐÎÄ£¬ÄÇôӦ¸Ã²»ÄÜ»³ÒÉmysqlµÄ±àÂë¡£
½¨ÒéÔÚResultSetÈ¡Êý¾ÝʱÈÕÖ¾´òӡһϣ¬¿´ÊÇ·ñ´ÓÊý¾Ý¿â¸Õ¶Á³öʱ¾ÍÊÇÂÒÂë¡£
Èç¹ûÊÇ£¬ÄÇô¿ÉÒÔÐÞ¸ÄmysqlĿ¼ÖеÄmy.iniÎļþ£¬ÀïÃæÓÐÁ½¸ö½Úµã¿ÉÒÔ¸ü¸Ä±àÂ뷽ʽ
Ïà¹ØÎÊ´ð£º
import java.io.*;
class FileTest
{
public static void main(String [] args) throws Exception
{
File fDir=new File(File.separator);
String strFile="javaÔ´´úÂë²âÊÔ"+File.separato ......
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......