转----java读写SQLServer2005的image型字段

不知道好用不，先保存一下

声明，来自： http://hi.baidu.com/longlong8304/blog/item/7c91f92b9886aa27d52af130.html

package com.test;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class Test{
public Connection getCon(){
try{
//连接SQLServer2005
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=test","sa","sasa");
return con;
}catch(Exception ex){
ex.printStackTrace();
}
return null;
}

public static void main(String[] args){
try{
Test t = new Test();
t.writeFileToDb("D:/Aobh/mypic/S5001645.JPG");
t.readImgFromDb("D:/Aobh/mypic/S5001645.JPG","c:/new.jpg");
}catch(Exception ex){
ex.printStackTrace();
}
}


public void writeFileToDb(String fileName){
System.out.println("Writing to database... from file:"+fileName);
Connection con = null;
try{
con = getCon();
File myFile = new File(fileName);
InputStream in = new FileInputStream(myFile);
String sql = "insert into Table_1 (picname,pic) values(?,?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1,fileName);
ps.setBinaryStream(2,in,(int)myFile.length());
int result = ps.executeUpdate();
if (result>0)
System.out.println("Writing to database picfile success");
else
System.out.println("Writing to database picfile error");
}catch(Exception ex){
ex.printStackTrace();
}finally{
if (con !=null){
try{
con.close();
}catch(Exception ex){
ex.printStackTrace();
}
con = null;
}
}
}


public void readImgFromDb(String picName,String newName){
System.out.println("Reading from database to file:"+newName);
Connection con = null;
try{
con = getCon();
OutputStream out = new FileOutputStream(newName);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from Table_1 where picname='"+picName+"'");
if(rs.next()){
System.out.println(rs.getString("picname"));
int tmpi=0;
InputStream ins= rs.getBinaryStream("pic");
while((tmpi=ins.read())!=-1){
out.write(tmpi);
}
ins.close();
out.flush();
out.close();
System.out.println("Reading from database to file "+newName+" success");
}
}catch(Exception ex){
ex.printStackTrace();
}finally{
if (con!=null){
try{
con.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
con = null;
}
}
}