import java.nio.file.Files;
import java.nio.file.Paths;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;


public class Cursor{


	@SuppressWarnings("unused")
	public static void main (String [] args) throws SQLException {
		Scanner teclado = new Scanner(System.in);
		int opcion=0, presupuesto,coddept, opcionDos=0, nuevoCodigo;
		String nombre, ciudad, cadena;
		String consulta = "select * from emple";
		List datos = new ArrayList();
		Connection conn;
		try {
			conn = leerConfig();
			Statement s = conn.createStatement();
			ResultSet rs = s.executeQuery(consulta);
			while(rs.next()) {
				System.out.println(rs.getInt("EMPNO") + "\t" + rs.getString("APELLIDO") + "\t" + rs.getString("OFICIO") + "\t" +
						rs.getInt("DIR") + "\t" + rs.getString("FECHAALT") + "\t" + rs.getInt("SALARIO") + "\t" + rs.getInt("COMISION") + "\t" +rs.getInt("DEPTNO") );
			}

		}catch (Exception e){
			System.out.println(e);
		}
	}
	private static Connection leerConfig() {
		List<String> lineas = new ArrayList<String>();
		String dbName, connectionURL;
		Connection conn = null;
		try {
			lineas = Files.readAllLines(Paths.get("config.txt"));
		} catch (Exception e) {
			e.printStackTrace();
		}
		dbName ="@" + lineas.get(0)+ ":" + lineas.get(1) +":" + lineas.get(2);
		connectionURL = "jdbc:oracle:thin:" + dbName;
		try {
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			//database connect
			conn = DriverManager.getConnection(connectionURL , lineas.get(3),lineas.get(4));
			System.out.println("Conectado");
		}catch(Exception e){
			System.out.println("Opcion no valida");
		}
		return conn;
	}
}