Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. Bitmap btm = foto_gallery.getDrawingCache();
  2.  
  3. //pruebaimg.setImageBitmap(btm);
  4.  
  5. ByteArrayOutputStream stream = new ByteArrayOutputStream();
  6.  
  7. btm.compress(Bitmap.CompressFormat.JPEG, 100, stream);
  8.  
  9. byteArray = stream.toByteArray();
  10.  
  11. encodedImage = Base64.encodeToString(byteArray, Base64.DEFAULT);
  12.  
  13. //Se inserta la imagen en la BD mas otros datos
  14.  
  15. Connection connect = ConexionSQL.ConnectionHelper();
  16.  
  17. Statement st = connect.createStatement();
  18. PreparedStatement pst = connect.prepareStatement("insert into "
  19. + tabla + " values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,'" + encodedImage
  20. + "')");
  21. pst.setString(1, IDM1);
  22. pst.setString(2, IDI.getText().toString());
  23. pst.setString(3, SCap.getSelectedItem().toString());
  24. pst.setString(4, SCuar.getSelectedItem().toString());
  25. pst.setString(5, SCam.getSelectedItem().toString());
  26. pst.setString(6, SBa.getSelectedItem().toString());
  27. pst.setString(7, SMas.getSelectedItem().toString());
  28. pst.setString(8, SEsta.getSelectedItem().toString());
  29. pst.setString(9, SH2O.getSelectedItem().toString());
  30. pst.setString(10, SCoc.getSelectedItem().toString());
  31. pst.setString(11, Dir.getText().toString());
  32. pst.setString(12, Price.getText().toString());
  33. pst.setString(13, SDis.getSelectedItem().toString());
  34. pst.setString(14, "U1001");pst.executeUpdate();
  35.  
  36. //Aqui recupero la imagen en una consulta y la guardo en un
  37. array
  38. //yes
  39. Statement st = connect.createStatement();
  40. ResultSet rs = st.executeQuery("SELECT TOP 5 Imagen FROM
  41. TB_Cabaña WHERE (ID_Cabaña > 1)ORDER BY NEWID()");
  42. while (rs.next()) {
  43. //Se extraen los datos
  44.  
  45. datosConsultado1 = rs.getString("Imagen");
  46.  
  47. String k =new String(datosConsultado1);//le mandas los
  48. parametros necesarios al constructor
  49. lista.add(k); //agregas ese objeto a la lista
  50.  
  51. }
  52.  
  53. i1= lista.get(0).toString();
  54. i2 = lista.get(1).toString();
  55. i3 = lista.get(2).toString();
  56. i4 = lista.get(3).toString();
  57. i5 = lista.get(4).toString();
  58.  
  59.  
  60.  
  61.  
  62.  
  63.  
  64. byte [] encodeByte1 = Base64.decode (i1, Base64.DEFAULT);
  65. prueba.setText(encodeByte1.toString());
  66. bitmap1 = BitmapFactory.decodeByteArray (encodeByte1, 0, encodeByte1.length);
  67. byte [] encodeByte2 = Base64.decode (i2, Base64.DEFAULT);
  68. bitmap2 = BitmapFactory.decodeByteArray (encodeByte2, 0, encodeByte2.length);
  69. byte [] encodeByte3 = Base64.decode (i3, Base64.DEFAULT);
  70. bitmap3 = BitmapFactory.decodeByteArray (encodeByte3, 0, encodeByte3.length);
  71. byte [] encodeByte4 = Base64.decode (i4, Base64.DEFAULT);
  72. bitmap4 = BitmapFactory.decodeByteArray (encodeByte4, 0, encodeByte4.length);
  73. byte [] encodeByte5 = Base64.decode (i5, Base64.DEFAULT);
  74. bitmap5 = BitmapFactory.decodeByteArray (encodeByte5, 0, encodeByte5.length);`
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement