Salvare info in DB SqlLite

[Chry1911]

Buongiorno amici sto facendo un'app interessante

praticamente devo scannerizzare in giro gli access point disponibili....sono arrivato a tal punto che la mia app lo fa solo che come faccio a salvare le info che trovo??

vi mostro quello che fa la mia app in foto, quelle sono le info che voglio salvare in un db

https://www.dropbox.com/s/uq9d4nl08f...%2002%2045.jpg

[Xerxes]

Spero che metti a disposizione i sorgenti, cmq se riesci a visualizzare i dati come stringhe per esempio, basta fare delle query di inserimento in SQLite interno ad android e quindi hai tutti i dati salvati. Wardriving???

[Chry1911]

Spero che metti a disposizione i sorgenti, cmq se riesci a visualizzare i dati come stringhe per esempio, basta fare delle query di inserimento in SQLite interno ad android e quindi hai tutti i dati salvati. Wardriving???

si se vuoi ti metto la classe che trova l'hotspot cmq salvo tutto come stringa
public class SearchActivity exten<span class="forTooltip">ds</span> ActionBarActivity {<br /> private TextView wifiText; <br /> private WifiManager wifiManager; <br /> private StringBuilder sb; <br /> private List<ScanResult> wifiList; <br /> private WifiReceiver wifiReceiver;<br /> @Override<br /> pr<span class="forTooltip">ot</span>ected void onCreate(Bundle savedInstanceState) {<br /> super.onCreate(savedInstanceState);<br /> setContentView(R.layout.activity_search);<br /> sb = new StringBuilder(); <br /> wifiText = (TextView) findViewById(R.id.wifi); <br /> wifiManager = (WifiManager) getSystemService(Context.WIFI_SERVICE); <br /> wifiReceiver = new WifiReceiver(); <br /> registerReceiver(wifiReceiver, new IntentFilter( <br /> WifiManager.SCAN_RESULTS_AVAILABLE_ACTION)); <br /> wifiManager.startScan(); <br /> wifiText.setText("\nStarting Scan\n"); <br /> <br /> <br /> <br /> if (savedInstanceState == null) {<br /> getSupportFragmentManager().beginTransaction()<br /> .add(R.id.container, new Fragment()).commit();<br /> }<br /> }<br /> <br /> <br /> <br /> @Override<br /> public boolean onCreate<span class="forTooltip">Op</span>tionsMenu(Menu menu) {<br /> menu.add(0, 0, 0, "Refresh"); <br /> return super.onCreateOptionsMenu(menu); <br /> }<br /> <br /> public boolean onOptionItemSelected(int featureId, MenuItem item) { <br /> wifiManager.startScan(); <br /> wifiText.setText("Starting Scan"); <br /> return super.onMenuItemSelected(featureId, item); <br /> <br /> } <br /> <br /> <br /> @Override <br /> pr<span class="forTooltip">ot</span>ected void onPause() { <br /> unregisterReceiver(wifiReceiver); <br /> super.onPause(); <br /> } <br /> <br /> @Override <br /> protected void onResume() { <br /> registerReceiver(wifiReceiver, new IntentFilter( <br /> WifiManager.SCAN_RESULTS_AVAILABLE_ACTION)); <br /> super.onResume(); <br /> } <br /> private final class WifiReceiver extends BroadcastReceiver { <br /> @Override <br /> public void onReceive(Context context, Intent intent) { <br /> sb = new StringBuilder(); <br /> wifiList = wifiManager.getScanResults(); <br /> for (int i = 0; i < wifiList.size(); i++) { <br /> sb.append(new Integer(i + 1).toString() + "."); <br /> sb.append((wifiList.get(i)).toString()).append("\n\n"); <br /> } <br /> wifiText.setText(sb.toString()); <br /> } <br /> } <br /> } <br /> <br /> <br /> <br /> <br />

 

1

public class SearchActivity extends ActionBarActivity {

2

    private TextView wifiText;  

3

    private WifiManager wifiManager;  

4

    private StringBuilder sb;  

5

    private List<ScanResult> wifiList;  

6

    private WifiReceiver wifiReceiver;

7

    @Override

8

    protected void onCreate(Bundle savedInstanceState) {

9

        super.onCreate(savedInstanceState);

10

        setContentView(R.layout.activity_search);

11

        sb = new StringBuilder();  

12

        wifiText = (TextView) findViewById(R.id.wifi);  

13

        wifiManager = (WifiManager) getSystemService(Context.WIFI_SERVICE);  

14

        wifiReceiver = new WifiReceiver();  

15

        registerReceiver(wifiReceiver, new IntentFilter(  

16

                WifiManager.SCAN_RESULTS_AVAILABLE_ACTION));  

17

        wifiManager.startScan();  

18

        wifiText.setText("\nStarting Scan\n"); 

19

20

21

​

22

        if (savedInstanceState == null) {

23

            getSupportFragmentManager().beginTransaction()

24

                    .add(R.id.container, new Fragment()).commit();

25

        }

26

    }

27

28

29

​

30

    @Override

31

    public boolean onCreateOptionsMenu(Menu menu) {

32

          menu.add(0, 0, 0, "Refresh");  

33

            return super.onCreateOptionsMenu(menu); 

34

    }

35

​

36

     public boolean onOptionItemSelected(int featureId, MenuItem item) {  

37

            wifiManager.startScan();  

38

            wifiText.setText("Starting Scan");  

39

            return super.onMenuItemSelected(featureId, item);  

40

41

        }  

42

43

44

    @Override  

45

    protected void onPause() {  

46

        unregisterReceiver(wifiReceiver);  

47

        super.onPause();  

48

    }  

49

50

    @Override  

51

    protected void onResume() {  

52

        registerReceiver(wifiReceiver, new IntentFilter(  

53

                WifiManager.SCAN_RESULTS_AVAILABLE_ACTION));  

54

        super.onResume();  

55

    }  

56

    private final class WifiReceiver extends BroadcastReceiver {  

57

        @Override  

58

        public void onReceive(Context context, Intent intent) {  

59

            sb = new StringBuilder();  

60

            wifiList = wifiManager.getScanResults();  

61

            for (int i = 0; i < wifiList.size(); i++) {  

62

                sb.append(new Integer(i + 1).toString() + ".");  

63

                sb.append((wifiList.get(i)).toString()).append("\n\n");  

64

            }  

65

            wifiText.setText(sb.toString());  

66

        }  

67

    }  

68

}  

69

​

70

​

71

​

72

​

73

​