ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö·û¸®¸ÄΪGB2312»òGBK£¬²»ÒªÊ¹ÓÃĬÈϵÄ×Ö·û¼¯¡£¾Í²»´æÔÚÄã˵µÄÎÊÌâÁË¡£
Õâ¸öÂÒÂëµÄ¶«Î÷ºÜÄÑ˵ÊÇmysqlµÄÎÊÌ⣬ÄãÒª¶Ï¶¨ÄãµÄ²åÈëÓï¾äÖÐȷʵÊÇÖÐÎÄ£¬Ëµ²»¶¨Äã²åÈë֮ǰÒѾÊÇ£¿ÁËÄØ£¬ÔÚ²åÈë֮ǰÄã´ò³ösql¿´¿´£¬ÒªÊÇÄãµÄÒ³Ãæ±àÂëºÍÄãµÄÊý¾Ý¿â±àÂëͳһ£¬Í¬Ê±sqlµÄ²åÈëÓï¾äÖÐȷʵÊÇÖÐÎÄ£¬ÄÇ´æÈëµÄÊý¾Ý¿Ï¶¨ÊÇÖÐÎÄ
ÔÚmysql°²×°Ä¿Â¼Ï´ò¿ªmy.iniÎļþ£¬°Ñdefault_character_setµÄÖµ¸ÄΪutf8»òÕßgbk
Êý¾Ý¿â±àÂëÓùú¼Ê±ê×¼UTF-8±àÂë,²»¹Üʲô±àÂëµÄÊý¾Ý´¢´æÐÎʽ¶¼ÎªUTF-8
Êý¾Ý¿âÁ¬½Ó²ÉÓÃGBK ±àÂë,±£´æÈ¡³ö¾ÍÊÇGBK±àÂë.
Êý¾Ý¿âÁ¬½Ó²ÉÓÃis8859-1±àÂë,±£´æÈ¡³ö¾ÍÊÇis8859-1±àÂë.
ÔÚmysql°²×°Ä¿Â¼Ï´ò¿ªmy.iniÎļþ£¬°Ñdefault_character_setµÄÖµ¸ÄΪutf8»òÕßgbk
×îºÃÉèÖóÉutf8
mysql±àÂëÓÐÎÊÌâ°É£¬Ä㽫ÄãÊý¾Ý¿âµÄ±àÂë¸ÄΪutf8¾ÍºÃÁË
ÔÚmysql°²×°Ä¿Â¼Ï´ò¿ªmy.iniÎļþ£¬°ÑËùÓÐdefault-character-set=µÄÖµ¶¼»»³Égbk
ÈçºÎÖØÆô
ËùÓÐÊÂÇé¾Í¸ã¶¨ÁË
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÎÒÏ£ÍûÔÚ±à¼ÎÄ×Öºó°Ñ·¢Ëͼü¸Äµ½ÆÁÄ»Öм䣬¾ßÌå˵¾ÍÊÇ
ÔÚkb.classÖеIJ¿·Ö×÷³öÐÞ¸Ä
²¿·Ö´úÂ룺
V = new TextBox(ld.a(383), "", 190, 0);
X = new Comma ......
¸÷λ´ó¸ç:
ÏîÄ¿ÖÐÓö¼ûÒ»¸öÄÑÌâ,ÄǾÍÊÇÈçºÎÔÚÐÞ¸ÄÊý¾Ý¿âÀïÃæµÄij¸ö×Ö¶ÎÊÇÄܲúÉúÒ»¸öÏûÏ¢,ʵʱÌáÐѵ½Ê×Ò³ÄØ?
¶øÇÒ¿Í»§ÒªÇó¿ÉÒÔ×Ô¼º¶¨ÖÆÄÄЩ×Ö¶Î,±ÈÈçÓÐA,B,C×Ö¶Î,ÎÒ¿ÉÒÔÑ¡ÔñÆäÖÐÒ»¸ö»òÁ½¸ö×Ö¶Î,µ±ÕâÁ½¸ö×ֶΠ......