When JDBC and MyBatis connect the MySQL database, set the character set encoding

When JDBC connects to the MySQL database, set the character set encoding!!!

You can configure MySQL to include character set settings directly after the URL:

String url = "jdbc:mysql://localhost:3306/exceltest1?useunicode=true&characterencoding=utf-8& Zerodatetimebehavior=converttonull ";

MyBatis when connecting to the MySQL database, set the character set encoding!!!

Can be configured as follows, in the MyBatis configuration file to write this: (note to use the escape & Instead of &)

<property name= "url" value= "jdbc:mysql://localhost:3306/exceltest1?useunicode=true&amp;characterencoding= Utf-8&amp;zerodatetimebehavior=converttonull "/>

When JDBC and MyBatis connect the MySQL database, set the character set encoding