Java连接Oracle数据库

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数据库，且已经创建表空间及用户，并存在表及数据，执行完即可看到输出指定字段的内容。