[JSP] Please solve my send.redirect("") error

[Viruthagiri]

Hello friends,

I have a table which contains file names. For example i have stored a file "java.pdf" in a directory called "course". The file is located here. http://www.something.com/course/java.pdf

 

Now i stored the file name in a column named "document_filename".

I stored it as "java.pdf"

 

Now if a user click the course it should rediect to view the file. I coded like this. Please correct my code.

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" %> 
<% 
try { Class.forName("com.mysql.jdbc.Driver"); 
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/elearning_datasource?user=root"); 
int course_id; 
String query,query1; course_id=Integer.parseInt(request.getParameter("course_id")); 
String statement="SELECT document_filename from x_masterlistofdocuments where course_id="+course_id+""; ResultSet objRs=null; response.sendRedirect("http://www.something.com/course/%=statement%"); 
con.close(); 
} 
catch(Exception e) 
{ 
out.println("Error?"+e.getMessage()); 
} 
%>

 

I understand the error is in this line:

response.sendRedirect("http://www.something.com/course/%=statement%");

 

 

I want redirect to the file what is selected using query. Thankyou friends