delete from t_address where aid=?

select * from t_address where uid=? order by modified_time DESC limit 0,1

/** * 根據(jù)收貨地址id刪除收貨地址數(shù)據(jù) * @param aid 收貨地址的id * @return 受影響的行數(shù) */Integer deleteByAid(Integer aid);/** * 根據(jù)用戶uid查詢用戶最后一次被修改的收貨地址數(shù)據(jù) * @param uid 用戶id * @return 收貨地址數(shù)據(jù) */Address findLastModified(Integer uid);

<delete id="deleteByAid">
    delete from t_address where aid=#{aid}
</delete>
<select id="findLastModified" resultMap="AddressEntityMap">
    select * from t_address
    where uid=#{uid}
    order by modified_time DESC limit 0,1
</select>

@Test
public void deleteByAid() {
    addressMapper.deleteByAid(11);
}
@Test
public void findLastModified() {
    System.out.println(addressMapper.findLastModified(11));
}
}

/**刪除數(shù)據(jù)時產(chǎn)生的異常*/
public class DeleteException extends ServiceException{
    /**重寫ServiceException的所有構(gòu)造方法*/
}

/**
* 刪除用戶選中的收貨地址數(shù)據(jù)
* @param aid 收貨地址id
* @param uid 用戶id
* @param username 用戶名
*/
void delete(Integer aid,Integer uid,String username);

@Override
public void delete(Integer aid, Integer uid, String username) {
    Address result = addressMapper.findByAid(aid);
    //1.
    if (result == null) {
        throw new AddressNotFoundException("收貨地址數(shù)據(jù)不存在");
    }
    //2.
    if (!result.getUid().equals(uid)) {
        throw new AccessDeniedException("非法數(shù)據(jù)訪問");
    }
    //3.
    Integer rows = addressMapper.deleteByAid(aid);
    if (rows != 1) {
        throw new DeleteException("刪除數(shù)據(jù)時產(chǎn)生未知的異常");
    }
    //4.如果刪除的是非默認地址則不需要再做后面的任何操作,終止程序
    if (result.getIsDefault() == 0) {
        return;
    }
    //5.
    Integer count = addressMapper.countByUid(uid);
    if (count == 0) {
        return;
    }
    //6.
    Address address = addressMapper.findLastModified(uid);
    //7.
    rows = addressMapper.updateDefaultByAid(address.getAid(), username, new Date());
    if (rows != 1) {
        throw new UpdateException("更新數(shù)據(jù)時產(chǎn)生未知的異常");
    }
}

@Test
public void delete() {
    addressService.delete(1,11,"4.11刪除");
}

else if (e instanceof DeleteException) {
    result.setState(5002);
    result.setMessage("刪除數(shù)據(jù)時產(chǎn)生未知的異常");
}

@RequestMapping("{aid}/delete")
public JsonResult<Void> delete(@PathVariable("aid") Integer aid,HttpSession session) {
    addressService.delete(
        aid,
        getUidFromSession(session),
        getUsernameFromSession(session));
    return new JsonResult<>(OK);
}

<td><a onclick="delete(#{aid})" class="btn btn-xs add-del btn-info"><span class="fa fa-trash-o"></span> 刪除</a></td>

function setDefault(aid) {
    $.ajax({
        url: "/addresses/"+aid+"/set_default",
        type: "POST",
        //data: $("#form-change-password").serialize(),
        dataType: "JSON",
        success: function (json) {
            if (json.state == 200) {
                //重新加載收貨地址列表頁面
                showAddressList();
            } else {
                alert("刪除收貨地址失敗")
            }
        },
        error: function (xhr) {
            alert("刪除收貨地址時產(chǎn)生未知的異常!"+xhr.message);
        }
    });
}