更新的java代码

/** * 更新日报 * @param dayreport * @return */public int updateDayreport(Dayreport dayreport) {int flag = 0;String sql = "update s_dayreport set `taskDate`=?,`isWorkDay`=?,`isAway`=?,`awayAddr`=?,`desc`=?,`workStatusId`=? where dayReportId=?";con = new DBUtlie().getConnection();try{ps= con.prepareStatement(sql);ps.setDate(1,dayreport.getTaskDate());ps.setInt(2, dayreport.getIsWorkDay());ps.setInt(3, dayreport.getIsAway());ps.setString(4, dayreport.getAwayAddr());ps.setString(5, dayreport.getDesc());ps.setInt(6, dayreport.getWorkStatusId());ps.setInt(7, dayreport.getDayReportId());ps.executeUpdate();flag = 1;System.out.println("************************* update it's ok!");}catch (Exception e) {e.printStackTrace();}finally{try{con.close();ps.close();}catch (Exception e) {e.printStackTrace();}}return flag;}