multiaction.java

往数据库中(mysql)写入图片,在eclipse下开发的

/*
 * 创建日期 2006-1-16
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package pic.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 pic.struts.actionform.MultiForm;

/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class MultiAction extends Action {
	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:///mybbs"; 
         Connection con=DriverManager.getConnection(url,"root","123"); 
         String sql="insert into test values (?,?)"; 
		 System.out.println(sql);
         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");
	}
}