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