问题

import java.sql.*;
public class TestJDBC
{
 public static void main(String[] args)throws Exception
 {
  Class.forName("oracle.jdbc.driver.OracleDriver");//会自动向大管家DriverManager注册
  Connection conn=DriverManagr.getConnection("url,user,password);//大管家Drivermanager连接到数据库
  Statement stmt=conn.creatStatement();
  ResultSet rs=stme.executrQuery(sql);
  
  while(rs.next())
  {
   System.out.println(rs.getString(" .... "));//如果在这之间出现异常，可能导致以下资源无法关闭，导致系统瘫痪，最好使用try....catch语句，不能直接抛出
   System.out.println(rs.getInt(" .... "));
   
  }
  rs.close();
  stmt.close();
  conn.close();
 }
}

比较完美的写法：

import java.sql.*;

public class TestJDBC {

 public static void main(String[] args) {
  ResultSet rs = null;以后还要用到，故定义写在外面
  Statement stmt = null;
  Connection conn = null;
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   //new oracle.jdbc.driver.OracleDriver();
   conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");
   stmt = conn.createStatement();
   rs = stmt.executeQuery("select * from dept");
   while(rs.next()) {
    System.out.println(rs.getString("deptno"));
    System.out.println(rs.getInt("deptno"));
   }
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   try {
    if(rs != null) {//进行判断，如果未进行初始化而进行关闭的话会抛出异常
     rs.close();
     rs = null;
    }
    if(stmt != null) {
     stmt.close();
     stmt = null;
    }
    if(conn != null) {
     conn.close();
     conn = null;
    }
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
 }

}