How to Selecting records with condition From a Database in java

<%@ page import="java.sql.*" %>

<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

Selecting tableName From a Database

<%
Connection connection = DriverManager.getConnection(
"jdbc:odbc:data", "userName", "password");

Statement statement = connection.createStatement() ;
ResultSet resultset =
statement.executeQuery("select * from tableName where city = 'Boston'") ;
%>









<% while(resultset.next()){ %>







<% } %>

ID	Name	City	State	Country
<%= resultset.getString(1) %>	<%= resultset.getString(2) %>	<%= resultset.getString(3) %>	<%= resultset.getString(4) %>	<%= resultset.getString(5) %>