package dbProject;

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

public class DataBase {
    public static void main(String args[]) {
        String user = "kursova";
        String pass = "bd";

        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) {
            e.printStackTrace();
        }
    }
}