Help connecting to mysql tables

[ajrobson]

\n" +
" image here\n" +
"" + title + "\n");

out.println("" +
"" +
" Title\n" +
" Director\n" +
" Rating\n" +
" Year Released\n" +
" Price\n" +
" Number in stock\n" +
" image name"
);

// Retrieve the results
while(rs1.next()){
// getInt or getString or getFloat etc to get the appropriate column data
// wrap output in html for web
out.println("" +
"" + rs1.getString("title") + "" +
"" + rs1.getString("director") + "" +
"" + rs1.getString("rating") + "" +
"" + rs1.getDouble("year_released") + "" +
"" + rs1.getString("price") + "" +
"" + rs1.getString("stock_count") + "" +

"" + rs1.getString("image_name") +"\n");
//"image here">"
}
// close the html
out.println("

[jwenting]

1) use code tags
2) don't put Java code in JSPs, they're meant ONLY for displaying results