Java连接Oracle数据库的实例
package com; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class TestJdbc { public static void main(String[] args){ try{ //String driverName="oracle.jdbc.driver.OracleDriver"; //Class.forName(driverName); Class.forName("oracle.jdbc.driver.OracleDriver"); String url="jdbc:oracle:thin:@localhost:1521:orcl"; String userName = "name"; String passWord = "orcl"; Connection conn = DriverManager.getConnection(url, userName, passWord); Statement stmt = conn.createStatement(); String sql = "select * from userinfo"; ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ String id = rs.getString("user_id"); String name = rs.getString("user_name"); String age = rs.getString("user_age"); System.out.println(id + "," + name + "," + age + ","); } rs.close(); stmt.close(); conn.close(); }catch (ClassNotFoundException e){ e.printStackTrace(); }catch (SQLException e) { e.printStackTrace(); } } } 实例环境为本地已安装oracle数据库，且已经创建表空间及用户，并存在表及数据，执行完即可看到输出指定字段的内容。