package myJdbc;

import java.sql.*;


public class MyDerby {

    public static void main(String[] args)
   {
      try {
         String driver = "org.apache.derby.jdbc.EmbeddedDriver";
        //String driver = "com.mysql.jdbc.Driver";
         Class.forName(driver).newInstance();
         Connection conn = null;
         //conn = DriverManager.getConnection("jdbc:derby://localhost:1527/car_data;user=timo;password=timo");
         //conn = DriverManager.getConnection("jdbc:mysql://localhost:3301/car_database", "timo", "timo");
         conn = DriverManager.getConnection("jdbc:derby://localhost:1527/car_data" , "timo" , "timo");

         Statement s = conn.createStatement();
         ResultSet rs = s.executeQuery("SELECT * FROM CAR");

         while(rs.next()) {
            System.out.println("MAKE   : "+ rs.getString(1));
            System.out.println("MODEL  : "+ rs.getString(2));
            System.out.println("PRICE: "+ rs.getInt("PRICE"));
            System.out.println();
         }
         rs.close();

         //s.executeUpdate("INSERT INTO CAR (make, model) values('eka', 'toka')");
         int rows = s.executeUpdate("UPDATE CAR SET price=10000 where make = 'Buick'");

         System.out.println("rows " + rows);


         String strSql = "UPDATE CAR SET price=?, make=? where model = 'A8'";

         PreparedStatement preStmt = conn.prepareStatement(strSql);

         preStmt.setInt(1, 300);
         preStmt.setString(2, "Audi");
         preStmt.executeUpdate();


         s.close();
         conn.close();
      } catch(Exception e) {
         System.out.println("Exception: "+ e);
         e.printStackTrace();
      }
   }
}