DaoImpl:
public <T> List<T> queryNativeSql(Class<T> entityClass, String sql) {
Session session = super.getSession(false);
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(entityClass);
List<T> list = query.list();
return list;
}ServiceImpl:
String sql="select count(*) from t_adwords_campagin t ";
List lst=super.queryNativeSql(sql);
Object[] object = (Object[]) lst.get(0);
String count =object[0].toString();抛错:
java.lang.ClassCastException: java.math.BigDecimal cannot be cast to [Ljava.lang.Object;
要怎么做啊获取count啊????????????????????????
public <T> List<T> queryNativeSql(Class<T> entityClass, String sql) {
Session session = super.getSession(false);
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(entityClass);
List<T> list = query.list();
return list;
}ServiceImpl:
String sql="select count(*) from t_adwords_campagin t ";
List lst=super.queryNativeSql(sql);
Object[] object = (Object[]) lst.get(0);
String count =object[0].toString();抛错:
java.lang.ClassCastException: java.math.BigDecimal cannot be cast to [Ljava.lang.Object;
要怎么做啊获取count啊????????????????????????
解决方案 »
- 迷茫 我该怎么办?
- 加线条验证码自动识别
- 迷茫了~~~~ 学完SSH 不知道学什么了 高手请帮忙
- spring bean 什么时候设置singleton=false什么时候设置singleton=true
- jar文件运行时向物理盘写入文件问题
- Spring上传问题
- hibernate保存的问题
- 急问:struts里点击导航栏,主页报错“Servlet action is not available”
- 初学者求助:jtable的问题,茫然不知所措ing,焦急等待ing....
- 请问哪里有netscape的ldap server 下载?
- commons-beanutils-core.jar等这些jar文件应该在哪里找呢?
- java中如何调用接口啊 webservice
String count =object.toString();
long count = ((BigDecimal)lst.get(0)).longValue();
可这样,又该怎么获取这两个值呢?继续郁闷中!!!!!!!!
String sql="select sum(clicks),count(clicks) from t_adwords_campagin t ";
List lst=super.queryNativeSql(sql);
long sum = ((BigDecimal)object[0]).longValue();
long count = ((BigDecimal)object[1]).longValue();
搞定。