JDBC 连接 Oracle

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

 

public class Test

{

    public static void main(String[] args) throws Exception

    {

        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

        Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.2.100:1521:orcl", "username", "password");

        Statement stmt = conn.createStatement();

        stmt.execute("select * from dual");

        ResultSet rs = stmt.getResultSet();

        while (rs.next())

        {

            System.out.println(rs.getString("DUMMY"));

        }

    }

}