public void populate(String u)  throws Exception{
        Connection conn =null;
        Statement stmt = null;
        ResultSet rs=null;
 
        try{
            
            Class.forName("com.mysql.jdbc.Driver");
            conn=DriverManager.getConnection(url);
            
            stmt = conn.createStatement();
            String sql;
            sql ="SELECT * from  USERS where USER_NAME = " +
                                             "'" + u + "'";
            rs= stmt.executeQuery(sql);

	    // analyze the result set
	    
	    rs.next();
            user= u;
            password = rs.getString("USER_PASS");
            name = rs.getString("NAME");
            street = rs.getString("STREET_ADDRESS");
            zip = rs.getString("ZIP_CODE");
            city = rs.getString("CITY");
	    country = rs.getString("COUNTRY");
	}   
	catch(SQLException sqle){
            throw new Exception(sqle);
	}
        finally{
 	    try{
		rs.close();
            }
            catch(Exception e) {}
            try{
		stmt.close();
            }
	    catch(Exception e) {}
            try {
		conn.close();
            }
            catch(Exception e){}
        }
    }