Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Main {
    static String url = "jdbc:oracle:thin:@localhost:1521:javaDemo";
    static String username = "username";
    static String password = "welcome";

    public static void main(String[] args) throws Exception {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection conn = DriverManager.getConnection(url, username, password);
        conn.setAutoCommit(false);

        String sql = "INSERT INTO pictures (name, description, image) VALUES (?, ?, ?)";
        PreparedStatement stmt = conn.prepareStatement(sql);
        stmt.setString(1, "java.gif");
        stmt.setString(2, "Java Official Logo");

        File image = new File("D:\\a.gif");
        FileInputStream fis = new FileInputStream(image);
        stmt.setBinaryStream(3, fis, (int) image.length());
        stmt.execute();

        conn.commit();
        fis.close();
        conn.close();
    }
}