Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Java²åÈëOracle Spatial¿Õ¼äÊý¾Ý

Java¶ÁÈ¡µØÀíÐÅÏ¢Êý¾ÝÎļþ£¬²¢½«Æä´æÈëOracleÊý¾Ý¿â¡£
package file;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.spatial.geometry.JGeometry;
import oracle.sql.STRUCT;
import util.DBConn;
public class ParseFile {
 
 private static String driverClassName = "oracle.jdbc.driver.OracleDriver";
 private static String url = "jdbc:oracle:thin:@localhost:1521:orcl";
 private static String username = "SUPER";
 private static String password = "SUPER";
 private static Connection conn;
 private static Statement stmt;
 private static PreparedStatement ps;
 private static ResultSet rs;
 
 public static void main(String[] args) throws IOException, SQLException {
  
  conn = DBConn.getConn(driverClassName, url, username,password);
  
  parseFile(new File("E:\\My Documents\\WS\\Dhubei.MID"));
  
 }
 public static void parseFile(File file) throws IOException, SQLException {
  
  if (!file.exists()) {// ÅжÏÎļþÊÇ·ñ´æÔÚ
   return;
  }
  String fileName = file.getName();// »ñÈ¡ÎļþÃû
  String tableName = fileName.split("\\.")[0];// »ñÈ¡±íÃû
  BufferedReader brMIF = null;// ÉùÃ÷Ò»¸ö»º³åÁ÷¶ÔÏóÓÃÀ´¶ÁÈ¡MIFÎļþ
  BufferedReader brMID = null;// ÉùÃ÷Ò»¸ö»º³åÁ÷¶ÔÏóÓÃÀ´¶ÁÈ¡MIDÎļþ
  String lineMIF = "";// ½ÓÊÕÒ»ÐÐMIFÎļþÀïµÄ×Ö·û´®
  String lineMID = "";// ½ÓÊÕÒ»ÐÐMIDÎļþÀïµÄ×Ö·û´®
  if (fileName.indexOf("MIF") != -1) {// Èç¹ûÊÇMIF¸ñʽÎļþ£¬×Ô¶¯Ñ°ÕÒMID¸ñʽÎļþ
   brMIF = new BufferedReader(new FileReader(file));
   brMID = new BufferedReader(new FileReader(new File(file.getParent(


Ïà¹ØÎĵµ£º

oracle ´æ´¢¹ý³ÌʵÏÖ·ÖÒ³

  ÓÃoracleÊý¾Ý¿âµÄ´æ´¢¹ý³ÌʵÏÖ·µ»Ø½á¹û¼¯²¢ÊµÏÖ·ÖÒ³µÄ¹¦ÄÜ¡£
Óû§´«Èë²ÎÊý
Ò»ÏÂÊÇת±ðÈ˵ĴúÂë
--°üÉùÃ÷
create or replace package p_page is
  -- Author  : PHARAOHS
  -- Created : 2006-4-30 14:14:14
  -- Purpose : ·ÖÒ³¹ý³Ì
  TYPE type_cur IS REF CURSOR;  &n ......

OracleÖÐÓÃRowid²éÕÒºÍɾ³ýÖØ¸´¼Ç¼

OracleÖÐÓÃRowid²éÕÒºÍɾ³ýÖØ¸´¼Ç¼
¡¡¡¡Æ½Ê±¹¤×÷ÖпÉÄÜ»áÅöµ½µ±ÊÔͼ¶Ô¿â±íÖеÄijһÁлò¼¸Áд´½¨Î¨Ò»Ë÷Òýʱ£¬ÏµÍ³Ìáʾ ORA-01452 £º²»ÄÜ´´½¨Î¨Ò»Ë÷Òý£¬·¢ÏÖÖØ¸´¼Ç¼¡£
¡¡¡¡ÏÂÃæ×ܽáһϼ¸ÖÖ²éÕÒºÍɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¨ÒÔ±íCZΪÀý£©£º
¡¡¡¡±íCZµÄ½á¹¹ÈçÏ£º
¡¡¡¡SQL> desc cz
¡¡¡¡Name Null? Type
¡¡¡¡---------- ......

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî(»ù´¡µÄ¼ÇÒä) 
¿ªÊ¼Ñ§Ï°ORACLEÓï¾äÓÅ»¯,´ÓÖ´Ðмƻ®¿ªÊ¼,ÏÈÊìϤÕâЩÃû´ÊÒÔ¼°»ù±¾º¬Òå,¼ÇÒäÔÚÎÒÄÔ×ÓÀï,2010-04-10
Rowid£ºÏµÍ³¸øoracleÊý¾ÝµÄÿÐи½¼ÓµÄÒ»¸öαÁУ¬°üº¬Êý¾Ý±íÃû³Æ£¬Êý¾Ý¿âid£¬´æ´¢Êý¾Ý¿âidÒÔ¼°Ò»¸öÁ÷Ë®ºÅµÈÐÅÏ¢£¬rowidÔÚÐеÄÉúÃüÖÜÆÚÄÚΨһ¡£
Recursive sql£ºÎªÁËÖ´ÐÐÓû§Óï¾ ......

(Oracle£©rownumÓ÷¨Ïê½â

(Oracle£©rownumÓ÷¨Ïê½â
2008-08-06 15:41
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖÆ²éѯ·µ»ØµÄ×ÜÐÐÊý£¬ÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
(1) rownum ¶ÔÓÚµÈÓÚijֵµÄ²éѯÌõ¼þ
Èç¹ûÏ£ÍûÕÒµ½Ñ§Éú±íÖеÚÒ»ÌõѧÉúµÄÐÅÏ¢£¬¿É ......

Oracle Ìåϵ½á¹¹ ORA

Linux/UnixÉÏ£¬OracleÊǶà¸ö½ø³ÌʵÏֵģ¬Ã¿Ò»¸öÖ÷Òªº¯Êý¶¼ÊÇÒ»¸ö½ø³Ì£»ÔÚWindowsÉÏ£¬ÔòÊÇÒ»¸öµ¥Ò»½ø³Ì£¬½ø³ÌÖаüº¬¶à¸öÏ̡߳£
Oracle°ÑһϵÁÐÎïÀíÎļþ£¬ÈçÊý¾ÝÎļþ(Data file)¡¢¿ØÖÆÎļþ(Control file)¡¢Áª»úÈÕÖ¾(Redo log file)¡¢²ÎÊýÎļþ(spfile or pfile)µÈÎïÀí½á¹¹¼°ÓëÖ®¶ÔÓ¦µÄÂß¼­½á¹¹£¬Èç±í¿Õ¼ä(Tablespace)¡¢¶Î(Seg ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ