java – problem to make a loan select in jsp, attribute value Bean class not valid

I create a loan management in JSP and I have a problem with the loan list.

I have not yet created a method to insert them, I have entered a database loan directly with MySQL to first check the registered loan listing method.

The problem is that when I run the application, the following error is displayed as an attachment to the screen with the image.

enter the description of the image here

This is the menu where I give the complete list

enter the description of the image here

This is the error that occurs.

I am now attaching the material I am using for this particular subject.

1º-The Loan class, which is in a package called Entities.

package entities;

import java.sql.Date;

/ **
*
* @author AlbertoPortatil
* /
public class Prestamo {

int id;
String DNIusuario = null;
String ISBNobra = null;
Date Date request = null;
Date Evolutiondate = null;

public loan (int id, String DNIusuario, String ISBNobra,
Date Date of application, Date Date of change) {
this.id = id;
this.DNIusuario = DNIusuario;
this.ISBNobra = ISBNobra;
this.Fechaslication = Request dates;
this.Vechadevolucion = Evolutiondate;
}
Public loan (String DNIusuario, String ISBNobra) {

this.DNIusuario = DNIusuario;
this.ISBNobra = ISBNobra;
}

public int getId () {
return id;
}

public void setId (int id) {
this.id = id;
}

public String getDNIuser () {
back DNIusuario;
}

public void setDNIuser (String DNIusuario) {
this.DNIusuario = DNIusuario;
}

public String getISBNobra () {
return ISBNobra;
}

setISBNobra (String ISBNobra) empty public {
this.ISBNobra = ISBNobra;
}

public Date getFechaslication () {
return the dates of application;
}

public void setFactsApplication (Date DatesApplication) {
this.Fechaslication = Request dates;
}

public Date getFechadevolucion () {
date of return of the change;
}

empty game publicFechadevolucion (Date Fechadevolucion) {
this.Vechadevolucion = Evolutiondate;
}

}

2nd The DAO class, where I have attached the specific selection for loans.

package entities;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

public class DAO {
public ArrayList selectPrestamo () throws an exception {
ArrayList Loans = null;

                try (Connection connection = DBConnection.get ()) {
if (connection == null) {// if the connection is null, throws an exception
throw a new exception ("Connection is null");
}

Statement statement = connection.createStatement ();
ResultSet rs = statement.executeQuery ("SELECT * FROM loan");

ready = new ArrayList ();
while (rs.next ()) {
Ready Ready = new loan (rs.getInt ("id"), rs.getString ("user ID"),
rs.getString ("ISBNobra"), rs.getDate ("DatesApplication"),
rs.getDate ("Modified"));
borrowing.add (borrowing);
}

} catch (Exception ex) {
launch ex;
} finally {
DBConnection.close ();
}
repay the loans;
}
}

3º-The SQL, the item of interest is the Ready table


– Table structure ready

CREATE THE TABLE ready (
login int (11) NOT NULL,
DNIusuario varchar (9) NOT NULL,
ISBNobra varchar (13) NOT NULL,
Dates of application date NOT NULL,
Date of revolution date DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = latin1;

– Data dump for the table ready

INSERT IN ready (login, DNIusuario, ISBNobra, Dates of application, Date of revolution) VALUES
(1, & quot; 11111111A & quot ;, & quot; 11111111A1 & quot ;, & quot; 2019-02-27 & quot ;, & quot; 2019-02-28 & quot;


– Table index ready

ALTER TABLE ready
ADD PRIMARY KEY (login)
ADD THE KEY prestamo_ibfk_1 (DNIusuario)
ADD THE KEY prestamo_ibfk_2 (ISBNobra)

– Filters for the table ready

ALTER TABLE ready
ADD CONSTRAINT prestamo_ibfk_1 FOREIGN KEY (DNIusuario) REFERENCES user (ID) ON THE CASCADE UPDATE,
ADD CONSTRAINT prestamo_ibfk_2 FOREIGN KEY (ISBNobra) REFERENCES job (ISBN) ON THE CASCADE UPDATE;
COMMIT;

/ *! 40101 SET CHARACTER_SET_CLIENT = @ OLD_CHARACTER_SET_CLIENT /;
/
! 40101 SET CHARACTER_SET_RESULTS = @ OLD_CHARACTER_SET_RESULTS /;
/
! 40101 SET COLLATION_CONNECTION = @ OLD_COLLATION_CONNECTION * /;

And here is the loan table with a record that I entered to test the select.

enter the description of the image here

4thThe jsp sheet "HojaPrestamo", where I make a link to another sheet called formListarPrestamo.jsp, which is the list.

<%@page contentType="text/html" pageEncoding="UTF-8"%>

User sheet

Home

Complete list