demo/demo_java.java

   1 import java.sql.*;
   2
   3 public class demo_java
   4 {
   5   public static void main(String[] args)
   6   {
   7     String url = "jdbc:mysql://localhost:3306/";
   8     String dbName = "test";
   9     String driver = "com.mysql.jdbc.Driver";
  10     String userName = "root";
  11     String password = "";
  12     try
  13     {
  14       Class.forName(driver).newInstance();
  15       Connection db = DriverManager.getConnection(url+dbName,userName,password);
  16
  17       Statement st = db.createStatement();
  18       st.executeUpdate("DROP TABLE IF EXISTS person");
  19       st.executeUpdate("DROP TABLE IF EXISTS money");
  20       demo_java_gen gen = new demo_java_gen(db);
  21       gen.create_person();
  22       gen.create_money();
  23
  24       gen.add_person("John","Black");
  25       ResultSet rs = st.executeQuery("SELECT LAST_INSERT_ID()"); rs.next();
  26       int john = rs.getInt(1);
  27
  28       gen.add_person("Ivan","Petrov");
  29       rs = st.executeQuery("SELECT LAST_INSERT_ID()"); rs.next();
  30       int ivan = rs.getInt(1);
  31
  32       gen.add_person("Sancho","Alvares");
  33       rs = st.executeQuery("SELECT LAST_INSERT_ID()"); rs.next();
  34       int sancho = rs.getInt(1);
  35
  36       // add money relations
  37       gen.add_money(john,ivan,200);
  38       gen.add_money(john,sancho,100);
  39       gen.add_money(john,sancho,250);
  40       gen.add_money(sancho,ivan,300);
  41
  42       class a1 implements demo_java_gen.calc_total_callback
  43       {
  44         public void callback(String fullname, int total)
  45         {
  46           System.out.println(fullname + " = " + total);
  47         }
  48       }
  49
  50       // summarize by person
  51       System.out.println("Total transfers:");
  52       gen.calc_total(new a1());
  53
  54       class a2 implements demo_java_gen.list_donors_callback
  55       {
  56         public void callback(String surname)
  57         {
  58           System.out.println(surname);
  59         }
  60       }
  61
  62       // list donors
  63       System.out.println("Donors:");
  64       gen.list_donors("petrov",100,new a2());
  65
  66       db.close();
  67     }
  68     catch (Exception e)
  69     {
  70       e.printStackTrace();
  71     }
  72   }
  73
  74 }