java´æ´¢Í¼Æ¬µ½Êý¾Ý¿â
1 mysql´æ´¢´óÈÝÁ¿µÄ¶þ½øÖÆÎļþµÄ¸ñʽÊÇblob£¬Æäʵ³ýÁËͼƬ»¹¿ÉÒÔ´æ±ðµÄ
2 ÒªÏòÊý¾Ý¿â´æ´¢¶þ½øÖƵÄÎļþÒ»¶¨Òª°ÑÒª´æ´¢µÄÊý¾Ýת»»³É¶þ½øÖÆÁ÷
·Ï»°¾Í²»¶à˵ÁË£¬´ó¼Ò¿´¿´´úÂëºÜÈÝÒ×Ã÷°×£¬ÏÈÀ´¿´Ò»¸öapp³ÌÐò£¬µ±È»Ê×ÏÈÄúÒªÔÚÊý¾Ý¿âÖÐÏȽ¨Á¢Ò»¸öÓÃÓÚ±£´æÍ¼Æ¬µÄ±íºÍÏàÓ¦µÄÁУ¬Êý¾Ý¸ñʽΪblob
package com.lizhe;
import java.io.*;
import java.sql.*;
public class PutImg {
public void putimg() {
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost/img?user=root&password=root&useUnicode=true&characterEncoding=gbk";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
//stmt.execute("insert into imgt (id) values (5)");
stmt.close();
PreparedStatement pstmt = null;
String sql = "";
File file = new File("c:\\blog.jpg");
InputStream photoStream = new FileInputStream(file);
//sql = " UPDATE imgt SET img = ? ";
sql = "INSERT INTO imgtable (img) VALUES (?)";
pstmt = conn.prepareStatement(sql);
pstmt.setBinaryStream(1, photoStream, (int) file.length());
pstmt.executeUpdate();
pstmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String args[]){
PutImg pi=new PutImg();
pi.putimg();
}
}
InputStream photoStream = new FileInputStream(file);
¿ÉÒÔºÜÇå³þµÄ¿´µ½ÎÒÃÇÊ×ÏȰÑÒ»¸öͼƬÎļþ(µ±È»Ò²¿ÉÒÔÊDZðµÄʲôÎļþ)ת»»³ÉÁËÒ»¸ö¶þ½øÖÆÊäÈëÁ÷
pstmt.setBinaryStream(1, photoStream, (int) file.length());
Õâ¸ö·½·¨½¨Òé´ó¼ÒÈ¥²éÒ»ÏÂAPIÎĵµ,µÚÒ»¸ö²ÎÊýÊÇͨÅä·ûλÖÃûµÄ˵,µÚ¶þ¸ö²ÎÊýÊÇÁ÷,ÕâºÍÒÔÍùµÄstringÀàÐ͵IJÎÊý²»Ì«Ò»Ñù,ÎÒ¸Õ¿´µ½µÄÊ
Ïà¹ØÎĵµ£º
1.½Ó¿ÚµÄ¶¨Ò壺
interface ½Ó¿ÚÃû
{ ½Ó¿ÚÌ壻 }
×¢Ò⣺½Ó¿ÚÌåÖÐÖ»Äܰüº¬³£Á¿¶¨ÒåºÍ·½·¨¶¨ÒåÁ ......
jdkÌṩÁËZipÏà¹ØµÄÀà·½±ãµÄʵÏÖѹËõºÍ½âѹËõ¡£Ê¹Ó÷½·¨ºÜ¼òµ¥¡£Ï±߷ֱðÊÇѹËõºÍ½âѹËõµÄ¼òµ¥ÊÂÀý
1£¬Ñ¹ËõµÄ
import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import ......
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar ;
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );
2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar ;
Class.forName( "org.postgresql. ......
ÔÚ³ÌÐòÖУ¬Îı¾Îļþ¾³£ÓÃÀ´´æ´¢±ê×¼µÄASCIIÂëÎı¾£¬±ÈÈçÓ¢ÎÄ¡¢¼Ó¼õ³Ë³ýµÈºÅÕâЩÔËËã·ûºÅ¡£Îı¾ÎļþÒ²¿ÉÄÜÓÃÓڴ洢һЩÆäËû·ÇASCII×Ö·û£¬Èç»ùÓÚ
GBKµÄ¼òÌåÖÐÎÄ£¬»ùÓÚBIG5µÄ·±ÌåÖÐÎĵȵȡ£ÔÚ´æ´¢ÕâЩ×Ö·ûʱÐèÒªÕýÈ·Ö¸¶¨ÎļþµÄ±àÂë¸ñʽ£»¶øÔÚ¶ÁÈ¡ÕâЩÎı¾Îļþʱ£¬ÓÐʱºò¾ÍÐèÒª×Ô¶¯Åж¨ÎļþµÄ±àÂë
¸ñʽ¡£
°´ÕÕ¸ø¶¨µÄ×Ö·û¼¯´ ......