mysql数据库存图片url_Mysql 数据库创建图片记录

package com;

import java.io.IOException;

import java.io.OutputStream;

import java.sql.Blob;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class GetImage extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

Connection con = null;

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

String URL = "jdbc:mysql://localhost:3306/test?user=root&password=root";

con = DriverManager.getConnection(URL);

Statement stmt = con.createStatement();

/*

* create a BLOB record in Mysql database.

* */

//PreparedStatement st = null;

//File file = new File("d:\\tom.jpg");

//InputStream in = new BufferedInputStream(new FileInputStream(file));

//String sql = "insert into image(Image) values(?)";

//st = con.prepareStatement(sql);

//st.setBinaryStream(1, in, (int) file.length());

//int i = st.executeUpdate();

//in.close();

/*

* Retrieve the image from database

* */

String sql = "select * from image where Id = 2";

ResultSet rs = stmt.executeQuery(sql);

if (rs.next()) {

Blob b = rs.getBlob("Image");

long size = b.length();

byte[] bs = b.getBytes(1, (int) size);

response.setContentType("image/jpeg");

OutputStream outs = response.getOutputStream();

outs.write(bs);

outs.flush();

rs.close();

}

}catch(Exception e){

e.printStackTrace();

} finally {

try {

con.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

web.xml中的配置信息：

GetImage

com.GetImage

GetImage

/GetImage.jsp

前台jsp中的code：

SQL脚本：

CREATE TABLE `image` (

`Id` int(11) NOT NULL auto_increment,

`Image` blob,

PRIMARY KEY (`Id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

分享到：

2009-11-20 12:14

浏览 906

评论