net.wicp.tams.cas.services.impl.QueryImpl Maven / Gradle / Ivy

Go to download
package net.wicp.tams.cas.services.impl;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.collections.CollectionUtils;
import org.apache.tapestry5.ioc.annotations.Inject;

import lombok.extern.slf4j.Slf4j;
import net.wicp.tams.cas.bean.constant.ColsSysOptitem;
import net.wicp.tams.cas.bean.constant.ColsSysOrg;
import net.wicp.tams.cas.services.IQuery;
import net.wicp.tams.common.apiext.StringUtil;
import net.wicp.tams.common.apiext.jdbc.JdbcAssit;
import net.wicp.tams.common.jdbc.DruidAssit;
import net.wicp.tams.common.mybatis.services.IMybatisSessionSource;
import net.wicp.tams.common.mybatis.services.IMybatisService;
import net.wicp.tams.component.services.IReq;

@Slf4j
public class QueryImpl implements IQuery {

	@Inject
	private IMybatisService batisService;

	@Inject
	private IMybatisSessionSource mybatisSessionSource;

	@Inject
	protected IReq req;

	@Override
	public List> queryOrgById(String orgId) {
		List> querySqlMap = new ArrayList>();
		Connection connection = mybatisSessionSource.createSession().getConnection();
		try {
			String sql = null;
			if (StringUtil.isNull(orgId)) {
				sql = String.format("select * from %s.%s", mybatisSessionSource.defaultDb(), ColsSysOrg.tb);
			} else {
				sql = "select * from " + mybatisSessionSource.defaultDb() + "." + ColsSysOrg.tb + " where "
						+ ColsSysOrg.orgIdPath.getOriColName() + " like '/" + orgId + "%'";
			}
			querySqlMap = JdbcAssit.querySqlMap(connection, sql, true);
		} catch (Exception e) {
			log.error("查询失败", e);
		} finally {
			DruidAssit.close(connection);
		}
		return querySqlMap;
	}

	@Override
	public Map queryOptById(long key) {
		Connection connection = DruidAssit.getConnection(mybatisSessionSource.getDatasourceName());
		try {
			List> querySqlMap = JdbcAssit.querySqlMap(connection,
					"select * from " + mybatisSessionSource.defaultDb() + "." + ColsSysOptitem.tb + " where id=" + key,
					true);
			if (CollectionUtils.isNotEmpty(querySqlMap)) {
				return querySqlMap.get(0);
			}
		} catch (Exception e) {
			log.error("查询失败", e);
		} finally {
			DruidAssit.close(connection);
		}
		return new HashMap();
	}

}