62,614
社区成员
发帖
与我相关
我的任务
分享
package service;
import java.io.File;
import java.sql.*;
import org.apache.struts2.ServletActionContext;
public class Delet {
public String fileNamed;
public String getFilename(){
return fileNamed;
}
public void setFilename(String fileNamed){
this.fileNamed=fileNamed;
}
public String getDFilename(){
String fileNamed=ServletActionContext.getRequest().
getParameter("fileNamed");
String deletname=fileNamed;
try{
deletname=new String(deletname.getBytes(),"UTF-8");
}catch(Exception e){
e.printStackTrace();
}
return deletname;
}
public String excute() throws Exception{
String name=getDFilename();
String realPath= "/upload"+"\\"+name;
File fileName=new File(realPath+name);
Connection conn=Jdbc.getConnection();
Statement stam=conn.createStatement();
String sql="delet from file where filename=?";
System.out.println(realPath);
try{
fileName.delete();
stam.executeUpdate(sql);
}catch(SQLException e){
e.printStackTrace();
conn.rollback();
}finally{
conn.close();
stam.close();
}
return "success";
}
}