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.网上教程很多.注意权限.权限不对配置文件不生效