eclipse调用jdbc连接oracle

这是参考网上一个哥们的文章写的， 链接忘了...特此留一行- -

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");
   conn = DriverManager.getConnection("jdbc:oracle:thin:@IP地址:端口:数据库名", "用户名", "密码");
   stmt = conn.createStatement();
   rs = stmt.executeQuery("select * from table");
   while(rs.next()) {
     System.out.println(rs.getInt("SERVICE_NUMBER"));
   }
  } 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();
   }
  }
 }

}