DataAccessUtil dau =new DataAccessUtil();
String sql = "UPDATE BPM_WORKLIST SET STATUS ='COMPLETED' , ENDDATE=to_date(?,'yyyy-MM-dd hh24:mi:ss' ) WHERE TASKID=? " ;
SimpleDateFormat f=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
java.util.Date utilDate=new Date();
String date = f.format(utilDate);
java.sql.Date sqlDate=new java.sql.Date(utilDate.getTime());
dau.addParamString(1, date);
dau.addParamString(2, taskId);
dau.excuteSql(sql);
sql = "UPDATE BPM_PROCINST SET FINISHEDDATE ='' WHERE INSTID IN ( SELECT INSTID FROM BPM_WORKLIST WHERE TASKID=?)" ;
dau.addParamString(1, taskId);
// pm.completeTask(taskId, paras);
return dau.excuteSql(sql);