Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»ù±¾²Ù×÷±¸Íü


1. ²éѯÊý¾Ý¿âÏÖÔڵıí¿Õ¼ä
select tablespace_name, file_name, sum(bytes)/1024/1024 table_size from dba_data_files group by tablespace_name,file_name;
2. ½¨Á¢±í¿Õ¼ä
CREATE TABLESPACE data01 DATAFILE '/oracle/oradata/db/DATA01.dbf' SIZE 500M; 
3.ɾ³ý±í¿Õ¼ä
DROP TABLESPACE data01 INCLUDING C ......

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

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

OracleÊý¾Ý¿â½â³ýscottÓû§Ëø

1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
      conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......

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

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