6stuuPXJ

1public class DBCreate extends SQLiteOpenHelper {
2
3    private static final String NOME_BANCO = "db_pv.db";
4    protected static final String TABELA = "clientes";
5    protected static final String ID = "_id";
6    protected static final String HANDLE = "handle";
7    protected static final String NOME = "cliente";
8    private static final int VERSAO = 1;
9
10    public DBCreate(Context context) {
11        super(context, NOME_BANCO, null, VERSAO);
12    }
13
14    @Override
15    public void onCreate(SQLiteDatabase db) {
16
17        String sql = "CREATE TABLE " + TABELA + " ("
18                + ID + " INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,"
19                + HANDLE + " INT NOT NULL UNIQUE,"
20                + NOME + " TEXT NOT NULL,"
21                + ")";
22        db.execSQL(sql);
23        insereTeste(db);
24    }
25
26    @Override
27    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
28        sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + TABELA);
29        onCreate(sqLiteDatabase);
30    }
31
32    public void insereTeste(SQLiteDatabase db) {
33        db.execSQL("INSERT INTO clientes (handle, nome) VALUES (1,'Cliente 1')");
34        db.execSQL("INSERT INTO clientes (handle, nome) VALUES (2,'Cliente 2')");
35        db.execSQL("INSERT INTO clientes (handle, nome) VALUES (3,'Cliente 3')");
36        db.execSQL("INSERT INTO clientes (handle, nome) VALUES (4,'Cliente 4')");
37    }
38
39}
40	
41public class ControllerClientes {
42
43    SQLiteDatabase sqLiteDatabase;
44    DBCreate banco;
45
46    public ArrayList<String> getClientes(){
47        ArrayList<String> clientes = new ArrayList<String>();
48        Cursor cursor = sqLiteDatabase.rawQuery("SELECT * FROM clientes",null);
49        if(cursor != null && cursor.moveToFirst()){
50            do{
51                clientes.add(cursor.getString(cursor.getColumnIndex("_id")));
52            }while(cursor.moveToNext());
53        }
54        return clientes;
55    }
56
57}
58	
59public class NovoRegistro extends AppCompatActivity {
60
61    Spinner spnClientes;
62
63    @Override
64    protected void onCreate(Bundle savedInstanceState) {
65        super.onCreate(savedInstanceState);
66        setContentView(R.layout.activity_novo_registro);
67
68        spnClientes = findViewById(R.id.spnClientes);
69        spinnerClientes();
70    }
71
72    public void spinnerClientes() {
73        ControllerClientes ctClientes = new ControllerClientes();
74        ArrayList<String> clientes = ctClientes.getClientes();
75        ArrayAdapter adapter = new ArrayAdapter(this, android.R.layout.simple_spinner_dropdown_item, clientes);
76        adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
77        spnClientes.setAdapter(adapter);
78    }
79
80}