@Override
	public List<ClienteBean> listar() {
		List<ClienteBean> list = new ArrayList<ClienteBean>();
		ResultSet rs = null;
		//Statement st = null;
		PreparedStatement ps = null;
		try{
			//st = conn.createStatement();
			String SQL = "SELECT * FROM Dig_Usuario c INNER JOIN Dig_Usuario_Cliente_Sis u"+
						 " ON u.id_Usuario = c.id_Usuario"+
						 " INNER JOIN Dig_Perfil_Sis p"+
						 " ON p.id_Perfil_Sis = u.id_Perfil_Sis";
					
			ps = conn.prepareStatement(SQL);			
				
			rs = ps.executeQuery();
			
			VeiculoDAO dao = new VeiculoDAO();
			
			while(rs.next()){
				ClienteBean bean = new ClienteBean();
				bean.setIdUsuario(rs.getLong(1));
				bean.setNome(rs.getString("nome"));
				bean.setEndereco(rs.getString("endereco"));
				bean.setCidade(rs.getString("cidade"));
				bean.setEstado(rs.getString("estado"));
				bean.setTelefone(rs.getString("telefone"));
				bean.setCpf(rs.getString("cpf"));
				bean.setEmail(rs.getString("email"));
				bean.setIdPerfilSis( rs.getLong(9));
				bean.setIdUsuarioClienteSis( rs.getLong("id_Usuario_Cliente_Sis"));
				bean.setUsuarioStr(rs.getString("usuario"));
				bean.setSenhaStr(rs.getString("senha"));
				bean.setPerfilStr(rs.getString("nome_Perfil"));
				
				bean.setListVeiculoBean(dao.listar(bean.getIdUsuario()));				
				
				list.add(bean);				
			}
			
		}catch(SQLException sql){
			sql.printStackTrace();
		}catch(Exception e){
			e.printStackTrace();
			
		}finally{
			try {
				rs.close();
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			fecharConexao();
		}		
		
		return list;		
	}