1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
import java.sql.*;
import java.io.*;
public class TestLongRaw {
public static void main (String args[]) {
if (args.length==0) {
System.out.println("USAGE: java -classpath .;classes111.zip ExpLongRaw <IP> <port> <SID> <user> <pass> <dest>");
System.exit(0);
}
TestLongRaw ess = new TestLongRaw();
ess.traite(args[0],args[1],args[2],args[3],args[4],args[5]);
}
public TestLongRaw() {
}
public void traite(String ip, String port, String sid, String user, String pass, String dest) {
Connection conn; // Holds the connection to the database
Statement stmt;
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//Class.forName ("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection ("jdbc:oracle:thin:@"+ip+":"+port+":"+sid,user,pass);
File file = new File("d:\\work\\Base_fond_ess.jpg");
PreparedStatement pstmt = conn.prepareStatement("INSERT INTO binary_object_data_block (blob_id, seq, data, length, application_data) VALUES (?,?,?,?,?)");
pstmt.setInt(1,10);
pstmt.setInt(2,1);
pstmt.setBinaryStream(3,new FileInputStream(file),(int)file.length());
pstmt.setInt(4,(int)file.length());
pstmt.setInt(5,7);
pstmt.execute();
} catch (Exception ex) {
ex.printStackTrace();
}
}
} |
Partager