JDBC_Test

import java.sql.*;

public class JDBC_Test{

  private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

  private static final String url = "jdbc:oracle:thin:@192.168.1.243:1521:orcl";

  private static final String USER ="scott";

  private static final String PWD ="tiger";

  public static void main(String args[]){

//1 Driver loading............

//2 Connection

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

String name = "sewonhwang";

String age = "28";

String address = "방배동";

  //

  String query = "select * from test";

try{

Class.forName(DRIVER);

System.out.println("Driver loading....ok");

   con = DriverManager.getConnection(url,USER,PWD);

        System.out.println("Connection....OK");

       stmt = con.createStatement();

  System.out.println("세수대야....OK");

//int count = stmt.executeUpdate(query);//이부분에서 에러가 가장 많이 발생함...

rs = stmt.executeQuery(query);

while(rs.next()){

          name = rs.getString("name");

 age = rs.getString("age");

 address = rs.getString("address");

 System.out.println(name+" "+age+" "+address);

}

/*if(count != 0){

System.out.println("query....OK");

}else{

System.out.println("query....FAIL");

}*/

     }catch(Exception e){

       e.printStackTrace();

       e.getMessage();

}

  }

}