package ber.db;

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

public class Primes {
  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;

      // ------------------------------------------------ query the test table
      stmt = conn.createStatement();
      stmt.execute("create table IF NOT EXISTS primes (n integer)");
      stmt.execute("delete from primes");

      int N = 5000;

      // insert all the numbers between 2 and N
      for (int i = 2; i < N; i++)
        stmt.execute("insert into primes values (" + i + ")");

      // delete all the numbers 
      for (int i = 2; i < Math.sqrt(N); i++)
        stmt.execute("delete from primes where MOD(n," + i + ") = 0 and n > " + i);

      conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

}