用struts向数据库中储存图片

Jack-chen

浏览: 71445 次
性别:
来自: 北京

最近访客更多访客>>

marky_live

liusheng088

chengzhang123

shenzhouTY

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Struts

Struts Myeclipse MySQL Eclipse Apache

这个例子是通过用Struts的FormFile来写入到MySQL中。。。

用用户通过选一个图片，然后按submit就可以存入数据库中

其中先要建立一个表:

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

1<%@ page language="java"%>
2<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%>
3<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%>
4
5<html>
6 <head>
7 <title>JSP for multiForm form</title>
8 </head>
9 <body>
10 <html:form action="/multi" enctype="multipart/form-data">一定要用enctype=“multipart/form-data“不然就提交之后就会有抛出异常
11   file : <html:file property="file"/><html:errors property="file"/></br>
12   name : <html:text property="name"/><html:errors property="name"/></br>
13   <html:submit/><html:cancel/>
14 </html:form>
15 </body>
16</html>
17
182. 相对应的ActionForm:
19
20//Created by MyEclipse Struts
21// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.1/xslt/JavaClass.xsl
22
23package saoo.struts.form;
24
25import org.apache.struts.action.ActionForm;
26import org.apache.struts.upload.FormFile;
27
28/** *//**
29 * MyEclipse Struts
30 * Creation date: 08-24-2004
31 *
32 * XDoclet definition:
33 * @struts:form name="multiForm"
34 */
35public class MultiForm extends ActionForm {
36
37    // --------------------------------------------------------- Instance Variables
38
39    /** *//** file property */
40    private FormFile file;
41
42    /** *//** name property */
43    private String name;
44
45    // --------------------------------------------------------- Methods
46
47    /** *//**
48     * Returns the file.
49     * @return FormFile
50     */
51    public FormFile getFile() {
52        return file;
53    }
54
55    /** *//**
56     * Set the file.
57     * @param file The file to set
58     */
59    public void setFile(FormFile file) {
60        this.file = file;
61    }
62
63    /** *//**
64     * Returns the name.
65     * @return String
66     */
67    public String getName() {
68        return name;
69    }
70
71    /** *//**
72     * Set the name.
73     * @param name The name to set
74     */
75    public void setName(String name) {
76        this.name = name;
77    }
78}
79
803. 对就的Action:
81
82//Created by MyEclipse Struts
83// XSL source (default): platform:/plugin/com.genuitec.eclipse.cross.easystruts.eclipse_3.8.1/xslt/JavaClass.xsl
84
85package saoo.struts.action;
86
87import java.io.FileNotFoundException;
88import java.io.IOException;
89import java.sql.Connection;
90import java.sql.DriverManager;
91import java.sql.PreparedStatement;
92import java.sql.SQLException;
93
94import javax.servlet.http.HttpServletRequest;
95import javax.servlet.http.HttpServletResponse;
96
97import org.apache.struts.action.Action;
98import org.apache.struts.action.ActionForm;
99import org.apache.struts.action.ActionForward;
100import org.apache.struts.action.ActionMapping;
101import org.apache.struts.upload.FormFile;
102
103import saoo.struts.form.MultiForm;
104
105/** *//**
106 * MyEclipse Struts
107 * Creation date: 08-24-2004
108 *
109 * XDoclet definition:
110 * @struts:action path="/multi" name="multiForm" input="/form/multi.jsp" scope="request"
111 */
112public class MultiAction extends Action {
113
114    // --------------------------------------------------------- Instance Variables
115
116    // --------------------------------------------------------- Methods
117
118    /** *//**
119     * Method execute
120     * @param mapping
121     * @param form
122     * @param request
123     * @param response
124     * @return ActionForward
125     */
126    public ActionForward execute(
127        ActionMapping mapping,
128        ActionForm form,
129        HttpServletRequest request,
130        HttpServletResponse response) {
131        MultiForm multiForm = (MultiForm) form;
132        FormFile file = multiForm.getFile();
133
134        String name = multiForm.getName();
135        try {
136            Class.forName("org.gjt.mm.mysql.Driver");
137            String url="jdbc:mysql:///test";
138            Connection con=DriverManager.getConnection(url,"root","password");
139            String sql="insert into pic values (?,?)";
140            PreparedStatement ps =con.prepareStatement(sql);
141            ps.setString(1, name);
142//加入图片到数据库
143            ps.setBinaryStream(2,file.getInputStream(),file.getFileSize());
144            ps.executeUpdate();
145            ps.close();
146            con.close();
147        } catch (SQLException se) {
148            se.printStackTrace();
149            return mapping.findForward("error");
150        } catch (ClassNotFoundException e) {
151            // TODO Auto-generated catch block
152            e.printStackTrace();
153            return mapping.findForward("error");
154        } catch (FileNotFoundException e) {
155            // TODO Auto-generated catch block
156            e.printStackTrace();
157            return mapping.findForward("error");
158        } catch (IOException e) {
159            // TODO Auto-generated catch block
160            e.printStackTrace();
161            return mapping.findForward("error");
162        }
163        return mapping.findForward("success");
164    }
165}
166

分享到：

用Struts的Token机制解决表单重复提交 | [整理]sql语句一些实用技巧for oracle

2010-03-30 09:54
浏览 994
评论(2)
论坛回复 / 浏览 (2 / 2770)
分类:企业架构
查看更多

2 楼 wulinshishen 2010-05-24

嗯！值得去学下

1 楼 proje 2010-05-22

值得学习，谢谢了哦

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论