oracle spatialÓëjdbcµÄÎÊÌâ
СŮĿǰcreateÁËÒ»¸ötable °üº¬sdo_geometryÀàÐ͵ÄÊôÐÔ¡£
±íºÍÊý¾Ý¶¼ÒѾ²åºÃÁË~
¿ÉÊÇÈ´²»ÖªµÀÔõô¶Á³öÀ´
ÎÒÓÃ ResultSet rs = statement.executeQuery("select * from table");
Ϊʲô¾Í¶Á²»³öÀ´ÄØ£¿
±È½Ï½ô¼± ¿ÒÇë¸÷λ´óÏÀÖ¸½Ì ÏÈÔÚÕâÀïл¹ý´ó¼Ò^^
ÄãÊý¾Ý¿âÓÐÁ´½ÓÂð¡£
ResultSet rs Õâ¸öÖ»ÊÇ»ñµÃÕâÕűíµÄ½á¹û¼¯¡£
Äã¿ÉÒÔ Ò»¸öÑ»· À´»ñÈ¡Õâ¸öÊý¾Ý¼¯ÖеÄÊý¾Ý£¬
¾ßÌåÔõô²Ù×÷£¬ÓеãÒÅÍüÁË£¬ºÃ¾ÃûÓÐÓÃjavaÁË£¬Äã×Ô¼º¿´Ò»Ï°ɡ£²é²é×ÊÁÏ¡£
¼ÇµÃÊÇRS.GET("×Ö¶Î")
Statement sta=con.createStatement();
ResultSet rs=sta.executeQuery(sql);
rs.next();
System.out.println(rs.getInt(1));
System.out.println(rs.getInt(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
лл´ó¼Ò~ ÆäʵÊÇÎÒÁ¬½ÓÓеãÎÊÌâ ÒѾ½â¾öÁË
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......