|
-
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>
}
Last edited by trixma; 09-08-2005 at 05:17 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Reply With Quote
Bookmarks