Guest User

Untitled

a guest
Jul 16th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. Local local = new Local();
  2. final Place place = PlacePicker.getPlace(this, data);
  3.  
  4. local.setID(locais.size() + 1);
  5. local.setLatitude(String.valueOf(place.getLatLng().latitude));
  6. local.setLongitude(String.valueOf(place.getLatLng().longitude));
  7. local.setNome(String.valueOf(place.getName()));
  8. local.setEndereco(String.valueOf(place.getAddress()));
  9. local.setNivel_alerta(String.valueOf(2));
  10.  
  11. try {
  12. String insertQuery = "INSERT INTO locais VALUES ("
  13. + local.getID() + ","
  14. + local.getLatitude() + ","
  15. + local.getLongitude() + ",'"
  16. + local.getNome() + "','"
  17. + local.getEndereco() + "',"
  18. + local.getNivel_alerta() + ","
  19. + 1 + ");";
  20. helper.adicionaLocais(this,nomeBD, insertQuery);
  21.  
  22. }catch (Exception e){
  23. Log.i("ERRO: ",""+e);
  24. }
  25.  
  26. public void adicionaLocais(Context context, String nomeBD, String query) {
  27. helperBD = HelperBD.getInstance(context, nomeBD);
  28. ArrayList<Local> locais = helperBD.listaLocais();
  29.  
  30. try {
  31. banco = helperBD.getWritableDatabase();
  32. banco.beginTransaction();
  33. banco.execSQL(query);
  34. banco.setTransactionSuccessful();
  35. banco.endTransaction();
  36. banco.close();
Add Comment
Please, Sign In to add comment