public QueryTableModel() {
cache = new Vector();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
} catch (java.lang.Exception e) {
System.err.println("Class not found exception : ");
System.err.println(e.getMessage());
}
} // konstr. sonu
public org.eclipse.swt.widgets.Shell open(org.eclipse.swt.widgets.Display display) {
java.lang.Class clazz = org.eclipse.swt.examples.hoverhelp.HoverHelp.class;
try {
if (images == null) {
images = new org.eclipse.swt.graphics.Image[imageLocations.length];
for (int i = 0; i < imageLocations.length; ++i) {
java.io.InputStream stream = clazz.getResourceAsStream(imageLocations[i]);
org.eclipse.swt.graphics.ImageData source =
new org.eclipse.swt.graphics.ImageData(stream);
org.eclipse.swt.graphics.ImageData mask = source.getTransparencyMask();
images[i] = new org.eclipse.swt.graphics.Image(display, source, mask);
try {
stream.close();
} catch (java.io.IOException e) {
e.printStackTrace();
}
}
}
} catch (java.lang.Exception ex) {
System.err.println(
getResourceString(
"error.CouldNotLoadResources", new java.lang.Object[] {ex.getMessage()}));
return null;
}
org.eclipse.swt.widgets.Shell shell = new org.eclipse.swt.widgets.Shell();
createPartControl(shell);
shell.addDisposeListener(
new org.eclipse.swt.events.DisposeListener() {
public void widgetDisposed(org.eclipse.swt.events.DisposeEvent e) {
if (images != null) {
for (int i = 0; i < images.length; i++) {
final org.eclipse.swt.graphics.Image image = images[i];
if (image != null) {
image.dispose();
}
}
images = null;
}
}
});
shell.pack();
shell.open();
return shell;
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
ResultSet rs = null;
try {
// SET UP Context environment, to look for Data Pooling Resource
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/TestDB");
Connection dbcon = ds.getConnection();
// ########### SEARCH INPUT PARAMETERS, EXECUTE search
// #####################################################
Vector<String> params = new Vector<String>();
params.add(request.getParameter("fname"));
params.add(request.getParameter("lname"));
params.add(request.getParameter("title"));
params.add(request.getParameter("year"));
params.add(request.getParameter("director"));
List<Movie> movies = new ArrayList<Movie>();
movies = SQLServices.getMovies(params.toArray(new String[params.size()]), dbcon);
// ########## SET DEFAULT SESSION() PARAMETERS ####################################
request.getSession().removeAttribute("movies");
request.getSession().removeAttribute("linkedListMovies");
request.getSession().removeAttribute("hasPaged");
request.getSession().setAttribute("hasPaged", "no");
request.getSession().setAttribute("movies", movies);
request.getSession().setAttribute("currentIndex", "0");
request.getSession().setAttribute("defaultN", "5");
// ########## IF MOVIES FROM SEARCH NON-EMPTY ###########################################
List<String> fields = Movie.fieldNames();
int count = 1;
if (!movies.isEmpty()) {
request.setAttribute("movies", movies);
for (String field : fields) {
request.setAttribute("f" + count++, field);
}
request.getRequestDispatcher("../movieList.jsp").forward(request, response);
} else {
out.println("<html><head><title>error</title></head>");
out.println("<body><h1>could not find any movies, try your search again.</h1>");
out.println("<p> we are terribly sorry, please go back. </p>");
out.println("<table border>");
out.println("</table>");
}
dbcon.close();
} catch (SQLException ex) {
while (ex != null) {
System.out.println("SQL Exception: " + ex.getMessage());
ex = ex.getNextException();
}
} catch (java.lang.Exception ex) {
out.println(
"<html>"
+ "<head><title>"
+ "moviedb: error"
+ "</title></head>\n<body>"
+ "<p>SQL error in doGet: "
+ ex.getMessage()
+ "</p></body></html>");
return;
}
out.close();
}
