後端JSP檔案裡Java語言如果操作Oracle Spatial提供的JGeometry對象，spatialjgeometry

最後更新：2014-11-26 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

記個流水賬，記錄下這個困擾自己多時的問題最後怎麼解決的。當時覺得該嘗試的都嘗試了，納悶到底怎樣能解決的，最後還是解決了~

正確的代碼如下：

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.*,oracle.spatial.geometry.*,oracle.spatial.util.*,oracle.sql.*"  errorPage="" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>no title text</title></head><body><% response.addHeader("Access-Control-Allow-Origin", "http://192.168.14.216:8888");//oracle.spatial.geometry.*,oracle.jdbc.driver.*,oracle.sql.STRUCT;    //out.print("OK!");String SQLStatement ="";String sp =request.getParameter("sp");//out.print(sp);Class.forName("oracle.jdbc.driver.OracleDriver"); //載入JDBC驅動程式//建立串連String URL = "jdbc:oracle:thin:@localhost:1521:cad"; Connection conn = DriverManager.getConnection(URL,"cadadmin","cad");/*if(conn.isClosed()) out.print("Failed to connect to the database!");else  out.print("Succeed connecting to the database!");*/Statement stmt=conn.createStatement();//求sp房間所對應的對象集合//SQLStatement = "select rm.x,rm.y,rm.z from table(select geom from room where idc = "+sp+") rm";//SQLStatement = "select mo.x,mo.y,mo.z,mo.room_id from table(select NavWithPosIndoor(position4indoor("+pos1id+","+pos1x+","+pos1y+","+pos1z+"),position4indoor("+pos2id+","+pos2x+","+pos2y+","+pos2z+"),ind.indoor) from inSpace ind) mo";    SQLStatement = "select geom from room where idc = "+sp;ResultSet res_room=stmt.executeQuery(SQLStatement);if(res_room.next()){  STRUCT dbObject=(STRUCT)res_room.getObject(1);  JGeometry geom=JGeometry.load(dbObject);  int plen=geom.getNumPoints();//點個數  //out.print("plen"+plen);  double rmzb[]=new double[plen*2];  rmzb=geom.getOrdinatesArray();  for(int i=0;i<plen*2;++i)  {   out.print(rmzb[i]+",");  }  //String rmid=res_room.getString(1);  //out.print("room:"+rmid);  //String rmx=res_room.getString(2);  //String rmy=res_room.getString(3);  //String rmz=res_room.getString(4);  //out.print("room:"+rmid+" "+rmx+" ");//+rmy+" "+rmz+" ");}out.print("1");stmt.close();conn.close();%></body></html>

其中，由於地圖是在8888連接埠，而該jsp檔案是在tomcat檔案夾下webapps檔案夾下建立的專案檔夾下，在8080連接埠。在chrome瀏覽器運行，需要如下代碼：

response.addHeader("Access-Control-Allow-Origin", "http://192.168.14.216:8888");

然後由於用到JGeometry對象，JGeometry對象是在sdoapi.jar中提供的。其中需要用到sdoapi.jar和sdoutl.jar。所以需要在頭資訊的import裡匯入相應包：oracle.spatial.geometry.*,oracle.spatial.util.*,oracle.sql.*

import="java.sql.*,java.lang.*,oracle.spatial.geometry.*,oracle.spatial.util.*,oracle.sql.*"

我之前置入的是oracle.spatial.geometry.*,oracle.jdbc.driver.*,oracle.sql.STRUCT; 沒有匯入oracle.spatial.util.*，可能導致JGeometry類型報錯。

之前都是在瀏覽器載入jsp頁面時報錯JGeometry是未定義類型。後來沒報這個錯了，但還是有問題，一直以為還是這個問題，以為JGeometry不可用。（因為之前報JGeometry錯的時候，也是有時報錯有時不報錯。）

然後程式裡，通過select geom 去除sdo_geometry對象，再進行getObject和load。其中getObject()中的索引是指總共的項索引，不是指Object的索引。比如第一個屬性是String，第二個屬性是sdo_geometry。則取值依次為getString(1)和getObject(2)。我之前是select *了，然後getObject(1)，所以是有問題的。(select * 出來的第一個是String，第二個是sdo_geometry)

SQLStatement = "select geom from room where idc = "+sp;ResultSet res_room=stmt.executeQuery(SQLStatement);if(res_room.next()){  STRUCT dbObject=(STRUCT)res_room.getObject(1);  JGeometry geom=JGeometry.load(dbObject);

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More