### 1、查看msyql字符集 ``` show variables like 'char%'; ``` ### 2、sudo vim /etc/my.cnf,加上如下配置 ``` [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 default-character-set=utf8 # 加上这句话 default-character=utf8 # 加上这句话 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] # 加上这句话 default-character-set=utf8 # 加上这句话 ``` ### 3、重启mysql ``` sudo service mysqld restart ``` ### 4、创建数据库,指定utf-8 编码格式 ``` CREATE DATABASE myweb default charset utf8 COLLATE utf8_general_ci; ``` ### 5、创建表,指定utf-8 编码格式 ``` USE myweb; CREATE TABLE class ( class_id BIGINT NOT NULL COMMENT '班级id', class_name VARCHAR(256) NOT NULL COMMENT '班级名称', class_master VARCHAR(256) NOT NULL COMMENT '班主任', PRIMARY KEY (class_id) )ENGINE =InnoDB DEFAULT CHARSET=utf8 COMMENT ='班级表'; ``` ### 6、java-mysql连接设置成utf8 ``` jdbc:mysql://master:3306/myweb?useUnicode=true&characterEncoding=utf8 ``` ### 7、设置html页面 ``` Hello World ``` ### 8、设置rest方式返回的json编码 ``` @RequestMapping(value = "/getStudentInfo", method = RequestMethod.GET, produces = "application/json; charset=utf-8") ```