Main.java Source code

Introduction

Here is the source code for Main.java

Source

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

public class Main {
    private static String url = "jdbc:oracle:thin:@localhost:1521:xe";

    private static String username = "yourDatabase";

    private 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 documents (name, description, data) VALUES (?, ?, ?)";
        PreparedStatement stmt = conn.prepareStatement(sql);
        stmt.setString(1, "a.txt");
        stmt.setString(2, "b");

        File data = new File("C:\\a.txt");
        FileReader reader = new FileReader(data);
        stmt.setCharacterStream(3, reader, (int) data.length());
        stmt.execute();

        conn.commit();
        reader.close();
        conn.close();

    }
}