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; } }