faguilavidal
5/6/2015 - 2:49 PM

Servlet & oracle

Servlet & oracle

Select table oracle on servlet.java
content_copyfile_download
package Servlet;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

public class Seleccionar extends HttpServlet {
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException, SQLException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            
            out.println(""
                    + "<!DOCTYPE html>"
                    +"<html>"
                    + "<head>"
                    + "<title>Servlet Seleccionar</title>"
                    + "</head>"
                    + "<body>"
                    + "<h3 align='center'>Accediendo a la Base de Datos de Oracle desde Jsp</h3>");
            try 
            {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                String user = "system";
                String password = "olofoo18";
                //String nombre = request.getParameter("nombre");
                Connection conexion = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE",user,password);
                Statement sql = conexion.createStatement();
                ResultSet tabla = sql.executeQuery("select * from alumno");
                //ResultSet tabla = sql.executeQuery("select * from alumno where nombre = '" + nombre + "'");
                
                out.println(""
                        + "<table border='1' align='center'>"
                            +"<thead>"
                                + "<tr>"
                                    + "<th>Nombre</th>"
                                    + "<th>Apellido</th>"
                                    + "<th>Rut</th>"
                                + "</tr>"
                            + "</thead>");
                while(tabla.next())
                {
                    out.println(""
                            + "<tbody>"
                                + "<tr>"
                                    + "<td>"+ tabla.getString("nombre")+ "</td>" 
                                    +"<td>" + tabla.getString("apellido") + "</td>"
                                    +"<td>" + tabla.getString("rut") + "</td>"
                                + "</tr>"
                            + "</tbody>");
                }
                out.println("</table>");
            } 
            catch (Exception ex) 
            {
                
            }
            out.println(""
                    + "</body>"
                +"</html>");
        }
    }
    
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        try 
        {
            processRequest(request, response);
        } 
        catch (SQLException ex) 
        {
            
        }
    }
}