// getting all coupons as an array from the DB
@Override
public Collection<Coupon> getAllCoupons() throws CoupSQLException {
Collection<Coupon> coupList = new ArrayList<>();
Connection conn = ConnectionPool.getInstance().getConnection();
try {
PreparedStatement prpst2 = conn.prepareStatement("SELECT * FROM CouponsL");
ResultSet rs = prpst2.executeQuery();
while (rs.next()) {
long id = rs.getLong(1);
String title = rs.getString(2);
String message = rs.getString(3);
String image = rs.getString(4);
int amount = rs.getInt(5);
java.sql.Date startDate = rs.getDate(6);
java.sql.Date endDate = rs.getDate(7);
double price = rs.getDouble(8);
String type = rs.getString(9);
Coupon c = new Coupon();
c.setId(id);
c.setTitle(title);
c.setMessage(message);
c.setImage(image);
c.setAmount(amount);
c.setPrice(price);
c.setStartDate(startDate);
c.setEndDate(endDate);
c.setType(enumCheck(type));
coupList.add(c);
System.out.print(c.getId() + ", ");
System.out.print(c.getTitle() + ", ");
System.out.print(c.getMessage() + ", ");
System.out.print(c.getImage() + ", ");
System.out.print(c.getAmount() + ", ");
System.out.print(c.getPrice() + ", ");
System.out.print(startDate + ", ");
System.out.print(endDate + ", ");
System.out.println(type + ", ");
}
} catch (SQLException e) {
throw new CoupSQLException("Couldn't get all coupons. ", e);
}
return coupList;
}
// getting coupon object through it's ID that's located in DB
@Override
public Coupon getCoupon(long id) throws CoupSQLException {
long cId = id;
String title = null;
String message = null;
String image = null;
java.sql.Date startDate = null;
java.sql.Date endDate = null;
int amount = 0;
double price = 0;
String type = null;
Coupon c = new Coupon();
Connection conn = ConnectionPool.getInstance().getConnection();
try {
PreparedStatement prpst2 = conn.prepareStatement("SELECT * FROM CouponsL WHERE id = " + cId);
ResultSet rs = prpst2.executeQuery();
while (rs.next()) {
title = rs.getString(2);
message = rs.getString(3);
image = rs.getString(4);
amount = rs.getInt(5);
startDate = rs.getDate(6);
endDate = rs.getDate(7);
price = rs.getDouble(8);
type = rs.getString(9);
c.setId(cId);
c.setTitle(title);
c.setMessage(message);
c.setImage(image);
c.setAmount(amount);
c.setPrice(price);
c.setStartDate(startDate);
c.setEndDate(endDate);
c.setType(enumCheck(type));
}
} catch (SQLException e) {
throw new CoupSQLException("Couldn't get the Coupon. ", e);
}
return c;
}
// Getting all coupons in an array by Type
@Override
public Collection<Coupon> getCouponbyType(CouponType cType) throws CoupSQLException {
String type = cType.name();
Collection<Coupon> TypeArr = new ArrayList<>();
Connection conn = ConnectionPool.getInstance().getConnection();
long id = 0;
try {
PreparedStatement prpst2 =
conn.prepareStatement("SELECT * FROM CouponsL WHERE Type='" + type + "'");
ResultSet rs = prpst2.executeQuery();
while (rs.next()) {
Coupon c = new Coupon();
id = rs.getLong("id");
String title = rs.getString(2);
String message = rs.getString(3);
String image = rs.getString(4);
java.sql.Date startDate = rs.getDate(5);
java.sql.Date endDate = rs.getDate(6);
int amount = rs.getInt(7);
double price = rs.getDouble(8);
c.setId(id);
c.setTitle(title);
c.setMessage(message);
c.setImage(image);
c.setAmount(amount);
c.setPrice(price);
c.setStartDate(startDate);
c.setEndDate(endDate);
c.setType(enumCheck(type));
TypeArr.add(c);
}
} catch (SQLException e) {
throw new CoupSQLException("Could not get coupon by Type. Please try again. ", e);
}
return TypeArr;
}