//Rizwan Kassim - 602 784 143 (c) Rizwan Kassim 2004 import java.io.*; import java.text.*; import java.util.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class P4 extends HttpServlet { PrintWriter out; // define query Strings for params String page; String param1; String param2; String param3; String param4; String param5; String param6; String param7; String param8; String query_text; Connection con; String debugloc; // GOT FORM VALIDATION HELP FROM http://javascript.about.com/library/weekly/aa070901a.htm public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException { try { Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); } catch (Exception e) { e.printStackTrace(); } resp.setContentType("text/html"); out = resp.getWriter(); // define query Strings for params page = ""; param1 = ""; param2 = ""; param3 = ""; param4 = ""; param5 = ""; param6 = ""; param7 = ""; param8 = ""; query_text = ""; // get params ( str = req.getParameter("paramname");) page = req.getParameter("page"); param1 = req.getParameter("param1"); param2 = req.getParameter("param2"); param3 = req.getParameter("param3"); param4 = req.getParameter("param4"); param5 = req.getParameter("param5"); param6 = req.getParameter("param6"); param7 = req.getParameter("param7"); param8 = req.getParameter("param8"); con = null; String url ="jdbc:db2:CS143"; try { con = DriverManager.getConnection(url); } catch ( SQLException ex ) { out.println( "

SQLException caught
---
" ); out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
---
"); } out.println(""); String title = "Rizwan Kassim's Project 4 - Internet Movie Database"; out.println("" + title + ""); //out.println(""); javascript(); out.println(""); out.println("

" + title + "

"); out.println("Actor Information - Movie Information
Actor Input - Comment Input - Movie Input
Search Query
"); //out.println(""); if ( page != null ) { if ( page.startsWith("B1") ) { page_B1(); } if ( page.startsWith("B2") ) { page_B2(); } if ( page.startsWith("S1") ) { page_S1(); } if ( page.startsWith("I1") ) { page_I1(); } if ( page.startsWith("I2") ) { page_I2(); } if ( page.startsWith("I3") ) { page_I3(); } } else { out.println("
"); } try { con.close(); } catch ( SQLException ex ) { out.println( "

SQLException caught
---
" ); out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
---
"); } } public void page_B1() { try { out.println("
"); out.println("On which actor do you want information?
"); // TODO : ADD DIRECTOR actor_droplist(true,1,param1); out.println("
"); if (param1 != null ) { out.println("
"); Statement query_actor_data = con.createStatement(); query_text = "SELECT * FROM ACTOR WHERE ID=" + param1; ResultSet actor_data = query_actor_data.executeQuery(query_text); out.println(""); out.println(""); while (actor_data.next()) { String id = actor_data.getString(1); String last = actor_data.getString(2); String first = actor_data.getString(3); String sex = actor_data.getString(4); String dob = actor_data.getString(5); String dod = actor_data.getString(6); out.println("
Actor's IDLast NameFirst NameSexDate of BirthDate of Death
"+id+""+last+""+first+""+sex+""+dob+""+dod+"

"); } out.println("

Roles:
"); Statement query_actor_role = con.createStatement(); query_text = "SELECT mid,role FROM MovieActor WHERE AID=" + param1; ResultSet actor_role = query_actor_role.executeQuery(query_text); while (actor_role.next()) { String mid = actor_role.getString(1); String role = actor_role.getString(2); out.println("Played " + role + " in "); Statement query_movie_name = con.createStatement(); query_text = "SELECT title,year,id FROM Movie WHERE ID=" + mid; ResultSet movie_name = query_movie_name.executeQuery(query_text); while (movie_name.next()) { String moviename = movie_name.getString(1); String year = movie_name.getString(2); String id = movie_name.getString(3); out.println(moviename+" ("+year+")
"); } } } } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passa: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void page_B2() { try { out.println(""); out.println("On which movie do you want information?
"); movie_droplist(true,1,param1); out.println("
"); if (param1 != null ) { out.println(""); Statement query_movie_data = con.createStatement(); query_text = "SELECT * FROM MOVIE WHERE ID=" + param1; ResultSet movie_data = query_movie_data.executeQuery(query_text); out.println(""); out.println(""); while (movie_data.next()) { String id = movie_data.getString(1); String title = movie_data.getString(2); String year = movie_data.getString(3); String rating = movie_data.getString(4); String company = movie_data.getString(5); String avgrating = ""; Statement query_movie_rating = con.createStatement(); query_text = "SELECT AVG(RATING) FROM REVIEW WHERE MID=" + param1; ResultSet movie_rating = query_movie_rating.executeQuery(query_text); while (movie_rating.next()) { avgrating = movie_rating.getString(1); } out.println("
Movie's IDTitleYearRatingProduction CompanyAverage RatingGenre(s)
"+id+""+title+""+year+""+rating+""+company+""+avgrating+""); String genre = ""; Statement query_movie_genre = con.createStatement(); query_text = "SELECT genre FROM moviegenre WHERE mid=" + param1; ResultSet movie_genre = query_movie_genre.executeQuery(query_text); while (movie_genre.next()) { genre = movie_genre.getString(1); } out.println(genre+"

"); } out.println("

Roles:
"); Statement query_movie_role = con.createStatement(); query_text = "SELECT aid,role FROM MovieActor WHERE MID=" + param1; ResultSet movie_role = query_movie_role.executeQuery(query_text); while (movie_role.next()) { String aid = movie_role.getString(1); String role = movie_role.getString(2); Statement query_actor_name = con.createStatement(); query_text = "SELECT last,first,sex FROM Actor WHERE ID=" + aid; ResultSet actor_name = query_actor_name.executeQuery(query_text); out.println(""); while (actor_name.next()) { String last = actor_name.getString(1); String first = actor_name.getString(2); String sex = actor_name.getString(3); out.println(last+", "+first+" ("+sex+")"); } out.println(" played as " + role + "
"); } Statement query_movie_comment = con.createStatement(); query_text = "SELECT * FROM Review WHERE MID=" + param1; ResultSet movie_comment = query_movie_comment.executeQuery(query_text); out.println("
"); out.println("
Comments
NameDate EnteredRatingReview"); while (movie_comment.next()) { String name = movie_comment.getString(1); String when = movie_comment.getString(2); String rating = movie_comment.getString(4); String comment = movie_comment.getString(5); out.println("
"+name+""+when+""+rating+"" + comment ); } // TODO : Assign different CSS values for each rating! (colors) out.println("

Add a comment" ); out.println("" ); } } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passb " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void page_S1() { try { out.println(""); out.println(""); out.println("

Search Movies
Search Actors

"); out.println("Partial Search Parameter (Case-Sensitive Permitted) :
"); out.println("
"); if (param1 != null) { out.println(""); if ( param2.startsWith("movie") ) { Statement query_movie_data = con.createStatement(); query_text = "SELECT * FROM MOVIE WHERE TITLE LIKE '%" + param1 + "%' ORDER BY TITLE"; ResultSet movie_data = query_movie_data.executeQuery(query_text); out.println(""); out.println(""); String id = movie_data.getString(1); String title = movie_data.getString(2); String year = movie_data.getString(3); String rating = movie_data.getString(4); String company= movie_data.getString(5); out.println(""); } out.println("
Movie's IDTitleYearRatingCompany"); while (movie_data.next()) { out.println("
"+id+""); out.println(""+title+""+year+""+rating+""+company+"

"); } if ( param2.startsWith("actor") ) { Statement query_actor_data = con.createStatement(); if ( param3 != null ) { if ( param3.startsWith("first") ) { query_text = "SELECT * FROM ACTOR WHERE FIRST Like '%" + param1 + "%' ORDER BY FIRST"; } else { query_text = "SELECT * FROM ACTOR WHERE LAST LIKE '%" + param1 + "%' ORDER BY LAST"; } } else { query_text = "SELECT * FROM ACTOR WHERE LAST LIKE '%" + param1 + "%' ORDER BY LAST"; } ResultSet actor_data = query_actor_data.executeQuery(query_text); out.println(""); out.println(""); String id = actor_data.getString(1); String last = actor_data.getString(2); String first = actor_data.getString(3); String sex = actor_data.getString(4); String dob = actor_data.getString(5); String dod = actor_data.getString(6); out.println(""); } out.println("
Actor's IDLast NameFirst NameSexDate of BirthDate of Death"); while (actor_data.next()) { out.println("
"+id+""); out.println(""+last+""+first+""+sex+""+dob+""+dod+"

"); } } } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passc: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void page_I1() { try { out.println(""); out.println("Insert a new Actor Director
"); out.println("Required fields in bold,
DOB/DOD must be in MM/DD/YYYY form.
Sex is ignored for Directors.
"); out.println(""); out.println(""); out.println(""); out.println(""); out.println("
First Name:
Last Name:
Sex:
Date of Birth:
Date of Death:
"); out.println("
"); if (param2 != null & param3 != null & param4 != null) { String query_text_a = "INSERT INTO "; String query_text_b; if (param2.startsWith("director") ) { query_text_b = "DIRECTOR (ID,LAST,FIRST,DOB,DOD) VALUES ("; } else { query_text_b = "ACTOR (ID,LAST,FIRST,SEX,DOB,DOD) VALUES ("; } // fetch MAXPERSONID String query_text_c; query_text_c = ""; query_text = "SELECT * FROM MAXPERSONID"; Statement max_person_s = con.createStatement(); ResultSet max_person = max_person_s.executeQuery(query_text); while (max_person.next()) { query_text_c = max_person.getString(1); } query_text = "update maxpersonid set id=id+1"; Statement query_s = con.createStatement(); query_s.executeUpdate(query_text); query_s.close(); String query_text_d = ",'"+param4+"','"+param3+"',"; String query_text_e; if (param2.startsWith("director") ) { query_text_e = ""; } else { query_text_e = "'"+param5 + "',"; } String query_text_f; String query_text_g; if (param6.length() > 2) { query_text_f = "'"+param6+"',"; } else { query_text_f = "NULL,"; } if (param7.length() > 2) { query_text_g = "'"+param7+"')"; } else { query_text_g = "NULL)"; } query_text = query_text_a + query_text_b + query_text_c + query_text_d + query_text_e + query_text_f + query_text_g; String query_text_z = query_text_c + query_text_d + query_text_e + query_text_f + query_text_g; Statement insert_query_s = con.createStatement(); insert_query_s.executeUpdate(query_text); out.println("Executed Query :
" + query_text_a + query_text_b + "
" + query_text_z + ",
updating the maxperson count to " + query_text_c + "+1
"); out.println("
Inserted Data was:
Type"+param2+"
ID"+query_text_c+"
First Name"+param3+"
Last Name"+param4+"
Sex (if App)"+param5+"
Date of Birth"+param6+"
Date of Death"+param7+"
"); } } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passd: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void page_I2() { try { out.println(""); out.println("Required fields in bold,
"); out.println(""); out.println("
Review which movie?"); movie_droplist(true,1,param1); out.println("
Your Name:
Rating:
Comment:
"); out.println("
"); if (param2 != null & param3 != null & param4 != null) { String query_text_a = "INSERT INTO REVIEW (NAME,TIME,MID,RATING,COMMENT) VALUES "; String query_text_b = "('" + param2 + "','"; Timestamp ts = new java.sql.Timestamp(System.currentTimeMillis()); String query_text_c = new String(ts.toString()); //outputBuffer.append(timestr.substring(timestr.indexOf(' ',2))); //https://lists.xcf.berkeley.edu/lists/advanced-java/2000-March/007661.html String query_text_d = "',"+param1+","+param3+",'"; String query_text_e = param4 + "' )"; query_text = query_text_a + query_text_b + query_text_c + query_text_d + query_text_e; String query_text_z = query_text_b + query_text_c + query_text_d + query_text_e; Statement insert_query_s = con.createStatement(); insert_query_s.executeUpdate(query_text); out.println("Executed Query :
" + query_text_a + "
" + query_text_z + ".
"); out.println("
Inserted Data was:
Type"+"Comment"+"
MID"+param1+"
Name"+param2+"
Rating"+param3+"
Comment"+param4+"
Timestamp"+query_text_c+"
"); } } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passe: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void page_I3() { try { out.println("
Required fields in bold,
"); out.println(""); out.println("
Add a movieORAdd actors to a movie
"); out.println(""); out.println(""); out.println(""); out.println("
Title:
Year:
Rating:
Production Company:
Genre:
"); out.println("		"); out.println("Add Actor:
"); actor_droplist(false,6,param6); out.println("
to Movie:
"); movie_droplist(true,7,param7); out.println("
as Role:

"); out.println("

"); // INSERT DIRECTOR NOT IMPLEMENTED if (param1 != null & param3 != null & param2 != null) { if (param1 .length() > 2 & param2 .length() >2) { String query_text_a = "INSERT INTO MOVIE (ID,TITLE,YEAR,RATING,COMPANY) VALUES ("; // fetch MAXPERSONID String query_text_b = ""; query_text = "SELECT * FROM MaxMovieID"; Statement max_movie_s = con.createStatement(); ResultSet max_movie = max_movie_s.executeQuery(query_text); while (max_movie.next()) { query_text_b = max_movie.getString(1); } query_text = "update MaxMovieID set id=id+1"; Statement query_s = con.createStatement(); query_s.executeUpdate(query_text); query_s.close(); String query_text_c = ",'"+param1+"',"+param2+","; String query_text_d = "'"+param3+"','"+param4+"')"; query_text = query_text_a + query_text_b + query_text_c + query_text_d; String query_text_z = query_text_b + query_text_c + query_text_d; Statement insert_query_s = con.createStatement(); insert_query_s.executeUpdate(query_text); out.println("
Executed Query :
" + query_text_a + "
" + query_text_z + ",
updating the maxmovie count to " + query_text_b + "+1
"); out.println("
Inserted Data was:
ID"+ query_text_b +"
Title"+param1+"
Year"+param2+"
Rating"+param3+"
Company"+param4+"
"); if (param5.length() > 2) { String query_text = "INSERT INTO MovieGenre (MID,GENRE) VALUES ("+query_text_b+",'"+param5+"')"; Statement insert_query_s2 = con.createStatement(); insert_query_s2.executeUpdate(query_text); out.println("
Executed Query :
" + query_text + "
"); out.println("
Inserted Data was:
MID"+query_text_b+"
Genre"+param5+"
"); } } } if (param6 != null & param7 != null & param8 != null) { if (param8 .length() >2) { String query_text_a = "INSERT INTO MovieActor (MID,AID,ROLE) VALUES "; String query_text_b = "(" + param7 + ","; String query_text_c = param6+",'"+param8+"')"; query_text = query_text_a + query_text_b + query_text_c; String query_text_z = query_text_b + query_text_c; Statement insert_query_s = con.createStatement(); insert_query_s.executeUpdate(query_text); out.println("
Executed Query :
" + query_text_a + "
" + query_text_z + ".
"); out.println("
Inserted Data was:
MID"+param7+"
AID"+param6+"
Role"+param8+"
"); } } } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Pass: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void actor_droplist(boolean paramtest,int whichselect,String param){ try { Statement Actorlist_s = con.createStatement(); //ResultSet Actorlist = Actorlist_s.executeQuery("SELECT * FROM Actor WHERE ID > 12100 AND ID < 12200 ORDER BY LAST "); ResultSet Actorlist = Actorlist_s.executeQuery("SELECT * FROM Actor ORDER BY LAST "); // CROPPED FIX TODO // all the IDs out.println(""); } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passf: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void movie_droplist(boolean paramtest,int whichselect,String param){ try { Statement Movielist_s = con.createStatement(); //ResultSet Movielist = Movielist_s.executeQuery("SELECT ID,TITLE,YEAR FROM Movie WHERE ID > 1750 AND ID < 1800 ORDER BY TITLE "); ResultSet Movielist = Movielist_s.executeQuery("SELECT ID,TITLE,YEAR FROM Movie ORDER BY TITLE "); // CROPPED FIX TODO // all the IDs out.println(""); } catch ( SQLException ex ) { out.println( "

SQLException caught
" ); out.println( "---
" ); while ( ex != null ) { out.println( "Message : " + ex.getMessage( ) + "
"); out.println( "SQLState : " + ex.getSQLState( ) + "
"); out.println( "ErrorCode : " + ex.getErrorCode( ) + "
"); out.println( "Query Passg: " + query_text + "
"); out.println( "---
" ); } ex = ex.getNextException( ); } // close catch } public void javascript(){ out.println(""); } } /* out.println("Insert a Tuple!
Name:
Movie:
Role:
Year:
"); out.println(""); out.println("

Roles:
"); Statement query_actor_role = con.createStatement(); query_text = "SELECT mid,role FROM MovieActor WHERE AID=" + param1; ResultSet actor_role = query_actor_role.executeQuery(query_text); while (actor_role.next()) { String mid = actor_role.getString(1); String role = actor_role.getString(2); // TODO : Make this link to movie once we have movie working out.println("Played " + role + " in "); // NESTING BAAAAAAAAAAAAAAAD Statement query_movie_name = con.createStatement(); query_text = "SELECT title,year FROM Movie WHERE ID=" + mid; ResultSet movie_name = query_movie_name.executeQuery(query_text); while (movie_name.next()) { String moviename = movie_name.getString(1); String year = movie_name.getString(2); out.println(moviename+" ("+year+")
"); } } */ /* String movie_query; String actor_query; String character_query; String sorted_query; String special_query; String total_query = ""; movie_query = req.getParameter("movie"); actor_query = req.getParameter("actor"); character_query = req.getParameter("character"); sorted_query = req.getParameter("sorted"); special_query = req.getParameter("special"); // since form is driven WITH data from DB we've had to initalize all the way back here Statement movielist_s = con.createStatement(); // print out the result out.println("Reset Query

"); out.println("On what movie do you want information?
"); out.println(""); movielist.close(); movielist_s.close(); out.println("
For which actor? (Partial Search Case-Sensitive Permitted) : "); out.println("
Playing which character? (Partial Search Case-Sensitive Permitted) : "); out.println("
Sorted by : Movies Actors Movies Actors Characters"); out.println("

"); out.println(""); debugloc = "Response"; if (special_query != null) { if ( special_query.length() == 4 ) { out.println("Modify Not Implemented (Yet)!
"); out.println("What would be here is something similar to the Insert Function, I'd put another form like this:
"); out.println("
Name:
Movie:
Role:
Year:
"); out.println("I'd repass the old passed data as well as the 'actor2' data from this form into a second form like Insert
"); } if ( special_query.length() == 5 ) { out.println("Deleting Tuple!"); Statement query_s = con.createStatement(); out.println("DELETE Query : " + "DELETE FROM Actors WHERE Name='"+actor_query+"' AND Movie='"+movie_query+"' AND Role='"+character_query+"' " + "" ); total_query = "DELETE FROM Actors WHERE Name='"+actor_query+"' AND Movie='"+movie_query+"' AND Role='"+character_query+"'"; query_s.executeUpdate(total_query); query_s.close(); out.println("Reset Query

"); } if ( special_query.length() == 6 ) { out.println("Insert a Tuple!
Name:
Movie:
Role:
Year:
"); out.println("
"); // INSERT } if ( special_query.length() > 10 ) { out.println("Done! Insert another Tuple!
Name:
Movie:
Role:
Year:
"); out.println("
"); // INSERT confirm Statement query_s = con.createStatement(); out.println("Insert Query : " + "INSERT INTO Actors (Name, Role, Movie, Year) VALUES ('"+actor_query+"','"+movie_query+"','"+sorted_query+"','"+character_query+"')" + "" ); total_query = "INSERT INTO Actors VALUES ('"+actor_query+"','"+movie_query+"',"+sorted_query+",'"+character_query+"')"; query_s.executeUpdate(total_query); query_s.close(); } } else if (sorted_query==null) { out.println(""); } else { Statement query_s = con.createStatement(); String the_query_a = "SELECT * "; // the_query_b is sorted_query - well not really String the_query_c = "FROM Actors "; String the_query_d = " "; String the_query_e = ""; String the_query_f = ""; String the_query_g = ""; String the_query_h = ""; String the_query_i = ""; String the_query_j = ""; if (sorted_query.length() == 1) { the_query_j = " ORDER BY Movie"; } if (sorted_query.length() == 2) { the_query_j = " ORDER BY Name"; } if (sorted_query.length() == 3) { the_query_j = " ORDER BY Role"; } int past = 0; if ( actor_query.length() > 0 ) { the_query_d ="WHERE "; the_query_e = "Name Like '%" + actor_query + "%'"; past = 1; } if ( character_query.length() > 0 ) { if (past==1) { the_query_f = " AND "; } else { the_query_f = " "; } the_query_d = "WHERE "; the_query_g = "Role Like '%" + character_query + "%'"; past = 1; } if ( movie_query.length() > 4) { if (past==1) { the_query_h = " AND "; } else { the_query_h = " "; } the_query_d = "WHERE "; the_query_i = "Movie='" + movie_query + "'"; } total_query = the_query_a + the_query_c + the_query_d + the_query_e + the_query_f + the_query_g + the_query_h + the_query_i + the_query_j; out.println("
The processed query was : " + total_query + "
"); // could have used String.appen but this works too :) // doc here http://java.sun.com/j2se/1.4.2/docs/api/java/lang/String.html ResultSet final_query = query_s.executeQuery(total_query); out.println(""); int counter = 0; out.println("

"); while (final_query.next()) { out.println("

"); counter++; } // close while out.println("
"); String sql_name = final_query.getString(1); String sql_movie = final_query.getString(2); String sql_year = final_query.getString(3); String sql_role = final_query.getString(4); if (sorted_query.length() == 1) { out.println("" + sql_movie + " (" + sql_year + ") starring "); out.println(""+sql_name+""); out.println(" as " + sql_role + ".
"); } if (sorted_query.length() == 2) { out.println("" + sql_name + " as " + sql_role + " in "); out.println(""+sql_movie+""); out.println(" (" + sql_year + ").
"); } if (sorted_query.length() == 3) { out.println("" + sql_role + " played by "); out.println(""+sql_name+""); out.println("in "); out.println(""+sql_movie+""); out.println(" (" + sql_year + ").
"); } out.println("		"); out.println(""); out.println("Delete"); out.println(""); out.println(""); out.println("Update"); out.println("
"); out.println("
" + counter + " rows returned."); final_query.close(); query_s.close(); } // end else */