import java.sql.*;
public class bil_c
{

  public static void main( String args[] )
  {
    String url = "jdbc:oracle:thin:";

    try
    {
      // Sök klass och länka in ...
      Class.forName(
        "oracle.jdbc.driver.OracleDriver" );
    
      // Skapa connection
      Connection db_conn =
        DriverManager.getConnection( 
          url, "javainl", "javainl" );

      // Hämta data ur DB
      Statement statement =
        db_conn.createStatement();
      ResultSet rs = statement.executeQuery(
        "select * from BIL_STAT" );

      // Skriv ut kolumnnamnen
      ResultSetMetaData rsmd =
        rs.getMetaData();
      int kolantal = rsmd.getColumnCount();

      for ( int index = 1; 
            index <= kolantal; index++ )
      {
        if ( index > 1 )
        {
          System.out.print( ", " );
        } // if
        System.out.print( 
          rsmd.getColumnLabel( index ) );
      } // for
      System.out.println();

      // Skriv ut datarader
      while ( rs.next() )
      {
        String marke = rs.getString( 1 );
        int ar = rs.getInt( 2 );
        int antal = rs.getInt( 3 );
        int summa = rs.getInt( 4 );
    
        System.out.println(
          marke + ", " + ar + ", " + 
          antal + ", " + summa );
      } // while

      // Anropa en lagrad procedur
      CallableStatement cs =
        db_conn.prepareCall( 
          "{call SELECT_1( ?, ?, ?, ?, ? )}" );

      String regnr = "BBC323";
      cs.setString( 1, regnr );
      cs.registerOutParameter( 2,
        java.sql.Types.VARCHAR );
      cs.registerOutParameter( 3,
        java.sql.Types.INTEGER );
      cs.registerOutParameter( 4,
        java.sql.Types.INTEGER );
      cs.registerOutParameter( 5,
         java.sql.Types.INTEGER );
      cs.execute();

      if ( cs.getInt( 5 ) > 0 )
      {
        // Felflagga > 0, skriv ut data
        String marke = cs.getString( 2 );
        int ar = cs.getInt( 3 );
        int nypris = cs.getInt( 4 );

        System.out.println( "SELECT_1 gav:" );
        System.out.println( marke + ", " + 
          ar + ", " + nypris );
      } // if

      // Stäng DB-kopplingar
      statement.close();
      cs.close();
      db_conn.close();
    }
    catch ( Exception exc )
    {
      System.out.println( "FEL PÅ DATAN" );
    }

  } // main
} // class bil_c