mysql读取大文件_图像,大文件的mysql导入与读取存放到本地

package conn;

import java.io.*;

import java.sql.Blob;

import java.sql.Clob;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.mysql.jdbc.Driver;

import com.sun.corba.se.spi.orbutil.fsm.Input;

public class Conn {

public Connection getConn(){

Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "gjl");

} catch (Exception e) {

e.printStackTrace();

}

return conn;

}

public void setlob(){

Connection conn = null;

PreparedStatement pre = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = getConn();

String sql = "insert into t_lob value (?,?,?)";

pre = conn.prepareStatement(sql);

File txt = new File("E:\\项目\\说明文件\\信息.txt");

File img = new File("G:\\1.jpg");

InputStream inTxt = new FileInputStream(txt);

InputStream inImg = new FileInputStream(img);

pre.setString(1, "1");

pre.setAsciiStream(2, inTxt, (int)txt.length());

pre.setBinaryStream(3, inImg, (int)img.length());

pre.executeUpdate();

conn.close();

pre.close();

System.out.println("read-ok");

} catch (Exception e) {

e.printStackTrace();

}

}

public void getlob(){

Connection conn = null;

Statement stmt = null;

ResultSet rs = null;

try {

conn = getConn();

stmt = conn.createStatement();

rs = stmt.executeQuery("select * from t_lob");

while(rs.next()){

Clob clob = rs.getClob(2);

Blob blob = rs.getBlob(3);

InputStream txt = clob.getAsciiStream();

InputStream img = blob.getBinaryStream();

FileOutputStream OutTxt= new FileOutputStream(new File("F:\\T.txt"));

FileOutputStream OutImg= new FileOutputStream(new File("F:\\I.jpg"));

int c1 = -1;

int c2 = -1;

while(( c1 = txt.read())!= -1)

OutTxt.write(c1);

OutTxt.flush();

OutTxt.close();

while(( c2 = img.read())!= -1)

OutImg.write(c2);

OutImg.flush();

OutImg.close();

}

System.out.println("write-ok");

} catch (Exception e) {

e.printStackTrace();

}

}

public  static void main(String[]args){

Conn conn = new Conn();

// conn.getlob();

// conn.setlob();

}

}