Created
September 3, 2014 20:59
-
-
Save Romain-P/be1fcf9e7d484efd2f00 to your computer and use it in GitHub Desktop.
More safe please ?
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package org.jumbo.backend.database.example; | |
| import lombok.Getter; | |
| import org.jumbo.commons.sql.model.annotations.PrimaryQueryField; | |
| import org.jumbo.commons.sql.model.annotations.QueryField; | |
| /** | |
| * Created by Return on 03/09/2014. | |
| */ | |
| public class Example { | |
| @Getter | |
| @PrimaryQueryField | |
| private int id; | |
| @Getter | |
| @QueryField | |
| private String name; | |
| @Getter | |
| @QueryField | |
| private String objective; | |
| public Example() {} | |
| public Example(int id, String name, String objective) { | |
| this.id = id; | |
| this.name = name; | |
| this.objective = objective; | |
| } | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package org.jumbo.backend.database.example; | |
| import lombok.extern.slf4j.Slf4j; | |
| import org.jumbo.commons.sql.QueryManager; | |
| import org.jumbo.commons.sql.exceptions.BadPutFieldTypeException; | |
| import org.jumbo.commons.sql.exceptions.BadQueryFormationException; | |
| import org.jumbo.commons.sql.model.Query; | |
| import org.jumbo.commons.sql.model.QueryModel; | |
| import org.jumbo.commons.sql.model.enums.OnlyExecuteQueryEnum; | |
| import java.sql.SQLException; | |
| /** | |
| * Created by Return on 03/09/2014. | |
| */ | |
| @Slf4j | |
| public class ExampleManager extends QueryManager<Example> { | |
| public ExampleManager() { | |
| super(new QueryModel<>("example", new Example()).schematize()); | |
| } | |
| @Override | |
| public boolean create(Example obj) { | |
| try { | |
| Query query = model.createNewQuery() | |
| .setData("id", obj.getId()) | |
| .setData("name", obj.getName()) | |
| .setData("objective", obj.getObjective()); | |
| execute(query, OnlyExecuteQueryEnum.CREATE); | |
| } catch (BadPutFieldTypeException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } catch (SQLException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } catch (BadQueryFormationException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } | |
| return true; | |
| } | |
| @Override | |
| public boolean delete(Example obj) { | |
| try { | |
| execute(model, obj.getId(), OnlyExecuteQueryEnum.CREATE); | |
| } catch (BadPutFieldTypeException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } catch (SQLException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } catch (BadQueryFormationException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } | |
| return true; | |
| } | |
| @Override | |
| public boolean update(Example obj) { | |
| try { | |
| Query query = model.createNewQuery() | |
| .setData("id", obj.getId()) | |
| .setData("name", obj.getName()) | |
| .setData("objective", obj.getObjective()); | |
| execute(query, OnlyExecuteQueryEnum.UPDATE); | |
| } catch (BadPutFieldTypeException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } catch (SQLException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } catch (BadQueryFormationException exception) { | |
| log.error(exception.getMessage()); | |
| return false; | |
| } | |
| return true; | |
| } | |
| @Override | |
| public Example load(Object primary) { | |
| try { | |
| Query query = createNewQuery(primary); | |
| return new Example( | |
| (int) query.getData().get("id"), | |
| (String) query.getData().get("name"), | |
| (String) query.getData().get("objective")); | |
| } catch (SQLException exception) { | |
| log.error(exception.getMessage()); | |
| return null; | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment