Oracle数据库链接（一）

没有使用ConnDBa辅助类package two;
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();
        }
      }
    }

}