java读取mysql视图字段不符问题

遇到个问题在此记录一下。

假如mysql中有一个视图： create view test_view as(select t1.name as user_name,t1.age as user_age,t2.name as dname from user t1，department t2 where t1.did=t2.did )。java 程序中读取test_view的值：select  * from test_view。将结果加到map中会发现执行的结果为{“name":"张三”，“age":18}而不是{”user_name":"张三","user_age":18}。

解决该问题只需要将mysql的连接url加上蓝色部分：url="jdbc:mysql://127.0.0.1:3306/project?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true"