浏览 2786 次
|
锁定老帖子 主题：用struts向数据库中储存图片
精华帖 (0) :: 良好帖 (0) :: 新手帖 (0) :: 隐藏帖 (6)
|
|
|---|---|
| 作者 | 正文 |
|
发表时间：2010-03-30
这个例子是通过用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 声明：ITeye文章版权属于作者，受法律保护。没有作者书面许可不得转载。
推荐链接
|
| 返回顶楼 | |
|
发表时间：2010-05-22
值得学习，谢谢了哦
|
| 返回顶楼 | |
|
发表时间：2010-05-24
嗯！值得去学下
|
| 返回顶楼 | |
