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Îļþ£¬ÀïÃæÓÐÁ½¸ö½Úµã¿ÉÒÔ¸ü¸Ä±àÂ뷽ʽ
Ïà¹ØÎÊ´ð£º
<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wang.connectDB"/>
< ......
import java.io.*;
class FileTest
{
public static void main(String [] args) throws Exception
{
File fDir=new File(File.separator);
String strFile="javaÔ´´úÂë²âÊÔ"+File.separato ......
ÎÒÃÇÓÐÏîÄ¿Ïë×齨һ¸ö¿ª·¢ÍŶӣ¬
Ö÷ÒªÓà tomcat,java,struts2,ÎÒÃǵĺËÐijÉÔ±¶¼ÊǾÑé·Ç³£·á¸»µÄϵͳÉè¼ÆÊ¦£¬
Èç¹ûÄúÔÚÌì½ò£¬Í¬Ê±¶Ôjava±È½Ï¸ÐÐËȤ£¬
¿ÉÒÔ¼ÓÈëÎÒÃÇ¡£
Ï£ÍûÒªÇó
1¡£°®ºÃ±à³Ì
......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
Ïë換個µØ·½¹¤×÷£¬²»ÊÇ´ó連¾ÍÐУ¬
java對ÈÕÍâ°ü4Äê經驗£¬ÈÕ語3級£¬±¾¿Æ
ÓÐÄÄλ´ó´ó給ÍÆÒ»個Ŷ
ÉϺ£±±¾©ºÜ¶àµÄ£¬È¥´³Ò»Ï°É
¶ÔÈյϹÐÐ.
ÄãÔõô² ......