package ru.nsu.ccfit.matveev.db.DB;

import java.sql.*;
import java.util.Vector;

/**
 * Created with IntelliJ IDEA.
 * User: alex
 * Date: 16.05.13
 * Time: 20:23
 * To change this template use File | Settings | File Templates.
 */
public class DataBase {
    private static DataBase ourInstance = new DataBase();

    private Connection connection;
    private Statement statement;

    public static DataBase getInstance() {
        return ourInstance;
    }

    private DataBase() {
        try {
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
        } catch (SQLException e) {
            e.printStackTrace();
            System.exit(1);
        }

        try {
            connection = DriverManager.getConnection("jdbc:oracle:thin:@10.4.0.119:1521:", "matveev_0204", "matveev_0204");
            if (!connection.isClosed()) {
                System.out.println("Successfully connected to OracleSQL server...");
            }
            statement = connection.createStatement();
        } catch (SQLException e) {
            System.err.print(e);
        }
    }

    public Statement getStatement(){
        return statement;
    }

    public Vector getNamesOfTables(){
        Vector res = new Vector();
        int i = 0;
        try {
            String query = "select TABLE_NAME from USER_TABLES";
            ResultSet resultSet = statement.executeQuery(query);
            while(resultSet.next())
            {
                Vector row = new Vector();
         //       System.out.print(resultSet.getString(1));
                row.add(0,resultSet.getString(1));
                res.add(i,row);
                i++;
            }
        } catch (SQLException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
        return res;
    }
}