thinkphp 5 用Query对象执行 增删改查

        $Model = new \think\db\Query();
		
        //执行查询
		//查询订单号对应的货品product_id
		$sql = "SELECT * FROM jshop_order_items WHERE order_id='".$order_id."' ORDER BY id DESC limit 1";		 
		$list = $Model->query($sql);	
		$product_id = $list[0]["product_id"];
   
        //执行增加
        $sql = "insert into 表";		 
		$list = $Model->query($sql);	

         //执行修改 
        $sql = "update 表";		 
		$list = $Model->query($sql);
		
        //执行删除
		//从表jshop_cart中删除用户product_id记录
		$sql = "delete FROM jshop_cart WHERE user_id=".$userId." and product_id=".$product_id;		 
		$list = $Model->query($sql);