자바 JDBC

import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Program {
 public static void main(String[] args) throws SQLException {
  
  /*************************************************************************************/
  // Class.forName("oracle.jdbc.driver.OracleDriver");   //0.드라이버로드하기 (저절로 됨.)
  String url = "jdbc:oracle:thin:@localhost:5050:sid";
       //url = "jdbc:mysql://localhost:5050/sid";
  
  Connection con = DriverManager.getConnection(url,"id","pw"); //1. 인증 도구
  Statement stmt = con.createStatement();      //2. 실행 도구

  String sql = "select * from member";
  ResultSet rs = stmt.executeQuery(sql);      //3. select문 결과집합 (결과보기)
 
  /*************************************************************************************/
 
  String mid;
  while(rs.next()) {
   mid = rs.getString("name");
   System.out.println(mid);
  }
  
}
  rs.close();   //닫는순서 있음.
  stmt.close(); 
  con.close(); 
 }