Untitled

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>

<html>
<head><title>JDBC</title></head>
   <body><font size=10>
	<h1>Ejemplo de JDBC</h1>
	<table border=1>
		<tr><td><b>Nombre</b></td><td><b>RUT</b></td></td></tr>
		<%
			Connection con;
			Statement set;
			ResultSet rs;
			String sURL="jdbc:oracle:thin:@srvOracle.exind.cl:7715:xe";
			String userName = "lab13d";
			String password = "lab13d";
			try
			{
				Class.forName("oracle.jdbc.driver.OracleDriver");
				con = DriverManager.getConnection(sURL, userName, password);
				System.out.println("Se ha conectado");
				String nombre;
				String rut;
				String calle;
				set = con.createStatement();
				rs = set.executeQuery("select * from BV_TBL_CLIENTES");
				while (rs.next())
				{
					rut = rs.getString(3);
					nombre = rs.getString(2);
					calle = rs.getString(3);

					out.println("<tr><td><b>"+nombre+"</b></td><td><b>"+rut+"</b></td></tr>");
				}
				rs.close();
				set.close();
				con.close();
			}
			catch(Exception e)
			{
				System.out.println("Error en acceso a BD");
			}
			%>
	</table>
	<h3>Muchas gracias por su visita</h3>
	</form></font>
   </body>
</html>