public Collection<ProvinciaDTO> buscarTodos()
    {
        Connection con = null;
        PreparedStatement pstm = null;
        ResultSet rs = null;
        try {
            con = UConnection.getConnection();
            String sql = "SELECT p.* FROM ubprovincia p";
            
            pstm = con.prepareStatement(sql);
            
            rs = pstm.executeQuery();
            
            Vector<ProvinciaDTO> ret = new Vector<ProvinciaDTO>();
            ProvinciaDTO dto = null;
            
            while( rs.next() ){
                dto = new ProvinciaDTO();
                dto.setIdprov(rs.getInt("IdProv"));
                dto.setProvincia(rs.getString("provincia"));
                ret.add(dto);
            }
            
            return ret;
            
        } catch (Exception ex) {
            ex.printStackTrace();
            throw new RuntimeException(ex);
        }
        finally
        {
            try {
                if ( rs != null)
                    rs.close();
                if (pstm != null)
                    pstm.close();
                
            } catch (Exception ex) {
                ex.printStackTrace();
                throw new RuntimeException(ex);
            }
        }
        
    }