本帖最后由 zhangyouyuangod 于 2018-6-21 21:10 编辑
为什么我给的String类型的参数都取到了,Decimal类型的参数取不到值(就拿ZDMJ这个字段来说,传过来的参数是有值的)。下面是我的JAVA代码- public static void insertDJ_ZDJBXX(String ZDDM,String BDCDYH,String TDZL,String QLXZ,String QLLX,String QLRMC,String QLSDFS,BigDecimal ZDMJ,String YT,BigDecimal JG,BigDecimal RJL,BigDecimal JZMD,BigDecimal JZXG){
- String sql = "insert into DJ_ZDJBXX a (a.ID,a.ZDDM,a.BDCDYH,a.DWMC,a.DW,a.TDZL,a.QLXZ,a.QLLX,a.BDCLX,a.BDCLXMC,a.QLRMC,a.QLSDFS,a.ZDMJ,a.YT,a.JG,a.RJL,a.JZMD,a.JZXG,a.ZT,a.ZTMC,a.SFYX,a.CJSJ,a.BZ5) VALUES (SEQ_DJ_ZDJBXX.NEXTVAL,'"+ZDDM+"','"+BDCDYH+"','平方米','1','"+TDZL+"','"+QLXZ+"','"+QLLX+"','0','包含土地','"+QLRMC+"','"+QLSDFS+"','"+ZDMJ+"','"+YT+"','"+JG+"','"+RJL+"','"+JZMD+"','"+JZXG+"','1','现势','1',sysdate,'不动产权证书(净地)补录')";
- System.out.println(sql + "==================");
- SQL.executeUpdate(sql, null, "/rightResearch/rightResearch/recordTest/data",null);
- };
复制代码 |