AddressDAO addBillingAddress:" Parameter at position 1 is not set."
Closed this issue · 2 comments
loveritsu929 commented
public int addBillingAddress(BillingAddressBean billing) throws SQLException{
System.out.println(billing);
System.out.println(billing.getUserId());
/*BillingAddressBean [id=0, userId=3, timestamp=2018-04-08 22:53:45.085, firstName= My dad , lastName=pays for me, credit=TD 11223344, cvv=CVV, street=Jane, province=AN, country=Wakada, zip=666 666]
3
*/
addBillingAddressStatement.setInt(1, billing.getUserId());
addBillingAddressStatement.setString(2, billing.getFirstName());
addBillingAddressStatement.setString(3, billing.getLastName());
addBillingAddressStatement.setString(4, billing.getCredit());
addBillingAddressStatement.setString(5, billing.getCvv());
addBillingAddressStatement.setString(6, billing.getStreet());
addBillingAddressStatement.setString(7, billing.getProvince());
addBillingAddressStatement.setString(8, billing.getCountry());
addBillingAddressStatement.setString(9, billing.getZip());
return addAddressStatement.executeUpdate();
}
mc256 commented
mc256 commented