oradriver.java

郭克华j2ee高级框架实战教学视频源代码 这个是比较值得一看的 由郭克华博士在总结多年Java培训的基础上

import java.sql.*;

public class OraDriver{
	public static void main(String args[]) throws Exception{
		//利用Oracle驱动进行连接
		Class.forName("oracle.jdbc.driver.OracleDriver");//载入驱动
		String url = "jdbc:oracle:thin:@localhost:1521:SCHOOL";
		Connection conn = DriverManager.getConnection(url,"scott","tiger");
		Statement stat = conn.createStatement();
		ResultSet rs = stat.executeQuery("SELECT 姓名 FROM 学籍");
		while(rs.next()){
			System.out.println(rs.getString("姓名"));
			}
		}
	}