ORACLE 连接测试

DBConnection

package com.blong.data.datasource;

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

public class DBConnection {

    public static Connection dbConn(String name, String pass) {
                Connection c = null;
               try {
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                         // 要是导入驱动没有成功的话都是会出现classnotfoundException.自己看看是不是哪里错了,例如classpath这些设置
                   } catch (ClassNotFoundException e) {
                         e.printStackTrace();
                   }
               try {
                        c = DriverManager.getConnection("jdbc:oracle:thin:@192.168.248.128:1521:orcl", name, pass);
                        // 连接数据的方法有四种, 这个属于最简单的,一般用网页程序 chenh是你的数据库实例名称，在下载的文件test.sql中可以执行语句查看
                        // "jdbc:oracle:thin:@计算机名称:监听端口:系统实例名", username, password,
                        // 计算机名称,要是自己不知道可以在计算机属性查知.
                        // 监听端口一般默认是1521, 要是改变了就看自己的监听文件listener.ora
                        // 系统实例名一般是默认orcl, 要是不是的话就用 select name from v$database; 看看当前的实例名.在本程序中我更改了实例为chenh
                        // username,password,就是登陆数据库的用户名和密码.
                    } catch (SQLException e) {
                         e.printStackTrace();
                     }
                return c;
              }
}

 

DB

package com.blong.data.datasource;

import java.sql.*;

/**
 * ORACLE12C Connection test
 */
class DB extends DBConnection{

    private static Connection con = null;
    private static Statement sql = null;
    private static ResultSet rs = null;


    public static void main(String[] args) throws SQLException {
        String COL1;
        String COL2;
        String COL3;
        String COL4;
        try {
            con = dbConn("c##stan", "stan");
            if (con == null) {
                System.out.print("连接失败");
                System.exit(0);
            }
            sql = con.createStatement();
            rs = sql.executeQuery("select * from A");

//            PreparedStatement ps = con.prepareStatement("update A set col4 = ? where col1 = ?");
//            while (rs.next()){
//                ps.clearParameters();
//                ps.setObject(1,"stan");
//                ps.setObject(2,"a1");
//                ps.executeUpdate();
//            }
            while (rs.next()) {
                COL1 = rs.getString(1);
                COL2 = rs.getString(2);
                COL3 = rs.getString(3);
                COL4 = rs.getString(4);
                System.out.println(COL1 + "    " + COL2 + "    " + COL3+ "    " + COL4);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            rs.close();
            con.close();
        }
    }
}

 

添加jar到maven本地库

mvn install:install-file -Dfile=D:/ojdbc7.jar  -DgroupId=com.oracle -DartifactId=ojdbc7 -Dversion=12.1.0.1  -Dpackaging=jar


<dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc7</artifactId>
        <version>12.1.0.1</version>
</dependency>