<%@ page import="java.sql.*" %> <% String username="dynamix1_root"; String password="root"; String dbName="dynamix1_bdultima"; String dbHost="localhost"; try { Class.forName("com.mysql.jdbc.Driver"); } catch(ClassNotFoundException msg) { out.println("Error loading driver:" + msg.getMessage()); } try{ String url ="jdbc:mysql://"+dbHost+":3306/"+dbName; Connection Conn = DriverManager.getConnection(url,username, password); Statement Stmt = Conn.createStatement(); String query = "select * from tb_provincia"; ResultSet res = Stmt.executeQuery(query); while(res.next()) { out.println("Codigo : "+res.getObject(1)); out.println("Nombre Prov. : "+res.getObject(2)); } } catch(SQLException e) { String err1Msg = e.getMessage(); %> err1Msg = <%= err1Msg %> <% } %>