1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
| import java.sql.*;
import java.io.*;
import oracle.jdbc.*;
import oracle.sql.*;
import oracle.ord.im.OrdImage;
import oracle.ord.im.OrdImageSignature;
public class Ajout_OrdImage {
public static void main(String[] args) {
try {
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:DBM",
"ROOT",
"root");
conn.setAutoCommit(false);String sql = "UPDATE MaTable SET image=ORDSYS.ORDImage.init() WHERE id=1";
Statement stmt = conn.createStatement();
stmt.execute(sql);
String sql2 = "SELECT image FROM MaTable WHERE id=1 FOR UPDATE";
OracleResultSet rset=(OracleResultSet) stmt.executeQuery(sql2);
if( rset.next()) {
OrdImage imgObj = (OrdImage) rset.getORAData(1, OrdImage.getORADataFactory() );
try{
imgObj.loadDataFromFile("c:\\image.jpg");
} |
