Spring JDBC表情符号不能存入数据库

ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8mb4;

JDBC解决方案:

//params
List<Object> params = Lists.newArrayList();

//sql
StringBuilder sql = new StringBuilder();
sql.append("INSERT into fxq_back_message(bank_id,content,create_date,is_delete,user_id,IMGS)" +
        " VALUES('"+entity.getBank().getId()+"','"+
        entity.getContent()+"','"+
        DateUtil.parseDateToStr(entity.getCreateDate(),"yyyy-MM-dd HH:mm:ss") +"','"+
        entity.getIsDelete()+"','"+entity.getBaseUser().getId()+"','"+entity.getImgs()+"')");
jdbcTemplate.execute("set names utf8mb4");
jdbcTemplate.execute(sql.toString());

关注公众号回复“书籍”就可以看大佬看得同款书籍了: