JSP+mysql无法进行中文CRUD（操作）CentOS8

1.保证JSP页面编码统一

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

2.获取参数时进行编码转换

request.setCharacterEncoding("UTF-8");

3.获取数据库链接时编码转换

jdbc:mysql://192.168.200.131:3306/yh?useUnicode=true&characterEncoding=UTF-8

4.mysql数据库设置编码

将mysql字符集设置如下：

show variables like 'character_set_%';

show variables like &