把多个int类型的字段转换成字符串类型

public class SearchCredentialResult{

private String accessGroup1Name;
private String accessGroup2Name;
private String accessGroup3Name;
private String accessGroup4Name;
private String accessGroup5Name;
private String accessGroup6Name;
private String accessGroup7Name;
private String accessGroup8Name;

public String getAccessGroup1Name() {
return this.accessGroup1Name == null ? "" : this.accessGroup1Name;
}

public void setAccessGroup1Name(String accessGroup1Name) {
this.accessGroup1Name = accessGroup1Name;
}

public String getAccessGroup2Name() {
return this.accessGroup2Name == null ? "" : this.accessGroup2Name;
}

public void setAccessGroup2Name(String accessGroup2Name) {
this.accessGroup2Name = accessGroup2Name;
}

public String getAccessGroup3Name() {
return this.accessGroup3Name != null ? "" :this.accessGroup3Name;
}

public void setAccessGroup3Name(String accessGroup3Name) {
this.accessGroup3Name = accessGroup3Name;
}

public String getAccessGroup4Name() {
return this.accessGroup4Name !=null ? "" :this.accessGroup4Name;
}

public void setAccessGroup4Name(String accessGroup4Name) {
this.accessGroup4Name = accessGroup4Name;
}

public String getAccessGroup5Name() {
return accessGroup5Name != null ? "":this.accessGroup5Name;
}

public void setAccessGroup5Name(String accessGroup5Name) {
this.accessGroup5Name = accessGroup5Name;
}

public String getAccessGroup6Name() {
return accessGroup6Name != null ? "":this.accessGroup6Name;
}

public void setAccessGroup6Name(String accessGroup6Name) {
this.accessGroup6Name = accessGroup6Name;
}

public String getAccessGroup7Name() {
return accessGroup7Name != null ? "":this.accessGroup7Name;
}

public void setAccessGroup7Name(String accessGroup7Name) {
this.accessGroup7Name = accessGroup7Name;
}

public String getAccessGroup8Name() {
return accessGroup8Name != null ? "":this.accessGroup8Name;
}

public void setAccessGroup8Name(String accessGroup8Name) {
this.accessGroup8Name = accessGroup8Name;
}

public String getAccessGroupNames() {
StringBuilder sb = new StringBuilder();
if(this.accessGroup1Name != null) {
sb.append(this.accessGroup1Name);
}
if(this.accessGroup2Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup2Name);
}
sb.append(this.accessGroup2Name);
}
if(this.accessGroup3Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup3Name);
}
sb.append(this.accessGroup3Name);
}
if(this.accessGroup4Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup4Name);
}
sb.append(this.accessGroup4Name);
}
if(this.accessGroup5Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup5Name);
}
sb.append(this.accessGroup5Name);
}
if(this.accessGroup6Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup6Name);
}
sb.append(this.accessGroup6Name);
}
if(this.accessGroup7Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup7Name);
}
sb.append(this.accessGroup7Name);
}
if(this.accessGroup8Name != null) {
if(sb.length() > 0) {
sb.append(",").append(this.accessGroup8Name);
}
sb.append(this.accessGroup8Name);
}
return sb.toString();
}
}

ProcessorImpl 实现:
SearchCredentialResult result = accessControlCardService.findAccessGroupName(creden.getCredentialId());
if(null != result){
credentialdto.setGroupNames(result.getAccessGroupNames());
}
ibatis sql:
<resultMap class="SearchCredentialResult" id="AccessCredentialResultMap">
<result column="groupname1" property="accessGroup1Name" jdbcType="VARCHAR" />
<result column="groupname2" property="accessGroup2Name" jdbcType="VARCHAR" />
<result column="groupname3" property="accessGroup3Name" jdbcType="VARCHAR" />
<result column="groupname4" property="accessGroup4Name" jdbcType="VARCHAR" />
<result column="groupname5" property="accessGroup5Name" jdbcType="VARCHAR" />
<result column="groupname6" property="accessGroup6Name" jdbcType="VARCHAR" />
<result column="groupname7" property="accessGroup7Name" jdbcType="VARCHAR" />
<result column="groupname8" property="accessGroup8Name" jdbcType="VARCHAR" />
</resultMap>

<select id="findAccessGroupName" resultMap="AccessCredentialResultMap" parameterClass="Integer">
SELECT f.CRDT_ID,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP1) as groupname1,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP2) as groupname2,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP3) as groupname3,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP4) as groupname4,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP5) as groupname5,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP6) as groupname6,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP7) as groupname7,
(SELECT g.ACS_GRP_NAM FROM ACS_CTRL_ACS_GRP g WHERE g.ACS_GRP_ID=f.ACS_GRP8) as groupname8
FROM ACS_CTRL_CRDT f
WHERE f.CRDT_ID= #credentialId:INTEGER#
</select>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值