实例.txt

JDBC 2k,2005.2000 的驱动.

import java.sql.*;
import java.io.*;

public class pic {

	public static void main(String[] args) throws Exception {

		// 将图片写入流中
		File file = new File("d:\\image1.jpg");
		int length = (int) (file.length());
		FileInputStream fis = new FileInputStream(file);
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//仅jdbc2005和jtds生效，jdbc2000异常
		Connection con = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1433;databasename=bbs", "sa", "");
		PreparedStatement stm = con
				.prepareStatement("insert into bbs_user(username,uface) values(?,?)");
		stm.setString(1, "Neo");
		stm.setBinaryStream(2, fis, length); // 把流中内容写入image字段中
		stm.executeUpdate();
		fis.close();
		stm.close();
		System.out.println("DB=>Stream   WriteIn Success! ");

		// 将流中图片读到硬盘上
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery("select * from bbs_user");
		rs.next();
		Blob bb = rs.getBlob(5);// 读出image字段内容
		FileOutputStream fop = new FileOutputStream("e:\\abc.jpg");// 自动建立该文件
		fop.write(bb.getBytes(1, (int)bb.length()));// 把blob写入输出流中
		fop.flush();
		fop.close();
		st.close();
		System.out.println("Stream=>Disk    ReadOut Success! ");
		con.close();
	}
}