/** 增加批准建议 */ public boolean addRatifyAdvice(RatifyAdvice ratifyAdvice) throws ManagerException { boolean r = false; DBUtil db = new DBUtil(); String delSql = "delete TD_SD_RATIFYADVICE where SCHEDULAR_ID = " + ratifyAdvice.getSchedularID() + ""; String sql = "insert into TD_SD_RATIFYADVICE (SCHEDULAR_ID,RATIFIER_ID,advice) values(" + ratifyAdvice.getSchedularID() + "," + ratifyAdvice.getRatifierID() + ",'" + ratifyAdvice.getAdvice() + "')"; try { db.executeDelete(delSql); db.executeInsert(sql); r = true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return r; }