jdbc prvi put

JDBC
1.NADJI...SELECT NAREDBA ,OBICAN STATEMENT

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 Nikola
 */
public class JDBCTest1 {
    public static void main(String[] args) {
        nadjiOdeljenja();
    }

    private static void nadjiOdeljenja() {
        String url= "jdbc:oracle:thin:@localhost:1521:XE";
        //jdbc:oracle:thin je protokol
        //localhost gde radimo,na nasem racunaru
        //1521 port
        //XE ili orcl je SID
        String upit="select * from odeljenje";

        try(Connection conn=DriverManager.getConnection(url,"student","student");
            Statement stat=conn.createStatement();
            ResultSet rs=stat.executeQuery(upit)) {


            //vracamo rezultat iz redova
            while(rs.next()){
                int sifra=rs.getInt("sifraodelj");// po broju kolone
                String naziv=rs.getString("nazivodelj");
                String grad=rs.getString("grad");//ovde nazivi kolona nisu casesensitive!

                 System.out.println("sifra: "+sifra+" Naziv: "+naziv+"Grad: "+grad);
            }



        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest1.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}
-------------------------
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 Nikola
 */
public class JDBCTest1 {
    public static void main(String[] args) {
        nadjiOdeljenja();
    }

    private static void nadjiOdeljenja() {
        String url= "jdbc:oracle:thin:@localhost:1521:XE";
        //jdbc:oracle:thin je protokol
        //localhost gde radimo,na nasem racunaru
        //1521 port
        //XE ili orcl je SID
        String upit="select * from odeljenje WHERE grad='Nis'";
// String upit="select * from odeljenje WHERE sifraodelj='50'";
//vrednosti pisem pod jednostrukim navodnicima!!!!!!!!!

        try(Connection conn=DriverManager.getConnection(url,"student","student");
            Statement stat=conn.createStatement();
            ResultSet rs=stat.executeQuery(upit)) {


            //vracamo rezultat iz redova
            while(rs.next()){
                int sifra=rs.getInt("sifraodelj");// po broju kolone
                String naziv=rs.getString("nazivodelj");
                String grad=rs.getString("grad");//ovde nazivi kolona nisu casesensitive!

                 System.out.println("sifra: "+sifra+" Naziv: "+naziv+"Grad: "+grad);
            }



        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest1.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}


2. hocu da dodam odeljenje-----INSERT
package jdbc;

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

/**
 *
 * @author Nikola
 */
public class JDBCTest2 {
    public static void main(String[] args) {
        dodajOdeljenje(150,"Proba","Novi Sad");
    }

    private static void dodajOdeljenje(int sifra, String naziv, String grad) {
        String url="jdbc:oracle:thin:@localhost:1521:XE";
                String upit="insert into odeljenje values(?,?,?)";

        try (Connection conn=DriverManager.getConnection(url,"student","student");
            PreparedStatement ps=conn.prepareStatement(upit)){

            conn.setAutoCommit(false);//!!!!

            ps.setInt(1, sifra);
            ps.setString(2, naziv);
            ps.setString(3, grad);


            int count=ps.executeUpdate();//!!!!!!!!!
            if(count>0){
            conn.commit();
            }else{
            conn.rollback();
            }
        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest2.class.getName()).log(Level.SEVERE, null, ex);
        }


    }

}





3.UPDATE!
package jdbc;

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

/**
 *
 * @author Nikola
 */
public class JDBCTest3 {
    public static void main(String[] args) {
        izmeni(20);
    }

    private static void izmeni(int sifra) {
        String url="jdbc:oracle:thin:@localhost:1521:XE";
        String upit="update odeljenje set nazivodelj='Ana' where sifraodelj=?";

        try (Connection conn=DriverManager.getConnection(url,"student","student");
            PreparedStatement ps=conn.prepareStatement(upit)){

            conn.setAutoCommit(false);

            ps.setInt(1, sifra);

            int count=ps.executeUpdate();
            if(count==1){
            conn.commit();
            }else{
            conn.rollback();
            }

        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest3.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}

4. DELETE
public class JDBCTest4 {
    public static void main(String[] args) {
        izbrisi(50);
    }

    private static void izbrisi(int sifra) {
        String url="jdbc:oracle:thin:@localhost:1521:XE";
        String upit="delete from odeljenje where sifraodelj=?";

        try (Connection conn=DriverManager.getConnection(url,"student","student");
            PreparedStatement ps=conn.prepareStatement(upit)){

            conn.setAutoCommit(false);
            ps.setInt(1, sifra);

            int count=ps.executeUpdate();
            if(count>0){
            conn.commit();

            }else{
            conn.rollback();
            }


        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest4.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}

5. datum string varijanta
package jdbc;

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

/**
 *
 * @author Nikola
 */
public class JDBCTest5 {
    public static void main(String[] args) {
        unesi(50,"Beni","12-JAN-2018","pas","snaucer");
    }

    private static void unesi(int ljubimacid, String ime, String datumrodjenja, String vrsta, String rasa) {
        String url="jdbc:oracle:thin:@localhost:1521:XE";
        String upit="insert into kucni_ljubimac values(?,?,?,?,?)";


        try (Connection conn=DriverManager.getConnection(url,"student","student");
            PreparedStatement ps=conn.prepareStatement(upit)){

            conn.setAutoCommit(false);

            ps.setInt(1, ljubimacid);
            ps.setString(2, ime);
            ps.setString(3, datumrodjenja);
            ps.setString(4, vrsta);
            ps.setString(5, rasa);

            int count=ps.executeUpdate();
            if(count>0){
            conn.commit();
            }else{
            conn.rollback();
            }

        } catch (SQLException ex) {
            Logger.getLogger(JDBCTest5.class.getName()).log(Level.SEVERE, null, ex);
        }

    }

}