package db;
import java.sql.*;
 
public class DbAccess
{
String url= "jdbc:mysql://localhost/agenda?";
String user = "root";
String pass = "";
Connection conn = null;
 
public void DbAccess(){
try{		
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
System.out.println("Loadin driver");
conn = DriverManager.getConnection(url, user, pass);
System.out.println("Making connection");
}catch(Exception E){
System.err.println("Unable to load driver and make connection.");
E.printStackTrace();
}
}
 
public ResultSet execQuery(String query){
Statement stmt = null;
ResultSet rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(query);
}catch (Exception E) {
System.err.println("Execute query");
E.printStackTrace();
}
return rs;
}
}

<%@ page import = "java.sql.*"%>
 
<%
try{		
agenda.DbAccess dbprueba = new agenda.DbAccess();
ResultSet dbrs = dbprueba.execQuery("Select * from tbllogin");
while (dbrs.next()){
out.println(dbrs.getString("username") + "  " + dbrs.getString("password"));
}
}catch(Exception E){
System.err.println("Unable to load driver and make connection.");
E.printStackTrace();
}
%>