Oracle数据库链接（一）

package one;   
import java.sql.Connection;   
import java.sql.DriverManager;   
import java.sql.ResultSet;   
import java.sql.SQLException;   
import java.sql.Statement;   
  
  
public class SingleOracleJDBC {   
  
  public static void main(String[] args) {   
  
    Connection conn=null;   
    Statement sm=null;   
    ResultSet rs=null;   
    try {   
      //1.注册驱动   
      Class.forName("oracle.jdbc.driver.OracleDriver");   
      //2.建立数据库链接    conn = DriverManager.getConnection(url, username, password);   
      conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","hello");   
      //3.创建JDBC Statement对象   
      sm=conn.createStatement();   
      //4.读取数据库   
      rs=sm.executeQuery("select * from dept");   
      while(rs.next()){   
        System.out.println("deptno==" + rs.getInt(1));   
        System.out.println("dname==" + rs.getString(2));   
        System.out.println("loc==" + rs.getString(3));   
      }   
    } catch (ClassNotFoundException e) {   
      e.printStackTrace();   
    } catch (SQLException e) {   
      e.printStackTrace();   
    }finally{   
        try {   
          if(rs!=null){   
          rs.close();   
          }   
          if(sm!=null){   
            sm.close();   
          }   
          if(conn!=null){   
            conn.close();   
          }   
        } catch (SQLException e) {   
          // TODO Auto-generated catch block   
          e.printStackTrace();   
        }   
      }   
    }   
  
}