コード例 #1
0
ファイル: PlanningFactDAO.java プロジェクト: musictang/algem
 public void insert(PlanningFact fact) throws Exception {
   String query =
       String.format(
           "INSERT INTO planning_fact VALUES (DEFAULT, '%s', '%s', %d, %d, '%s', '%s', %d, %d, '%s')",
           toTimeStamp(fact.getDate()),
           fact.getType().toDBType(),
           fact.getPlanning(),
           fact.getProf(),
           escape(fact.getCommentaire()),
           minutesToPGInterval(fact.getDureeMinutes()),
           fact.getStatut(),
           fact.getNiveau(),
           escape(fact.getPlanningDescription()));
   dataConnection.executeUpdate(query);
 }
コード例 #2
0
ファイル: PlanningFactDAO.java プロジェクト: musictang/algem
 public void update(PlanningFact fact) throws Exception {
   if (fact.getId() == -1)
     throw new IllegalArgumentException("Cannot save transient fact " + fact);
   String query =
       String.format(
           "UPDATE planning_fact "
               + "SET date = '%s', type = '%s', planning = %d, prof =  %d, commentaire = '%s', duree = '%s', statut = %d, niveau = %d, planning_desc = '%s' "
               + "WHERE id = "
               + fact.getId(),
           toTimeStamp(fact.getDate()),
           fact.getType().toDBType(),
           fact.getPlanning(),
           fact.getProf(),
           escape(fact.getCommentaire()),
           minutesToPGInterval(fact.getDureeMinutes()),
           fact.getStatut(),
           fact.getNiveau(),
           escape(fact.getPlanningDescription()));
   dataConnection.executeUpdate(query);
 }