mybatis中注解的方式实现批量删除

/**
 * desc: 批量删除
 * param:
 * return:
 * author: CDN
 * date: 2019/7/11
 */
public String deleteList(List<String> list) {
    StringBuilder sb = new StringBuilder();
    sb.append("DELETE FROM invoice WHERE no IN (");
    for (int i = 0; i < list.size(); i++) {
        sb.append("'").append(list.get(i)).append("'");
        if (i < list.size() - 1)
            sb.append(",");
    }
    sb.append(")");
    return sb.toString();
}