Databases
StackOverflow2013
Postsdbo
POHow to get Started with Netbeans, WSDL and JSP
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get Started with Netbeans, WSDL and JSP
    primarykey
    data
    text
    <p>I'm working on a project and I need to use some webservices, such as Global Weather, to add to the service..</p> <p>I'm using NetBeans, and Currently I can use this Web Service to call Weather + Cities By Country Name: <a href="http://www.webservicex.net/globalweather.asmx?WSDL" rel="nofollow">http://www.webservicex.net/globalweather.asmx?WSDL</a></p> <p>Anyway, so this is what I'm doing now:</p> <pre><code>&lt;%@page contentType="text/html" pageEncoding="UTF-8"%&gt; &lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt; &lt;title&gt;Weather Finder&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;h1&gt;Weather Test&lt;/h1&gt; &lt;%-- start web service invocation --%&gt;&lt;hr/&gt; &lt;% try { net.webservicex.GlobalWeather service = new net.webservicex.GlobalWeather(); net.webservicex.GlobalWeatherSoap port = service.getGlobalWeatherSoap(); java.lang.String countryName = "Australia"; java.lang.String result = port.getCitiesByCountry(countryName); out.println("Result = "+result); } catch (Exception ex) { } %&gt; &lt;%-- end web service invocation --%&gt;&lt;hr/&gt; &lt;%-- start web service invocation --%&gt;&lt;hr/&gt; &lt;% try { net.webservicex.GlobalWeather service = new net.webservicex.GlobalWeather(); net.webservicex.GlobalWeatherSoap port = service.getGlobalWeatherSoap(); java.lang.String cityName = "Melbourne"; java.lang.String countryName = "Australia"; java.lang.String result = port.getWeather(cityName, countryName); out.println("Result = "+result); } catch (Exception ex) {} %&gt; &lt;%-- end web service invocation --%&gt;&lt;hr/&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>Which Returns:</p> <pre><code> &lt;!DOCTYPE html&gt; &lt;html&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8"&gt; &lt;title&gt;Weather Finder&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;h1&gt;Hello World!&lt;/h1&gt; &lt;hr/&gt; Result = &lt;NewDataSet&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Archerfield Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Amberley Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Alice Springs Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Brisbane Airport M. O&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Coolangatta Airport Aws&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Cairns Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Charleville Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Gladstone&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Longreach Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Mount Isa Amo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Mackay Mo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Oakey Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Proserpine Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Rockhampton Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Broome Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Townsville Amo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Weipa City&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Gove Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Tennant Creek Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Yulara Aws&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Albury Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Devonport East&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Goldstream Aws&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;East Sale Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Hobart Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Launceston Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Laverton Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Moorabbin Airport Aws&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Mount Gambier Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Mildura Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Melbourne Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Macquarie Island&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Wynyard West&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Adelaide Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Albany Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Broken Hill Patton Street&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Ceduna Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Derby&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Darwin Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Bullsbrook Pearce Amo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Edinburgh M. O.&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Forrest Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Geraldton Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Kalgoorlie Boulder Amo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Kununurra Kununurra Aws&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Leigh Creek Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Learmonth Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Meekatharra Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Port Hedland Pardoo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Parafield Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Belmont Perth Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Katherine Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Woomera Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Bankstown Airport Aws&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Canberra&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Coffs Harbour Mo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Cooma&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Camden Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Dubbo&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Norfolk Island Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Nowra Ran Air Station&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Richmond Aus-Afb&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Sydney Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Tamworth Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Wagga Airport&lt;/City&gt; &lt;/Table&gt; &lt;Table&gt; &lt;Country&gt;Australia&lt;/Country&gt; &lt;City&gt;Williamtown Aerodrome&lt;/City&gt; &lt;/Table&gt; &lt;/NewDataSet&gt; &lt;hr/&gt; &lt;hr/&gt; Result = &lt;?xml version="1.0" encoding="utf-16"?&gt; &lt;CurrentWeather&gt; &lt;Location&gt;Melbourne Airport, Australia (YMML) 37-40S 144-50E 141M&lt;/Location&gt; &lt;Time&gt;Sep 19, 2011 - 07:39 AM EDT / 2011.09.19 1139 UTC&lt;/Time&gt; &lt;Wind&gt; from the WSW (240 degrees) at 29 MPH (25 KT):0&lt;/Wind&gt; &lt;Visibility&gt; greater than 7 mile(s):0&lt;/Visibility&gt; &lt;SkyConditions&gt; mostly cloudy&lt;/SkyConditions&gt; &lt;Temperature&gt; 57 F (14 C)&lt;/Temperature&gt; &lt;DewPoint&gt; 44 F (7 C)&lt;/DewPoint&gt; &lt;RelativeHumidity&gt; 62%&lt;/RelativeHumidity&gt; &lt;Pressure&gt; 29.53 in. Hg (1000 hPa)&lt;/Pressure&gt; &lt;Status&gt;Success&lt;/Status&gt; &lt;/CurrentWeather&gt; &lt;hr/&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>Which is Great, But how do I get all that XML Information back into my Java Application so I can put it somewhere useful?</p> <p>For example, how to I change the Result of the Weather into something more useful like an Array? Or ArrayList and call it somewhere else in my Application.</p> <p>Thank you!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMoe
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COOn a side note, you may want to read this answer by BalusC on using scriptlets in JSP http://stackoverflow.com/questions/3177733/how-to-avoid-java-code-in-jsp-files/3180202#3180202
      singulars
      1. POHow to get Started with Netbeans, WSDL and JSP
      1. USSean
    2. COHow could I use JSTL in this situation?
      singulars
      1. POHow to get Started with Netbeans, WSDL and JSP
      1. USMoe
    3. COI would suggest looking more at EL here. the only thing you display is the result, which could easily be placed in a request attribute before displaying your JSP.
      singulars
      1. POHow to get Started with Netbeans, WSDL and JSP
      1. USSean
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload