MyEclipse
mysql
在增删改查时出现乱码
安装MyEclipse和mysql软件(貌似废话),然后设置MyEclipse与mysql的连接jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8
设置MyEclipse文件编码。且跟mysql的连接编码一致set names gbk; SET character_set_client='utf8';SET character_set_connection='utf8';SET character_set_results='utf8';show variables like '%char%';SET character_set_client='utf8';SET character_set_connection ='utf8';SET character_set_database ='utf8';SET character_set_filesystem='utf8';SET character_set_results ='utf8';SET character_set_server ='utf8';SET character_set_system ='utf8';SET character_set_client='utf8';
建表就定义字符编码,且与之前定义的一致:create table recommentd(id int(255)not null primary key auto_increment,productUrl varchar(255)character set utf8,ImgUrl varchar(255)character set utf8,name varchar(255)character set utf8)ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
执行增删改查测试:
这是java开发的web程序经常出现烦人的乱码,在百度行五花八门,在此本人做一次齐全百发百中的分享,希望帮助到有困难的盆友