1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| public class DAO {
private final DataSource myDataSource;
public DAO(DataSource dataSource) {
this.myDataSource = dataSource;
}
public int addOrder(int ordernum, int idcustomer, int idproduct, int quantity, int shippingcost, Date salesDate, Date shippingDate, String company) throws SQLException {
int result = 0;
String sql = "INSERT INTO PURCHASE_ORDER VALUES=(?,?,?,?,?,?,?,?) ";
try (Connection connection = myDataSource.getConnection();
PreparedStatement stmt = connection.prepareStatement(sql)) {
stmt.setInt(1, ordernum);
stmt.setInt(2, idcustomer);
stmt.setInt(3, idproduct);
stmt.setInt(4, quantity);
stmt.setInt(5, shippingcost);
stmt.setDate(6, (java.sql.Date) salesDate);
stmt.setDate(7, (java.sql.Date) shippingDate);
stmt.setString(8, company);
result = stmt.executeUpdate();
}
return result;
}
public int deleteOrder(int OrderNum) throws SQLException {
int result = 0;
String sql = "DELETE FROM PURCHASE_ORDER WHERE ORDER_NUM = ?";
try (Connection connection = myDataSource.getConnection();
PreparedStatement stmt = connection.prepareStatement(sql)) {
stmt.setInt(1, OrderNum);
result = stmt.executeUpdate();
}
return result;
}
public int changeOrder(int Qte, int ordernum) throws SQLException {
int result=0;
String sql = "UPDATE PURCHASE_ORDER SET QUANTITY = ? WHERE ORDER_NUM=?";
try (Connection connection = myDataSource.getConnection();
PreparedStatement stmt = connection.prepareStatement(sql)) {
stmt.setInt(1, Qte);
stmt.setInt(2, ordernum);
result=stmt.executeUpdate();
}
return result; |
Partager