Connecting an ArcIMS Site to an External Database - Esri

Malo Gauthier | Download | HTML Embed
  • Apr 14, 2005
  • Views: 21
  • Page(s): 3
  • Size: 139.54 kB
  • Report

Share

Transcript

1

2 rt=java.sql.* %> number and service name can also be found in tnsnames.ora le located A ClassNotFoundException Connection conn=null; // dening variable thin:@serverName:1521:myDB, userName, Password); An exception occurred while interacting with database // connection to the database message := Listing 4: Sample code for connecting to an Oracle database. Querying the Database Listing 6: Handling errors. Two objects, Statement and ResultSet, need to be created. (ResultSet is similar to Visual Basics Recordset object.) Statement is created by Linking JSP and ArcIMS Pages the createStatement() function of the Connection object. ResultSet is Linking ArcIMS with JSP is relatively easy. When the user clicks on populated with queried records when the executeQuery() function of the a map feature, the feature ID is retrieved using ArcIMS functions and Statement object is executed. The executeQuery() function has a SQL passed as part of a URL to the JSP page. If a user is searching for features statement as an argument. The next() function with a while() statement by any attributes other than the feature ID (for example, nding parcel by is used to loop through all records. To extract data, use functions such address), those search strings are passed to the JSP page, which causes the as getString(), getInt(), or getFloat() (as appropriate for the eld type) database to be searched and may populate a JavaScript for a with either the eld name or eld index. Note that the eld index starts tags onLoad() event with the IDs of any features found. When the page from 1, not 0. Examples of these functions are rset.getString(ID) or is loaded, the script will execute and submit XML code to the ArcIMS rset.getFloat(3). See the sample code in Listing 5. server, which will highlight those features on the map. See Listing 7 for a sample page. Statement stmt = conn.createStatement(); // creating Statement ResultSet rset = null; // declaring ResultSet for queried records Conclusion String sqlStmnt = SELECT ID, GIS_ID, ADDRESS FROM This method for connecting ArcIMS to an external database is a quick REALMAST WHERE and simple solution. JavaScript code can be added to a JSP page to + GIS_ID = + id + ; // SQL string check the validity of input data before it is passed. /* ResultSet object contains an array of records returned by SQL For more information, contact query */ Mohammed A. Hoque, GIS Coordinator rset = stmt.executeQuery(sqlStmnt); Town of West Springeld, Massachusetts Tel.: 413-263-3070 while (rset.next()) // loop E-mail: [email protected] { Web: gis.west-springeld.ma.us // extract and print value from eld named ID out.println(rset.getString(ID); Continued on page 58 } JSP and JDBC Resources Listing 5: Querying the database. Title URL www-106.ibm.com/developerworks/ Handling Unexpected Errors Introduction to JSP Technology edu/j-dw-jsp-i.html It is not unusual to get unexpected errors while accessing a database. It is preferable to create another JSP page that is called when an error Dynamic Web-Based Data Access www-106.ibm.com/developerworks/ occurs. In this example, add a JSP directive on top of myJSP.jsp page Using JSP and JDBC Technologies java/library/j-webdata/ (i.e., ) and java.sun.com/developer/ create another le called errPage.jsp. Add the code in Listing 6 and save JavaServer Pages Fundamentals, onlineTraining/JSPIntro/contents. it in the myJSPs Web application directory. Short Course Contents html java.sun.com/docs/books/tutorial/ JDBC Database Access jdbc/index.html home.mindspring.com/~thornton. JDBC Basics error... rose/articles/JDBC/JDBC_Basics.html Tutorial: Java Servlets, JSP, Jakarta- error page... www.yolinux.com/TUTORIALS/ Tomcat, a Database (PosgreSQL or LinuxTutorialTomcat.html MySQL), Apache, and Linux Installation resources/software.html An SQL Exception www.esri.com ArcUser AprilJune 2005 57

3 Hands On Connecting an ArcIMS Site to an External Database Continued from page 57 Parcel Information ID = GIS ID = Address = Listing 7: Source code for myJSP.jsp. Comments are shown in green, JSP/Java codes are in blue, and HTML tags and text are in black. 58 ArcUser AprilJune 2005 www.esri.com

Load More