Advertisement
Ahmed_Kamal

Untitled

Nov 22nd, 2019
313
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.05 KB | None | 0 0
  1.         DB dataBase = new DB("dataBase");
  2.         Table table = new Table("contacts", new String[]{"name", "phone", "email"}, new String[]{"String", "Integer", "String"});
  3.         table.add(new Object[]{"abc", 12456789, "abc@gmail.com"});
  4.         table.add(new Object[]{"def", 987654321, "def@gmail.com"});
  5.         table.add(new Object[] {"abc", 171925, "jkl@gmail.com"});
  6.         table.add(new Object[]{"rty", 987654321, "rty@gmail.com"});
  7.         table.add(new Object[]{"fido", 12304, "dog@email.com"});
  8.         table.updateRecord("phone",987654321,481926);
  9.         dataBase.addTable(table);
  10.         Object[][] arr;
  11.         try{
  12.             arr = dataBase.executeQuery("SELECT name FROM contacts WHERE email = \"abc@gmail.com\"");
  13.         } catch (SQLException e){
  14.             System.out.println(e.getMessage());
  15.             return;
  16.         }
  17.         for (int i = 0 ; i < arr.length ; i++ ){
  18.             for (int j = 0; j < arr[i].length; j++) {
  19.                 System.out.print(arr[i][j] + "   ");
  20.             }
  21.             System.out.println();
  22.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement