@Override public int update(AbstractBean ab) { CompanyBean companyBean = (CompanyBean) ab; String query = "update tbl_crm_company set companyName = ?, companyAddress = ?, companyPhone = ?, companyFax = ?, companyEmail = ?, status = ?, writeBy = ?, writeDate = ? where companyId = ?;"; try { preparedStatement = DBUtility.connection.prepareStatement(query); preparedStatement.setString(1, companyBean.getCompanyName()); preparedStatement.setString(2, companyBean.getCompanyAddress()); preparedStatement.setString(3, companyBean.getCompanyPhone()); preparedStatement.setString(4, companyBean.getCompanyFax()); preparedStatement.setString(5, companyBean.getCompanyEmail()); preparedStatement.setBoolean(6, companyBean.isStatus()); preparedStatement.setString(7, companyBean.getWriteBy()); preparedStatement.setTimestamp(8, new Timestamp(System.currentTimeMillis())); preparedStatement.setInt(9, companyBean.getCompanyId()); } catch (SQLException e) { ZLog.err("VNC CRM for Zimbra", "Error in update operation in CompanyHelper", e); } operationStatus = dbu.update(preparedStatement); return operationStatus; }