How to Fetching Data From a Database in java

<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

Database Lookup

Please enter the ID of the publisher you want to find:

Fetching Data From a Database

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

Statement statement = connection.createStatement();

String id = request.getParameter("id");

ResultSet resultset =
statement.executeQuery("select * from tableName where id = '" + id + "'") ;

if(!resultset.next()) {
out.println("Sorry, could not find that publisher. " +
"Please try again.");
} else {
%>

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

<%
}
%>