SQL Help and Servlet help
I created the following servlet, it is meant to access an SQL database and display records of a movieTitle and a review. My code only displays the headings and no records and an error. The sqlException error that is thrown is Column Index out of range, 3 > 2.
in the database i have a int reviewId, String movieTitle and a String review. Can anyone help?
Thanks Trixxma
/*
* MovieServlet.java
*
* Created on 3 September 2005, 21:50
*/
import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Trixxma
* @version
*/
public class MovieServlet extends HttpServlet {
/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
sendMovies(response);
}
public void sendMovies(HttpServletResponse response) throws IOException {
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet a</title>");
out.println("<link href='main.css' rel='stylesheet' type='text/css' />");
out.println("</head>");
out.println("<body>");
out.println("<div id='navbar'>");
out.println("<img src='images/heading.gif'>");
out.println("<ul>");
out.println("<li><a href='Index.html '>Home</a></li>");
out.println("<li><a href='MovieDatabase '>Movie Database</a></li>");
out.println("<li><a href='Registration.html '>Register</a></li>");
out.println("<li><a href='Review'>Create a Review</a></li>");
out.println("<li><a href='Comment'>Comment</a></li>");
out.println("<li><a href='Login.html '>Login</a></li>");
out.println("<li><a href='Movie?logout=1' value='logout' name='logout' >Logout</a></li>");
out.println("</div>");
out.println("<div id='main'>");
String query = "SELECT movieTitle, review" + " FROM movie";
try {
Connection con = DataManager.getInstance().getConnection();
ResultSet result;
Statement stmt = con.createStatement();
out.println("<TABLE>");
out.println("<TR>");
out.println("<TH>Movie Title</TH>");
out.println("<TH>Review</TH>");
out.println("<TH></TH>");
out.println("</TR>");
result = stmt.executeQuery(query);
while (result.next()){
int reviewid = result.getInt(1);
out.println("<TR>");
out.println("<TD>" + result.getString(2) + "</TD>");
out.println("<TD>" + result.getString(3) + "</TD>");
out.println("<TD><a href=Comment?reviewid =" + reviewid + ">Add a comment</a></TD>");
out.println("</TR>");
}
result.close();
} catch (SQLException se) {
out.println("<p>There has been a problem finding results.");
//out.println("<p>SQL Error executing query=<br>"+query+"<br>");
out.println(se.getMessage());
} catch (Exception e){
out.println(e.getMessage());
}
out.println("</TABLE>");
out.println("</div>");
out.println("<div id='left'>");
out.println("<center><P>Search the movie database</P></center>");
out.println("<center><form action=Search METHOD='POST'>");
out.println("Search: <input type='text' name='search' size='40'>");
out.println("<center><input type='submit' value='submit' name='submit'></center>");
out.println("</form></center>");
out.println("</div>");
out.println("</body>");
out.println("</html>");
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}
