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");
Ïà¹ØÎĵµ£º
Ê×ÏÈÒªÉùÃ÷Ò»µã£¬´ó²¿·ÖÇé¿öÏ£¬ÐÞ¸ÄMySQLÊÇÐèÒªÓÐmysqlÀïµÄrootȨÏ޵ģ¬ ËùÒÔÒ»°ãÓû§ÎÞ·¨¸ü¸ÄÃÜÂ룬³ý·ÇÇëÇó¹ÜÀíÔ±¡£ ·½·¨Ò»Ê¹ÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬ ²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£ ·½·¨¶þʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£ mysqladmin -u root -p password mypasswd ÊäÈëÕâ¸ö ......
JAVAÅÅÐò»ã×Ü ÊÕ²Ø
package com.softeem.jbs.lesson4;
import java.util.Random;
/**
* ÅÅÐò²âÊÔÀà
*
* ÅÅÐòËã·¨µÄ·ÖÀàÈçÏ£º
* 1.²åÈëÅÅÐò£¨Ö±½Ó²åÈëÅÅÐò¡¢ÕÛ°ë²åÈëÅÅÐò¡¢Ï£¶ûÅÅÐò£©£»
* 2.½»»»ÅÅÐò£¨Ã°ÅÝÅÝÅÅÐò¡¢¿ìËÙÅÅÐò£©£»
* 3.Ñ¡ÔñÅÅÐò£¨Ö±½ÓÑ¡ÔñÅÅÐò¡¢¶ÑÅÅÐò£ ......
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 ......
String str = "[010101]+[010102]";
String ss = "
System.out.println(ss); // \[010101]
[ ÊÇÌØÊâ×Ö·û£¬
ÐèÒªÓ÷´Ð±¸Ü \[ ¶ÔÆä½øÐÐתÒå
\\[010101]";
String ssss = "
\\ ......