Java嵌入oracle,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(