Java ¶ÁÈ¡ MySQL ÖÐÎÄ ÂÒÂë
Java ¶ÁÈ¡ MySQL ÖÐÎÄ ÂÒÂë
³¡¾°:Java,eclipse£¬¶ÁÈ¡MySQLÊý¾Ý¿â£¬MySQL±àÂëΪutf-8
ÎÊÌ⣺¶Á³öÀ´µÄÖÐÎÄÔÚeclipseµÄÊä³ö´°¿ÚÖÐÏÔʾΪÂÒÂë
´íÎóµÄд·¨
1
System.out.print(new String( rs.getString("bib_author").getBytes("utf-8"),"GBK" ));
2
System.out.print( rs.getString("bib_author"));
JavaÖÐͳһʹÓÃUnicode±àÂë¡£
ÕýÈ·µÄд·¨£º
System.out.print(new String (rs.getBytes("bib_author"),"utf-8") + " ");
Èç»®Ïß¼Ó´Ö²¿·ÖËùʾ£¬Ó¦¸ÃÏÈÓöþ½øÖÆ·½Ê½¶Á½øÀ´£¬È»ºóÔÙת»¯Îªutf-8·½Ê½£¬ºÍÊý¾Ý¿âÖеıàÂëÒ»Ö¡£
ÏÂÃæÊÇ֮ǰÅöµ½¹ýµÄÒ»¸öÀý×Ó£¬´Óweb·þÎñÆ÷¶ÁÈ¡Êý¾Ý£¬²¢×ª»¯Îªutf-8¡£web·þÎñÆ÷ʹÓõÄÊÇiso-8859-1±àÂë¡£
ͬÑùÒ²ÊÇÏÈÓÃgetbytes·½Ê½ÏÈ»ñÈ¡¶þ½øÖÆÁ÷£¬È»ºóת³Éutf-8¡£
-------------------------------------------------------------------------------------------
3¸öµØ·½ÉèÖñàÂ룬½â¾öÂÒÂëÎÊÌâ
public static String GetResponse(HttpMethodBase Method) throws IOException {
String charset= Method.getResponseCharSet();
System.out.println("·µ»ØµÄ×Ö·û±àÂëΪ£º"+charset);
InputStream responseBody = Method.getResponseBodyAsStream();
// BufferedReader br = new BufferedReader(new InputStreamReader(responseBody));
BufferedReader br = new BufferedReader(new InputStreamReader(Method.getResponseBodyAsStream(), "ISO-8859-1"));//1
String tempbf;
StringBuffer htmlbf = new StringBuffer(100);
while ((tempbf = br.readLine()) != null) {
// htmlbf.append(tempbf);
htmlbf.append(new String(tempbf.getBytes("iso-8859-1"),"utf-8"));//2
htmlbf.append("\n");
Ïà¹ØÎĵµ£º
Dos½øÈëMySqlµÄbinĿ¼,Ö´ÐУºmysqldump -hÔ¶³ÌÊý¾Ý¿âIP Êý¾Ý¿âÃû×Ö -uÔ¶³ÌÊý¾Ý¿âÓû§Ãû -pÔ¶³ÌÊý¾Ý¿âÃÜÂë --add-drop-table | mysql ±¾µØÊý¾Ý¿âÃû×Ö -u±¾µØÊý¾Ý¿âÓû§Ãû -p±¾µØÊý¾Ý¿âÃÜÂë
ÔÚ¾ÖÓòÍøÄÚ²âÊԳɹ¦ ......
6
¡¢ÐÞ¸ÄÊý¾Ý¿âµÄ×Ö·û¼¯
mysql>use mydb
mysql>alter database mydb character set utf-8;
6
¡¢´´½¨Êý¾Ý¿âÖ¸¶¨Êý¾Ý¿âµÄ×Ö·û¼¯
mysql>create database mydb character set utf-8;
ͨ¹ýÅäÖÃÎļþÉèÖô´½¨Êý¾Ý¿âʱ×Ö·û¼¯:
#vi /var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-col ......
package dtm.tools;
import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.Socket;
import java.net.UnknownHostException;
import java.util.Calendar;
import java.util.Dat ......
ÎÒ¸Õ´ÓÔÚAntwerpÕÙ¿ªµÄDevoxx
´ó»áÉÏ»ØÀ´£¬»áÉϽéÉÜÁËJava7µÄÐÂÌØÐÔ£¬¶ÔÓ¦µÄJDK½«ÓÚ2010Äê9Ô·¢²¼¡£
ÏÂÃæÊÇ7¸öÒѾÍê³ÉµÄÐÂÌØÐÔ£º
¶ÔcollectionsµÄÓïÑÔ¼¶Ö§³Ö
×Ô¶¯×ÊÔ´¹ÜÀí
¸Ä½ø·ºÐÍÔÚ´´½¨ÊµÀýʱµÄÀàÐÍÒýÓÃ
´øÏ»®ÏßµÄÊý×Ö
ÔÚswitchÖÐʹÓÃString
¶þ½øÖÆÎÄ×Ö
¼ò»¯µÄ¿É±ä²ÎÊý·½·¨µ÷ÓÃ
Java7»¹ÓкܶàÆäËûµÄÐÂÌØÐÔ£¬Î ......
±¾ÌùÕª×Ô http://bbs.langsin.com/redirect.php?tid=9936&goto=lastpost
Ïë´òÓ¡Ò»¸öString ±äÁ¿µÄµØÖ·£¬ÇëÎÊÈçºÎÀ´Ð´£¿
²»ÊÇhashcode£¬¾ÍÊÇÄÚ´æµØÖ·£¬¶øÇÒÒª´òÓ¡³öÀ´¡£
Ò²Ðí±È½Ï¼òµ¥£¬²»¹ýÎÒûд³öÀ´¡£
----------------------------------------------------------------------------------------
ʹÓÃSyst ......