处理Blob类型数据（国外英文资料）.doc

处理Blob类型数据（国外英文资料） Blob -- the Binary Long Object is the meaning of the Binary Long Object, which is commonly used to store large files, such as a picture or a sound file Using Blob columns, you can store binary data from images, sounds, and other files in a database and restore it from the database to a specified file. So inserting a Blob data into the database requires a PreparedStatement, which is the method of the object: The setBinaryStream (int parameterIndex, InputSteam x) allows you to pass the binary input stream to the specified parameter, which can be implemented Blob data is saved to the database. When we need to extract Blob data from a ResultSet, we can call the ResultSets getBlob (int columnIndex) method, This method returns a Blob object, which provides the getBinaryStream method to retrieve the input stream of the Blob data A Blob object can be used to provide the getByte method directly to extract the binary data encapsulated by the Blob object. To put the image into the database, the program USES the following SQL statements to create a data table: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- The create table img_table ( Img_id int auto_increment primary key, Img_name varchar (255). - create a data column for the mediumblob type to hold the image data Img_data mediumblob ); Note: the BLOB type in the MySQL database can only store up to 64k content, which may not be sufficient for practical purposes. So using the mediumblob type, This type of data column can store 16M content. -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- the following program can perform image upload -- -- -- -- -- is actually to save images to the database, and on the right The list box displays the name of the image. When the user double-clicks the image name of the list box, the left window displays the image - - the