请问: nvarchar 值 '200310130001' 的转换溢出了 INT1 列。请使用较大的整数列?
seamg 2003-10-13 11:01:03 <ora:sqlQuery id="servicelist" dataSource="qsdb" >
SELECT Max(Service_TaskId) FROM Service
</ora:sqlQuery>
<% if (servicelist.isEmpty()) {taskId=curday+"0001";}
else
{Row servicerow=(Row)servicelist.get(0);
String tasId=servicerow.getString(1);
System.out.println(tasId);
if(curday.equals(tasId.substring(0,8))){
String add=""+Long.parseLong(tasId.substring(9))+1;
taskId=curday+add;
}else{taskId=curday+"0001";} }%
请帮忙!什么问题,Max(Service_TaskId)的原因吗?还是Long.parseLong?