Oracle_jdbc_connect

1. mvn dependence

 

 写道

刚研究maven不久，遇到一个比较头疼的问题，在工程里怎么下都下载不了oracle的jdbc驱动。

刚还以为是网络问题，重新下载了很多次，都提示maven库里找不到相关jar文件。网上一查，原来是这个驱动包是需要Oracle官方授权才能被我们下载。没办法，只能找来一个ojdbc14的10.2.0.1.0包，通过下面的命令，让maven放到本地库中去：

mvn install:install-file -DgroupId=com.oracle -DartifactIdojdbc14 -Dversion=10.2.0.1.0 -Dpackaging=jar -Dfile=ojdbc.jar

然后再在工程中加入如下配置即可：

<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.1.0</version>
</dependency>

  2.Connect :

// Copyright (c) 1998-2011 Core Solutions Limited. All rights reserved.
package com.mark.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author mark.lin
 */
public class OracleConnect {
    static Connection conn;
    static Statement stm;
    static ResultSet rs;
    static String driver = "oracle.jdbc.driver.OracleDriver";
    static String url = "jdbc:oracle:thin:@localhost:1521:core";

    public static void main(String[] args) {
        try {
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
            conn = DriverManager.getConnection(url, "user", "password");
            stm = conn.createStatement();
            // initialed 10000 records.
            int begin_id = 1;
            int records = 10000;
            for(int i = begin_id ;i < records ; i++){
                stm.executeUpdate("insert into t_person_no_index_id(id,name) values(" + i + ",'Mark_"+i+"')");
            }
            // stm.executeUpdate("insert into test values("+3453+")");
            rs = stm.executeQuery("select * from t_person_no_index_id");
            while (rs.next()) {
                System.out.println(rs.getInt("id"));
            }
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}