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ÎÊý²»Ì«Ò»Ñù,ÎÒ¸Õ¿´µ½µÄÊ
Ïà¹ØÎĵµ£º
javaµÄ·¶ÐÍ»úÖÆ¿´ÆðÀ´ÓеãÏñC++µÄÄ£°æ£¬µ«Ïà±È½ÏC++µÄÄ£°æÀ࣬javaÖеķ¶ÐÍûÓйؼü×Ötemplate£¬²¢ÇÒÓÐ×Ų»Í¬µÄʵÏÖ»úÖÆ£¨±¾ÖÊÇø±ð£©¡£
·¶ÐÍÀà
ÏÈ¿´Ò»¸ö·¶ÐÍÀàµÄÀý×Ó£º
public class Demo1<T> {
private T value;
public Demo1(T value) {
&n ......
¶ÔÏó³Ö¾Ã»¯£¬Ò²¾ÍÊÇ¿ÉÒÔ°ÑÕâ¸ö¶ÔÏóÓÀÔ¶µÄ±£´æÆðÀ´£¬ÕâÀïµÄ±£´æ²»½öÊǶÔÏó±¾Éí£¬»¹°üÀ¨ËûµÄÊôÐÔºÍËùÒÀÀµµÄÆäËûÀࡣͨ³££¬¶ÔÏó¿ÉÒԳ־û¯µ½Îļþ»òÕßÊÇÊý¾Ý¿âÖС£ÎÒÕâÀïÖ»½éÉÜÈçºÎ½«¶ÔÏó´æ´¢µ½Êý¾Ý¿âÖС£Ç¡ÇÉOracleÊý¾Ý¿âΪÎÒÃÇÌṩÁËÕâÑùµÄ·½±ã¡£
ÔÚOracleÖУ¬ÓÐÒ»ÖÖblogµÄ×Ö¶ÎÀàÐÍ£¬ËüÊÇÓÃÀ´´æ´¢´óÁ¿µÄ¶ ......
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. ......
̸̸Java¼Ì³ÐÖеÄÖØÔØ£¬¸²¸ÇºÍÒþ²Ø
ºÃ¾Ã²»Ð´²©¿ÍÁË£¬¾àÀëÉÏһƪÒѾ¹ýÁËÁ½Äê¶àÁË¡£ÕâÁ½ÄêÔÚ¸ÉÂï,×ÜÖ®Ò»ÄêÄѾ¡£¡
ǰһ¶Îʱ¼äæÁËÁ½¸öÔ£¬Ã¦×ÅÑо¿ºÍ×öһЩSSH¼Ü¹¹µÄ¶«Î÷£¬Á½¸öÔÂÏÂÀ´£¬ÊÕ»ñÆÄ·á£¬×î½üÏÐÏÂÀ´ÁË£¬ÓÚÊǾÍÍ´¿ìµÄ¿ªÊ¼ÍæÓÎÏ·£¬µ«ÊDz»ÖªÔõôµØ£¬ÔõÃ´Íæ¶¼Ã»Òâ˼£¬ÓÚÊǾö¶¨¿ªÊ¼ÔٺúÃÑо¿Ñо¿Java°É¡£ÓÚÊÇ´ó¸Å·ÁË· ......
¡¾1¡¿Í¨¹ý¿´ÕâÌ×ÊÓÆµÎÒѧµ½ÁËÃæÊԵļ¼ÇÉ£¬ÒÔ¼°Ò»Ð©ÐèÒª¼ÇסµÄÃæÊÔÌâ
¡¾2¡¿Í¨¹ý¿´ÊÓÆµÎÒѧµ½ÁËÔõÑùȥѧϰ£¬ÔõÑùÔÚ¶Ìʱ¼äÄڰѸÃÓõļ¼Êõѧ»á£¬Í¨¹ý²é¿´×ÊÁÏÆ©ÈçAPIµÈ£¬¶øÇÒ»¹Ñ§»áÁËÏÖѧÏÖÂô£¬»îѧ»îÓÃ
¡¾3¡¿Ê²Ã´ÊÇIDEÓ¦ÓóÌÐò¿ª·¢¹¤¾ß
¡¾4¡¿MyEclipseµÄһЩʹÓÃС¼¼ÇÉ£¬Í¨¹ýÕâЩС¼¼ÇÉ¿ÉÒÔÔö¼Ó¿ª·¢Ð§ÂÊ
£¨¿ì½Ý¼ü£©£¨javaÄ ......