Example usage for org.springframework.jdbc.support GeneratedKeyHolder getKey

Introduction

In this page you can find the example usage for org.springframework.jdbc.support GeneratedKeyHolder getKey.

Prototype

@Override
    @Nullable
    public Number getKey() throws InvalidDataAccessApiUsageException, DataRetrievalFailureException

Source Link

Usage

From source file:org.openlmis.performancetesting.dao.ProgramDAO.java

public long insertProgram(Program program) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertProgramQuery, new BeanPropertySqlParameterSource(program), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    program.setId(id);/*from w w w . ja  v a 2  s . c  om*/
    return id;
}

From source file:org.openlmis.performancetesting.dao.SupplyLineDAO.java

public long insertSupplyLine(SupplyLine supplyLine) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertSupplyLineQuery, new BeanPropertySqlParameterSource(supplyLine), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    supplyLine.setId(id);/*from ww w .  j av a 2 s . c o m*/
    return id;
}

From source file:org.openlmis.performancetesting.dao.ProgramProductDAO.java

public long insertProgramProduct(ProgramProduct programProduct) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertProgramQuery, new BeanPropertySqlParameterSource(programProduct), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    programProduct.setId(id);/*from   ww w  .j  a v  a 2  s  .c om*/
    return id;
}

From source file:org.openlmis.performancetesting.dao.ProcessingScheduleDAO.java

public long insertPeriod(ProcessingPeriod period) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertPeriodQuery, new BeanPropertySqlParameterSource(period), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    period.setId(id);//from   w  w  w .ja  v a  2  s . c om
    return id;
}

From source file:org.openlmis.performancetesting.dao.ProgramsSupportedDAO.java

public long insertProgramSupported(ProgramSupported programSupported) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertProgramsSupported, new BeanPropertySqlParameterSource(programSupported), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    programSupported.setId(id);//from  w ww  .jav  a2  s.com
    return id;
}

From source file:org.openlmis.performancetesting.dao.SupervisoryNodeDAO.java

public long insertSupervisoryNode(SupervisoryNode supervisoryNode) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertSupervisoryNodeSql, new BeanPropertySqlParameterSource(supervisoryNode), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    supervisoryNode.setId(id);/*from  ww  w .ja  v  a  2 s  .c om*/
    return id;
}

From source file:org.openlmis.performancetesting.dao.ProcessingScheduleDAO.java

public long insertSchedule(ProcessingSchedule processingSchedule) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertScheduleQuery, new BeanPropertySqlParameterSource(processingSchedule), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    processingSchedule.setId(id);/*w ww .  j av a2  s.  com*/
    return id;
}

From source file:org.openlmis.performancetesting.dao.FacilityApprovedProductDAO.java

public long insertFacilityApprovedProduct(FacilityApprovedProduct facilityApprovedProduct) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertFacilityApprovedProductQuery,
            new BeanPropertySqlParameterSource(facilityApprovedProduct), keyHolder, new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    facilityApprovedProduct.setId(id);//w  ww .  j av a 2 s.c o  m
    return id;
}

From source file:org.openlmis.performancetesting.dao.RequisitionGroupDAO.java

public long insertRequisitionMember(RequisitionGroupMember rgMember) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertRequisitionGroupMemberQuery, new BeanPropertySqlParameterSource(rgMember), keyHolder,
            new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    rgMember.setId(id);//from   w w w.ja v a 2 s. c o m
    return id;
}

From source file:org.openlmis.performancetesting.dao.RequisitionGroupDAO.java

public long insertRequisitionGroup(RequisitionGroup requisitionGroup) {
    GeneratedKeyHolder keyHolder = new GeneratedKeyHolder();
    template.update(insertRequisitionGroupQuery, new BeanPropertySqlParameterSource(requisitionGroup),
            keyHolder, new String[] { "id" });

    long id = keyHolder.getKey().longValue();
    requisitionGroup.setId(id);/*from w  w  w.j a  v  a2  s  .c o  m*/
    return id;
}