查询SQL, IN, 某列值，VO处理类，内含多个后端查询类及使用方法

本文链接：https://blog.youkuaiyun.com/Cc_Rain0624/article/details/112857388

博客介绍了如何利用SuperVOHelper工具类从VO对象集合中获取特定列值，如pk_dept，转化为数组进行后端查询操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

获取VO中的某个列值以数组形式返回
String[] deptPKs = SuperVOHelper.getAttributeValueArray(managerVOs, “pk_dept”, String.class);

package nccloud.impl.hrzz.deptpsn.impl;

import nc.bs.dao.BaseDAO;
import nc.bs.framework.common.NCLocator;
import nc.hr.utils.CommonUtils;
import nc.hr.utils.InSQLCreator;
import nc.itf.om.IOMCommonQueryService;
import nc.jdbc.framework.processor.BaseProcessor;
import nc.jdbc.framework.processor.BeanListProcessor;
import nc.jdbc.framework.processor.ColumnListProcessor;
import nc.md.persist.framework.MDPersistenceService;
import nc.vo.hi.psndoc.PsndocVO;
import nc.vo.hr.tools.pub.GeneralVO;
import nc.vo.hr.tools.pub.GeneralVOProcessor;
import nc.vo.ml.MultiLangUtil;
import nc.vo.om.hrdept.HRDeptVO;
import nc.vo.om.orginfo.HROrgManagerVO;
import nc.vo.om.pub.SuperVOHelper;
import nc.vo.pub.BusinessException;
import nccloud.commons.lang.ArrayUtils;
import nccloud.commons.lang.StringUtils;
import nccloud.itf.hrzz.deptpsn.IDeptPsnQueryService;
import sun.misc.BASE64Encoder;
import java.util.ArrayList;
import java.util.List;

public class DeptPsnServiceImpl implements IDeptPsnQueryService {
   
   
	
    private IOMCommonQueryService getOMCommonQueryService()
    {
   
   
        return NCLocator.getInstance().lookup(IOMCommonQueryService.class);
    }

	@Override
	public String[] queryPsnPks(String strCond, String strOrder) throws BusinessException {
   
   
		StringBuffer psnSql = new StringBuffer(" select hi_psnjob.pk_psnjob from bd_psndoc ")
				.append("inner join hi_psnorg  on bd_psndoc.pk_psndoc = hi_psnorg.pk_psndoc  ")
				.append("inner join hi_psnjob on hi_psnorg.pk_psnorg = hi_psnjob.pk_psnorg ")
				.append("left outer join org_orgs on hi_psnjob.pk_org = org_orgs.pk_org ")
				.append("left outer join org_dept on hi_psnjob.pk_dept = org_dept.pk_dept ")
				.append("left outer join om_job on hi_psnjob.pk_job = om_job.pk_job ")
				.append("left outer join om_post on hi_psnjob.pk_post = om_post.pk_post ")
				.append("where hi_psnorg.endflag = 'N' and hi_psnorg.indocflag = 'Y' and hi_psnorg.psntype = 0 ")
				.append("and hi_psnjob.lastflag = 'Y' and hi_psnjob.ismainjob = 'Y' and hi_psnjob.endflag = 'N'  ");

		if (StringUtils.isNotBlank(strCond)) {
   
   
			psnSql.append(strCond);
		}
		if (StringUtils.isNotBlank(strOrder)) {
   
   
			psnSql.append(