ORA-01841: (full) year must be between -4713 and +9999, and not be 0
造成这个错误是因为把=号和'号之间加了个空格,如下
改成下边这样就没问题:
注意
和
黑色头发:http://heisetoufa.iteye.com/
造成这个错误是因为把=号和'号之间加了个空格,如下
String SQL = "SELECT consumption FROM dzjc.bookUse WHERE consumptionclass = '"+consumptionclass+"' " ;
改成下边这样就没问题:
String SQL = "SELECT consumption FROM dzjc.bookUse WHERE consumptionclass ='"+consumptionclass+"' " ;
注意
consumptionclass = '"+consumptionclass+"'
和
consumptionclass ='"+consumptionclass+"'
的差别
黑色头发:http://heisetoufa.iteye.com/