解决方法
您可能需要查看以下示例:
从java2s.com: Insert picture to MySQL开始:
import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.sqlException; public class InsertPictureToMysqL { public static void main(String[] args) throws Exception,IOException,sqlException { Class.forName("org.gjt.mm.MysqL.Driver"); Connection conn = DriverManager.getConnection("jdbc:MysqL://localhost/databaseName","root","root"); String INSERT_PICTURE = "INSERT INTO MyPictures (photo) VALUES (?)"; FileInputStream fis = null; PreparedStatement ps = null; try { conn.setAutoCommit(false); File file = new File("/tmp/photo.png"); fis = new FileInputStream(file); ps = conn.prepareStatement(INSERT_PICTURE); ps.setBinaryStream(1,fis,(int) file.length()); ps.executeUpdate(); conn.commit(); } finally { ps.close(); fis.close(); } } }
MysqL表:
CREATE TABLE MyPictures ( photo BLOB );
如果映像位于MysqL服务器主机上,则可以使用MysqL客户端的LOAD_FILE()
命令:
INSERT INTO MyPictures (photo) VALUES(LOAD_FILE('/tmp/photo.png'));