Advertisement
Guest User

Untitled

a guest
Apr 25th, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.05 KB | None | 0 0
  1. package jdbc;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import java.util.logging.Level;
  10. import java.util.logging.Logger;
  11.  
  12.  
  13. public class JDBCTest {
  14.    
  15.     public static void main(String[] args) {
  16.         nadjiOdeljenja();
  17.         dodajOdeljenje(60, "Test", "Test");
  18.         nadjiOdeljenja();
  19.     }
  20.    
  21.     public static void nadjiOdeljenja() {
  22.         String url = "jdbc:oracle:thin:@localhost:1521:orcl";
  23.         String upit = "select * from odeljenje";
  24.        
  25.         try (Connection con = DriverManager.getConnection(url, "student", "student");
  26.                 Statement stat = con.createStatement();
  27.                 ResultSet rs = stat.executeQuery(upit);) {
  28.             while(rs.next()) {
  29.                 int sifra = rs.getInt(1);
  30.                 String naziv = rs.getString("nazivodelj");
  31.                 String grad = rs.getString(3);
  32.                 System.out.println("Sifra: "+sifra+", naziv: "+naziv+", grad: "+grad);
  33.             }
  34.         } catch (SQLException ex) {
  35.             Logger.getLogger(JDBCTest.class.getName()).log(Level.SEVERE, null, ex);
  36.         }
  37.     }
  38.    
  39.     public static void dodajOdeljenje(int sifra, String naziv, String grad) {
  40.         String url = "jdbc:oracle:thin:@localhost:1521:orcl";
  41.         String upit = "insert into odeljenje values(?,?,?)";
  42.        
  43.         try (Connection con = DriverManager.getConnection(url, "student", "student");
  44.                 PreparedStatement ps = con.prepareStatement(upit)) {
  45.             con.setAutoCommit(false);
  46.             ps.setInt(1, sifra);
  47.             ps.setString(2, naziv);
  48.             ps.setString(3, grad);
  49.             int broj = ps.executeUpdate();
  50.             if(broj > 0) {
  51.                 con.commit();
  52.             } else {
  53.                 con.rollback();
  54.             }
  55.         } catch (SQLException ex) {
  56.             Logger.getLogger(JDBCTest.class.getName()).log(Level.SEVERE, null, ex);
  57.         }
  58.     }
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement