package ber.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class Fibonacci {

  public static void main(String[] args) {
    try {
      Class.forName("com.mysql.jdbc.Driver"); // Load the driver

      // connect to the database.
      Connection conn = DriverManager.getConnection("jdbc:mysql://home.cab.u-szeged.hu/test", "", "");
      Statement stmt;
      PreparedStatement prepStmt;

      // ------------------------------------------------ query the test table
      stmt = conn.createStatement();
      stmt.execute("create table IF NOT EXISTS fibon (n integer, fib integer)");
      stmt.execute("delete from fibon");
      stmt.execute("insert into fibon values (0,0)");
      
      prepStmt = conn.prepareStatement("insert into fibon values (?,?)");
      int a = 0, b = 1, c = 1;
      for (int i = 1; i < 40; i++) {
        prepStmt.setInt(1, i);
        prepStmt.setInt(2, c);
        prepStmt.execute();
        c = a + b;
        a = b;
        b = c;
      }
      conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
}