Windows平台eclipse连接Mysql解决方案

1、  eclipse的db.properties配置

       db.driverClassName=com.mysql.jdbc.Driver
       db.url=jdbc:mysql://localhost:3306/“数据库名”?characterEncoding=utf8
       db.username=用户登录名
       db.password=用户密码

2、  mysql字符集设置为utf8
           

       mysql> show variables like '%character%';
       +--------------------------+-----------------------------+
       | Variable_name            | Value                       |
       +--------------------------+-----------------------------+
       | 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                        |
       | character_sets_dir       | H:\MySQL5.5\share\charsets\ |
       +--------------------------+-----------------------------+
       8 rows in set (0.00 sec)

              设置语句是：

             

       mysql> SET character_set_client = utf8 ;
       mysql> SET character_set_connection = utf8 ;
       mysql> SET character_set_database = utf8 ;
       mysql> SET character_set_results = utf8 ;
       mysql> SET character_set_server = utf8 ;
       mysql> SET character_set_system= utf8 ;

              查看数据库的字符集：

       mysql> status;
       --------------
       mysql  Ver 14.14 Distrib 5.5.40, for Win32 (x86)

       Connection id:          2040
       Current database:       dating_test
       Current user:           root@localhost
       SSL:                    Not in use
       Using delimiter:        ;
       Server version:         5.5.40 MySQL Community Server (GPL)
       Protocol version:       10
       Connection:             localhost via TCP/IP
       Server characterset:    utf8
       Db     characterset:    utf8
       Client characterset:    utf8
       Conn.  characterset:    utf8
       TCP port:               3306
       Uptime:                 23 hours 16 min 37 sec

       Threads: 1  Questions: 20178  Slow queries: 6  Opens: 109  Flush tables: 1  Open
       tables: 0  Queries per second avg: 0.240
       --------------

              如果数据库 Db characterset字符集不是utf8，是系统默认的latin1:

       Db     characterset:    latin1

              用下面的语句把之前设置字符集之前创建的数据库字符集改为utf8;

       mysql> SET character_set_database = utf8 ;

3、  Windows的DOS窗口默认的是GBK编码，所以在DOS窗口输入的语句中汉字是无法插入到utf8字符集数据库中的，会报以下错误。

            

       RROR 1366 (HY000): Incorrect string value:……

              解决方法： 下载navicat，真的很好用（支持windows、linux和mac OS），以后就用它做mysql图形工具了。

            链接：http://pan.baidu.com/s/1dD4UkHN 密码：zu4s