public static int insertIntoCart(String email, String productId, String appendNo, int quantity) { String insertSQL = "insert into cart" + "(email,productId,cartAppendNo,quantity) " + "values('" + email + "','" + productId + "','" + appendNo + "','" + quantity + "')"; return DB.update(insertSQL); }
public int insert() { // TODO Auto-generated method stub String insertSQL = "insert into cart" + "(email,cartAppendNo,productId,quantity) " + "values(" + "'" + email + "','" + cartAppendNo + "', '" + productId + "','" + quantity + "');"; System.out.println(insertSQL); return DB.update(insertSQL); }
public int delete(String email2) { // TODO Auto-generated method stub String deleteSQL = "delete from cart " + "where email= '" + email2 + "'"; System.out.println(deleteSQL); return DB.update(deleteSQL); }