package com.cmsz.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;


import com.cmsz.vo.WorkGroupVO;



public class RoleInfoDaoSupport extends DAOSupport {
	private static Logger logger = LoggerFactory.getLogger(RoleInfoDaoSupport.class);
	public List<WorkGroupVO> queryWorkGroup(String groupId) {
		logger.info("开始查询工作组信息-----------------");
		String sql="SELECT ROLE_ID, ROLE_NAME, ROLE_DESCRIPTION, CREATE_TIME, MODIFY_TIME, ROLE_TYPE, VALID_BEGIN, VALID_END, SAFE_MODE FROM JCPZ_ROLE_INFO_T";
		List<WorkGroupVO> resultList = new ArrayList<WorkGroupVO>();
		if (groupId.trim().isEmpty() || groupId == null) {//为空
			
		} else {
			sql+=" where ROLE_ID="+groupId;
		}
		try {
			ResultSet rs=this.getResultSet(sql);
			while(rs.next())
			{
				WorkGroupVO vo = new WorkGroupVO();
				vo.setGroupId(rs.getString("ROLE_ID"));
				vo.setGroupType(rs.getString("ROLE_TYPE"));
				vo.setName(rs.getString("ROLE_NAME"));
				vo.setNote(rs.getString("ROLE_DESCRIPTION"));
				vo.setSafeMode(rs.getString("SAFE_MODE"));
				vo.setValidBegin(rs.getDate("VALID_BEGIN"));
				vo.setValidEnd(rs.getDate("VALID_END"));
				resultList.add(vo);
			}
			this.closeAll();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return resultList;
	}

}