JDBC(访问二进制类型的数据)

数据库读取图片

public static void create() throws SQLException, IOException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			// 2.建立连接
			conn = jdbcUtils.getinstance().getConnection();

			// 3.创建执行SQL的语句
			String sql = "insert into blob_test (big_bit) value (?)";
			ps = conn.prepareStatement(sql);
			File file = new File("1.jpg");
			InputStream in = new BufferedInputStream(new FileInputStream(file));
			ps.setBinaryStream(1, in, (int) file.length());
			// 4.执行语句
			ps.executeUpdate();

			in.close();

		} finally {
			// 6.释放资源
			jdbcUtils.free(rs, ps, conn);
		}
	}

读取数据库文件图片

public static void read() throws SQLException, IOException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			// 2.建立连接
			conn = jdbcUtils.getinstance().getConnection();

			// 3.创建执行SQL的语句
			String sql = "select big_bit from blob_test";
			ps = conn.prepareStatement(sql);

			// 4.执行语句
			rs = ps.executeQuery();

			// 5.处理结果
			while (rs.next()) {
				//写法一
				Blob blob = rs.getBlob(1);
				InputStream in = blob.getBinaryStream();
				/*
				 * 写法二
				 * InputStream in = rs.getBinaryStream(1);
				 * rs.getBinaryStream(1)——这里的参数'1'表示SQL语句的第几列
				 * 比如上面的SQL语句"select big_bit from blob_test"的'big_bit'列
				 * 可以写成rs.getBinaryStream("big_bit")
				 * */

				File file = new File("IMG_002.JPG");
				BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(file));
				byte[] buff = new byte[1024];
				for (int i = 0; (i = in.read(buff)) > 0; i++) {
					out.write(buff, 0, i);
				}
				out.close();
				in.close();
			}
		} finally {
			// 6.释放资源
			jdbcUtils.free(rs, ps, conn);
		}
	}