JDBC even MySQL garbled problem:

Last night jumped out of such a bug, hurriedly solve, for the database course design Assault JSP, really met a lot of problems ...

Just like the utf8mb4_unicode_ci I used to say in MySQL,

Then, the main reason for garbled characters is that the character encoding (characterencoding) is incorrect:

1. There is no option to support Chinese encoding when creating tables on the database server

2. The JDBC connection was not specified to support the Chinese encoding method

That's what I wrote:

" Jdbc:mysql://127.0.0.1/librarysystem;

Obviously the second one doesn't fit,

Specify the Chinese code to solve the problem.

" Jdbc:mysql://127.0.0.1/librarysystem?userunicode=true&characterencoding=utf8 ";

JDBC even MySQL garbled problem: