最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
处理blob的完整例子
时间:2008-01-12 编辑:简简单单 来源:一聚教程网
import oracle.jdbc.driver.OracleResultSet;
import oracle.sql.BLOB;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.io.*;
import java.sql.Statement;
public class testBlob {
public static void main(String args[]) {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@java:1521:eteda", "system", "manager");
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
stmt.execute("insert into testblob values (empty_blob())");
ResultSet rset = stmt.executeQuery("SELECT tt FROM testblob FOR UPDATE");
BLOB blob = null;
while (rset.next()) {
blob = ((OracleResultSet) rset).getBLOB(1);
System.out.println(blob.length());
}
File binaryFile = new File("c:meilin.xml");
System.out.println("meilin.xml length = " + binaryFile.length());
import oracle.sql.BLOB;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.io.*;
import java.sql.Statement;
public class testBlob {
public static void main(String args[]) {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@java:1521:eteda", "system", "manager");
conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
stmt.execute("insert into testblob values (empty_blob())");
ResultSet rset = stmt.executeQuery("SELECT tt FROM testblob FOR UPDATE");
BLOB blob = null;
while (rset.next()) {
blob = ((OracleResultSet) rset).getBLOB(1);
System.out.println(blob.length());
}
File binaryFile = new File("c:meilin.xml");
System.out.println("meilin.xml length = " + binaryFile.length());
相关文章
- Surface Book 2终于要来了 配备第八代酷睿处理器 08-01
- 联想Moto Z2 Force渲染图曝光 搭载骁龙835处理器 07-21
- 英特尔推出至强可扩展处理器 高达28颗内核 07-12
- 索尼全面屏旗舰曝光 自研处理器加持 07-05
- vivo新旗舰现身跑分 搭载骁龙660处理器 06-29
- PS批处理功能怎么使用 06-13