oracle数据库建立链接-优快云博客

本文提供了一个使用Java连接并查询Oracle数据库的示例，包括数据库驱动注册、URL配置、用户验证、创建Statement和执行SQL查询的过程。通过实例演示了如何从Java应用中获取Oracle数据库的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package db;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
import java.util.Vector;

public class OracleConn
{

    private final static String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";
    protected static Connection dbConnection = null;
    public static boolean openConnection() throws SQLException
    {
        boolean bSucceed = false;

        String strURL = "jdbc:oracle:thin:@10.40.111.20:1521:uep" ;
        StringBuffer sbInfo = new StringBuffer(200);
        sbInfo.append("openConnection():strDriver=oracle.jdbc.driver.OracleDriver;jdbcUrl=jdbc:oracle:thin:@10.40.111.20:1521:uep;dbuser=system;password=password");
        Statement stmt = null;
        ResultSet rs = null;
            try
            {
                DriverManager.registerDriver((Driver) Class.forName(JDBC_DRIVER).newInstance());
            }
            catch(Exception ex)
            {
                ex.printStackTrace();
            }

        try
        {
            //加此调试是为了诊断代码是否停在下面的getConnection那里了。
            //dMsg.info("- 0 Try to connect: "+dbInfo.getDBMSKey());
            Properties prop = new Properties();
            prop.put("user", "system");
            prop.put("password", "netnumen");

            Driver driver = DriverManager.getDriver(strURL);
            DriverManager.setLoginTimeout(60);
            dbConnection = driver.connect(strURL, prop);
            //使用下面代码容易产生阻塞
            //dbConnection = DriverManager.getConnection(strURL,
            //                                          this.dbInfo.getUser(),
            //                                        this.dbInfo.getPassword());
            stmt = dbConnection.createStatement();
            rs = stmt.executeQuery("select * from caffm.caf_alarm");

            while(rs.next())
            {
               // Vector vecTablespaceInfo = new Vector(5);
                System.out.println("haha");
            }
            bSucceed = true;
        }
        catch(SQLException sqlEx)
        {
            if(dbConnection!=null)
            {
                dbConnection.close();
            }
            sqlEx.printStackTrace();
            bSucceed = false;
            throw sqlEx;
        }
        catch(Exception ignore)
        {
            if(dbConnection!=null)
            {
                dbConnection.close();
            }
            ignore.printStackTrace();
            bSucceed = false;

        }
        //dMsg.info("- 1 End to connect: "+dbInfo.getDBMSKey());
        return bSucceed;
    }



    public static void main(String[] args)
    {
        try
        {
            openConnection();
        }
        catch(SQLException e)
        {

            e.printStackTrace();
        }
        System.out.println("ok");
    }

}