Exemplo n.º 1
0
 public boolean update(Payment payment) {
   PreparedStatement statement = null;
   String sql =
       "UPDATE payment SET id_transaction = "
           + payment.getIdTransaction()
           + ", lens_price = "
           + payment.getLensPrice()
           + ", frame_price = "
           + payment.getFramePrice()
           + ", amount = "
           + payment.getAmount()
           + ", dp = "
           + payment.getDp()
           + ", agency = "
           + payment.getAgency()
           + ", variance= "
           + payment.getVariance()
           + " WHERE id_payment = "
           + payment.getIdPayment();
   try {
     statement = (PreparedStatement) connection.prepareStatement(sql);
     statement.executeUpdate();
     System.out.println(sql);
     return true;
   } catch (SQLException ex) {
     Logger.getLogger(PaymentDAO.class.getName()).log(Level.SEVERE, null, ex);
     return false;
   } finally {
     if (statement != null) {
       try {
         statement.close();
       } catch (SQLException ex) {
         Logger.getLogger(PaymentDAO.class.getName()).log(Level.SEVERE, null, ex);
       }
     }
   }
 }
Exemplo n.º 2
0
 public boolean insert(Payment payment) {
   PreparedStatement statement = null;
   String sql =
       "INSERT INTO payment VALUES ("
           + payment.getIdPayment()
           + ", "
           + payment.getIdTransaction()
           + ", "
           + payment.getLensPrice()
           + ", "
           + payment.getFramePrice()
           + ", "
           + payment.getAmount()
           + ", "
           + payment.getDp()
           + ", "
           + payment.getAgency()
           + ", "
           + payment.getVariance()
           + ")";
   try {
     statement = (PreparedStatement) connection.prepareStatement(sql);
     statement.executeUpdate();
     return true;
   } catch (SQLException ex) {
     Logger.getLogger(PaymentDAO.class.getName()).log(Level.SEVERE, null, ex);
     return false;
   } finally {
     if (statement != null) {
       try {
         statement.close();
       } catch (SQLException ex) {
         Logger.getLogger(PaymentDAO.class.getName()).log(Level.SEVERE, null, ex);
       }
     }
   }
 }