Oracle数据库表里是testNum number(2)
Java类里的属性是testNum int
但是我用this.getSession().createSQLQuery(sql)查询出来的结果对象里对应的属性却是bigdecimal
所以必须进行类型强转,否则报错类型转换错误。
这里该怎么处理,让从数据查询出来的数据就是int类型,而不是bigdecimal呢?谢谢。
java.lang.ClassCastException: [Ljava.lang.Object;
width="728" height="90" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" id="aswift_1" name="aswift_1" style="box-sizing: content-box; left: 0px; position: absolute; top: 0px;">
-
id="iframeu1636200_0" src="http://pos.baidu.com/bcjm?rdid=1636200&dc=2&di=u1636200&dri=0&dis=0&dai=2&ps=907x268&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1461741518986&ti=oracle%E9%87%8C%E5%AD%98%E7%9A%84%E6%98%AFnumber%E7%B1%BB%E5%9E%8B%2Cjava%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%9D%A5%E7%9A%84%E5%AF%B9%E8%B1%A1%E5%B1%9E%E6%80%A7%E6%98%AFbigdecimal%E7%B1%BB%E5%9E%8B%EF%BC%8C%E8%AF%A5%E6%80%8E%E4%B9%88%E8%A7%A3%E5%86%B3%EF%BC%9F-CSDN%E8%AE%BA%E5%9D%9B-&ari=1&dbv=2&drs=3&pcs=1114x553&pss=1114x3561&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1461741518<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390075163<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DgbZbWBzYX3VZ6eR6xNBBbsUqX7E7A5qvWkceBIZ992UXMeO-4uFryyEFLjDrWmXw%26wd%3D%26eqid%3Dcd1b7d6900009eb700000005572067a0&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1461741519&qn=b14d1c0e3ca0cd4f&tt=1461741518966.26.312.314" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
-
id="iframeu1636201_0" src="http://pos.baidu.com/bcjm?rdid=1636201&dc=2&di=u1636201&dri=0&dis=0&dai=3&ps=907x522&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1461741518986&ti=oracle%E9%87%8C%E5%AD%98%E7%9A%84%E6%98%AFnumber%E7%B1%BB%E5%9E%8B%2Cjava%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%9D%A5%E7%9A%84%E5%AF%B9%E8%B1%A1%E5%B1%9E%E6%80%A7%E6%98%AFbigdecimal%E7%B1%BB%E5%9E%8B%EF%BC%8C%E8%AF%A5%E6%80%8E%E4%B9%88%E8%A7%A3%E5%86%B3%EF%BC%9F-CSDN%E8%AE%BA%E5%9D%9B-&ari=1&dbv=2&drs=3&pcs=1114x553&pss=1114x3561&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1461741518<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390075163<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DgbZbWBzYX3VZ6eR6xNBBbsUqX7E7A5qvWkceBIZ992UXMeO-4uFryyEFLjDrWmXw%26wd%3D%26eqid%3Dcd1b7d6900009eb700000005572067a0&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1461741519&qn=e0f917a3fdd5b9e0&tt=1461741518966.28.319.323" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
-
id="iframeu1636204_0" src="http://pos.baidu.com/bcjm?rdid=1636204&dc=2&di=u1636204&dri=0&dis=0&dai=4&ps=907x776&dcb=BAIDU_SSP_define&dtm=BAIDU_DUP_SETJSONADSLOT&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1461741518986&ti=oracle%E9%87%8C%E5%AD%98%E7%9A%84%E6%98%AFnumber%E7%B1%BB%E5%9E%8B%2Cjava%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%9D%A5%E7%9A%84%E5%AF%B9%E8%B1%A1%E5%B1%9E%E6%80%A7%E6%98%AFbigdecimal%E7%B1%BB%E5%9E%8B%EF%BC%8C%E8%AF%A5%E6%80%8E%E4%B9%88%E8%A7%A3%E5%86%B3%EF%BC%9F-CSDN%E8%AE%BA%E5%9D%9B-&ari=1&dbv=2&drs=3&pcs=1114x553&pss=1114x3561&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1461741518<u=http%3A%2F%2Fbbs.csdn.net%2Ftopics%2F390075163<r=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DgbZbWBzYX3VZ6eR6xNBBbsUqX7E7A5qvWkceBIZ992UXMeO-4uFryyEFLjDrWmXw%26wd%3D%26eqid%3Dcd1b7d6900009eb700000005572067a0&ecd=1&psr=1366x768&par=1366x728&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1461741519&qn=ea72a5d28553bc58&tt=1461741518966.30.325.326" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">