Oracle+JDBC连接实例

import java.sql.*;

public class Jdbc{
	private static String Driver = "oracle.jdbc.driver.OracleDriver";	//加载jdbc连接oracle的驱动包
	private static String url = "jdbc:oracle:thin:@127.0.0.1:1521:Exercise";	//连接数据库的url注意：<span style="background-color: rgb(255, 0, 0);">thin后面的冒号、端口号、末尾不要加分号</span>
	private static String root = "scott";	//数据库登录用户名
	private static String pwd = "tiger";	//登录密码

	/**
	*获取数据库连接
	*/
	private static Connection conn;
	public static Connection getConnection(){
		try{
			Class.forName(Driver);
			conn = DriverManager.getConnection(url,root,pwd);
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(SQLException e){
			e.printStackTrace();
		}
		return conn;	//返回数据库连接
	}	
	/**
	*关闭数据库连接
	*/
	public static void closeConnection(Connection conn){
		try{
			conn.close();
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	public static void main(String arg[]){
		Connection conn = Jdbc.getConnection();
		String sql = "select * from person";
		try{
			PreparedStatement pstm = conn.prepareStatement(sql);
			ResultSet res = pstm.executeQuery();
			while(res.next()){
				String name = res.getString("username");
				System.out.println(name);
			}
		}
		catch(SQLException e){
			e.printStackTrace();
		}
	}
}

下面附上连接数据库的驱动

OJdbc14.jar