public boolean create(Project project)  {
 String id = UUID.randomUUID().toString().toUpperCase().replace("-", "");
 project.setId(id);

    try {
        Class.forName("org.h2.Driver");
        Connection connection = DriverManager.getConnection("jdbc:h2:~/dao_db", "sa", "");
        PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO PROJECT VALUES(?, ?,?)");

        preparedStatement.setString(1, id);
        preparedStatement.setString(2, project.getName());
        preparedStatement.setString(3, project.getTrigram());
        int resultSet = preparedStatement.executeUpdate();

        if(resultSet!=0)
        {
            System.out.println("Project created");
            connection.close();
            return true;
        }

        else {
            System.out.println("No project was  created ");
            connection.close();
            return false;
        }

    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
    return false;

}

@Override
public boolean update(Project project){

    try {
        Class.forName("org.h2.Driver");

        Connection connection = DriverManager.getConnection("jdbc:h2:~/dao_db", "sa", "");
        PreparedStatement preparedStatement = connection.prepareStatement("UPDATE PROJECT SET NAME=?, TRIGRAM = ? WHERE ID=?");

        preparedStatement.setString(1, project.getName());
        preparedStatement.setString(2, project.getTrigram());
        preparedStatement.setString(3, project.getId());
        int resultSet = preparedStatement.executeUpdate();

        if(resultSet==0) {
            System.out.println("The project was not updated ");
            connection.close();
            return false;
        }
        else {
            System.out.println("Project updated" + 'n'+  project.toString());
            connection.close();
            return true;
        }

    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
    return false;
}

@Override
public boolean delete(String id) {

    try {
        Class.forName("org.h2.Driver");
        Connection connection = DriverManager.getConnection("jdbc:h2:~/dao_db", "sa", "");
        PreparedStatement preparedStatement = connection.prepareStatement("DELETE FROM PROJECT WHERE ID=?");
        preparedStatement.setString(1,id);
        int result = preparedStatement.executeUpdate();

        if(result!=0) {

            PreparedStatement preparedStatement2 = connection.prepareStatement("DELETE FROM MILESTONE WHERE FK_PROJECT_ID =?");
            preparedStatement2.setString(1,id);
            preparedStatement2.executeUpdate();

            PreparedStatement preparedStatement3 = connection.prepareStatement("DELETE FROM REQUIREMENT WHERE FK_PROJECT_ID =?");
            preparedStatement3.setString(1,id);
            preparedStatement3.executeUpdate();

            System.out.println("Project deleted with id = " + id);
            connection.close();
            return true;

        }

        else {
            System.out.println("No project was deleted with id = " + id);
            connection.close();
            return false;
        }

    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
    return false;
}