YorkU-Citrus/Citrus

AddressDAO addBillingAddress:" Parameter at position 1 is not set."

Closed this issue · 2 comments

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

image
Problem Reproduced.

mc256 commented

Problem addressed, FIXED
qq 20180416150549