遇到个问题在此记录一下。
假如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"