delet.jsp

jsp+ajax实例

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import ="java.io.*" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@page import="java.io.*"%>
<% 
response.setHeader("Pragma","No-Cache"); 
response.setHeader("Cache-Control","No-Cache"); 
response.setDateHeader("Expires", 0); 
%> 
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db=getServletContext().getRealPath("\\")+"music.mdb";
File dbpath=new File(db);
String path = new java.io.File(db).getAbsolutePath();
Connection conn= DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" +
"DBQ="+path);
Statement sql=conn.createStatement();
ResultSet rs=sql.executeQuery("select file,pic,type,lrc from mp3 where id="+request.getParameter("id"));
rs.next();
String type=null;
String add=rs.getString(1);
String img=rs.getString(2);
String fileType=rs.getString("type");
String lrc=rs.getString("lrc");
if(fileType.equals("1"))
{type="audio\\";}
else if(fileType.equals("2"))
{type="video\\";}
String db1=getServletContext().getRealPath("\\")+type;
String path1 = new java.io.File(db1).getAbsolutePath()+"\\";
File addfile=new File(path1+add);
addfile.delete();
String db2=getServletContext().getRealPath("\\")+"img\\";
String path2 = new java.io.File(db2).getAbsolutePath()+"\\";
File imgfile=new File(path2+img);
imgfile.delete();

String db3=getServletContext().getRealPath("\\")+"Lyrics\\";
String path3 = new java.io.File(db3).getAbsolutePath()+"\\";
File lrcfile=new File(path3+lrc);
lrcfile.delete();
sql.executeUpdate("delete * from mp3 where id="+request.getParameter("id"));
out.print("<script>alert('删除成功！！');window.location=('index.html');</script>");
//out.println("<script>javascript:history.go(-1);</script>");
}
catch(Exception e)
{out.println(e);
}
%>