jdbc查询

import java.util.ArrayList;
import java.util.List;

import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;

import com.yundaex.common.dao.DataGrid;
import com.yundaex.common.dao.QueryCriteria;
import com.yundaex.common.dao.impl.BaseDaoImpl;
import com.yundaex.common.security.annotation.EnableDataSecurity;
import com.yundaex.wms.basicdata.dao.RivWorkingPositionDao;
import com.yundaex.wms.basicdata.po.RivWorkingPosition;


@Repository("workingPositionDao")
public class RivWorkingPositionDaoImpl extends BaseDaoImpl<RivWorkingPosition>
        implements RivWorkingPositionDao {

    //查询简单类型
    @Override
    public int querySomeTypeQtyEnabled(String type) {
        List<Object> params = new ArrayList<Object>();
        params.add(type);
        String sql = "select count(1) from riv_working_position wkp where wkp.WKP_WORKING_P_TYPE = ? and wkp.WKP_IS_ENABLED =1";
        Integer result = this.jdbcTemplate.getJdbcOperations().queryForObject(sql, params.toArray(),Integer.class);
        return result;
    }
    //查询复杂类型

      //this.jdbcTemplate.getJdbcOperations().queryForObject(sql, params.toArray(),new BeanPropertyRowMapper<AClass>(AClass.class));

}

 

    public List<Map<String, Object>> queryMatInfoByMatCode(String matCodeList) {
        if (StringUtil.isBlank(matCodeList)) {
            return new ArrayList<Map<String, Object>>();
        }
        List<Object> params = new ArrayList<Object>();
        params.add(matCodeList);
        String sql = "select mat.MAT_ID, mat.MAT_CODE from riv_material mat where mat.MAT_CODE in (?)";
        List<Map<String, Object>> list = jdbcTemplate.getJdbcOperations().queryForList(sql,params.toArray());
        return list;
    }