Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Bitmap btm = foto_gallery.getDrawingCache();
- //pruebaimg.setImageBitmap(btm);
- ByteArrayOutputStream stream = new ByteArrayOutputStream();
- btm.compress(Bitmap.CompressFormat.JPEG, 100, stream);
- byteArray = stream.toByteArray();
- encodedImage = Base64.encodeToString(byteArray, Base64.DEFAULT);
- //Se inserta la imagen en la BD mas otros datos
- Connection connect = ConexionSQL.ConnectionHelper();
- Statement st = connect.createStatement();
- PreparedStatement pst = connect.prepareStatement("insert into "
- + tabla + " values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,'" + encodedImage
- + "')");
- pst.setString(1, IDM1);
- pst.setString(2, IDI.getText().toString());
- pst.setString(3, SCap.getSelectedItem().toString());
- pst.setString(4, SCuar.getSelectedItem().toString());
- pst.setString(5, SCam.getSelectedItem().toString());
- pst.setString(6, SBa.getSelectedItem().toString());
- pst.setString(7, SMas.getSelectedItem().toString());
- pst.setString(8, SEsta.getSelectedItem().toString());
- pst.setString(9, SH2O.getSelectedItem().toString());
- pst.setString(10, SCoc.getSelectedItem().toString());
- pst.setString(11, Dir.getText().toString());
- pst.setString(12, Price.getText().toString());
- pst.setString(13, SDis.getSelectedItem().toString());
- pst.setString(14, "U1001");pst.executeUpdate();
- //Aqui recupero la imagen en una consulta y la guardo en un
- array
- //yes
- Statement st = connect.createStatement();
- ResultSet rs = st.executeQuery("SELECT TOP 5 Imagen FROM
- TB_Cabaña WHERE (ID_Cabaña > 1)ORDER BY NEWID()");
- while (rs.next()) {
- //Se extraen los datos
- datosConsultado1 = rs.getString("Imagen");
- String k =new String(datosConsultado1);//le mandas los
- parametros necesarios al constructor
- lista.add(k); //agregas ese objeto a la lista
- }
- i1= lista.get(0).toString();
- i2 = lista.get(1).toString();
- i3 = lista.get(2).toString();
- i4 = lista.get(3).toString();
- i5 = lista.get(4).toString();
- byte [] encodeByte1 = Base64.decode (i1, Base64.DEFAULT);
- prueba.setText(encodeByte1.toString());
- bitmap1 = BitmapFactory.decodeByteArray (encodeByte1, 0, encodeByte1.length);
- byte [] encodeByte2 = Base64.decode (i2, Base64.DEFAULT);
- bitmap2 = BitmapFactory.decodeByteArray (encodeByte2, 0, encodeByte2.length);
- byte [] encodeByte3 = Base64.decode (i3, Base64.DEFAULT);
- bitmap3 = BitmapFactory.decodeByteArray (encodeByte3, 0, encodeByte3.length);
- byte [] encodeByte4 = Base64.decode (i4, Base64.DEFAULT);
- bitmap4 = BitmapFactory.decodeByteArray (encodeByte4, 0, encodeByte4.length);
- byte [] encodeByte5 = Base64.decode (i5, Base64.DEFAULT);
- bitmap5 = BitmapFactory.decodeByteArray (encodeByte5, 0, encodeByte5.length);`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement