- 浏览: 1303952 次
- 性别:
- 来自: 广州
文章分类
- 全部博客 (351)
- Java General (37)
- .net General (2)
- Linux Toy (55)
- Oracle (81)
- Mysql (11)
- Programer Career (12)
- Oh, my living ! (2)
- Shell Script (8)
- Web Service (0)
- Linux Server (22)
- Php/Python/Perl (3P) (2)
- Javascript General (5)
- Saleforce Apex Dev (2)
- Web General (5)
- Xen & VM tech. (17)
- PSP (13)
- OpenSolaris (34)
- php (1)
- RAI/flex/action script (16)
- asterisk/CTI (7)
- 交互设计 (6)
- English (3)
- Lucene (1)
最新评论
-
GuolinLee:
markmark
JVM调优总结 -Xms -Xmx -Xmn -Xss -
di1984HIT:
写的太好啊。
JVM调优总结 -Xms -Xmx -Xmn -Xss -
javajdbc:
javajdbc 写道
JVM调优总结 -Xms -Xmx -Xmn -Xss -
javajdbc:
...
JVM调优总结 -Xms -Xmx -Xmn -Xss -
alvin198761:
非常感谢,国外的被封杀了,你这里还有一份
How to Convert An Image-Based Guest To An LVM-Based Guest
package data; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.InputStream; import java.io.OutputStream; import java.sql.Blob; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class BlobTest { public void insertBlob(String imageId, String fileName) { Connection conn = null; try { conn = getConnection(); if (!fileName.equals("")) { PreparedStatement ps = conn.prepareStatement("INSERT INTO IMAGES VALUES(?, ?)"); ps.setString(1, imageId); FileInputStream fis = new FileInputStream(fileName); ps.setBinaryStream(2, fis, fis.available()); ps.execute(); ps.close(); } else { PreparedStatement ps = conn.prepareStatement("INSERT INTO IMAGES VALUES (?, empty_blob())"); ps.setString(1, imageId); ps.execute(); ps.close(); } conn.close(); } catch (Exception e) { e.printStackTrace(); } } public void readBlob(String fileName) { Connection conn = null; try { conn = getConnection(); Statement st = conn.createStatement(); ResultSet rs = st.executeQuery("SELECT IMAGE FROM IMAGES"); while (rs.next()) { // The following two lines can be replaced by // InputStream is = rs.getBinaryStream(1); Blob blob = rs.getBlob(1); InputStream is = blob.getBinaryStream(); FileOutputStream fos = null; fos = new FileOutputStream("c:/TEMP/" + fileName); byte[] data = new byte[1024]; int i = 0; while ((i = is.read(data)) != -1) { fos.write(data, 0, i); } } conn.close(); } catch (Exception e) { e.printStackTrace(); } } public void writeBlob(String fileName) { Connection conn = null; try { conn = getConnection(); Statement st = conn.createStatement(); ResultSet rs = st.executeQuery("SELECT IMAGE FROM IMAGES FOR UPDATE"); while (rs.next()) { Blob blob = rs.getBlob(1); System.out.println(blob); OutputStream os = blob.setBinaryStream(1); FileInputStream fis = null; fis = new FileInputStream("c:/TEMP/" + fileName); byte[] data = new byte[1]; int i; while ((i = fis.read(data)) != -1) { os.write(data, 0, i); } os.close(); break; } conn.close(); } catch (Exception e) { e.printStackTrace(); } } private Connection getConnection() throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "tiger"); return conn; } public static void main(String[] args) { BlobTest blobTest = new BlobTest(); blobTest.insertBlob("img1", ""); blobTest.writeBlob("2.gif"); } }
发表评论
-
使用Spring 的封装的MailSender
2010-11-29 22:24 6663使用Spring 的封装的Ma ... -
有时候,SVN 上代码太多,而我们只想下载自己负责的那个部分进行修改,这时可以这样
2010-09-04 09:06 1239svn checkout <url_of_big_dir ... -
tomcat session replication on linux server.
2010-07-26 10:49 1163Specially, to turn on multicast ... -
Session lost when app. is redeployed (Solved)
2010-07-07 16:02 1223There is a workaround to this p ... -
jvm 5.0 GC 回收机制
2009-10-16 11:55 1728http://java.sun.com/docs/hotspo ... -
How to Create a Custom Annotations?
2009-10-08 11:32 1193There are a lot of documentatio ... -
JAXB 深入学习<1>
2009-08-04 22:22 2317说白了就是一个api将 xml+schema->ja ... -
simple json lib for java
2009-08-04 21:57 3175有时候为了需要将一个对象或数组转成json string 给前 ... -
在servlet 上输出图片
2008-07-30 21:38 4250public void doGet(HttpServletRe ... -
有关 java 的 tnameserv的link
2008-07-15 22:39 2250http://java.sun.com/j2se/1.4.2/ ... -
SOAP and JDOM
2008-06-18 21:54 2114看完上一篇 blog: Web 服务搜 ... -
Java Reflection API 运用示例
2008-05-05 15:51 2336本文节选 ... -
将系统移植到Spring
2008-04-29 11:06 1448Spring已经是一个在Apache 2.0许可下发布的基础构 ... -
动态代理一例
2008-04-28 15:33 1184在之前的一篇关于Dec ... -
使用JAVA中的动态代理实现数据库连接池
2008-04-28 13:48 1440作者通过使用JAVA中的动 ... -
Have you known enough about DBCP?
2008-04-23 12:08 2226Have you known enough about DBC ... -
AX-RPC Evolves into Simpler, More Powerful JAX-WS
2008-03-23 15:40 3521s of version 2.0, JAX-RPC has b ... -
更改 Netbeans 界面的字体大小
2008-03-22 07:29 4637学习或者使用 Netbeans 的时候, 有时候觉得界面字体很 ... -
JSF+Spring+Hibernate的实例讲解
2008-03-20 16:41 2414我一直认为jsf必定会成为MS的 Net ... -
Struts+Spring+Hibernate练习(完整)
2008-03-20 16:17 2033工具: Eclipse3.2.1、MyEclipse5 ...
相关推荐
运用Java如何存取Oracle中的CLOB类型字段
基于Java+oracle学生信息管理系统的设计与实现(含源文件).docx基于Java+oracle学生信息管理系统的设计与实现(含源文件).docx基于Java+oracle学生信息管理系统的设计与实现(含源文件).docx基于Java+oracle学生信息...
java连接oracle数据库jar包
java对oracle数据库中blob字段的处理
java存取oracle中的COLB类型数据.pdf
java存取oracle中的COLB类型数据.docx
java实现oracle分页策略完整版,可当做参考类使用,有详细注释,适合初学者。
用java语言从oracle数据库中存取图片的方法
java导出oracle数据(单表)
JAVA 连接oracle数据库工程 JAVA oracle数据库 Myeclipse
使用java连接oracle数据库,使用软件为eclipse操作界面
java中读取ORACLE中BLOB字段存储的图片
oracle中date类型的操作,增删改查oracle中date类型的操作,增删改查
Java classes when using the JDBC Thin and OCI client-side driver - with Java 7.0 VM. ojdbc6.jar Java classes when using the JDBC Thin and OCI client-side driver - with Java 6.0 VM. ojdbc5.jar Java ...
java实现oracle数据库备份.pdf
java调用oracle存储过程或者函数
Java操作Oracle数据库(建表,插数据,删除)
在oracle数据据库中批量插入数据的java方法