I have created a simple oracle database connection within a jsp file. (below)

1) How can you populated a selection box within the jsp file based on this connection?
2) Is there a more efficient solution to creating the connection within the jsp file?

//DB connection

Connection conn = null;

try
{

Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbcracle:thin:@192.168.*.*:1521:*",
"username",
"password");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("Select * from schema.tablename");

while(rs.next())
{

}
}
catch(SQLException e)
{
out.println("SQLException: " + e.getMessage() + "<BR>");
while((e = e.getNextException()) != null)
out.println(e.getMessage() + "<BR>");
}
catch(ClassNotFoundException e)

{
out.println("ClassNotFoundException: " + e.getMessage() + "<BR>");
}
finally
{

//Clean up resources, close the connection.
if(conn != null)
{
try
{
conn.close();
}
catch (Exception ignored) {}
}
}