package oracle;

import java.sql.*;
import java.util.Scanner;

public class BD {
    public static void main(String args[]) {
    String user="proekt";
    String pass="231295";
    try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe",user,pass);
    Statement stmt=c.createStatement();
    String query;
    System.out.println("Enter query to database :");
    Scanner inp=new Scanner(System.in);
    query=inp.nextLine();
    System.out.println("Enter number of column: ");
    Scanner col=new Scanner(System.in);
    int num=col.nextInt();
    ResultSet rset=stmt.executeQuery(query);
    while(rset.next()){
        for(int i=0;i<num;i++){
            System.out.print(rset.getString(i+1)+"\t");
        }
    }
    } catch (ClassNotFoundException | SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    }
}