delproduct.jsp

大学JSP课程大作业

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="my.shop.db.*" %>

<%-- 会话过滤 --%>
<%@ include file="sessionfilter.jsp" %>

<%
	String id = request.getParameter("id") ;
	Connection conn = DBConnection.getInstance().getConnection() ;
	String getFilename = "select picture from product where id="+ id ;
	ResultSet rsfilename = conn.createStatement().executeQuery(getFilename) ;
	String filename = "" ;
	if(rsfilename.next()){
		filename = rsfilename.getString(1) ;
	}
	rsfilename.close() ;
	File delFile = new File(getServletContext().getRealPath("/")+"productimage\\"+filename); //取得指定路径下的指定文件
	if(delFile.exists() && delFile.isFile()){//删除指定的磁盘文件
		delFile.delete();
	}
	String sql = "delete from product where id=?" ;
	PreparedStatement pstmt = conn.prepareStatement(sql) ;
	pstmt.setString(1,id) ;
	pstmt.executeUpdate() ;
	out.println("<div align='center'><font color=blue>指定产品成功删除！</font><br><a href='mgrproduct.jsp'>返回</a></div>") ;
	pstmt.close() ;
	conn.close() ;
%>