コード例 #1
0
  public void editEntry(final String permId, final String oldEmail, final AddressBkEntry entry)
      throws AddressBkDAOException {
    Connection con = null;
    try {
      con = getConnection();
      PreparedStatement ps = null;
      try {
        ps =
            con.prepareStatement(
                "UPDATE abkPerson SET name=?, company=?, position=?, phoneHome=?, phoneWork=?, phoneCell=?, address=?, notes=? WHERE contactId=(SELECT contactId FROM abkEmail WHERE userId=? AND email=? LIMIT 1)");
        ps.setString(1, entry.getPersonal());
        ps.setString(2, entry.getCompany());
        ps.setString(3, entry.getPosition());
        ps.setString(4, entry.getPhoneHome());
        ps.setString(5, entry.getPhoneWork());
        ps.setString(6, entry.getPhoneCell());
        ps.setString(7, entry.getMailingAddress());
        ps.setString(8, entry.getNotes());
        ps.setString(9, permId);
        ps.setString(10, oldEmail);
        int count = ps.executeUpdate();

        if (count == 0) {
          throw new AddressBkDAOException(
              "Address book edit failed for entry: " + entry.toString());
        }

        ps = con.prepareStatement("UPDATE abkEmail set email=? WHERE userId=? AND email=?");
        ps.setString(1, entry.getAddress());
        ps.setString(2, permId);
        ps.setString(3, oldEmail);

        count = ps.executeUpdate();

        if (count == 0) {
          throw new AddressBkDAOException(
              "Address book edit failed for entry: " + entry.toString());
        }

      } finally {
        if (ps != null) {
          ps.close();
        }
      }
      // con.close();
    } catch (Exception e) {
      try {
        if (con != null) {
          con.close();
        }
      } catch (SQLException se) {
        logger.error(se.getMessage(), se);
      }
      throw new AddressBkDAOException(e.getMessage());
    }
  }
コード例 #2
0
  public void addEntry(final String permId, final AddressBkEntry entry)
      throws AddressBkDAOException {
    Connection con = null;
    try {
      con = getConnection();
      PreparedStatement ps = null;
      try {

        ps =
            con.prepareStatement(
                "INSERT INTO abkPerson "
                    + "(userId, name,company,position,phoneHome,phoneWork,phoneCell,address,notes) "
                    + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
                Statement.RETURN_GENERATED_KEYS);
        ps.setString(1, permId);
        ps.setString(2, entry.getPersonal());
        ps.setString(3, entry.getCompany());
        ps.setString(4, entry.getPosition());
        ps.setString(5, entry.getPhoneHome());
        ps.setString(6, entry.getPhoneWork());
        ps.setString(7, entry.getPhoneCell());
        ps.setString(8, entry.getMailingAddress());
        ps.setString(9, entry.getNotes());

        int count = ps.executeUpdate();

        if (count == 0) {
          throw new AddressBkDAOException(
              "Address book insert failed for entry: " + entry.toString());
        }

        ResultSet keys = ps.getGeneratedKeys();

        int key = -1;

        while (keys.next()) key = keys.getInt(1);

        if (key <= 0)
          throw new AddressBkDAOException("Error retrieving index from abkPerson entry!");

        ps =
            con.prepareStatement("INSERT INTO abkEmail(userId, contactId, email) VALUES (?, ?, ?)");
        ps.setString(1, permId);
        ps.setString(2, (new Integer(key)).toString());
        ps.setString(3, entry.getAddress());

        count = ps.executeUpdate();

        if (count == 0) {
          throw new AddressBkDAOException(
              "Address book insert failed for entry: " + entry.toString());
        }

      } finally {
        if (ps != null) {
          ps.close();
        }
      }
      con.close();
    } catch (Exception e) {
      try {
        if (con != null) {
          con.close();
        }
      } catch (SQLException se) {
        logger.error(se.getMessage(), se);
      }
      throw new AddressBkDAOException(e.getMessage());
    }
  }