/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author FON
 */
public class JDBCTest1 {
    //psvm
    public static void main(String[] args) {
        nadjiOdeljenja();

    }



    public static void nadjiOdeljenja(){

        String url="jdbc:oracle:thin:@localhost:1521:orcl";
            String upit="select * from odeljenje";

        try {
            //konekcija ka bazi
            //url username,password
            Connection conn = DriverManager.getConnection(url, "student", "student");

            Statement stat=conn.createStatement();
            //execute Query izvrsavanje upita
            //promenljicva u kojoj se prihvata rezultat upita
            ResultSet rs=stat.executeQuery(upit);
            while(rs.next()){
            //uzima se sifra iz upita
            //moze da se stavi i 1 jer je prvi red
            int sifra =rs.getInt(1);
            //naziv kolone
            String naziv=rs.getString(2);
            String grad=rs.getString(3);

            //sout
                System.out.println("Sifra "+sifra+" ,naziv "+naziv+" ,grad "+grad);
            }
            rs.close();
            stat.close();
            conn.close();
        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest1.class.getName()).log(Level.SEVERE, null, ex);
        }


    }








}