JDBC 连接 Oracle

驱动依赖

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>10.1.0</version>
</dependency>

JDBC

Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@172.24.4.94:1521:orcl";
String username = "qblldb7";
String password = "passW0RD";
//在表QB_DICT 中，从第1开始，回去10条数据
String sql = "select * from QB_DICT WHERE ROWNUM < 10";
//获取连接
Connection connection = DriverManager.getConnection(url, username, pas
//执行SQL
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery();
//遍历结果
while (resultSet.next()) {
    String col1 = resultSet.getString(1);
    String col2 = resultSet.getString(2);
    String col3 = resultSet.getString(3);
    System.out.println(col1 + "\t" + col2 + "\t" + col3 + "\t");
}