关于jdbc + mysql utf-8 乱码

来源:互联网 发布:three.js webgl 编辑:程序博客网 时间:2024/06/03 23:12
1.JDBC URL
   <property name="jdbcUrl">
      <value>jdbc:mysql://localhost:3306/lei?useUnicode=true&amp;characterEncoding=UTF-8</value>
   </property>


2.用MySQL命令查询:show variables like "%char%";显示:
character_set_client     utf8
character_set_connection     utf8
character_set_database     utf8
character_set_filesystem     binary
character_set_results     utf8
character_set_server    utf8
character_set_system    utf8

3.MY.INI
[client]
port=3306

[mysql]

default-character-set=utf-8

[mysqlID]

character-set=utf-8


4.程序本身(在action里面写了防止乱码的代码)
// 获得servletAPI
HttpServletResponse response = ServletActionContext.getResponse();
HttpServletRequest request = ServletActionContext.getRequest();


5.jsp 页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>


0 0