android sqlite insert image

0

I have encountered a problem when inserting a photo which is loaded from a button, but, I'm going around and I do not have the clear idea, the code is this:

import android.Manifest;
import android.content.ContentValues;
import android.content.Intent;
import android.content.pm.PackageManager;
import android.database.sqlite.SQLiteDatabase;
import android.graphics.Bitmap;
import android.graphics.BitmapFactory;
import android.graphics.drawable.BitmapDrawable;
import android.net.Uri;
import android.os.Bundle;
import android.support.annotation.NonNull;
import android.support.annotation.Nullable;
import android.support.v4.app.ActivityCompat;
import android.support.v7.app.AppCompatActivity;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.Toast;

import com.example.beeo.proyecto_final.constantes.Constante;

import java.io.ByteArrayOutputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;

public class ClienteActivity extends AppCompatActivity {

EditText nombre,apellido,cedula,telefono,email,direccion,precio;
Button foto,cedulaf,contrato;
final int request_code_gallery = 999;

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_cliente);

    nombre = (EditText)findViewById(R.id.et_nombre);
    apellido = (EditText)findViewById(R.id.et_apellido);
    cedula =(EditText)findViewById(R.id.et_cedula);
    telefono = (EditText)findViewById(R.id.et_telefono);
    email = (EditText)findViewById(R.id.et_email);
    direccion = (EditText)findViewById(R.id.et_direccion);
    precio = (EditText)findViewById(R.id.et_precio);
    foto = (Button)findViewById(R.id.bt_cliente_foto);
    cedulaf= (Button)findViewById(R.id.bt_cliente_cedula);
    contrato = (Button)findViewById(R.id.bt_cliente_contrato);

    foto.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            cargar_archivo();

        }
    });

    cedulaf.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            cargar_archivo();

        }
    });

    contrato.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            cargar_archivo();

        }
    });

}

public void onClick(View view){
    registrarCliente();
}



private void cargar_archivo() {
    ActivityCompat.requestPermissions(
            ClienteActivity.this,
            new String[]{Manifest.permission.READ_EXTERNAL_STORAGE},
            request_code_gallery

    );
}

@Override
public void onRequestPermissionsResult(int requestCode, @NonNull String[] permissions, @NonNull int[] grantResults) {
    if (requestCode == request_code_gallery){
        if (grantResults.length >0 && grantResults[0]== PackageManager.PERMISSION_GRANTED){
            Intent intent = new Intent(Intent.ACTION_PICK);
            intent.setType("*/*");
            startActivityForResult(intent, request_code_gallery);
        }else {
            Toast.makeText(getApplicationContext(),"No tienes los permisos para acceder al archivo",Toast.LENGTH_SHORT).show();
        }
        return;
    }
    super.onRequestPermissionsResult(requestCode, permissions, grantResults);
}

@Override
protected void onActivityResult(int requestCode, int resultCode, @Nullable Intent data) {
    if (requestCode == request_code_gallery && resultCode == RESULT_OK && data != null){
        Uri uri = data.getData();
        try {
            InputStream inputStream = getContentResolver().openInputStream(uri);
            Bitmap bitmap = BitmapFactory.decodeStream(inputStream);
          foto.setImageBitmap(bitmap);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }
    }

    super.onActivityResult(requestCode, resultCode, data);
}

private byte[] imageToByte(ImageView image){
    Bitmap bitmap = ((BitmapDrawable)image.getDrawable()).getBitmap();
    ByteArrayOutputStream stream = new ByteArrayOutputStream();
    bitmap.compress(Bitmap.CompressFormat.JPEG,100,stream);
    byte [] byteArray = stream.toByteArray();
    return byteArray;
}

private void registrarCliente() {
    Conexion con = new Conexion(this, "db_proyecto", null, 1);
    SQLiteDatabase db = con.getWritableDatabase();
    try{
        ContentValues valores = new ContentValues();
        valores.put(Constante.campo_nombre, nombre.getText().toString());
        valores.put(Constante.campo_apellido, apellido.getText().toString());
        valores.put(Constante.campo_cedula, cedula.getText().toString());
        valores.put(Constante.campo_telefono, telefono.getText().toString());
        valores.put(Constante.campo_email, email.getText().toString());
        valores.put(Constante.campo_direccion, direccion.getText().toString());
        valores.put(Constante.campo_precio, precio.getText().toString());
        valores.put(Constante.campo_foto, foto.getBlob);

        long resultado = db.insert(Constante.tabla_cliente, Constante.campo_nombre,valores);

        Toast.makeText(getApplicationContext(),"id registro :"+resultado,Toast.LENGTH_SHORT).show();

    }catch (Exception e){
        e.printStackTrace();
    }




}

}

I select the image from the phone gallery, but, I do not understand the way to save the image in the database, I am guided by some tutorials, but, the truth is that I do not know where the saved image is xD

Thank you very much for your help

    
asked by Barly Espinal 01.12.2018 в 22:47
source

0 answers