I think there are a number of things that you could be doing differently here. First I will say that getting a ResultSet from a JavaBean to a JSP can be strange at first. Here is how I would do it (This may not be the best way and I have not coded it exactly but you should get the idea):
1. Create a method in your bean that connects the database... so for your purposes it would be...
Connection con
public void connect() {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:MyDatabase2");
}
catch(Exception e)
{
System.out.println( "error: connection to " + "sun.jdbc.odbc.JdbcOdbcDriver");
}
try{
}
catch(Exception e)
{
System.out.println( "error: connection to DriverManager");
}
}
2. Then create a method that returns a ResultSet... like so for your example it would be something like...
public String getPHONE()
{
try{
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM CONTACTTABLE");
}
catch(Exception e)
{
System.out.println( "error: SQL query");
}
return rs;
}
The create a JSP that uses that JavaBean and populates the HTML like so ...
<ul>
<%
theBean.connect();
ResultSet rs = theBean.getPHONES();
while(rs.next()) {
%>
<li><%= rs.getString("aDatabaseColumn") %></li>
<%
}
%>
</ul>
Also you should create another method in the bean that disconnects the database connection...
Sorry I did not code it all out perfectly for you but hope that helps some...
