Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Main {
- public static void main(String[] args) throws SQLException, ClassNotFoundException, IOException {
- String userName = "root";
- String password = "1";
- String connectionUrl = "jdbc:sqlite:D:\Java_project\Rabota_s_basami_dannix\database";
- Class.forName("org.sqlite.JDBC");
- try(Connection connection = DriverManager.getConnection(connectionUrl);
- Statement statement = connection.createStatement()) {
- System.out.println("Connection establish");
- BufferedImage image = ImageIO.read(new File("img.jpg"));
- Blob blob = connection.createBlob();
- OutputStream outputStream = blob.setBinaryStream(1);
- ImageIO.write(image,"jpg",outputStream);
- outputStream.close();
- PreparedStatement statement1 = connection.prepareStatement("insert into carblob(name,speed,img) values(?,?,?)");
- statement1.setString(1,"BMW");
- statement1.setInt(2,200);
- statement1.setBlob(3,blob);
- statement1.execute();
- }
- }
- }
Add Comment
Please, Sign In to add comment