Skip to content

Latest commit

 

History

History
68 lines (55 loc) · 1.56 KB

README.md

File metadata and controls

68 lines (55 loc) · 1.56 KB

Database

Connect

protected boolean conect() {
  try {
    Class.forName(driver);
		cn = DriverManager.getConnection(url + database, user, password);
		return true;
    } catch (ClassNotFoundException e) {
      logger.warning(e.getMessage());
      return false;
    } catch (SQLException e) {
      logger.warning(String.format("Code: %s | Message: %s", e.getErrorCode(), e.getMessage()));
		return false;  
    }
}

Disconnect

protected boolean disconect() {
  try {
    cn.close();
    return true;
  } catch (SQLException e) {
    logger.warning(String.format("Code: %s | Message: %s", e.getErrorCode(), e.getMessage()));
  }
  return false;
}

Interface

public Person insert(Person person);
public Person update(int id, Person personUpdated);
public Person delete(int id);
public List<Person> getAll();
public Person findById(int id);
public List<Person> list(int[] listPerson);

PersonDAO