/*****************************************************************************/
/* journal.java  */
/* But : interroger la table JOURNAL de la feuille Requetes */
/*****************************************************************************/

import java.sql.*;
import java.io.*;

public class journal {

  public static void main (String args []) throws SQLException {
    Connection conn=connexion();
    insertion(conn);
    interrogation(conn);
    deconnexion(conn);
  }
  
  static Connection connexion() throws SQLException {
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
    Connection conn =
      DriverManager.getConnection(
        "jdbc:oracle:oci8:@ORCL", "waller", "waller");
    return conn;
  }

  static void interrogation(Connection conn)  throws SQLException {
    Statement stmt = conn.createStatement();
    ResultSet rset = 
      stmt.executeQuery(
        "select TITRE, PRIX from JOURNAL where TITRE='LE CANARD'");
    rset.next();
    System.out.println("Titre: " + rset.getString(1) + "Prix: " 
                        + rset.getFloat("PRIX"));
    rset.close();
    stmt.close();
  }

  static void insertion(Connection conn)  throws SQLException {
    PreparedStatement pstmt = 
      conn.prepareStatement(
        "insert into JOURNAL (CODE_J,TITRE,PRIX) values (?, ?, ?)");
    pstmt.setInt(1, 123);
    pstmt.setString(2, "LE CANARD");   
    pstmt.setDouble(3, 20.3);
    pstmt.executeUpdate();
    pstmt.close();
  }

  static void deconnexion(Connection conn) throws SQLException {
    conn.close();
  }
}