DML说明

增

public boolean insertInfos(IDataset infos) throws Exception{

    IData data = infos.getData(0);

    boolean resultFlag = this.insert("IpuMemberInfo", data);

    if (log.isDebugEnabled()){

        log.debug(resultFlag ? "数据插入成功" : "数据插入失败");

    }

    return resultFlag;

}

删

public boolean deleteInfos(IDataset staffid) throws Exception{

    IData data = staffid.getData(0);

    boolean resultFlag =  this.delete("IpuMemberInfo", data , new String[]{ "STAFFID" });

    if (log.isDebugEnabled()){

        log.debug(resultFlag ? "数据删除成功" : "数据删除失败");

    }

    return resultFlag;

}

改

public boolean updateInfos(IDataset infos) throws Exception{

    IData data = infos.getData(0);

    boolean resultFlag = this.update("IpuMemberInfo", data, new String[]{"STAFFID"});

    if (log.isDebugEnabled()){

        log.debug(resultFlag ? "数据更新成功" : "数据更新失败");

    }

    return resultFlag;

}

查

public DatasetList queryInfos(IData params) {

    DatasetList infos = new DatasetList();

        IData datas = this.queryList("select * from IpuMemberInfo s where s.STAFFID = :StaffID",params).first();

        if (log.isDebugEnabled()){

            log.debug("查询到的数据为" + datas == null ? "null" : datas.toString());

        }

    return datas;

}