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Êý¾Ý¿âÊÇ·ñΪ¹éµµÄ£Ê½£º[1]
¡¡¡¡1.select name,log_mode from v$database;
¡¡¡¡NAME LOG_MODE
¡¡¡¡------------------ ------------------------
¡¡¡¡QUERY NOARCHIVELOG
¡¡¡¡2.ʹ ......
oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî(»ù´¡µÄ¼ÇÒä)
¿ªÊ¼Ñ§Ï°ORACLEÓï¾äÓÅ»¯,´ÓÖ´Ðмƻ®¿ªÊ¼,ÏÈÊìϤÕâЩÃû´ÊÒÔ¼°»ù±¾º¬Òå,¼ÇÒäÔÚÎÒÄÔ×ÓÀï,2010-04-10
Rowid£ºÏµÍ³¸øoracleÊý¾ÝµÄÿÐи½¼ÓµÄÒ»¸öαÁУ¬°üº¬Êý¾Ý±íÃû³Æ£¬Êý¾Ý¿âid£¬´æ´¢Êý¾Ý¿âidÒÔ¼°Ò»¸öÁ÷Ë®ºÅµÈÐÅÏ¢£¬rowidÔÚÐеÄÉúÃüÖÜÆÚÄÚΨһ¡£
Recursive sql£ºÎªÁËÖ´ÐÐÓû§Óï¾ ......
sysÊÇOracleÊý¾Ý¿âÖÐȨÏÞ×î¸ßµÄÕʺţ¬¾ßÓÐcreate databaseµÄȨÏÞ£¬¶øsystemûÓÐÕâ¸öȨÏÞ£¬sysµÄ½ÇÉ«ÊÇsysdba£¬systemµÄ½ÇÉ«ÊÇsysoper¡£
¡¡¡¡ÆäÓà¾ÍÊÇËûÃÇÁ½¸öÓû§¹²ÓеÄȨÏÞÁË£º
¡¡¡¡startup/shutdown/dbaÁ½¸öÓû§¶¼ÊÇ¿ÉÒÔ¹ÜÀíµÄ¡£
¡¡¡¡Æ½Ê±ÓÃsystemÀ´¹ÜÀíÊý¾Ý¿â¾Í¿ÉÒÔÁË¡£Õâ¸öÓû§µÄȨÏÞ¶Ô ......
1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í ......
Linux/UnixÉÏ£¬OracleÊǶà¸ö½ø³ÌʵÏֵģ¬Ã¿Ò»¸öÖ÷Òªº¯Êý¶¼ÊÇÒ»¸ö½ø³Ì£»ÔÚWindowsÉÏ£¬ÔòÊÇÒ»¸öµ¥Ò»½ø³Ì£¬½ø³ÌÖаüº¬¶à¸öÏ̡߳£
Oracle°ÑһϵÁÐÎïÀíÎļþ£¬ÈçÊý¾ÝÎļþ(Data file)¡¢¿ØÖÆÎļþ(Control file)¡¢Áª»úÈÕÖ¾(Redo log file)¡¢²ÎÊýÎļþ(spfile or pfile)µÈÎïÀí½á¹¹¼°ÓëÖ®¶ÔÓ¦µÄÂß¼½á¹¹£¬Èç±í¿Õ¼ä(Tablespace)¡¢¶Î(Seg ......