@Override
	public List<CargoBean> listar(Long idEmpresa) {
		 List<CargoBean> list = new ArrayList<CargoBean>();
		 
		ResultSet rs = null;
		//Statement st = null;
		PreparedStatement ps = null;
		try{
			//st = conn.createStatement();
			String SQL = "SELECT * FROM Dig_Cargo WHERE id_Empresa = ?";
			
			ps = conn.prepareStatement(SQL);
			
			ps.setLong(1, idEmpresa);
				
			rs = ps.executeQuery();
			
			while(rs.next()){
				CargoBean bean = new CargoBean();
				bean.setIdCargo(rs.getLong("id_Cargo"));
				bean.setDescricao(rs.getString("descricao"));				
				
				list.add(bean);
				
			}
			
		}catch(SQLException sql){
			sql.printStackTrace();
		}catch(Exception e){
			e.printStackTrace();
			
		}finally{
			try {
				rs.close();
				ps.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			fecharConexao();
		}		
		
		return list;
		
	}