Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

java²Ù×÷oracleÊý¾Ý¿âÖеÄblob×Ö¶Î

oracleÖеÄBLOB×Ö¶ÎÊÇ´æ´¢2½øÖƵÄÎļþ£¬±ÈÈçÎļþ£¬Í¼Æ¬µÈ¡£
1¡¢°Ñ±¾µØÎļþдÈëÊý¾Ý¿â
package com.data;
import java.io.File;
import java.io.FileInputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class WriteBlob {
/**
* beckham 2009-12-7 ÏÂÎç09:47:36
*/
public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:menhu";
String user = "zm";
String password = "zm";
Connection conn = DriverManager.getConnection(url, user, password);
// ÉèÖÃÊÖ¶¯Ìá½»
conn.setAutoCommit(false);
Statement sta = null;
ResultSet rs = null;
PreparedStatement ps = null;
// ²åÈë¿ÕÖµ
String sql = "insert into mytest values(3,empty_blob()) ";
sta = conn.createStatement();
sta.executeUpdate(sql);
conn.commit();
// Ëø¶¨²¢±à¼­µ±Ç°Êý¾Ý
sql = "select images from mytest where id=3 for update";
rs = sta.executeQuery(sql);
if (rs.next()) {
oracle.sql.BLOB b = (oracle.sql.BLOB) rs.getBlob("images");
// ÊäÈëÁ÷
OutputStream os = b.getBinaryOutputStream();
// Êä³öÁ÷
FileInputStream fiis = new FileInputStream(new File("1.doc"));
// Èë¿â
byte[] tmp = new byte[1024];
int a = 0;
while ((a = fiis.read(tmp)) != -1) {
os.write(tmp, 0, a);
os.flush();
}
os.close();
fiis.close();
}
conn.commit();
rs.close();
sta.close();
conn.close();
}
}
 
2¡¢´ÓÊý¾Ý¿âÖжÁÈ¡Blob×Ö¶ÎÊý¾Ý
package com.data;
import java.io.File;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ReadBlob {
/**
* beckham 2009-12-8 ÏÂÎç03:49:30
*/
public static void main(String[] args) throws Exception


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

java ö¾ÙÀàÐÍ


Tiger ÖеÄÒ»¸öÖØÒªÐÂÌØÐÔÊÇö¾Ù¹¹Ô죬ËüÊÇÒ»ÖÖеÄÀàÐÍ£¬ÔÊÐíÓó£Á¿À´±íÊ¾ÌØ¶¨µÄÊý¾Ý Ƭ¶Ï£¬¶øÇÒÈ«²¿¶¼ÒÔÀàÐͰ²È«µÄÐÎʽÀ´±íʾ¡£Tiger ר¼Ò¡¢developerWorks µÄ¶à²ú×÷Õß Brett McLaughlin½«½âÊÍö¾ÙµÄ¶¨Ò壬½éÉÜÈçºÎÔÚÓ¦ÓóÌÐòÖÐÔËÓÃö¾Ù£¬ÒÔ¼°ËüΪʲôÄܹ»ÈÃÄúÅׯúËùÓоɵÄ
public static final ´úÂë¡£
  & ......

javaÖÐ120¸ö¾­µäÎÊÌâ1

1¡¢ÃæÏò¶ÔÏóµÄÌØÕ÷ÓÐÄÄЩ·½Ãæ
    1.³éÏ󣺳éÏó¾ÍÊǺöÂÔÒ»¸öÖ÷ÌâÖÐÓ뵱ǰĿ±êÎ޹صÄÄÇЩ·½Ã棬ÒÔ±ã¸ü³ä·ÖµØ×¢ÒâÓ뵱ǰĿ±êÓйصķ½Ãæ¡£³éÏó²¢²»´òËãÁ˽âÈ«²¿ÎÊÌ⣬¶øÖ»ÊÇÑ¡ÔñÆäÖеÄÒ»²¿·Ö£¬ÔÝʱ²»Óò¿·Öϸ½Ú¡£³éÏó°üÀ¨Á½¸ö·½Ã棬һÊǹý³Ì³éÏ󣬶þÊÇÊý¾Ý³éÏó¡£
    2.¼Ì³Ð£º¼Ì³ÐÊÇÒ»ÖÖÁª½á ......

JAVA·´ÉäºÍCLASSÀà


¸ÐлԭÎÄ×÷Õß:http://blog.sina.com.cn/s/blog_62a6ceb10100gwe0.html
 
JAVAÆäʵ²»ËãÊÇÒ»ÃŶ¯Ì¬ÓïÑÔ£¬µ«JAVAÖÐÈ´ÓÖÒ»ÖÖ»úÖÆ¿ÉÒÔ´ïµ½¶¯Ì¬µÄijÖÐЧ¹û£¬Õâ¾ÍÊÇJAVAÖеķ´Éä¡£
     JAVA·´ÉäÖ¸µÄÊÇÎÒÃÇ¿ÉÒÔÓÚÔËÐÐʱ¼ÓÔØ¡¢Ì½Öª¡¢Ê¹ÓñàÒëÆÚ¼äÍêȫδ֪µÄclasses¡£
     ¶¼Ja ......

javaʵս¼¼ÇÉ ¹ØÓÚ¸ñʽ»¯Êä³öÈÕÆÚ

javaʵս¼¼ÇÉ--¹ØÓÚ¸ñʽ»¯Êä³öÈÕÆÚ
ʹÓÃSimpleDateFormat ¸ñʽ»¯Êä³öÈÕÆÚÓë
ʹÓÃCalendar ¸ñʽ»¯Êä³öÈÕÆÚ
ÔÚºÄʱÉϵĶԱÈÈçÏÂ
²âÊÔÈí¼þƽ̨
win 7,CUP T4200,ÄÚ´æ 2G,
eclipse 3.5,
android sdk1.5
²âÊÔÓ²¼þƽ̨
T Mobile G1,
SimpleDateFormatµÄÊä³öÒª±ÈCalendar Âý2±¶ÒÔÉÏ
SimpleDateFormatµÄ¸ñʽÓÐÏÞÖÆ
±ÈÈç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ