// public static void update(Commande obj) {
// Connection dbConnection = null ;
// PreparedStatement preparedStatement = null;
// try{
// dbConnection = DaoCon.getCon();
// preparedStatement = dbConnection.prepareStatement(updateQuery);
// preparedStatement.setInt(1, obj.getClient().getId());
// preparedStatement.setString(2, obj.getAdresse());
// preparedStatement.setDate(3, new java.sql.Date(obj.getDate().getTime()));
// preparedStatement.setString(4, obj.getEtat().toString());
// preparedStatement.setInt(5, obj.getId());
// preparedStatement.executeUpdate();
// }catch (Exception e){
// e.printStackTrace();
// }finally{
// DaoCon.close(dbConnection, preparedStatement);
// }
// }
public static void update(Commande obj) {
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
try {
dbConnection = DaoCon.getCon();
preparedStatement = dbConnection.prepareStatement(updateQuery);
preparedStatement.setString(1, obj.getEtat().toString());
preparedStatement.setInt(2, obj.getId());
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DaoCon.close(dbConnection, preparedStatement);
}
}
public static void delete(int id) {
DaoPlaCom.delete(id);
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
try {
dbConnection = DaoCon.getCon();
preparedStatement = dbConnection.prepareStatement(deleteQuery);
preparedStatement.setInt(1, id);
preparedStatement.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
DaoCon.close(dbConnection, preparedStatement);
}
}
public static List<Commande> getAll(boolean bool) {
List<Commande> commandes = new ArrayList<Commande>();
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
ResultSet rs = null;
try {
dbConnection = DaoCon.getCon();
preparedStatement = dbConnection.prepareStatement(getAllQuery);
rs = preparedStatement.executeQuery();
while (rs.next()) {
commandes.add(mapRes(rs, bool));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DaoCon.close(dbConnection, preparedStatement, rs);
}
return commandes;
}
public static Commande find(int id) {
Commande commande = null;
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
ResultSet rs = null;
try {
dbConnection = DaoCon.getCon();
preparedStatement = dbConnection.prepareStatement(findQuery);
preparedStatement.setInt(1, id);
rs = preparedStatement.executeQuery();
while (rs.next()) {
commande = mapRes(rs);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DaoCon.close(dbConnection, preparedStatement, rs);
}
return commande;
}
public static void create(Commande obj) {
Connection dbConnection = null;
PreparedStatement preparedStatement = null;
try {
dbConnection = DaoCon.getCon();
preparedStatement =
dbConnection.prepareStatement(createQuery, Statement.RETURN_GENERATED_KEYS);
preparedStatement.setInt(1, obj.getClient().getId());
preparedStatement.setString(2, obj.getAdresse());
preparedStatement.setTimestamp(3, new java.sql.Timestamp(obj.getDate().getTime()));
preparedStatement.setString(4, obj.getEtat().toString());
// preparedStatement.executeUpdate();
int affectedRows = preparedStatement.executeUpdate();
if (affectedRows == 0) {
throw new SQLException("Creating user failed, no rows affected.");
}
try (ResultSet generatedKeys = preparedStatement.getGeneratedKeys()) {
if (generatedKeys.next()) {
// System.out.println("ID of the last commande = "+generatedKeys.getLong(1));
obj.setId(generatedKeys.getInt(1));
for (PlaCom p : obj.getPlacoms()) {
p.setCommande(obj);
DaoPlaCom.create(p);
}
} else {
throw new SQLException("Creating command failed, no ID obtained.");
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DaoCon.close(dbConnection, preparedStatement);
}
}
