Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DB dataBase = new DB("dataBase");
- Table table = new Table("contacts", new String[]{"name", "phone", "email"}, new String[]{"String", "Integer", "String"});
- table.add(new Object[]{"abc", 12456789, "abc@gmail.com"});
- table.add(new Object[]{"def", 987654321, "def@gmail.com"});
- table.add(new Object[] {"abc", 171925, "jkl@gmail.com"});
- table.add(new Object[]{"rty", 987654321, "rty@gmail.com"});
- table.add(new Object[]{"fido", 12304, "dog@email.com"});
- table.updateRecord("phone",987654321,481926);
- dataBase.addTable(table);
- Object[][] arr;
- try{
- arr = dataBase.executeQuery("SELECT name FROM contacts WHERE email = \"abc@gmail.com\"");
- } catch (SQLException e){
- System.out.println(e.getMessage());
- return;
- }
- for (int i = 0 ; i < arr.length ; i++ ){
- for (int j = 0; j < arr[i].length; j++) {
- System.out.print(arr[i][j] + " ");
- }
- System.out.println();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement