至顶网›软件频道 ›用Struts向MYSQL数据库中储存图片实例

用Struts向MYSQL数据库中储存图片实例

扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条

作者：dxaw 来源：赛迪网 2007年11月20日

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

create table test 
( name varchar(20), 
pic blob );
在MySQL的test库中

<%@ page language="java"%>
<%@ taglib uri=
"http://jakarta.apache.org/struts/tags-bean"
prefix="bean"%> 
<%@ taglib uri=
"http://jakarta.apache.org/struts/tags-html"
prefix="html"%>
 
<html> 
 <head>
  <title>JSP for multiForm form</title>
 </head>
 <body>
  <html:form action="/multi"
  enctype="multipart/form-data">
  一定要用enctype=“multipart/form-data“
  不然就提交之后就会有抛出异常
   file : <html:file property="file"/>
   <html:errors property="file"/></br>
   name : <html:text property="name"/>
   <html:errors property="name"/></br>
   <html:submit/><html:cancel/>
  </html:form>
 </body>
</html>

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");
    }
}

href="http://java.ccidnet.com/art/3559/20070822/1186015_1.html" target=_blank>查看本文来源

用Struts向MYSQL数据库中储存图片实例

VIP专区

VIP用户

普通用户

闂備緡鍙庨崰鏇炩枎閵忋垺濯奸柕蹇嬪€栭～锟�

婵犵鈧啿鈧綊鎮樻径鎰畺闁靛ň鏅滄慨婊堟偨椤栨稓鎽冮柟鐑╂櫊瀹曟岸宕堕埡鍌滄殸闂佽鍨伴崢鏍姳閿涘嫭鍠嗘い銈呭姬婵☆偅婢樺Λ妤呮偂濞嗘挸瀚夐柍褜鍓熷顒侊紣娓氣偓閻涙捇鏌涘┑鍛樂缂佹鐭傞獮搴ㄥ焵椤掑嫬瀚夋い鏍ㄧ懁缁诲棝鏌熼褍鐏茬紒杈ㄧ箞閺屽洭鏁愰崟顓犳澖闁荤姳闄嶉崹钘壩ｉ崟顖涘殜闁硅泛顫曢埀顒€锕︾槐鏃堝箣閻愬弬妤呮煛閸偄鐏﹂柛瀣墬缁傛帞鎹勯搹瑙勵啈闂佸搫瀚烽崹閬嶅磻瀹ュ鍎嶉柛鏇ㄥ墯娴犳ê霉閿濆棗鈻曢柍褜鍓氶弻銊ф閻愬鈻曢悗锝傛櫇椤忛亶鏌曢崱顓熷

重磅专题

往期文章

用Struts向MYSQL数据库中储存图片实例

业界热点: