<%@page import="java.sql.*"%>
Obtaining a Connection
This Page Obtains a Connection to a Database and executes a query
<%
Connection conn = null;
ResultSet result = null;
Statement stmt = null;
try {
Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (Exception e) {
System.out.println("Error occurred " + e);
}
try {
conn = DriverManager.getConnection("jdbc:odbc:ADDRESS", "","");
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
try {
stmt = conn.createStatement();
result = stmt.executeQuery("SELECT * FROM ADDRESS");
}
catch (SQLException e) {
System.out.println("Error occurred " + e);
}
%>