Guest User

Untitled

a guest
Dec 10th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. public class Main {
  2.  
  3. public static void main(String[] args) throws SQLException, ClassNotFoundException, IOException {
  4. String userName = "root";
  5. String password = "1";
  6. String connectionUrl = "jdbc:sqlite:D:\Java_project\Rabota_s_basami_dannix\database";
  7. Class.forName("org.sqlite.JDBC");
  8. try(Connection connection = DriverManager.getConnection(connectionUrl);
  9. Statement statement = connection.createStatement()) {
  10.  
  11. System.out.println("Connection establish");
  12.  
  13. BufferedImage image = ImageIO.read(new File("img.jpg"));
  14. Blob blob = connection.createBlob();
  15. OutputStream outputStream = blob.setBinaryStream(1);
  16. ImageIO.write(image,"jpg",outputStream);
  17. outputStream.close();
  18.  
  19. PreparedStatement statement1 = connection.prepareStatement("insert into carblob(name,speed,img) values(?,?,?)");
  20. statement1.setString(1,"BMW");
  21. statement1.setInt(2,200);
  22. statement1.setBlob(3,blob);
  23. statement1.execute();
  24.  
  25. }
  26. }
  27. }
Add Comment
Please, Sign In to add comment