Hola gente de foros del web , les escribo pq recintemente estuve en un curso de java, y vi un ejemplo que me parecio intersante, uso el esquema HR de la db oracle y netbeans(en el ejmplo se aplica e MVC), lo probe en mi pc pero no corre, el problema es el arraylist, buscando informacion , teoricamente por usar la version 1.5 del jdk debe funcionar pero no se pq no muestra el resultado,quisiera saber que es lo que falla, espero que alguien me pueda orientar ,aqui les muestro el codigo del bean:
package Conn.bean;
import java.beans.*;
import java.io.*;
import java.math.BigDecimal;
import java.util.*;
/**
* @author asp.net
*/
public class BEmployee {
public BEmployee() {
}
private String Employee_Id;
private String First_Name;
private String Last_Name;
private String Email;
private String Phone_Number;
private String Hire_Date;
private String Job_id;
private BigDecimal Salary;
private BigDecimal Commission_Pet;
private int Department_Id;
private int Manager_Id;
public String getEmployee_Id() {
return Employee_Id;
}
public void setEmployee_Id(String Employee_Id) {
this.Employee_Id = Employee_Id;
}
public String getFirst_Name() {
return First_Name;
}
public void setFirst_Name(String First_Name) {
this.First_Name = First_Name;
}
public String getLast_Name() {
return Last_Name;
}
public void setLast_Name(String Last_Name) {
this.Last_Name = Last_Name;
}
public String getEmail() {
return Email;
}
public void setEmail(String Email) {
this.Email = Email;
}
public String getPhone_Number() {
return Phone_Number;
}
public void setPhone_Number(String Phone_Number) {
this.Phone_Number = Phone_Number;
}
public String getHire_Date() {
return Hire_Date;
}
public void setHire_Date(String Hire_Date) {
this.Hire_Date = Hire_Date;
}
public String getJob_id() {
return Job_id;
}
public void setJob_id(String Job_id) {
this.Job_id = Job_id;
}
public BigDecimal getSalary() {
return Salary;
}
public void setSalary(BigDecimal Salary) {
this.Salary = Salary;
}
public BigDecimal getCommission_Pet() {
return Commission_Pet;
}
public void setCommission_Pet(BigDecimal Commission_Pet) {
this.Commission_Pet = Commission_Pet;
}
public int getDepartment_Id() {
return Department_Id;
}
public void setDepartment_Id(int Department_Id) {
this.Department_Id = Department_Id;
}
public int getManager_Id() {
return Manager_Id;
}
public void setManager_Id(int Manager_Id) {
this.Manager_Id = Manager_Id;
}
}
ahora les mando el del servlet:
package Conn.Servlet;
import Conn.bean.BEmployee;
import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import javax.sql.*;
import javax.*;
import java.util.ArrayList;
//import oracle.sql.*;
import java.util.*;
/**
*
* @author Administrador
* @version
*/
public class SList_Employee extends HttpServlet {
public Connection conn;
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
HttpSession session=request.getSession();
ArrayList L= new ArrayList();
//List<String> L = new ArrayList<String>();
BEmployee bemployee=new BEmployee();
Statement sen;
ResultSet res;
this.init_Oracle();
try{
sen=conn.createStatement();
res=sen.executeQuery("select e.employee_id,e.First_name,e.last_name,e.email from Employees e");
while(res.next())
{
//BEmployee bemployee=new BEmployee();
bemployee=new BEmployee();
//
// bemployee.setEmployee_Id(res.getString(1));
bemployee.setFirst_Name(res.getString(2));
bemployee.setLast_Name(res.getString(3));
bemployee.setEmail(res.getString(4));
//la infomcion de cada usuario es
//almacenada en L
L.add(bemployee);
}
res.close();
sen.close();
conn.close();
}catch(SQLException ex){
System.out.println("SQLException "+ex.toString());
ex.printStackTrace();
}catch(Exception e){
System.out.println(e.toString());
e.printStackTrace();
}
request.setAttribute("a_employee",L);
RequestDispatcher rd=request.getRequestDispatcher("lista_employee.js p");
rd.forward(request,response);
}
private void init_Oracle(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin :@SERVER2003:1521:MIDB","HR","HR");
}
catch (Exception e){
System.out.println("conexion fallida");
e.printStackTrace();
}
}
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// processRequest(request, response);
}
}
este servlet muestra los resultados en un pagina JSP llamada lista_employee.jsp.
aqui esta el codigo :
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page import="java.util.ArrayList, Conn.bean.BEmployee, java.util.Iterator" %>
<jsp:useBean class="java.util.ArrayList" id="a_employee" scope="request"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
<style type="text/css">
<!--
.Estilo4 {color: #3300FF}
.Estilo5 {
font-size: 18px;
color: #FF0000;
font-family: Georgia, "Times New Roman", Times, serif;
}
-->
</style>
</head>
<body>
<%=a_employee.size()%>
<form name="form1" method="post" action="">
<p align="center" class="Estilo5">Ejemplo de Tomcat y Oracle </p>
<table width="584" border="2" align="center">
<tr>
<th width="65" scope="col"><div align="center"><span class="Estilo4">Num</span></div></th>
<th width="46" scope="col"><div align="center"><span class="Estilo4">ID</span></div></th>
<th width="114" scope="col"><div align="center"><span class="Estilo4">FirstName</span></div></th>
<th width="109" scope="col"><div align="center"><span class="Estilo4">Last Name </span></div></th>
<th width="124" scope="col"><div align="center"><span class="Estilo4">Email</span></div></th>
<th width="84" scope="col"><div align="center"><span class="Estilo4">Borrar</span></div></th>
</tr>
<%
BEmployee bemployee=new BEmployee();
// List L=a_employee.getClass();
for(int i=0;i < a_employee.size();i++)
{
bemployee=(BEmployee)a_employee.get(i);
%>
<tr>
<td><%=i%></td>
<td><a href='SData_Employee?employee_id=<%=bemployee.getE mployee_Id()%>'>
<%=bemployee.getEmployee_Id()%>
</a> </td>
<td><%=bemployee.getFirst_Name()%></td>
<td><%=bemployee.getLast_Name()%>
</td>
<td><%=bemployee.getEmail()%>
</td>
<td><a href=''>delete </a> /td>
</tr>
<% } %>
</table>
<p> </p>
</form>
<h1> </h1>
</body>
</html>
