/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package beadando;
import java.sql.*;

/**
 *
 * @author Levente
 */
public class Main {
 static Connection conn;

    /**
     * @param args the command line arguments
     */
public static void kapcsolodas(){
    try{
    DriverManager.registerDriver(
    new oracle.jdbc.driver.OracleDriver());
    conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/XE","leva","xi1edil2");
    conn.close();
    }
    catch(SQLException e){
    e.printStackTrace();
    }
 }

public static void motorSelect(){
         try {
         Statement stmt = conn.createStatement();
         ResultSet rs = stmt.executeQuery("SELECT * FROM MOTORKEREKPAR");

         System.out.println(rs);
         while (rs.next()){
         //rs.next();
           System.out.println(rs.getObject(1)+" "+rs.getObject(2));
         }
         }
         catch (SQLException e){
          e.printStackTrace();
        }


}


    public static void main(String[] args) {

        kapcsolodas();
        motorSelect();

    }

}