Java StatementContext.setAttribute方法代码示例

import org.skife.jdbi.v2.StatementContext; //导入方法依赖的package包/类
@Override
public Location map(int index, ResultSet rs, StatementContext ctx) throws SQLException {
	Location l = new Location();
	l.setId(rs.getInt("id"));
	l.setName(rs.getString("name"));
	l.setLat(rs.getDouble("lat"));
	l.setLng(rs.getDouble("lng"));
	l.setCreatedAt(new DateTime(rs.getTimestamp("createdAt")));
	l.setUpdatedAt(new DateTime(rs.getTimestamp("updatedAt")));
	l.setLoadLevel(LoadLevel.PROPERTIES);
	
	if (MapperUtils.containsColumnNamed(rs, "totalCount")) { 
		ctx.setAttribute("totalCount", rs.getInt("totalCount"));
	}
	
	return l;
}
 

import org.skife.jdbi.v2.StatementContext; //导入方法依赖的package包/类
@Override
public Position map(int index, ResultSet rs, StatementContext ctx) throws SQLException {
	//This hits when we do a join but there's no Billet record. 
	if (rs.getObject("positions_id") == null) { return null; }
	
	Position p = fillInFields(new Position(), rs);
	
	if (MapperUtils.containsColumnNamed(rs, "totalCount")) { 
		ctx.setAttribute("totalCount", rs.getInt("totalCount"));
	}
	
	if (MapperUtils.containsColumnNamed(rs, "people_id")) { 
		PersonMapper.fillInFields(p.getPerson(), rs);
	}
	return p;
}
 

import org.skife.jdbi.v2.StatementContext; //导入方法依赖的package包/类
@Override
public Organization map(int index, ResultSet r, StatementContext ctx) throws SQLException {
	Organization org = new Organization();
	org.setId(r.getInt("organizations_id"));
	org.setShortName(r.getString("organizations_shortName"));
	org.setLongName(r.getString("organizations_longName"));
	org.setType(MapperUtils.getEnumIdx(r, "organizations_type", OrganizationType.class));
	
	Integer parentOrgId = MapperUtils.getInteger(r, "organizations_parentOrgId");
	if (parentOrgId != null) { 
		org.setParentOrg(Organization.createWithId(parentOrgId));
	}
	
	org.setCreatedAt(new DateTime(r.getTimestamp("organizations_createdAt")));
	org.setUpdatedAt(new DateTime(r.getTimestamp("organizations_updatedAt")));
	org.setLoadLevel(LoadLevel.PROPERTIES);
	
	if (MapperUtils.containsColumnNamed(r, "totalCount")) { 
		ctx.setAttribute("totalCount", r.getInt("totalCount"));
	}
	
	return org;
}
 

import org.skife.jdbi.v2.StatementContext; //导入方法依赖的package包/类
@Override
public Poam map(int index, ResultSet r, StatementContext ctx) throws SQLException {
	Poam p = new Poam();
	p.setId(r.getInt("id"));
	p.setLongName(r.getString("longName"));
	p.setShortName(r.getString("shortName"));
	p.setCategory(r.getString("category"));
	p.setStatus(MapperUtils.getEnumIdx(r, "status", PoamStatus.class));
	
	Integer parentPoamId = MapperUtils.getInteger(r, "parentPoamId");
	if (parentPoamId != null) { 
		p.setParentPoam(Poam.createWithId(parentPoamId));
	}
	
	Integer responsibleOrgId = MapperUtils.getInteger(r, "organizationId");
	if (responsibleOrgId != null) { 
		p.setResponsibleOrg(Organization.createWithId(responsibleOrgId));
	}
	
	p.setCreatedAt(new DateTime(r.getTimestamp("createdAt")));
	p.setUpdatedAt(new DateTime(r.getTimestamp("updatedAt")));
	
	if (MapperUtils.containsColumnNamed(r, "totalCount")) { 
		ctx.setAttribute("totalCount", r.getInt("totalCount"));
	}
	
	return p;
}
 

import org.skife.jdbi.v2.StatementContext; //导入方法依赖的package包/类
@Override
public Person map(int index, ResultSet rs, StatementContext ctx) throws SQLException {
	Person p = fillInFields(new Person(), rs);
	
	if (MapperUtils.containsColumnNamed(rs, "positions_id")) { 
		p.setPosition(PositionMapper.fillInFields(new Position(), rs));
	}
	
	if (MapperUtils.containsColumnNamed(rs, "totalCount")) { 
		ctx.setAttribute("totalCount", rs.getInt("totalCount"));
	}
	return p;
}
 

import org.skife.jdbi.v2.StatementContext; //导入方法依赖的package包/类
@Override
public Report map(int index, ResultSet rs, StatementContext ctx) throws SQLException {
	Report r = new Report();
	r.setId(rs.getInt("reports_id"));
	
	r.setState(MapperUtils.getEnumIdx(rs, "reports_state", ReportState.class));
	r.setCreatedAt(new DateTime(rs.getTimestamp("reports_createdAt")));
	r.setUpdatedAt(new DateTime(rs.getTimestamp("reports_updatedAt")));
	
	Timestamp engagementDate = rs.getTimestamp("reports_engagementDate");
	if (engagementDate != null) { 
		r.setEngagementDate(new DateTime(engagementDate));
	}
	
	Timestamp releasedAt = rs.getTimestamp("reports_releasedAt");
	if (releasedAt != null) { 
		r.setReleasedAt(new DateTime(releasedAt));
	}
	
	Integer locationId = MapperUtils.getInteger(rs, "reports_locationId");
	if (locationId != null) { 
		Location l = Location.createWithId(locationId);
		r.setLocation(l);
	}
	
	Integer approvalStepId = MapperUtils.getInteger(rs, "reports_approvalStepId");
	if (approvalStepId != null) { 
		r.setApprovalStep(ApprovalStep.createWithId(approvalStepId));
	}
	
	r.setIntent(rs.getString("reports_intent"));
	r.setExsum(rs.getString("reports_exsum"));
	r.setAtmosphere(MapperUtils.getEnumIdx(rs, "reports_atmosphere", Atmosphere.class));
	r.setAtmosphereDetails(rs.getString("reports_atmosphereDetails"));
	r.setCancelledReason(MapperUtils.getEnumIdx(rs, "reports_cancelledReason", ReportCancelledReason.class));
	
	r.setReportText(rs.getString("reports_text"));
	r.setKeyOutcomes(rs.getString("reports_keyOutcomes"));
	r.setNextSteps(rs.getString("reports_nextSteps"));
	
	Person author = Person.createWithId((MapperUtils.getInteger(rs, "reports_authorId")));
	PersonMapper.fillInFields(author, rs);
	r.setAuthor(author);
	r.setLoadLevel(LoadLevel.PROPERTIES);
	
	Integer advisorOrgId = MapperUtils.getInteger(rs, "reports_advisorOrganizationId");
	if (advisorOrgId != null) { 
		r.setAdvisorOrg(Organization.createWithId(advisorOrgId));
	}
	
	Integer principalOrgId = MapperUtils.getInteger(rs, "reports_principalOrganizationId");
	if (principalOrgId != null) { 
		r.setPrincipalOrg(Organization.createWithId(principalOrgId));
	}
	
	if (MapperUtils.containsColumnNamed(rs, "totalCount")) { 
		ctx.setAttribute("totalCount", rs.getInt("totalCount"));
	}
	
	return r;
}