mysql 存图片 教程_实例讲解如何用Struts向MySQL中储存图片

这个例子是通过用Struts的FormFile来写入到MySQL中。用户通过选一个图片，然后按submit就可以存入数据库中。

1.首先需要建立一个表:

create table test

( name varchar(20),

pic blob );

在MySQL的test库中

"http://jakarta.apache.org/struts/tags-bean"

prefix="bean"%>

"http://jakarta.apache.org/struts/tags-html"

prefix="html"%>

JSP for multiForm form

enctype="multipart/form-data">

一定要用enctype=“multipart/form-data“

不然就提交之后就会有抛出异常

file :

name :

2. 相对应的ActionForm:

//Created by MyEclipse Struts

// XSL source (default):

platform:/plugin/com.genuitec.eclipse.

cross.easystruts.eclipse_3.8.1

/xslt/JavaClass.xsl

package saoo.struts.form;

import org.apache.struts.action.ActionForm;

import org.apache.struts.upload.FormFile;

/**

* MyEclipse Struts

* Creation date: 08-24-2004

*

* XDoclet definition:

* @struts:form name="multiForm"

*/

public class MultiForm extends ActionForm

{

// ----------------

Instance Variables

/** file property */

private FormFile file;

/** name property */

private String name;

// -----------------

Methods

/**

* Returns the file.

* @return FormFile

*/

public FormFile getFile()

{

return file;

}

/**

* Set the file.

* @param file The file to set

*/

public void setFile(FormFile file)

{

this.file = file;

}

/**

* Returns the name.

* @return String

*/

public String getName()

{

return name;

}

/**

* Set the name.

* @param name The name to set

*/

public void setName(String name)

{

this.name = name;

}

}

3. 对就的Action:

//Created by MyEclipse Struts

// XSL source (default):

platform:/plugin/com.genuitec.eclipse.

cross.easystruts.eclipse_3.8.1

/xslt/JavaClass.xsl

package saoo.struts.action;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionForward;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.upload.FormFile;

import saoo.struts.form.MultiForm;

/**

* MyEclipse Struts

* Creation date: 08-24-2004

*

* XDoclet definition:

* @struts:action path="/multi"

name="multiForm" input="/form/multi.jsp"

scope="request"

*/

public class MultiAction extends Action

{

// ---------------

Instance Variables

// ---------------

Methods

/**

* Method execute

* @param mapping

* @param form

* @param request

* @param response

* @return ActionForward

*/

public ActionForward execute(

ActionMapping mapping,

ActionForm form,

HttpServletRequest request,

HttpServletResponse response)

{

MultiForm multiForm = (MultiForm)

form;

FormFile file = multiForm.getFile();

String name = multiForm.getName();

try {

Class.forName

("org.gjt.mm.mysql.Driver");

String url="jdbc:mysql:

///test";

Connection con=DriverManager.getConnection

(url,"root","password");

String sql="insert into pic values (?,?)";

PreparedStatement ps

=con.prepareStatement(sql);

ps.setString(1, name);

//加入图片到数据库

ps.setBinaryStream

(2,file.getInputStream(),

file.getFileSize());

ps.executeUpdate();

ps.close();

con.close();

} catch (SQLException se)

{

se.printStackTrace();

return mapping.findForward("error");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

return mapping.findForward("error");

} catch (FileNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

return mapping.findForward("error");

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

return mapping.findForward("error");

}

return mapping.findForward("success");

}

}

本文来源:赛迪网