java db연결 기본

package chapter16;
import java.sql.*;

public class Exam134 {
 public static void main(String[] ar) {
  try {
   Class.forName("com.mysql.jdbc.Driver");
   System.out.println("Driver OK!");
  } catch (ClassNotFoundException e) {
   System.out.println("Oh no~~~~~~~~~~~~~~~~~~~" + e);
  }
 
  String url  = "jdbc:mysql://localhost:3306/java";
  String id  = "root";
  String pass = "1234";
 
  try {
   Connection conn = DriverManager.getConnection(url, id, pass);
   System.out.println("DBConnection OK!");
   
   String query = "Select * from person";
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   
   while(rs.next()) {
    int num   = rs.getInt("num");
    String name  = rs.getString("name");
    String jumin  = rs.getString("jumin");
    String address = rs.getString("address");
   
    System.out.println(num + "\t" +  name + "\t" + jumin + "\t" + address );
   }
     
  } catch (SQLException e) {
   System.out.println("SQL Oh no~~~~~~~~~~~~~~~~~~~" + e);
  }
 
 
 }
}