jdbc mysql写入中文乱码解决

mysql> create database dbnameDEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

drop table if exists `test`;
create table `test` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) default '',
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

url: jdbc:mysql://host:port/dbname

url: jdbc:mysql://host:port/dbname?characterEncoding=utf8