转换object类型数据出现转换类型错误
在使用原生sql进行数据查询时,得到object类型数据进行类型转换时,一直报错,但是类型转化的写法正确,此时需要考虑的造成出错原因可能在于原生sql的查询的数据列仅有一列当使用newlist.get(0)[0]取数据就会出现类型转化错误,
下边是Java代码
下边是Java代码
String startDate = appDataInfo.getDateTime();
String queryName = "";
if("7".equals(handleType)){
queryName = "t.`userChurn_seven`";
}else if("14".equals(handleType)){
queryName = "t.`userChurn_Fourteen`";
}else{
queryName = "t.`userChurn_Thirty`";
}
String sqlnext = "SELECT "+queryName+" FROM `entplus_data_analysis`.`app_data_analysis_user_churn` t WHERE DATE(t.`log_time`)" +
" = (SELECT '"+startDate+"' - INTERVAL + 1 DAY) AND t.`fromOsType` = '" +fromOsType+"'";
Session newsession = logUserVisitFocusDao.getSessionFactory().getCurrentSession();
List<Object[]> newlist = session.createSQLQuery(sqlnext).list();
if(newlist != null && newlist.size()>0){
if(newlist.get(0)[0] != null){
appDataInfo.setUserChurn_new(appDataInfo.getUserChurn()- Integer.parseInt(newlist.get(0)[0].toString()));
}else{
appDataInfo.setUserChurn_new(0);
}
}else{
appDataInfo.setUserChurn_new(0);
}
仅查询一个数据列的sql情况下出现了,下边的错误
SELECT
t.`userChurn_seven`
FROM
`entplus_data_analysis`.`app_data_analysis_user_churn` t
WHERE
DATE(t.`log_time`) = (
SELECT
'2015-07-18' - INTERVAL + 1 DAY
)
AND t.`fromOsType` = 'android'
java.lang.ClassCastException: java.lang.Integer cannot be cast to [Ljava.lang.Object;
at com.entplus.appDataAnalysis.service.AppDataAnalysisService.queryUserChurnDataInfo(AppDataAnalysisService.java:3500)
at com.entplus.appDataAnalysis.service.AppDataAnalysisService$$FastClassBySpringCGLIB$$68d