import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class findPicture {
public void findPicture1(String picname) throws ClassNotFoundException, SQLException, IOException {
FileOutputStream fo=new FileOutputStream("D:/"+picname+".png");
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/xiezhikuai";
Connection con=DriverManager.getConnection(url, "root", "12315");
String sql="select * from jbpm4_lob where NAME_="+"\""+picname+".png\"";
Statement sta=con.createStatement();
ResultSet rs=sta.executeQuery(sql);
InputStream in=null;
if(rs.next()){
in=rs.getBinaryStream(3);
}
int i;
while ((i=in.read())!=-1) {
fo.write(i);
}
}
}
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class findPicture {
public void findPicture1(String picname) throws ClassNotFoundException, SQLException, IOException {
FileOutputStream fo=new FileOutputStream("D:/"+picname+".png");
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/xiezhikuai";
Connection con=DriverManager.getConnection(url, "root", "12315");
String sql="select * from jbpm4_lob where NAME_="+"\""+picname+".png\"";
Statement sta=con.createStatement();
ResultSet rs=sta.executeQuery(sql);
InputStream in=null;
if(rs.next()){
in=rs.getBinaryStream(3);
}
int i;
while ((i=in.read())!=-1) {
fo.write(i);
}
}
}