Fetching Data From a Database
<%@ page import="java.sql.*" %>
<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>
Fetching Data From a Database
Database Lookup
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) %> |
<%
}
%>