Java connection to MySQL database 2

When MySQL is used, it is inevitable to encounter a common problem in the use of this database. These problems are generally known as Baidu and Google, and MySQL is popular.
1. Chinese Garbled text.
My solution:
1) when the database is connected, the URL address is: JDBC: mysql: // 192.168.1.2: 3306/nlt? User = root & Password = nlt & useunicode = true & characterencoding = GBK
2) In my. ini configuration file
Client Section
[Client]
Port = 3306
[MySQL]
Default-character-set = GBK
# Server section
[Mysqld]
Default-character-set = GBK
Refer to the Article (to) MySQL key to garbled code processing summary
3) If you have created a table, you can modify the DB. Opt configuration file in the corresponding database directory in the data directory.
Default-character-set = GBK
Default-collation = gbk_chinese_ci