DbUtils 的 QueryRunner 查询的sql语句带中文,查不到结果!!

Question

rt

QueryRunner runner = new QueryRunner(JDBCUtils.getDataSource());
runner.query(sql, new BeanListHandler<>(CityBean.class));

sql语句带中文.用原生的Connection 对象链接数据库时设置编码就没问题.
String url = "jdbc:mysql://localhost:3306/abc?useSSL=true&characterEncoding=utf8";
Connection conn = DriverManager.getConnection(url,"root","abc");

Answer 1

把数据库的服务语言修改成utf8.网上教程很多.注意权限.权限不对配置文件不生效