java 读取 sqlserver text 类型字段

有这样一个需求，需要将原本存储在数据库中的文档转存至文件系统中，于是写了一个简单的程序完成此功能，代码如下：

Java代码
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.dbunit.util.Base64;
public class ReadBlob {

    /**
     * @param args
     */
    public static void main(String[] args) throws Exception {

        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection conn = DriverManager.getConnection(
                "jdbc:sqlserver://localhost:1433;DatabaseName=test1", "sa",
                "123456");
        PreparedStatement ps = conn.prepareStatement("select * from aa");
        ResultSet rs = ps.executeQuery();

        while(rs.next()){
            String fileName = rs.getString("FileName");
            String content = rs.getString("Content");
            byte[] byte_content = Base64.decode(content);

            generateFile(byte_content, "D:\\doc", fileName);
        }
        conn.close();
    }
    /**
     * 根据byte数组，生成文件
     */
    public static void generateFile(byte[] bfile, String filePath,String fileName) {
        BufferedOutputStream bos = null;
        FileOutputStream fos = null;
        File file = null;
        try {
            File dir = new File(filePath);
            if(!dir.exists()&&dir.isDirectory()){
                dir.mkdirs();
            }
            file = new File(filePath+"\\"+fileName);
            fos = new FileOutputStream(file);
            bos = new BufferedOutputStream(fos);
            bos.write(bfile);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (bos != null) {
                try {
                    bos.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
            if (fos != null) {
                try {
                    fos.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
        }
    }
}

补充：软件开发 , Java ,